Blog Archives

PASS Summit 2016

Last night I arrived in Seattle for PASS Summit 2016. This is my 4th consecutive PASS Summit, and my second time to be here as a speaker, and I am certainly looking forward to the week. Before I had even

Posted in PASS Summit Tagged with: ,

Interested in some personal training on Database Health Monitor?

At PASS Summit next week, I will be available most of the day on Monday and Tuesday to meet with anyone to discuss Database Health Monitor, or consulting work. Just send me an email or contact me via twitter @SqlEmt. I

Posted in PASS Summit, Summit 2016 Tagged with:

Presenting at PASS Summit Next Week

Next week I will be presenting on Database Corruption on Friday afternoon at Pass Summit.  The session is called “When Database Corruption Strikes.”   This session is on Friday afternoon, if you are interested in how to deal with database corruption,

Posted in Corruption, Summit 2016 Tagged with: , ,

CHUG 2016 Session – Tune, Monitor and Analyze the Health of Your Centricity SQL Server

Here is the session download material for my CHUG 2016 Session – Tune, Monitor and Analyze the Health of Your Centricity SQL Server. Download PerformanceCHUGAustin2016.pdf

Posted in CHUG Tagged with:

Presenting this Friday at the CHUG Conference

This Friday, October 14th I will be presenting at the Centricity Healthcare Users Group (CHUG) conference in Austin TX. The session is on “Tune, Monitor and Analyze the Health of Your Centricity SQL Server” and I will be co-presenting with

Posted in CHUG, Performance Tuning Tagged with: , ,

Don’t Reboot SQL Server So Often

How often should I reboot SQL Server? It is a common belief with computers that rebooting cleans things up in memory and that they run better if they are rebooted more often. With your windows desktop or your cell phone

Posted in Performance Tagged with: , ,

Database Corruption Overview for Beginners

Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response plan. Out of all of the things that can happen to your SQL Server this is the one that you

Posted in Corruption Tagged with: , , , , , , ,

Cortana Intelligence Suite – Podcast Episode #62.

This weeks latest podcast is an interview with Melissa Coates, on the topic of Cortana Intelligence Suite. From this weeks podcast: The Cortana Intelligence Suite is actually a huge collection of services in Azure for the purposes of providing big

Posted in Podcast Tagged with:

Instant File Initialization (IFI)

One way to improve performance on SQL Server is with IFI or Instant File Initialization. Normally files are zeroed out on a database growth during an AUTOGROW, RESTORE, CREATE DATABASE or ALTER DATABASE. This is done by SQL Server when

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

Duplicate Indexes, What a Waste

Today on the tuning minute on the SQL Data Partners Podcast, we discussed duplicate indexes, which lead me to think more about and and write this post. You know there are many different ways of doing things in SQL Server,

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