I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about previous whistle stops and why they are called whistle stops here.
Amazing this thing is still going on after the sailing train comment that was made around the time of PASS Summit 2013.
Time to sink or sail, so to speak. SQL Saturday 403 in Louisville will mark the next attempt at what I hope to be a repeat performance – many times. I will be tag-teaming with Wayne Sheffield in this all day workshop event. The session is one of two all day sessions for the event in Louisville, KY. Did I mention that this is a:
That’s right! If you get two all day sessions for the price of one! Attend just one or both of the sessions that Wayne and I will be presenting. You can see full details at our eventbrite site here.
If you are a DBA or a database developer, these sessions are for you. If you are managing a database and are experiencing performance issues, these sessions are a must. We will chat with attendees about a horde of performance killers and other critical issues we have seen in our years of working with SQL Server. In short, some of these issues are pure murder on your database, DBA, developer and team in general. We will work through many of these things and show some methods to achieve a higher state of database Zen.
Description
Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous crazy implementations they have seen over the years, and how these implementations can be murder on SQL Server. No topic is off limits as they cover the effects of these crazy implementations from performance to security, and how the “Default Blame Acceptors” (DBAs) can use alternatives to keep the developers, DBAs, bosses and even the end-users happy.
Course Objectives
- Recognize practices that are performance pitfalls
- Learn how to Remedy the performance pitfalls
- Recognize practices that are security pitfalls
- Learn how to Remedy the security pitfalls
- Demos Demos Demos – scripts to demonstrate pitfalls and their remedies will be provided
- Have fun and discuss
- We might blow up a database
That is just the Murder session. Here are the details for the XE session.
A Masters Passport to Extended Events
As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.
It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.
This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.
You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.
Course Objectives
- Build a knowledge base for Extended Events
- Become familiar with the tools for Extended Events
- Become familiar with uses for Extended Events
- Get acquainted with troubleshooting scenarios for Extended Events
- Begin to put Extended Events to practical use
- Return to work with enough information to eradicate Profiler from the environment
Presented by:
Wayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne
Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments. Jason also has 18 years experience in IT working with the hardware, OS, network and even the plunger (ask him sometime about that). He is currently a Consultant and a Microsoft Certified Master(MCM). Jason is also an MVP for SQL Server.
There will be a nice mix of real world examples and some painfully contrived examples. All will have a good and useful point.
If you will be in the area, and you are looking for high quality content with a good mix of enjoyment, come and join us. You can find registration information and event details at the Louisville SQL Saturday site – here. There are only 75 seats available for this murder mystery theater. Reserve yours now.
The cost for the class is $150 (plus fees) up through the day of the event. When you register, be sure to tell your coworkers and friends.
Wait, there’s more…
Not only will I be in Louisville for these workshops, I will also be presenting as a part of the SQLSaturday event on August 22, 2015 (the Saturday after the workshops which run Aug. 20-21, 2015). You can view the available sessions here.
Shameless plug time
I present regularly at SQL Saturdays. Wayne also presents regularly at SQL Saturdays. If you are organizing an event and would like to fill some workshop sessions, please contact either Wayne, myself or both of us for this session.
