TSQL to Determine Plan Cache Size
In SQL Server 2012, there was a change to the dynamic management view that reports on the plan cache, so the query has changed. Here… Read More »TSQL to Determine Plan Cache Size
Index Defragementation and Management
As I have been creating the Database Health project over the last couple of months, I have discovered that my favorite part of the whole… Read More »Index Defragementation and Management
Making Progress on the Server Health Re-write
Originally I implemented the Database Health Reports as a series of SQL Server Reporting Services reports, which was very handy and easy to create, but hard… Read More »Making Progress on the Server Health Re-write
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… Read More »Gone Fishing.
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
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.