SQL Server

New SQL Server Management Studio Version 21 – First Test

Last week, at the Pass Data Summit, they announce the new version of SQL Server Management Studio: SSMS 21 You can find the preview in here. It’s a good opportunity to test this new version before installing it by(…)

SQL Konferenz 2024 – SQL Server stuff and AI

I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning,(…)

Understanding Head Blockers in SQL-Server

A customer of mine had a recurring issue with one of his business critical applications where everything was frozen and stuck for the users. The issue was caused due to a head blocking transaction which increased blocking in the database(…)

SQL Konferenz 2024 – Microsoft Copilots

Today, we followed (with Roger Schönmann) the first day of the SQL Konferenz 2024.  We will be attending this event from October 01 to 02 in Hanau. At dbi services, we are no strangers to this conference, as(…)

Coming back to the Future Data Driven Summit 2024’s Event last night

Last night, I followed with Amine Haloui the Future Data Driven Summit 2024 from 3 PM to 2 AM This event was remote and very easy to follow. One day with 5 rooms and  more then 55 speakers…(…)

SQL Server: The importance of the default language during a login migration

Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about “conversion of a varchar data type to datetime data type” on this application.The error was an(…)

“Edit Top 200 rows” does not work between SSMS 18.12.1 & SQL Server 2022

Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a(…)

Power BI – Scheduled refresh stuck

Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included.

SQL Server: Basic AG – One listener, multiple databases

Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of(…)

SQL Server Tips: How to know how long goes a shrink ?

Few days ago, I perform a shrink on a data file to spend a little bit space on a disk.The SQL Server is a test server and the customer does not want to expand the disk. I run the shrink(…)