It's not so much about allowing people to "fail" as it allowing people to experiment. Small controlled failures are intrinsic to the experimentation process and learning, not just in IT and...

As database administrators and developers, it's our job to keep the innovation bandwagon headed in the right direction. We should not simply jump on the back of the bandwagon. There...

Innovation should solve a problem or add value to an existing solution. Sometimes engineers and marketers forget that.

This story is perhaps the most cringe-worthy of all IT...

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...