SQL Server

SQL Server AlwaysOn – Failover does not work but everything is green on the cluster

Recently I was called by a customer because the failover on a SQL server AlwaysOn 2 nodes cluster does not work. I connect to the first node of AlwaysOn cluster who is the primary and check the cluster with the(…)

dbo vs. db_owner in SQL Server – What are the differences between them?

During the last years working with customers and teaching them in security topics, I realised that a lot of DBAs are not familiar with or aware of the differences between the two “owner” existing in SQL Server. That’s why I(…)

Automate your Deployments in Azure with Terraform!

Terraform is a strong open-source declarative and platform agnostic infrastructure as code (IaC) tool developed by HashiCorp. It facilitates the deployment and whole management of infrastructure. In this hands on blog I will show you how you can use Terraform(…)

Help yourself out with the ‘log_reuse_wait_desc’ column

A few days ago a customer called me to ask if I could help him with a problem with the log file. He tried to shrink it, but the system wasn’t doing anything and he didn’t know why. With the column(…)

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(…)