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......
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......
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......
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......
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.......