Stéphane Haby

Green SQL Server DBA Tips #3 – The hidden cost of forgotten databases

How many times have I found, during a migration, that I also have to clean up the databases no more used?Why keep them for so long if we’re not going to use them? This is something we often(…)

SQL Server:  msdb is in Suspect State

This Monday morning, we begin our SLA Support with a customer call.He cannot do a select on a table in his database… After creating the Ticket, I connect to the instance and see that the msdb system(…)

Green SQL Server DBA Tips #2 – When logs and history records cause your database to growth and crash

How often do I come across this sort of problem when visiting clients? Even more with our customers’ service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying(…)

Green SQL Server DBA Tips  #1 – Are unnecessary indexes cluttering up your database?

This summer I start a series of blog posts on the ‘green SQL Server DBA’, as it’s a topic that continues to interest me and one that hasn’t been covered very much so far. I hope you’ll enjoy my(…)

SQL Server’s LinkedIn Posts catch-up!

You may not have followed all my posts this summer about what we are doing with Microsoft SQL Server technology and the BI stack like Power BI and Azure Data Fabric. So, I thought I’d write a little(…)

SQL Server: Do you know how to use SERVERPROPERTY()  function in a useful way?

The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it’s good to come back to basis… How to begin? Read the documentation of course here but you(…)

SQL Server: New SQL Server Management Studio (SSMS)  landing page

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

SQL Server 2025: Local SQL Server Container – Schema design preview

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

SQL Server 2025: Local SQL Server Container – Schema compare preview

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

SQL Server: New connectivity and Drivers landing page

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