This is my first blog post since going-independent. As mentioned in my previous post, I’ll still be blogging periodically on my original SQLskills blog.
As for what I’ve been up to these last few weeks, I’ve been working on-site with a local Minneapolis client – spending about half of my time on the DBA side of things and half embedded with a developer team. I’ve been helping out on longer-term projects and I’m definitely enjoying it so far.
So on to the subject of this brief blog post – today Pluralsight published my new course, “SQL Server: Temporary Objects”.
This is a short course on how to effectively leverage SQL Server temporary objects in your T-SQL code. The decision as to whether to use temporary tables or table variables can have a significant impact on your workload performance and scalability, and this course walks through several specific scenarios so that you can see first-hand the nuances of this design decision.