Tag Archives: sql server

Backing up a Certificate

Posted on February 27, 2012 by way0utwest

If you create your own certificate in SQL Server, you need to make sure that you back it up immediately. Once you start to encrypt anything with a certificate, you increase the risk that you’ll lose your data if an … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Checking Your Service Account with T-SQL

Posted on February 22, 2012 by way0utwest

Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect my test machines were mostly SQL Server 2008 or SQL Server 2012, and I hadn’t been paying attention to the … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Where’s My Backup? SQL Server Backup Issues

Posted on February 21, 2012 by way0utwest

You can cause yourself problems if you don’t know where your backups are stored, and how they are being made. It also helps to understand the defaults of how your backups are created in files. Here’s a short story to … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Where’s My Backup? SQL Server Backup Issues

Creating Your Own Certificates

Posted on February 16, 2012 by way0utwest

Did you know that you don’t need to go to Digicert or Thawte, or any other company to get a certificate to use in SQL Server? You can create your own certificate. Why you would want to do this is … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment