Tag Archives: administration

Test Your Restores

Posted on December 11, 2012 by way0utwest

I was talking with someone the other night about their database systems and they mentioned they had implemented TDE (Transparent Data Encryption) to comply with HIPAA regulations. This person had verified that they were backing up the Database Encryption Key, … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Test Your Restores

The Default DBA

Posted on December 4, 2012 by way0utwest

When we setup SQL Server, there are a few choices we need to make, some of which require a few items be prepared in advance. Service accounts are one of those preparation tasks that DBAs usually perform in advance of … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Default DBA

The Last DBCC CHECKDB Date and Restores

Posted on November 28, 2012 by way0utwest

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For those of you that don’t know this, you can run this command on your instance (in a database) DBCC DBINFO … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

The Cost of Storage

Posted on November 16, 2012 by way0utwest

One thing that we can be sure of as data professionals: we will need more storage over time. We gather more data in our organizations and more data is sent to us by partners or automated systems. At the same … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Cost of Storage