Database troubleshooting is not for the faint of heart, especially when it comes to troubleshooting locking and blocking problems. Sometimes the elephant in the room is actually a rhino, a problem ...

In SQL Server 2005, Microsoft introduced the Upgrade Advisor. This was a great idea to be able to analyze your current SQL Server in a safe environment and start the planning process of an important ...

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

This week we will discuss how to troubleshoot different assembly errors that we get while troubleshooting installs for SQL Server. I’ll focus this article more on SQL Server and Windows systems.

Microsoft complements its relational database engine, SQL Server, with several add-on services that manage different aspects of enterprise business intelligence and information processing such as data ...

Lansweeper has issued a stark warning to enterprise administrators regarding the looming issue of outdated Microsoft SQL Server instances. Company Chief Strategy Officer Roel Decneut revealed (via The ...