Gregory Larsen

Have you ever wanted an easier way to provide security at the record level? If so, well now you can easily do this with the Row Level Security feature that is being introduced with SQL Server 2016.  In this article I will introduce you to how easy it is to use this new feature as […]

In my last article I introduced you to Dynamic Data Masking: https://www.databasejournal.com/features/mssql/exploring-sql-server-2016-dynamic-data-masking-part-one-creating-a-table-that-uses-dynamic-data-masking.htm.  In that article I show you how to create and populate a table where you wanted to mask one or more columns.  In this article I will continue on and explore some of the other aspects of using the Dynamic Data Masking feature […]

In this article about exploring SQL Server 2016 features I will start investigating a new feature known as Dynamic Data Masking. By using data masking you can obscure the real value of a data column with a masked value.  In this article I’ll be exploring the different features of how to hide the value of […]

As with most new technology it is not only intended for new development, but it is also targeted at fixing existing issues with current applications.  This is also true with the new SQL Server Always Encrypted feature.  In my “Exploring SQL Server 2016 Always Encrypted” series so far I’ve only shown how to create new […]

In my last article (Exploration of SQL Server 2016 Always Encrypted – Part 1) I discussed how to setup and use the new SQL Server 2016 Always Encrypted feature, and the problem I had with restricting access from Database Administrators.  In this article I will expand my exploration of Always Encrypted.  I will explore the […]

With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted.  With Always Encrypted, data is encrypted at the application layer via ADO.NET. This means you can encrypt your confidential data with your .NET application prior to the data being sent across the network to SQL Server.   […]

The installation process for SQL Server has changed slightly with the release of SQL Server 2016.  You now have a couple of new installation options available when you install SQL Server 2016.  One of those new features is being able to define multiple tempdb data files while installing SQL Server.  Additionally the incorporation of PolyBase […]

There is a lot of buzz around SQL Server 2016.  Microsoft announced the release of SQL Server 2016 at the Microsoft Ignite Conference during the first week of May 2015. Since that time a number of Community Technical Previews (CTPs) have come out.  It will not be too long until SQL Server 2016 will be […]

There are times when you want to return a set of records that are based on the results of another set of records. When you have this requirement how do you accomplish this with TSQL? One method is to write a correlated subquery. In this article I will be explaining what a correlated subquery is, […]

In my last article I talked about how you could restrict the number of rows returned by using the TOP clause.  In that article all my examples where about using the TOP clause to only select data, not update data.  In this article I will explore how to use the TOP clause in conjunction with […]

There are times when you don’t what to return a complete set of records. An example where you might need this requirement would be in an inventory system when you want to produce a pick list where the stock you want to ship has the oldest manufacture dates.  When you have this kind of requirement […]