Blog Archives

This weeks podcast featuring Jessica Moss

This weeks SQL Data Partners podcast, Episode 55,  is on (SSRS) Reporting Services Changes in SQL 2016. This episode features Jessica Moss, and the discussion is on some of the great new features in SSRS 2016. One of the key take-aways

Posted in Podcast Tagged with: , , , , ,

Database Health Monitor – July 2016 Release

I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website. Since the releases have been coming about monthly lately, I have decided to add

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

Database Health Monitor Version 2.4.2 Released Today

Today I released the latest update to Database Health Monitor.  Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes. Here is a preview of

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

CTE to Split a String in a function SplitString

Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: At the time, I thought it was pretty handy

Posted in CTE Book 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: , , , , , , ,

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.   Related Links: Common Table Expression (CTE) Month at (introduction)

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

Max Server Memory – SQL Server

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more

Posted in Performance, Server Health Tagged with: , , , , , , ,

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: , , , , , , ,

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 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 with my newsletter.
Newsletter signup form.

Stedman Solutions