Browse by Tags

• Administration
• Best Practices
• Documentation
• Error Codes
• Help
• Maintenance
• Maintenance Plans
• Process
• Security
• SQL Server
• Tips

• 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 Read More... Posted Tuesday, April 20, 2010 6:14 AM by BuckWoody | 1 Comments Filed under: Administration, Best Practices, DBA, Disaster Recovery, Maintenance, Maintenance Plans, Security, SQL Server, Tips

• 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 Read More... Posted Monday, March 01, 2010 7:06 AM by BuckWoody | 4 Comments Filed under: Administration, Best Practices, DBA, Disaster Recovery, Maintenance, Maintenance Plans, Security, SQL Server, Tips

• 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 Read More... Posted Thursday, January 07, 2010 8:56 AM by BuckWoody | 0 Comments Filed under: Administration, DBA, Disaster Recovery, Error Codes, Help, Process, SQL Server, Tips

• 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 Read More... Posted Thursday, December 10, 2009 6:56 AM by BuckWoody | 6 Comments Filed under: Administration, DBA, Disaster Recovery, Documentation, SQL Server