Blog Archives

Introduction to SQL Server Class

From September 15th 2015 to October 1st 2015 on Tuesday and Thursday evenings I will be teaching a Introduction to SQL Server class. Interested you can sign up here:  Class Info and Signup Introduction to SQL Server – Why take this course?

Posted in Classes Tagged with: ,

Silencing Backup Messages with Trace Flag 3226

As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your

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

SQL Server Mentoring – Now Available

Yesterday I was asked by a client about consulting questions and for my help without the typical minimum hourly commitment. He pointed out that he has things that he could use help with that don’t require a multi-hour type project.

Posted in SQL Server Tagged with: , , , ,

SQL Server Database Corruption Repair

Database corruption repair with SQL Server is one of those things that you generally don’t see every day, but as a DBA, you are expected to be able to fix it quickly without any data loss. From the risk analysis

Posted in Corruption Tagged with: , , ,

What is a Page Split

Tables, and indexes are organized in SQL Server into 8K chunks called pages. If you have rows that are 100k each, you can fit about 80 of those rows into a given page. If you update one of those rows

Posted in Performance, Performance Tuning 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: ,

Error Log: I/O is Frozen On Database

I/O is Frozen on Database. You are scanning your SQL Server Logs and discover the following error messages. There may be a long list of them, one frozen and one resumed for each database on your SQL Server. I/O Is Frozen

Posted in Performance, Performance Tuning 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:

Steps to Improve ETL Performance Using SSIS

Some of the biggest performance tuning wins that I have had over my career have been related to performance tuning queries that are being called from SSIS. So often the actual query performance gets overlooked in the SSIS environment. A

Posted in Performance Tuning, SSIS Performance Tagged with: , ,

Statistics IO for Performance Tuning in SSMS

Statistics IO and Statistics Time is another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks. Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how many

Posted in Performance, Performance Tuning 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