Blog Archives

Database Health Monitor Version 2 Almost Done

Over the last 4 years I have been working on the Database Health Monitor. I am about a week away from releasing Version 2, which will finally be out of the beta process. In preparation for the release I am

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

Using a Common Table Expression Instead of a Derived Table

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the

Posted in Classes, CTE Tagged with: , , , , , , ,

What is a Common Table Expression

I just a added a video to YouTube titled “What is a Common Table Expression”.  This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is

Posted in CTE Tagged with: , , , , , , ,

Database Health Reports Beta 9 – Released

Today I have released beta 9 of the Database Health Monitor. It has been 27 months since the release of Database Health Beta 1, and almost 4 years since the original SSRS implementation of Database Health reports. To be honest

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

Introducing the Joes2Pros Academy

The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Students can interact with other students and instructors

Posted in Academy, DBA, SQL 2012, TSQL 2012 Tagged with:

What is a Common Table Expression – Video

  Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction

Posted in CTE, CTE Book Tagged with: , , , , , , ,

One Thousandth Download of Database Health Reports

Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be the perfect opportunity to recap on the history of the database health report application. First

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

What twitter hash tags do you follow for SQL Server?

# The key to twitter is to follow the right hash tags.  What hash tags do you follow related to Microsoft SQL Server? Here are a few of the twitter hash tags that I follow: #SQLServer The generic SQL Server

Posted in SQL 2012, SQL Saturday, SSMS, SSRS, TSQL Tagged with: , , ,

SQL Server Memory Hog Query

The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.”  Another name for the article could just be “SQL Server Bug Report” depending on how you look at it.

Posted in CTE Tagged with: , , , , , , ,

It is finally here. Beta 1 of the Database Health Reports for SQL Server.

In October last year I started work on the Database Health reports project.  It started out as a series of SSRS reports that I released and updated in December 2011 to March 2012.  After that it became clear that the

Posted in Server Health Tagged with: , , , ,

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