News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
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
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
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
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
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 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
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
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
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
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
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
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
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
Microsoft has announced the end of the SQL Server Reporting Services (SSRS) service. In other words, Microsoft will no longer provide new versions of SSRS. Currently, the latest available version is the 2022 version (https://www.microsoft.com/fr-FR/download/details.aspx?id=104502). However, it is important to note that this service will be supported until January 11, 2033. Moreover, it will still […]
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 […]
dbi Blog
This week, I’m in London attending the SQLBits 2025 conference.Since joining dbi services as a consultant, this is my second time taking part in the event. The last time was in 2022, but I attended remotely due to the uncertainties surrounding international travel at the time, as COVID-19 was still a concern.You can actually find […]
dbi Blog
Once upon a time in IT project land What an achievement, it’s been a good while your team is working on a huge project and it’s finally completed. All related documentation is well registered and managed into your knowledge workers enterprise content management, M-Files. Time to get some rest and move on other tasks. Hence […]
dbi Blog
SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog “SQL Server 2025 Public Preview and SSMS 21 now available“.In this blog, I want to make an highlight on one Engine High Availability (HA) feature: Availability Group Commit Time. For a little background, Always […]