SQL Server 2016

External Article

The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs

  • 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.


3,612 reads

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


Daily Coping 18 Aug 2022


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

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo


I’ve added a new parameter to my permissions scripts (well, just the main two...

Creating TAIL on Windows for Text Files


I wrote recently about making a HEAD utility to find the top few lines...

Read the latest Blogs


Query help

By SQL_Surfer

Here is the DDL of the table: I need single row per invoicenumber and...

TDE master key password change

By SQL_Hunt

Hello I have a requirement to change the TDE master key password in one...

Image within a Rectangle

By Jeffs1977

I am being asked to overlay text objects to a government form for a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers