Category: Security

• Invite for #tsql2sday #71 – SQL Server Audit

  

  2015-09-01 - Audit, General, Security, T-SQL Tuesday

  T-SQL Tuesday is a monthly blog party. This month is the 70th episode and the topic is: “SQL Server Audit”. Read on to discover what #tsql2sday is all about and what you have to do to participate in this exciting blog-party.

  [more…]

• PCI DSS Compliance – Is It For Me?

  

  2015-03-28 - General, PCI DSS, Security

  If you have a small or medium sized business, you might be wondering of your business needs to be PCI DSS compliant. Read on to find out now.

  [more…]

• You’ve been Hacked! [T-SQL Tuesday #63 – Security]

  

  2015-02-10 - Audit, Cryptography, General, Security, T-SQL Tuesday

  One Billion – The number of accounts affected by security breaches during the last ten years. Is the data of your customers safe with you?

  [more…]

• How to Script Database Permissions

  

  2014-10-07 - DMVs & CVs, General, Security, Security

  Scripting all permissions in a SQL Server database is not trivial. Discover how to generate the necessary statements yourself with this simple query. (Well, copy & paste of the query is simple…)

  [more…]

• Common Database Vulnerabilities: Defects

  

  2014-10-02 - Common Database Vulnerabilities, General, Security, Series, TDD, tSQLt

  Defects are a nuisance. However, they often lead to bigger problems. You might find your code corruption data by updating the wrong records or opening up gaping security holes allowing users to see other users’ data. Find out how to protect yourself from this danger.

  [more…]