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.
2016-02-02
3,545 reads
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.
2016-01-06
4,919 reads
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
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
Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.
2015-11-19
4,175 reads
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.
2015-11-16
5,348 reads
Links and references to understand what the Query Store is in SQL Server 2016.
2015-09-28
2,831 reads
Denzil Ribeiro looks at how SQL Server 2016's new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance significantly.
2015-09-08
3,007 reads
Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. Tim Radney introduces Stretch Database by looking at the applications and limitations of the new feature.
2015-08-28
5,395 reads
Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.
2015-08-07
5,485 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers