Browse by Tags

• Administration
• Best Practices
• 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