Tag: SQL Server

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

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

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