A common criticism for SQL Server’s security model is that it only understands tables and columns. If you want to apply security rules on a row-by-row basis, you have to simulate it using stored ...

CS codes first appeared on the MS SQL Server in 2012. The basic idea was to store the data grouped by columns rather than by rows.

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

Using MS SQL Server, is there a way to query all of the tables in a database for a specific column name?Thanks,Pete ...

About the Author Eric Johnson, SQL Server MVP, is the owner of Consortio Services in Colorado Springs providing IT systems management and technology consulting.