SQL Server 2016

Article

The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.

2016-02-09

3,612 reads

Exploration of SQL Server 2016 Always Encrypted – Part 3

by Additional Articles

SQLServerCentral

SQL Server 2016

Article

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-02-08

3,437 reads

Data security, SQL Server 2016, and Your Business

by Additional Articles

SQLServerCentral

SQL Server 2016

Article

From an IT infrastructure and compliance perspective, the importance of protecting data is clear. But it also has profound business implications and can even be a competitive differentiator by helping drive customer loyalty and retention. David Hobbs-Mallyon talks about Microsoft’s approach to data security.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-02-02

3,545 reads

Exploration of SQL Server 2016 Always Encrypted – Part 2

by Additional Articles

SQLServerCentral

SQL Server 2016

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2016-01-06

4,919 reads

Exploration of SQL Server 2016 Always Encrypted – Part 1

by Additional Articles

SQLServerCentral

SQL Server 2016

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-12-14

3,661 reads

The SQL Server 2016 Query Store: Overview and Architecture

by Additional Articles

SimpleTalk

SQL Server 2016

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

Installing SQL Server 2016

by Additional Articles

SQLServerCentral

SQL Server 2016

Article

Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2015-11-19

4,175 reads

SQL Server 2016 Stretch Database

by Suresh Yaram

SQLServerCentral.com

SQL Server 2016

Article

SQL Server 2016 brings a new feature called Stretch Database, which allows a database to keep transactional data on local instance and warm and cold data on the Azure SQL database platform.