Gone Fishing.
I am off today and headed out fishing, with hopes of catching some salmon. It is going to be a great season. http://Fishing.stevestedman.com -Steve Stedman Bellingham WA
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 things that the Server Health report evaluates are the following Index Fragmentation Big One Time Use Queries Long Running Queries Duplicate Indexes CPU Utilization Database Size Backup Set Statistics But…. I have found it very challenging to …
SQL Server Health Reports — Working on Version 2 Read more »
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 creates a database called pivot, you probably already have your own database to work in. Then it creates a table called REVENUE and fills it in with department revenue for just over a 10 year …
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 of lean, and a ton of common sense. Here is a link to the presentation: Lean Software Development its not done yet, just a start.
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 to Split Up a Query String Using a CTE to Split a String Into Rows Can we use CTEs use in SSRS? CTE Hierarchy compared to the alternative Calculating Factorials with a Recursive CTE CTE …
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 attended was Accelerating your Development Workflow presentation by Ian Davis. What a great presentation, it touched on the lean and agile development processes, it was very well done. The next one was a PowerShell presentation that …
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 to the day. I am looking forward to attending the Accelerating your Development Workflow presentation by Ian Davis. Here is what I am presenting… What’s New in TSQL 2012 This is the first time that …
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 to avoid switching to the mouse when you don’t have to. Here are some shortcut keys that I find very useful in SQL Server Management Studio, some of which I just discovered recently. Window + …
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 that returns the item at a specific index. Syntax: CHOOSE(index, val_1, val_2, val_3, …) If the index is greater than the number of values or less than 1 it returns NULL Easier than using a …