THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » Disaster Recove... » Administration   (RSS)
  • Backup those keys, citizen

    Periodically I back up the keys within my servers and databases, and when I do, I blog a reminder here. This should be part of your standard backup rotation – the keys should be backed up often enough to have at hand and again when they change. The first key you need to back up is the Service Master Key, which each Instance already has built-in. ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 20, 2010
  • Cluster Nodes as RAID Drives

    I'm unable to sleep tonight so I thought I would push this post out VERY early. When you don't sleep your mind takes interesting turns, which can be a good thing. I was watching a briefing today by a couple of friends as they were talking about various ways to arrange a Windows Server Cluster for SQL Server. I often see an ''active'' node ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 25, 2010
  • Have you backed up your keys lately?

    Did you know that you already have a Server Master Key (SMK) generated for your system? That’s right – while a Database Master Key (DMK) is generated when you encrypt a certificate or Asymmetric Key with code, the Server Master Key is generated automatically when you start the Instance. So you should back all of those keys up periodically, and ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 1, 2010
  • Plan and Prepare or Just Do It? How about Both!

    I'm kind of a type ''A'' person. OK, I'm a VERY type ''A'' person. I even cook by setting things up ahead of time. I'm definitely more in the ''Plan and Prepare'' camp than the ''Just Do It'' camp. But I do realize that there are times when you just can't stop and prepare. Sure, it would be great to know that server is going to melt down just ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 7, 2010
  • The Dark Sides of Consolidation

    Consolidation, as it applies to databases, is simply putting more databases or SQL Server Instances on less hardware. This is a good thing, normally, because it allows you to save on hardware costs and use what you have at it’s highest capacity. It also saves on energy costs, floor and rack space, and in some cases even licensing and ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 10, 2009
  • Knowledge is how you break the rules

    Last night I had to do something on a production system that you're not supposed to do. It's not important what I did or where I did it, but I will explain why I did it. A friend was in a situation where it was either ''break the rules'' or lose the system. So I did what I had to do, with lots of caveats and explanations on why ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 8, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement