Blog Archives

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

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

Using SQL Server Compressed Backups

The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups. Not using compressed backups? Why not?

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

Free SQL Server Training Videos

Over the last year, I have published many videos to YouTube with Free SQL Server Training. You can find these on my YouTube Channel at the following link:   Most of the focus has been around training people for

Posted in 70-461 Training, Classes 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: , , , , , , ,

SQL Server – Dedicated Admin Connection (remote DAC)

In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even

Posted in DBA Tagged with: , , , , , ,

Database Health Monitor version 2.1 Just Released

I have just released version 2.1 of Database Health Monitor, this release involved 2 months of development since version 2.0 was released in July. People often times ask me if this is free, or free to use in production, or

Posted in Uncategorized Tagged with: , , , , , , ,

Presenting at SQL Saturday Las Vegas

This Saturday, September 12th, 2015 I will be presenting at SQL Saturday Las Vegas. My presentation is on Database Corruption, here are the details. When Database Corruption Strikes – Will you be ready? Duration: 60 minutes Track: Enterprise Database Administration

Posted in Corruption, SQL Saturday Tagged with: , , , ,

mssqlsystemresource Database

I was looking through my SQL Server error logs to confirm that CheckDB was being run as I had scheduled based on my previous post to run DBCC CheckDB on all databases. I wanted to confirm that there was no

Posted in SQL Internals Tagged with: , , , ,

SQL Server Script to Display Job History

Its not always quick and easy in SQL Server to get a full list of the jobs that have been run, when they were run and how long they took. I created the following script to quickly check on the

Posted in SQL Server, TSQL 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