Latest from the Blog
Every SQL Server install includes the sa login as a sysadmin. This can be good for consistency; however, that also makes it a prime target for attackers trying to get into your SQL Server. That is one of many reasons why you should make the following changes to protect your sa login from being used … Continue reading Changes for sa Login Safety
You setup TDE for your database. Great! Now you need to restore that database to a different server. Maybe you’re migrating off of an older server or maybe there is testing to be completed for an upcoming release. If we try to backup/restore or attach the database on a different server we’ll get some variation … Continue reading Restoring a TDE Database to a Different Server
Transparent Data Encryption (TDE) has been a topic of conversation recently and I felt like it would make a good post. What is TDE? TDE is all about encrypting data at rest. If you are in a situation where you’re only worried about encrypting one column or a few columns in a database table, Always … Continue reading Setting up Transparent Data Encryption (TDE)
Get new content delivered directly to your inbox.