SQL Server 2016

External Article

Exploration of SQL Server 2016 Always Encrypted – Part 2

  • Article

It is important to only allow authorized individuals access to confidential data. Therefore when setting up an Always Encrypted table it is important to consider splitting configuration tasks between multiple individuals/groups to improve security. Follow Greg Larsen as he shows how to setup up SQL Server Always Encrypted tables where database administrators can’t see the clear text confidential data.


4,919 reads

External Article

Exploration of SQL Server 2016 Always Encrypted – Part 1

  • Article

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. In this article, Greg Larson explains his experience with exploring setting up a table that stores always encrypted data.


3,661 reads

External Article

The SQL Server 2016 Query Store: Overview and Architecture

  • Article

SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be the most significant enhancement of SQL Server 2016 - Enrico van de Laar explores.


4,278 reads

External Article

Introduction to SQL Server 2016 Temporal Tables

  • Article

Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.


5,485 reads


Using Data Masker on Chinese Surnames


A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft


looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Using ChatGPT for Writing


I have been experimenting more and more with ChatGPT on a regular basis. I’m...

Read the latest Blogs


MSSQL Service Broker DSQL operation on another database causing Broker failure

By andyewx

I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...

Validating Password Expiration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Validating Password Expiration

Extracting multiple fields from one column

By JeremyU

    Hello, I have a situation. I am trying to show each  distinct...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers