Tag Archives: sql server

Where’s My Certificate Backup?

Posted on August 16, 2012 by way0utwest

If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner, and if I need to move the instance somewhere else, all my code works. No pathing issues. A certificate backup … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Where’s My Certificate Backup?

T-SQL Tuesday #33 – Trick Shot

Posted on August 14, 2012 by way0utwest

It’s T-SQL Tuesday time again, and this is my post for #33. The host is Mike Fal and his topic is Trick Shots, which is an interesting one. I’m not a tricky guy, and I tend to lean towards common, … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

The Copy Cat Poll

Posted on August 3, 2012 by way0utwest

One of the interesting facts I saw a few years ago talked about storage in enterprise environments. There was research that showed many enterprise applications had 6 or 7 copies of their large databases inside the organization. In addition to … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Copy Cat Poll

Startup Jobs

Posted on August 2, 2012 by way0utwest

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you can run a job when the Agent starts? I haven’t often used this, but there are cases where it was … Continue reading →

Posted in Blog | Tagged , | 2 Comments