Welcome to the “SQL Server” category! This is your hub for all things related to Microsoft’s premier database management system. As an experienced database administrator with years of hands-on experience in managing Microsoft SQL Servers, I’m your guide in this category. We will delve deep into the various aspects of this powerful DBMS.
In our articles, you’ll find comprehensive information about SQL Server installations, configurations, best practices, and performance optimizations. We will also explore the integration of Azure SQL, covering techniques for connectivity, secure operation, and efficiency maximization.
We’ll address critical topics such as database management, security considerations, and automation using PowerShell and dbatools. Moreover, we’ll discuss real-world challenges and their solutions to assist you in tackling your SQL Server issues.
Our content is practical and enriched with technical details. We provide references to official Microsoft documentation and offer guides and recommendations based on best practices.
Dive into the world of SQL Server with us, expand your knowledge, and stay up to date with the SQL community.
Actually, I should have written this post years ago 😉 to shed light on the history or the genesis of this blog. But as the saying goes … it’s never too late. At that time, I took my first initiatives and activities with the German SQL Server community, attended the first events, and made the…
Any one of my customers has asked, or should have asked, “do I need a certain level of high availability for my SQL server or one of my SQL servers?” Regrettably, these deliberations often come to a halt when it comes to the budget… Naturally, such HA-solutions are more expensive, and depending on the solution…
A customer had asked me the last few days to help him optimize a SQL server on an Azure VM. The customer always had slight performance problems with this SQL server, so he first asked the application manufacturer or supervisor, but they didn’t want to or could help. The only answer they received was that…
Yesterday I was able to give my speech as part of DataSaturday #6 in Malta. It was about changes in the life of a DBA when he is confronted with the fact that his SQL servers and/or databases should be migrated to the Microsoft Cloud Azure. With this session, I wanted to minimize the fears…
Now I had to fight with a previously unknown “login not possible” problem: Error: 17832, Severity: 20, State: 8 on a SQL Server 2008 R2. Also, the error message in the SQL server log I had not seen so far, let alone heard of it. The login packet used to open the connection is structurally…
In the last week, I installed several SQL Servers for one customer and had to install and configure them all identically. What is closer here than to do this with a Powershell script, so I made the “effort” and the individual steps of the SQL Server configuration with dbatools to realize. I do not want…
