Live Query Statistics in SQL 2014, not just SQL 2016

One of the coolest things in SQL Server 2016 is Live Query Statistics (LQS). But did you know that it’s available in SQL 2014? (Edit: Needs SP1) The thing is that we haven’t been able to view it effectively before now, before SQL Server Management Studio 2016 became available. LQS provides the ability to watch … Continue reading Live Query Statistics in SQL 2014, not just SQL 2016

Can you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

Yes. #ShortestPostEver @rob_farley    Oh, ok… I’ll explain some more. Transparent Data Encryption encrypts data at rest. That’s the stuff that’s on disk – the encryption happens when the data is written to disk, and the decryption happens as the data is loaded into RAM from the disk. The engine handles this so that it’s … Continue reading Can you still use DBCC PAGE to access data in dropped tables if TDE is turned on?

Always Encrypted with SQL 2016

Transparent Data Encryption has been around for some time now, making sure that data in SQL Server as stored on disk is encrypted. When it was announced, this was incredibly exciting. You see, by default, SQL Server data is not encrypted. If you open up the pages within a data file, you can read the … Continue reading Always Encrypted with SQL 2016