Category: General

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

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