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

8) Don't Rename Script-Based Objects You'll often create a script-based object, such as a view, a stored procedure, or a user-defined function. SQL Server then stores the script that created the ...

In-Depth Top 7 Features Coming to SQL Server 2016 SQL 2016 has a number of major enhancements which will help whether or not you are implementing on-prem, in Azure or in a hybrid model. By Joey D ...

Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...