Tag: Best Practice

• How to Back Up the Service Master Key

  

  2014-06-06 - Backup, Cryptography, General, Security

  In SQL Server the Service Master Key is probably the most important encryption entity. Because of that, it needs to be protected and backed up. Read on to discover how to take a backup of this key encryption key.

  [more…]

• How to Back Up Your Certificates

  

  2014-05-02 - Backup, Cryptography, General, Security

  Certificates are an important part of you encryption strategy and as such need to be backed up. Discover how to achieve that, by using the BACKUP CERTIFICATE statement.

  [more…]

• How to Pick a Good Password

  

  2014-04-21 - General, Security

  Do you know why you care about picking a good password and why reusing a password is a bad idea, even if you think your life is boring to a would-be hacker. Read on to discover how hackers get a hold of long lists of usernames and passwords and that a hack on a random page you might have used once can be a real threat to your online life.

  [more…]

• Betting on SQL Injection [T-SQL Tuesday #51 – Place Your Bets]

  

  2014-02-11 - General, Security, SQL Injection

  SQL Injection is the most commonly exploited vulnerability. Don’t bet that it wont happen to you. Read on to see recent cases of prominence and learn why you can’t ignore it.

  [more…]

• 5 Reasons to Automate Your Tests [T-SQL Tuesday #50 – Automation]

  

  2014-01-14 - General, T-SQL Tuesday, TDD, tSQLt

  Discover five reasons why automated testing is so much more powerful than manual testing and how it can transform your software development.

  [more…]