Blog Archives

SchemaDrift – Database Schema Differences – My Weekend Project

This weekend I had some spare time, so I started coding on a new project on Friday night. This project is something that I intend to include in the next release of Database Health Monitor. THis project allows users to

Posted in Uncategorized Tagged with: , , , , ,

SSRS Report Usage Queries

This last week I had the opportunity to do some work with SSRS, determining some stats on report usage. I ended up digging up some queries that I wrote a couple years ago against the ReportServer database, and thought they

Posted in SSRS Tagged with: , , , , , , ,

The Walking Desk

Lately I was asked a question about getting steps in using my FitBit. The answer is the walking desk. This allows me to use my computer while walking on the treadmill at 2.2 miles per hour. 2.1mph to 2.4mph for me

Posted in Uncategorized

2015 Review

What 2015 meant to me and my business. Stedman Solutions, LLC – Startup After unexpectedly leaving a regular full time employment position on March 31st 2015, the very next day April 1st 2015, Stedman Solutions, LLC was launched. Looking back,

Posted in Steve Tagged with: , , , , , ,

Optimize for Ad Hoc Workloads

The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server,

Posted in SQL Server Tagged with: , , , , ,

Jingle Bell Run – My second 5K run.

Today I participated in my second ever 5K race today, the Bellingham Jingle Bell Run. My running partner (Gypsy the black dog in the picture) accompanied me, and might have increased my speed at a couple of points due to

Posted in Epic Life Quest Tagged with:

Database Health Version 2.2 Released Today

Today I have the pleasure of releasing the next version of the Database Health Monitor application. Currently at version 2.2, I have been working on this since 2011, and I have introduced some new features in the latest version. Visit

Posted in Database Health Tagged with: , , , , , , ,

Bellingham SQL Server Users Group – Building a Static Data Warehouse Server

Please help spread the word to anyone who may want to attend this free users group meeting and presentation. The November meeting of the Bellingham SQL Server Users Group (PASS Chapter) will be held on Wednesday November 18th at 6:00pm.

Posted in PASS Chapter Tagged with: , , , , ,

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs

Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions.   Here is the sample code from the presentation. AdvancedCTEs.zip   Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction)

Posted in PASS Summit Tagged with: , , , , , ,

Advanced Common Table Expressions and Recursive Query Technique

Friday morning at 8:00am at PASS Summit 15 in Seattle, I will be presenting my Advanced Common Table Expressions and Recursive Query Technique session. Advanced Common Table Expressions Here is the abstract: You might have been introduced to Common Table Expressions

Posted in PASS Summit Tagged with:

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives