Posts filed under: development
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......
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.......
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......
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......
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......
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......
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......
Troubleshooting a Full Transaction Log
Transaction logs are one of the most critical parts of a database and should be managed as such. Running out of disk space can cause application errors and even database......
I love you Agile – here is my Waterfall breakup Letter
I came across an agile retrospective activity that asked participants to write a breakup letter for parts of your process that you wanted to break up with or a love......
[We] ain’t afraid of no [retrospective] (Retrospective Activity)
I previously blogged about how important I think retrospectives are, and you can read it here. We recently decided to try and mix up our team EOS Level 10 meeting......