SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

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 ...