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.
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 and now we can really shrink and have some place on the disk. I don’t precise but it’s very important…
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 announces the replacement of the “old” sqlcmd with a new version called go-sqlcmd. This new version includes all parameters from the…
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: ERROR Message: A connection was successfully established with the server, but then an error occurred during the login process. (provider:…
First, a little explanation about TLS, DTLS & SSL: We can find 3 versions of SSL (1.0,2.0 & 3.0) and 4 versions of TLS (1.0,1.1,1.2 & 1.3) actually. Even if some protocols are deprecated or no more used, it’s good to verify. TLS 1.0 is available for Windows Server 2008 and more TLS 1.1& 1.2 is available from Windows Server…
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 Laporte D4B2 – HYDRA – Unleash the testing of your CI/CD pipelines for SQL Server deployments in Azure DevOps – Advanced – Kevin Chant…
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 Mahajan D3B2 – KATMAI – Extent and Page Management in Microsoft SQL Server – Expert – Torsten Strauß D3B3 –…
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 & Ajay Jagannathan D2B2 – HYDRA- SQL Server 2022 IQP Deep Drive – Advanced – Kate Smith, Derek Wilson &…
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, welcome to the lobby! Going to the rooms: After selecting your session, you select the room name and you start!…
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 Tuning Magic Show yesterday & today. It’s every time good to do a refresh and learn about the performance and tuning. It’s good to have…
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 say: Ledger helps streamline audits, providing cryptographic proof of data integrity to auditors. Ledger is also a protection of the…
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 query…. The CIS (Center for Internet Security) provides guidance to secure SQL Server. One of the points is to ensure…
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 view it was more complicated. Let me try to explain you. As you now, to have the history of all jobs…
