This particular question came up while I was delivering a workshop last week on the new features in SQL Server 2014. Since transparent data encryption has been available since SQL Server 2008, why would I still need the backup encryption feature? For one, transparent data encryption is an Enterprise Edition-only feature whereas backup encryption exists in […]
“Today’s DBAs have responsibilities that go far beyond their traditional role of data custodian.” I was reading the infographic that Idera published about their accidental DBA survey results last week and wasn’t surprised at all by the results. I considered myself an accidental DBA when I was starting out in the industry and can totally […]
In a previous blog post, I talked about Partition-Level Online Index Operations in SQL Server 2014 and how it affects high availability and disaster recovery. With more features being added in every new version of SQL Server, it’s important to understand how its implementation will affect your overall objectives. One feature that got a lot […]
“Only wimps use tape backup: REAL men just upload their important stuff on ftp, and let the rest of the world mirror it” – Linus Torvalds – I really don’t have a clue whether that quote was intended as a joke or not but that’s beside the point. If you’ve worked in the IT industry for a […]
Failing to plan is planning to fail Designing and deploying high availability solutions takes a lot of preparation and planning. Whenever I do presentations that involve demos of creating SQL Server failover clustered instances (FCIs) and Availability Groups (AGs,) I emphasize that while the demo only takes less than 20 minutes to complete, it takes […]