Stéphane Haby

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

SQL Server: Last duration for all SQL Server jobs in TIME format from HHmmss to HH:mm:ss

For a customer, I want to see all last duration for a job and have a good format for it. The query to do it is very simple (at the beginning…) but when I try to have a better(…)

SQL Server: msdb too big with the table dbo.sysmaintplan_logdetail

Today, I was by a new customer and the I see that the msdb data file was over 4GB. A little too big… To see which table are so big, in SSMS, I select the msdb database, right-click, go in(…)