Stéphane Haby

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

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

SQL Server: how do monitor SQL Dumps?

Few weeks ago, we had a big issue by a customer and a lot SQL Dumps was created in the SQL Server log folder. After playing fireman at the customer’s premises, we decided to set up a monitoring system for(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

SQL Server Security: Ensure that SQL Server service accounts are not a member of the Windows local Administrator group

These last few weeks, I work on a project to check the compliance of an instance with the Center for Internet Security (CIS) document. The Benchmark documentation provides prescriptive guidance to secure SQL Server and I develop a tool(…)

PosgreSQL + SQL Server = WiltonDB – Part 1 – Installation

I know,  few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that I write(…)

SQL Server: How to shrink the T-log file for a lot of old user-databases

Recently I have the case that a customer has a lot of databases not more used but need to be accessible at any time. In this case, we had a lot of T-log with the size when there are used(…)

SQL Server Tools: First steps with go-sqlcmd tool on Windows Server 2022

As you know, with the new version of SSMS since the version 18, the tools like sqlcmd are no more included in the installation. You need to download separately the tools that you need here Few months ago, Microsoft(…)

SQL Server Tips: CMS – Connection Error: -2146893019 Severity: 20

Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection test:(…)