Monthly Archives: May 2015

Learn tSQLt and Unit Testing in Philadelphia

Posted on May 6, 2015 by way0utwest

SQL Saturday #390 is in Philadelphia on June 6, 2015. This is my second time attending the event, and not only am I speaking on Saturday, but I’ll be delivering information on Friday at a pre-con. My first SQL Saturday … Continue reading →

Posted in Blog | Tagged , , , , | 2 Comments

Idempotent

Posted on May 6, 2015 by way0utwest

I ran into the word idempotent in the Stairway to Integration Services. I had heard the word, but I hadn’t really considered how important it can be for a DBA or developer until that time. It’s a term used in computer science, … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Can Auditing Fail?

Posted on May 5, 2015 by way0utwest

I saw someone’s list of requirements for a SQL Server auditing system recently that included many of the standard items most of us would want. DDL changes should be captured, along with configuration alterations. The performance impact should be low, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Can Auditing Fail?

Complete Definitions

Posted on May 4, 2015 by way0utwest

I saw a script from a user recently that looked like this: Create db x on file = go alter db set compatbility = 120 go alter db set containment = none go … alter db set service_broker off go … Continue reading →

Posted in Editorial | Tagged | Comments Off on Complete Definitions