Monthly Archives: January 2016

What is Technical Debt

With all the snow lately I know everyone was looking forward to another Summer Friendly T-Shirt Series post. To be honest I did not have time to finish writing the next article in that series yet as I was shoveling...
Continue Reading →

T-Shirt Series: The Misunderstood Table Variable

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. You can check...
Continue Reading →

Incorrect SQL71558 error when joining synonyms in SSDT

I recently ran into an issue where the SSDT compiler in Visual Studio was misreporting an error and I wanted to post about the setup and work-around. SSDT, also known as SQL Server Data Tools, is an add-in for Visual...
Continue Reading →

T-Shirt Series: What is so special about “TEMP” 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. Today we...
Continue Reading →