News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
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
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
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
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
Well, this blog is unfortunately reserved to DBA folk running Oracle engineered systems #Exadata, #ExaCC, #ExaCS and Oracle Multitenant database (aka. CDB) architecture. One of our #ExaCC customer has a strong DevOps focused business and heavily relies on Exadata sparse clones to quickly provision “lightweight” database clones for their development teams. As part of the […]
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 […]
dbi Blog
Backup operations can increase significantly I/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.For the time being, supported backups on a secondary replicas are: So we cannot […]
dbi Blog
Introduction SQL Server 2025 introduces a new algorithm for backup compression: ZSTD. As a result, SQL Server 2025 now offers three solutions for backup compression: In this blog, we will compare MS_XPRESS and ZSTD. Environment To perform these tests, the following virtual machine was used: Additionally, I used the StackOverflow database to run the backup […]
dbi Blog
For a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is usually easy to setup and configure and all you need are the client libraries (for Db2 in this case). But […]
dbi Blog
Introduction The arrival of SQL Server 2025 introduces the Standard Developer edition, allowing companies to deploy across all development, quality and testing environments using an edition equivalent to the Standard Edition without having to pay the associated licensing fees. Here are the different editions available in SQL Server 2025: What problem does this solve? Some […]
dbi Blog
I had the chance to attend SQLDay 2025 in Wrocław, one of the largest Microsoft Data Platform conferences in Central Europe. The event gathers a wide range of professionals, from database administrators to data engineers and Power BI developers. The first day was fully dedicated to pre-conference workshops. The general sessions are scheduled for the […]
dbi Blog
After a packed workshop day, the SQLDay conference officially kicked off on Tuesday with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more. Here is a short overview of the sessions I attended on the first day of the main conference. Morning Kick-Off: Sponsors and Opening The day started with a short […]
dbi Blog
This is a short blog post to share that the SQL Server 2025 public preview is now available for download. At the same time, SSMS 21 has also been released and is now generally available. The LinkedIn post by Bob Ward announcing the news can be found here: Announcing SQL Server 2025 Public Preview In […]
dbi Blog
As PostgreSQL 18 Beta 1 has been released (link) and is packed with lots of cool features like improved IO on reads for example, I wanted to test out the new pg_createsubscriber and pg_upgrade options and how they are going to help us performing smoother major upgrades using the “blue-green” migration similar to the ones […]
dbi Blog
After the “Welcome 3rd Day APEX Connect, DOAG e.V.”, and the very entertaining Keynote “Trouble in the Old Republic” by Samuel Nitsche, I decided to attend presentations on following topics:– 23ai – Building an AI Vector Search API using APEX, ORDS, REST and PL/SQL– APEX in Style – Ein Überblick über die verschiedenen UI-Customizingmöglichkeiten– SQL […]
dbi Blog
This year I can unfortunately only attend APEX Connect for 2 days, starting on Day 2 of the conference. Conference is hosted in the famous EuropaPark.The Day has started with the traditional 5K run (which ended up to be 5.8 km in fact) to wake-up the body with fresh air and nice sunshine. After the […]
dbi Blog
( note: I am writing this as member of the pgconf.de organization team, and not as a dbi services employee ) After almost half a year of planning and preparation PostgreSQL Conference Germany 2025 finally took place last week in Berlin. It was in the same hotel as the 2022 edition of PostgreSQL Conference Europe […]
dbi Blog
The last day of the M-Files IMPACT Global Conference 2025 was dedicated to M-Files partners only. Throughout the day, M-Files shared partner-specific information and hot news. Below is a summary of the main topics. Keynote In the Keynote session they emphasised theuir continueing support of their partner network. In addition, to that they shared the […]
dbi Blog
The second day of the M-Files IMPACT Global Conference 2025 commenced at 9 am with a keynote session. On this occasion, the key note was entitled ‘Unlocking the Future of Business’. The Future of AI: Unlocking New Opportunities and Navigating the Challenges Ahead’The importance of AINO was emphasised, especially the automatic filling of metadata. Keynote […]