PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check

If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session called “How to Perform a SQL Server Health Check”. Here’s the abstract for the session:

Are all the SQL Server instances you manage healthy, running optimally, and providing the high availability your organization expects of them? If you don’t know, or if you have inherited, or are consulting with some SQL Server instances you are not familiar with, then you need to perform a SQL Server Health Check in order to find out.

Think of a SQL Server health check similarly to a health check with your physician. On your visit, the doctor will record your basic stats, take a medical history, and perform a number of tests. In many ways, what the doctor does is to document your health, and then compares what he finds to medical health best practices, to determine your current health. The next year at your annual check-up, the doctor will examine your again and then compare it to the baseline from the initial checkup. This helps the doctor determine if your health is the same, getting better, or getting worse. A SQL Server health check is very similar.

In this day-long session, you will learn how to document your SQL Server instances and how to determine if your instances are employing generally accepted best practices. Based on this information, you will be able to conclude if your instances are healthy, which means that they are running optimally and providing the level of high availability your organization expects of them. If not, you will learn how to fix any problems you find.

More specifically, you will learn about how to document your instances, and learn best practices in all of the following areas: Hardware Setup & Configuration, Operating System Setup & Configuration, SQL Server Instance Level Settings, Database Level Settings, Security Settings, Database Maintenance, SQL Server Jobs, Logs to Monitor and Review, SQL Server Monitoring, Performance Optimization, and High Availability. In many ways, this session will bring together all the best practices every DBA should know about administering a SQL Server instance.

This session will cover hundreds of health checklist items and their best practices. To help you keep track of all this information, you will be provided with scripts to collect the data, and a spreadsheet in order to collect and analyze the data.

This session is designed for database administrators from novice to intermediate level. After attending this session, attendees will be able to go back to their organizations and begin to immediately perform their own SQL Server health checks.

For more information on the event, visit the PASS SQLRally website.

devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19

imageThis year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011. This three day event includes over 120 sessions, costs only $100, the least expensive full conference you can attend anywhere. While the conference is developer-oriented, it still offers plenty of SQL Server sessions.

I will be presenting a session on “Inside the SQL Server Transaction Log”. Other SQL Server speakers include Joe Webb, Robert Cain, David Buckingham, and Jeremiah Peschka.

SQLBits Attendance Breaks Previous Records

How many people can you identify in the above photo from the closing party at SQLBits? Can you find Ola Hallengren, Mladen Prajdić, Jonathan Allen (FatherJack), Ross Mistry, James Rowland-Jones, Andre Kamman, among others?

SQLBits 8 (Beside the Seaside) was held this past weekend (April 7-9, 2011) at the Grand Hotel in Brighton, England. With over 800 registrations, it was the largest SQLBits to date, and the largest SQL Server event in Europe.

Continue reading

Don’t Forget to Sign Up for the 24 Hours of PASS: Summit Preview

Looking for some free SQL Server training? How about 24 hours of free training offered by some of the top SQL Server experts in the world? If so, sign up for the upcoming 24 Hours of PASS live webcasts to be held September 15-16, 2010. It’s your opportunity to continue and broaden your SQL Server education, with your only investment being your time.

Continue reading

devLINK a Huge Success

Where can you spend $100 and get three full days of technical training? devLINK of course. devLINK  2010 was held this past week in Nashville (August 5-7), and had 800 registered attendees. There were over 150 session in 10 different tracks, with 71 different speakers. While the focus of the event was more towards developers, there was a Database Platforms and Development track that included many prominent speakers, including Kevin Kline, Joe Webb, Jeremiah Peschka, Joe Kuemerle, Jason Follas, Louis Davidson, Dennis Bottjer, Philip Japikse, and Brad McGehee.

If you were unable to attend, or can’t get enough SQL Server training, there will be a SQL Saturday in Nashville on August 21, 2010.

Speaking at Nashville, St Louis, and Baton Rouge in August

In August, I will be presenting at the following events:

DevLINK, August 5-7, 2010

  • How and When to Use Indexed Views
  • Identifying SQL Server Performance Problems Using SQL Trace
  • Essential DBA Skills: Introduction to Graphical Execution Plans

St. Louis SQL Server Users Group, August 11, 2010

  • Identifying SQL Server Performance Problems Using SQL Trace
  • Essential DBA Skills: Introduction to Graphical Execution Plans

Baton Rouge SQL Saturday, August 14, 2010

  • Best Practices Every SQL Server DBA Must Know
  • Database Maintenance Essentials

If you are attending, be sure to stop me and say hello.