My primary goal for 2018 Q1 (what I'm working on when I'm not doing the obligatory day to day DBA stuff) is to learn the basics of Cosmos DB, identify...

TDE will impact compression of backups, because backup compression is applied on top of encrypted data. However, TDE has no effect on table and index compression, because TDE is applied...

So, if there happens to be 50 scripts sitting in that folder, then all 50 will be executed starting at the same time? This sounds like it's intended to be...

Jeff, you should run for president (of the American National Standards Institute).

It's different paradigms, but we have to make choices about which paradigm is most appropriate for the given environment and application. Regarding Always Encrypted, maybe one day someone will invent an...

... A contractor just pleaded guilty to stealing classified information from the US National Security Agency, about 50GB worth of data. This isn't a case of spying or malicious intent....

Another difference between FDE and TDE is who owns the process and controls the keys: the local server admin or the database administrator. Depending on the IT organization, this could...

Based on replies above, I'd like to add a couple of things. It's true that enabling TDE on one database will result in SQL Server also encrypting TEMPDB, but that's...

I use tool on my personal PC to keep tabs on disk space allocation by folder. It would help in your case too.
https://jam-software.com/treesize_free/

Where I work, we've started implementing SQL Server TDE, which I believe has many advantages over FDE (Full Disk Encryption) solutions.

TDE:
- Is free with the SQL Server...

1. Easy 5 minute fix to get you out of the red: Run a tool to identify temp files, recycle folder, download folder, and other stuff that can be deleted...