News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
dbi Blog
Chronoscan is a well known application to scan, split and extract metadata from documents. This is possible with traditional functionalities like Intelli-Tag from Chronoscan, which requires additional complex and sometimes time-consuming configuration. It also offers an AI implementation, which makes things much less complex and reduces implementation time considerably. In the last version that I […]
dbi Blog
If you have been running Documentum on Oracle in the past, you might have noticed that recent versions of Dctm requires more Database permissions to be able to perform an install/upgrade. This blog will just be a quick one to show what I used to request for DB permissions for older versions of Documentum as […]
dbi Blog
There is no debate: an Enterprise Content Management system is a must-have nowadays. Now, it’s more than just a place to store documents. We need intelligent systems that help us manage content, improve collaboration and ensure compliance. M-Files excels in this area, particularly with its Advanced Workflow and Version Control module. Let’s take a look […]
dbi Blog
When performing search operations on large datasets, performance is a key consideration for ensuring that an application remains efficient and user-friendly. This consideration equally applies when working with embedded data. That’s why in this blog post we’ll explore the different possibilities for vector search and show how to leverage the latest features of SQL Server […]
dbi Blog
In this Blog we will continue with our AI journey in SQL-Server 2025 preview. If you didn’t read the first Blog you’ll find it here: dbi Blog In this article, we will explore the concept of data embeddings, a key concept for modern AI-driven applications and platforms. We will then examine the latest capabilities introduced […]
dbi Blog
The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase of this evolution with context-aware AI assistants and autonomous AI agents that will have even […]
dbi Blog
The ZDM 21.5 version brings some new functions like encrypting automatically now the TEMP, SYSTEM, SYSAUX and UNDO tablespaces. There is no need to do it manually any more after the ZDM migration, ZDM will take care of it on its own. Little problem, this is adding a new bug because the temporary database needs […]
dbi Blog
I have already written several articles about my experience migrating databases with Oracle Zero Downtime Migration. At that time, the version available was 21.4. The current version is now 21.5. Recently, I had the opportunity to patch our customer ZDM environment to 21.5 and to run new migrations in this new version. In this blog, […]
dbi Blog
The client’s environment includes two SQL Server instances (I1 and I2). One of the databases, D1 (on I1), is replicated to I2 via transactional replication. Additionally, the tables in this database are partitioned. The largest table (which is the one of interest) is approximately 350 GB in size and contains around 800 million rows. This […]
dbi Blog
Let’s have a look how we can install and update Oracle Zero Downtime Migration tool, and see how we can automatise it with ansible… Check ZDM build Let’s first see how we can check ZDM version using zdm cli. [zdm@zdmhost ~]$ zdmcli -v RHP_PT.ZDM21_LINUX.X64_221207.30 [zdm@zdmhost ~]$ zdmcli -build version: 21.0.0.0.0 full version: 21.4.0.0.0 patch version: […]
dbi Blog
In the last post about SUSE Multi Linux Manager we had a look at how you can schedule OpenSCAP reports using the API. In this post we’ll look into something very basic: How can you patch the server components of SUSE Multi Linux Manager. We speak about components because you need to patch the host […]
dbi Blog
As you might know, on ExaCC, it is possible to create spare clones. This is based on snapshot technology. There is no physical copy and the modified blocks will be written to the sparse clone, and in our case these blocks will be part of the ASM spare disk group. And of course, the sparse […]
dbi Blog
As we’ve recently supported some customers on SUSE Multi Linux Manager I’d like share something which was not as easy to implement as it appeared to be in the first place. But first of all, what is SUSE Multi Linux Manager? It is basically a fork of Spacewalk which was also used as the upstream […]
dbi Blog
I have been recently patching RAC databases on ODA 2-HA configured with Data Guard from version 19.20 to 19.26. During prepatch I have been facing an issue with missing sqldeveloper files, for which I could find a solution. I would like to share this solution with you as it might help you win some time. […]
dbi Blog
Within the past few days I was investigating another new feature of SQL Server 2025: OPTIMIZED_SP_EXECUTESQL. I was curious about the capabilities and the behaviour. OPTIMIZED_SP_EXECUTESQL is a database scoped configuration which allows us to get rid of the overhead of compiling and producing execution plans when we deal with dynamic SQL. The first user-session […]
dbi Blog
Introduction The AutoUpgrade utility is designed to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during postupgrade checks and configuration migration The Oracle AutoUpgrade Tool is part of Oracle Home since the version 12.1.0.2.It’s a java-based program which can be download on MySupport Oracle : ID 2485457.1It’s recommanded to use the […]
dbi Blog
I recently had to move a database from a 19.23 to a 19.26 dbhome on an ExaCC. This will include the database to be patched. The command dbaascli database move failed during the datapatch steps with following error: With this blog I would like to share my troubleshooting with you and how I resolved the […]
dbi Blog
Within the past few days I was investigating one of the new features of SQL Server 2025: Optimized Locking. I was curious about the capabilities, the behaviour and as well the limits of the feature. Optimized Locking is based on two primary components: Here we have the transaction ID working as a unique identifier for […]
dbi Blog
A contained availability group is a special availability group which manages its owns logins, users, permissions, jobs… with a dedicated master and msdb system databases, more information here.At a customer place we found some unexpected “login failed” for the group managed service account in the SQL Server logs. The source of the issue is coming […]
dbi Blog
Les 29 et 30 mai dernier (oui, j’ai pris un peu de temps pour écrire mon blog suite à un planning un peu trop chargé) j’ai assisté à la DataPoint à Prague. Avant de parler plus des sessions auxquelles j’ai assisté, je souhaitais remercier l’organisation de cette conférence.L’accueil était super, une mention spéciale à Bára […]
dbi Blog
After the new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages, you have a new landing page for SQL Server Management Studio (SSMS) : https://learn.microsoft.com/en-us/ssms You will see 6 parts in the main panel: If you have a look on the left menu, you will find […]
dbi Blog
After my blogs about “SQL Server 2025: Local SQL Server Container without Docker Command” and “SQL Server 2025: Local SQL Server Container – Schema compare preview”, I continue to play & test it. One new feature in preview is the “Schema Design compare” in this last MSSQL extension for Visual Studio Code: Let’s start and […]
dbi Blog
After my blog about “SQL Server 2025: Local SQL Server Container without Docker Command”, I continue to play & test it. One new feature in preview is the “schema compare” in this last extension for Visual Code: I like new feature and now let’s go for a test! 😉 I create 2 identically databases db1 […]
dbi Blog
The last version of” MSSQL extension for Visual Studio Code” has in Preview “the Local SqlServer Containers” based on SQL Server 2025 with the following keys: See all Preview Features here First Step: Download and install Visual Studio Code here Second Step: Download and install MSSQL extension for Visual Studio Code here You can also […]
dbi Blog
With the latest version of SSMS, SSMS 21, there is now integration with Copilot. In this blog post, we’ll go through the setup step by step, with screenshots, to get everything ready to use Copilot in SSMS.There is already some official documentation on this, but I believe many people will find it clearer to see […]
dbi Blog
You will find a new connectivity and drivers landing page for SQL Server with .Net, Java, Python, C++, Go and PHP languages: SQL Connectivity and Drivers – SQL Server | Microsoft Learn As you can see, you can download, have a quick start and some code samples… Let’s test on Python! When I click on […]
dbi Blog
I’m looking back on three amazing days of interesting technical insights from the SQLBits event 2025 in London. It’s actually my first time having the pleasure of attending one of Europe’s biggest data platform events and I can sincerely say, that I enjoyed every minute of interesting workshops and sessions all around Data management, Data […]
dbi Blog
Like every time with a new version of SQL Server, it’s good to see what the new configurations possibilities are for us to manage the instance. To do this, I will compare SQL 2022 and SQL 2025 using the system view sys.configurations. I begin with a count(*) to see how many differences I have: 95 […]