SQL Server Health Reports — Working on Version 2
Late last year and early this year, I created a collection of report in SSRS that I called SQL Server Health reports. Some of the… Read More »SQL Server Health Reports — Working on Version 2
June 2012
TSQL Pivot Table
TSQL Pivot Table? Whats that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below… Read More »TSQL Pivot Table
Working on my Lean Software Development presentation today.
Working on a 1h hour introduction to LEAN Software development entitled Applying Lean Manufacturing Principles to Software Development. Its a little bit of agile, a bit… Read More »Working on my Lean Software Development presentation today.
Common Table Expression – links
Here are a few links to some of the other CTE examples used during my Common Table Expressions presentation. Using a CTE in a Function… Read More »Common Table Expression – links
Home after Seattle (Redmond) Code Camp 2012
What a great day at Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I… Read More »Home after Seattle (Redmond) Code Camp 2012
Code camp 2012.
Code Camp Schedule… The photo is pretty bad, but if you could see it you would see my three sessions.
Code Camp in Redmond Today
I am headed to Code Camp in Redmond WA today. I ended up with 3 sessions that I will be presenting, and I am really looking forward… Read More »Code Camp in Redmond Today
Whats your favorite SSMS time saving hotkey?
Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is… Read More »Whats your favorite SSMS time saving hotkey?
TSQL 2012 CHOOSE Function
In SQL Server 2012 there is a new function called CHOOSE that takes in an offset, and a list of options. Choose is a function… Read More »TSQL 2012 CHOOSE Function
Sessions Submitted for SQL Saturday – Olympia
SQL Saturday 166 in Olympia WA on November 10th was announced, and that one is close enough to drive to. I have submitted 2 sessions… Read More »Sessions Submitted for SQL Saturday – Olympia