Our Blog category is the central hub for all enthusiasts of Microsoft SQL Server and database administration. Here, you’ll find a wealth of informative articles authored by an experienced database expert for Microsoft SQL Server. Dive into the world of databases, best practices, and proven techniques to help you operate your SQL Server instances more efficiently and securely. We cover topics such as configuration, performance optimization, high availability, and Azure SQL. Our articles are rich in technical details and guides, accompanied by helpful images and screenshots. Whether you’re just getting started in the realm of SQL Server administration or an experienced DBA, our blog has something for everyone.
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…
Yesterday, I had the opportunity to speak at the Cloud Summit, an international community event, about Azure Arc-enabled Data Services. Specifically, I focused on operating an Azure SQL Managed Instance in your data center. As I previously did at DataSaturday #14 in Oslo, I began my presentation by discussing the various options of Azure Arc….
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…
Exploring the Data Geeks Community in South Florida On a warm and inviting Saturday, I delivered another presentation, this time in beautiful South Florida, to the Data Geeks community. This event marked the eleventh year of their “SQL Saturday,” drawing around 700 in-person participants passionate about all things related to the Microsoft Data Platform. These…
I see the other contributions as a personal refresh of my knowledge of the Azure SQL Database and all its numerous features. After a long time, it was necessary to deal with it in detail again and show my own experience with learning that “writing down” helps remember the content and essential points. So I’ll just…
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…
