Blog

• Can A Temp Table Name Cause Plan Cache Bloat?

  

  2016-01-19 - General, SQL Server Internals

  “Use descriptive object names.” – Read on to discover how ignoring this best practice can cause plan cache bloat and in turn performance issues.

  [more…]

• 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…]

• The Hidden SQL Server Gem: UPDATE from SELECT

  

  2015-08-19 - Fundamentals, General, Queries, T-SQL Statements

  Sometimes we need to update data in one table based on the contents of one or more other tables. Discover how the UPDATE from SELECT variation of SQL Server’s UPDATE statement provides an easy way to achieve this.

  [more…]

• Presentation Materials: SQL Server Cryptology – A Primer

  

  2015-03-31 - Presentations

  Abstract So, you got told you need to encrypt “the database”. Now what? There are many reasons to encrypt your database. You might have to comply with HIPAA or PCI DSS, or you might just have generally sensitive data. Correctly [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…]

• Six Reasons to use Continuous Integration

  

  2015-01-28 - General, TDD, tSQLt

  Continuous Integration (CI), while it comes with a high startup cost, provides several benefits that lead to a better product in the long term. Read on to discover six of the strongest reasons to us CI in your project.

  [more…]

• Continuous Integration

  

  2015-01-21 - Continuous integration, General

  Continuous Integration (CI) is an automated process that complements your unit testing efforts. Discover how CI can create deployable software packages while giving feedback about the health of the project.

  [more…]

• Test Data – Why Sharing is Not Always Caring

  

  2015-01-15 - Fragile Tests, General, Series, TDD, tSQLt

  Shared test data can lead to a particularly nasty form of fragile test. Discover why shared test data is bad and how to avoid using it in your unit tests.

  [more…]

• Testing Time – Three Ways to Avoid Fragile Tests

  

  2015-01-07 - Fragile Tests, General, Series, TDD, tSQLt

  Testing functionality dependent on the current time or date commonly leads to fragile tests. Discover three proven test patterns to avoid that trap.

  [more…]