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.
If you’re working with a table where data is constantly being inserted, updated, or deleted, you’ve probably encountered the problem: performance degradation due to index fragmentation and inefficient execution plans. I often see indexes in place but not used optimally. In this post, I’ll show you what to look out for when indexing frequently changed…
Introduction Date functions in SQL are powerful tools, but they are also one of the most common sources of errors in database queries and applications. Database administrators (DBAs) and developers frequently encounter issues with processing, storing, and converting date values. These problems often lead to inconsistent results, performance issues, or even data loss. In this…
In case you missed it: As of February 28, 2025, SQL Server 2019 is no longer in mainstream support. That means no more functional updates or performance improvements – just security patches. If you’re still running SQL Server 2019, here’s what you need to keep in mind. What does this mean for you? No need…
There’s exciting news from Microsoft that specifically affects data management and provisioning. The SQLPackage tool, already indispensable to many of us, has received an impressive update. With preview support for extracting and publishing data stored in Parquet files in Azure Blob Storage, it opens up a new world of possibilities for managing data in Azure…
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…
