Slides

Thanks for looking at my slide decks!

While I retain the copyright, feel free to download and even reuse any of my slides for any local SQL Server presentation.  Of course, accreditation is appreciated.  If you like the slide deck, I humbly request that you let me know.  A little bit of encouragement goes a long way.

In addition, constructive criticism is welcome.  Let me know if you spot any typos, inconsistencies, or other issues with the content.  Click the hyperlinked entry to download the slide decks for my current sessions.  I’ve included links to video webcasts, white papers, and other resources where available.

The slide decks are zipped and, when uncompressed, in either PowerPoint 2007 or PowerPoint 2010 format.  If you don’t have Microsoft PowerPoint 2007, you can get the free viewer here.

Here they are, in alphabetic order:

Also available without slides:

Simplify SQL Server Management with DMVs – the Experts’ Perspective

Tuning disk subsystems for optimal SQL Server performance is typically the domain of very experienced, enterprise DBAs. It normally takes many years of exposure to the hard disk subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance, and allow for the most scalability.  This session will answer questions like:

How do I configure my hard disks?  Do I need RAID?

What are the types of RAID and which kind is best for my application?

How does RAID compare to SAN?

How many disks will I need for my high-performance application?

What is needed to properly monitor the performance of my disk subsystem?

How do I tune SQL Server to improve IO performance?

Setting up hardware can be very intimidating, especially when the application needs to scale. Learning the tips and techniques described in this session will help you avoid costly mistakes and serve as the foundation for the long-term success of your SQL Server environment.