Monthly Archives: March 2016

Starting with T-SQL for SQL Server

I was recently having a conversation with someone and they asked me what some good resources were to begin writing SQL.  So I thought it would be a good idea to compile a quick list of places I like to...
Continue Reading →

Lessons Learned: Standard Dashboard Episode 1

Where I currently work many process improvement projects end up requiring some sort of software deliverable be created and left behind to aid in the sustainment of the process improvement work. Originally these were prototypes developed for a single site,...
Continue Reading →

Quickly Defining a Table Structure From a Query

I recently saw a comment that described getting data into a temp table using SELECT <Columns> INTO <Table>.  The main reason this was done was just for convenience and to speed up getting to the answers they ultimately needed. For...
Continue Reading →

Ransomware: another reason to have a good Disaster Recovery Plan

I read a chilling editorial over at SQL Server Central in regards to the growing threat of Ransomware. Steve Jones presents a nightmare scenario for a business. Imagine you come into work and all of your database columns are encrypted....
Continue Reading →

T-Shirt Series: The Temporary Line

Throughout the T-Shirt series we have discussed Temp Tables, Table Variables, Derived Tables, and Common Table Expressions (CTE). In this post I will summarize high level differences under normal circumstances. See the articles above for further details. Temp Table Table...
Continue Reading →