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.
At times, specific topics come together simultaneously. In this case, several emails were received from the Data Platform MVP distribution list, and various customer reports and suitable posts in other blogs were found on “how DatabaseMailUserRole stops your patching,” so a German contribution was made to this. It’s about a bug that has appeared in…
Today the time had come – I was finally able to speak at Data Saturday (formerly SQLSaturday) in Oslo … that was finally not due to the organizers but rather to me or the pandemic, since I hadn’t dared to give lectures until 2020 Keeping English, I hadn’t submitted any sessions for Oslo either. I…
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…
