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


Flying Halfway Around the World to Australia


I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources


As I look at the state of information technology today, I see one constant:...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance


I recently started full time learning of Amazon Web Services (AWS). I found that...

Read the latest Blogs


insert duplicate records with new timestamp

By Tara-1044200

how can i insert records from a transaction table into a transaction table with...

Performance benchmarking tools for SQL Server

By MichaelT

Are there any performance test tools that can check the performance of a SQL...

Backing up and Restoring a 3 terabyte database takes over 5 hours

By ericwenger1

I have a 3 terabyte database that is taking over 5 hours to backup...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers