Why SQL 2016 rocks – the series (part 2)

The second post of the series will be covering all those “small” scalability improvements in the SQL core, that help you run your workloads with even better performance just by upgrading to SQL Server 2016. The following articles are coming from the CSS SQL Server engineering team and its under the “It just runs faster”…

0

Permissions required to run Query Store in SQL Server 2016

If you wondered what is the minimum permission set you need to have in order to use Query Store in SQL Server 2016, then here is the answer: you need VIEW DATABASE STATE. I tried overcoming it by giving read permissions to all the stored procedures, DMVs and DMFs but to be honest – I…

2

Listing encrypted columns–AE learning series part 03

In the first two parts (part 1, part 2) we learned how to build our first application using Always Encrypted and import new or existing data in it. In the following post I want to give you some details on the available metadata for Always Encrypted. There are some changes in existing DMVs (such as…

0

Encrypting existing data – AE learning series part 02

In the first post of the series we built our first application with Always Encrypted infrastructure. Now it is time to insert some data and the options are not that many. Because the AE is only supported by ADO.NET connections, you must use a tool that supports it, therefore you can use: Use SSMS Encrypt…

0

Build your first app with SQL 2016 Always Encrypted – AE learning series part 01

Dear reader, this is the first post of a learning series I decided to compile over the Christmas Holidays. I am working on one of my first implementations on AlwaysEncrypted and as a new technology, we, as SQL guys, need to pump-up our knowledge and share what we found along the way, especially if it…

0