Monthly Archives: February 2016

The value of an effective stand-up

Lately, I have been thinking about how we could execute our stand-up meeting better. Usually when I start questioning the effectiveness of something I like to refocus on the intended value. I recalled a post I read quite a while...
Continue Reading →

T-Shirt Series: The CTE (Common Table Expressions)

I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog post on each and then summarize the differences. I like to...
Continue Reading →

Generate XSD from Sql query using FOR XML

Transitioning from site specific prototypes to more standardized products for delivery to multiple customer sites has been a driving factor for separating custom source system translations from the product itself. This has led to many of our products having a...
Continue Reading →

T-Shirt Series: Derived tables

I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog post on each and then summarize the differences. I like...
Continue Reading →