Stéphane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.
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 configurations for SQL 2022 and…
Few days ago, through our alerting at the Service Desk, we receive an alert about a database in an AlwaysOn cluster with the message: CRITICAL: Database xxxx [replica: xxxxxx] [role: SECONDARY] state is SUSPECT, synchronization health is NOT_HEALTHY, synchronization state is NOT SYNCHRONIZING [suspended: true] [failover ready: false] [joined: true] After creating the ticket, I go to the environment and…
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 Failover Cluster Manager. Nothing tells us that it is not working. All is green! It’s a good point! I connect…
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 customers… After downloading the file vs_SSMS.exe (4,3 MB), start the file to doanload and install it. For the installation, you have…
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… Difficult to choose the session between this lot of choice and so interesting. I will share with you my experience on this…
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 log4net:exception and without more explanation: For the migration, I perform a backup/restore, the collation on both servers is the same…
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 test… The version of SSMS is 18.12.1 and it’s a version coming out the 21.06.2022… It’s the last version before…
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 like usual and waiting…. After ~15 minutes, I don’t know how much time I need to wait until it’s finished……
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 the creation of SQL dumps. The first step, is how to test it? In the latest version of SQL Server…
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 test now by SSMS GUI: As you can see, only the T-SQL Command script can be used. After the creation, I…
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 to do a security audit automatically following these recommendations. On the Authentication and Authorization Chapter, you have three sub-chapters: These three…
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 a blog about PostgreSQL but also SQL Server… My first one in 10 years by dbi services but it’s good to…