Monthly Archives: November 2015

Webinar: Unit Testing with SQL Server and tSQLt

Posted on November 11, 2015 by way0utwest

I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is the founder and developer of tSQLt, which I really like using. We’ve done some teaching together and I’ve delivered a … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Updating Extended Properties

Posted on November 11, 2015 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I wrote recently about adding extended properties. Updating them is very similar. There’s an analogous procedure called sp_updateextendedproperty that changes … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Do You Have Scary Code?

Posted on November 10, 2015 by way0utwest

I once worked in a company that had a VB6 application (this was a long time ago), which had been mainly written by three developers working at the company. Two of them left, but we still have one of the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Do You Have Scary Code?

Poor Data Modeling – T-SQL Tuesday #72

Posted on November 10, 2015 by way0utwest

This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short story. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Poor Data Modeling – T-SQL Tuesday #72