dbta

Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...
Redmond Magazine

How Telemetry Is Making SQL Server and Azure SQL Better: Part 1

In recent releases of SQL Server, Microsoft has delivered a great deal of feature enhancements and performance improvements. This rapid delivery has been facilitated by some development changes at ...
Houston Chronicle

How to Build a Query String in T-SQL

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...
Visual Studio Magazine

Next-gen SQL Projects with Microsoft.Build.Sql

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...
Visual Studio Magazine

Working with JSON in SQL Queries

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...