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

SQL Server 2016 adds new support for the JSON format when retrieving rows from a database ... after FOR JSON AUTO. This example returns multiple customers inside an object called Customers: If you’d ...

There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides ... the use of a primary key column. The WHILE loop example performs 31130 logical ...

Here are two more in the works to think about: dynamic data masking and row-level security. In the case of these two features, they’ll be released first to the cloud platform (Azure SQL Database) and, ...