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,313 reads
Links and references to understand what the Query Store is in SQL Server 2016.
2015-09-28
2,796 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 Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Comments posted to this topic are about the item Lies You Should Believe -...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers