Stéphane Haby

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

SQL Server: How to see your enable security protocols (TLS/SSL/DTLS) with a TSQL Query?

First, a little explanation about TLS, DTLS & SSL: TLS is Transport Layer Security. It’s a cryptographic protocol to provide communication security over the network. DTLS is the abbreviation of Datagram Transport Layer Security. It’s also a cryptographic protocol providing(…)

Data Platform Virtual Summit 2022 –  Day 4 – Focus on Azure SQL Managed Instance

Today the Data Platform Virtual Summit begin at 09:30 am with the keynote: Creating a Data Culture… My schedule for the day: D4B1 – SPHINX – Configure SQL Server for efficient troubleshooting – Intermediate – Christophe LaporteD4B2 – HYDRA –(…)

Data Platform Virtual Summit 2022 –  Day 3

Today the Data Platform Virtual Summit begin at 06:00 am for us…It’s in our time offset, this time better to wake up! 😉 My schedule for the day: D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay(…)

Data Platform Virtual Summit 2022 –  Day 2

Today the Data Platform Virtual Summit begin at 03:30 am for us… It’s a little bit early but better than yesterday. My schedule for the day: D2B1 – HYDRA – Overview of SQL Server 2022 – Intermediate – Bob Ward(…)

Data Platform Virtual Summit 2022 –  Day 1

Today the Data Platform Virtual Summit begin at 00:30 am for us… It’s a little bit early but when we like our work and like to learn, we stay up with plaisir. My schedule for the day: After the login,(…)

Data Platform Virtual Summit Pre-con 2022

Thanks to dbi services to let me the opportunity to follow this week and next week, the Data Platform Virtual Summit beginning with the Pre-con. I subscribe the session of Guy Glantser about The Performance(…)

SQL Server 2022 security: Do you know Ledger?

You probably hear or view that on the security point of view, the next version of SQL Server: SQL Server 2022, has a feature named Ledger. It’s already used in Azure but what is Ledger? In 2 points, I will(…)

SQL Server Security: Check if the guest is active on all user-databases through the CMS

Today, a customer asks me to have look on each SQL Server instance to control if the user-database Guest is active or not. The easiest way is to go through the CMS (Central Management Servers) with a query but witch(…)