Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

The movement towards data-driven business requires sophisticated capabilities incorporating robust, scalable, and adaptable databases. When Microsoft announced Linux platform support for SQL in 2017, ...

Microsoft has a lot of database pilots and projects in the works, among them Katmai, Astoria, Jasper and Volta. But how do they all fit together? Francois Ajenstat, director of SQL Server, explained ...