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

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

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

DBCC CheckDB All Databases

If you use the SQL Server maintenance plans to run DBCC Check DB, you are not allowed to include TempDB in your DBCC CheckDB sequence. For a while I was using maintenance plans, and ending up adding a separate job

Posted in Uncategorized Tagged with: , , ,

Blog hosting trouble while on vacation

This last weekend I went on vacation to the San Juan islands for 4 nights. Our annual family trip to the islands for some good family time, and fishing. Here are some photos from the trip.    

Posted in Uncategorized Tagged with: ,

Website Outage

Last night my website (this site) experienced an outage. Sometime during the night the Mysql process hosting my WordPress website crashed. Too bad there isn’t a WordPress solution that uses a SQL Server database. Things are back now, and the

Posted in Uncategorized Tagged with:

System Outage… How do you communicate with your customers?

While watching a movie tonight, the Amazon Prime video system had an outage, no Amazon videos would play on my Amazon Fire TV Device. Netflix and Hulu worked fine, other internet traffic worked fine, just no Amazon Prime videos. After

Posted in Uncategorized Tagged with: , ,

TSQL JOIN Types Poster (version 4.1)

After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The think I love about

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

Database Corruption Challange 6 – Coming Soon

Hello everyone, the last week I have not been able to keep everyone as up to date on the Database Corruption Challenge as I would like to. Life has just turned really busy in the last 10 days, but I

Posted in Uncategorized Tagged with: ,

Week 5 – Alternate Solution

Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014.   To oversimplify, here are the steps: Restore the

Posted in Uncategorized 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