SQL Server 2016

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.

2015-12-14

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.

2015-12-04

4,278 reads

Blogs

Daily Coping 11 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using DBCC CLONEDATABASE to create a schema only copy of your database.

By

DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...

VS Live Microsoft HQ Slides and Code

By

Thanks to everyone that attended my sessions today at VS Live. I have my...

Read the latest Blogs

Forums

SSIS Running From SQL Job Fails - Most Of The Time

By AMCiti

I have three SSIS packages created in Visual Studio 2019, going against a SQL...

Grand total of the sum of a field taking another field

By JeremyU

Hello everyone, I am trying to calculate the field called "Load weight". The calculation...

query

By adisql

Hi, Trying to Create a query that will execute on the current database and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers