Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, ...

For a wholly numeric one, the kind is 1; for other ones, it's kind 2. When retrieving data that you want to sort, order by the kind of serial, then the serial - e.g. SELECT * FROM tblFoo ORDER BY ...

Code Focused Deleting All Data from a SQL Server Database There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, ...

Ok. I have some tables that store dollar amounts, among other data. I had the fields set to be a data type of money, and was planning on the values including zero. When selecting the data, I was ...