You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may not have enough time to deliver all of the material that you prepared for. Recognizing this, my friend Jason Brimhall and I teamed up and created an all-day workshop for SQL training. We’ve been chugging around the country on the SQL Saturday Crazy Train doing this workshop, and our next stop will be in Louisville, KY. This workshop, titled “Murder They Wrote”, at SQL Saturday #403 on Thursday, August 20th, 2015.
And then we found out that our attendees want more information, on other topics. So we hooked up a caboose to our train, and on Friday, August 21st, 2015 we will be delivering a second all day workshop. This workshop is titled “A Masters Passport to Extended Events”.
It’s… Just…. Crazy!
And because it’s a Crazy Train, and we’re crazy, well, we have a crazy deal for you!
Yes, that’s right. You get both all day workshops for the price of one. Come to either one, or both, and pay the same price. You can see full details at our eventbrite site here.
Murder They Wrote
The Target Audience and what we cover
If you are a DBA, a database developer, or an application developer that connects to a SQL Server back-end database, then this session is for you. If you are experiencing performance issues, then this session is most definitely for you. If you’re looking for a fun way to spend a day and to get some #sqllearning, then this session is for you. This presentation is geared around decisions that have been made in the development life cycle and the effects that those decisions have on SQL Server, based upon the things that we have seen done to the instances that we have managed (and, in my case, some of the things that I did back when I was a developer and didn’t know better). With no topic being off limits, we also cover critical issues that just aren’t that great to do – and that still happen way too often. And demos? Oh yeah! You know that I like to show things instead of just telling them, so in that spirit, this is a demo-heavy presentation. We don’t just tell you that something is bad and something else is good… we’ll show it to you. We might even blow something up!
So, come on out for a day of learning, fun, and SQL camaraderie. We look forward to spending a day chatting with the attendees, and in helping them to overcome some of their issues.
The Official Session Abstract
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.
- 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 and even more demos – (and the scripts to demonstrate both the pitfalls and their remedies will be provided to attendees!)
- Have fun and discuss
- We might blow up a database
We are trying to have a nice mix of real world examples (and some contrived ones), all of which demonstrate a good and useful point.
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.
- 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
Wayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80′s. With over 25 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 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at //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).
Registration – or what to do to join us
If you will be in the area, and you are looking for high quality content with a good mix of enjoyment (and some self-ridiculing), come and join us! You can register for this session at Eventbrite. There is a limit of available seats for this two day train stop, so sign up now to ensure that you have a spot saved for you! The cost is a mere $150 (plus EventBrite fees), and as previously mentioned, this covers either or both days!
And then, on Thursday August 20th and Friday August 21st, join us in Room 201 at the Indiana Wesleyan University, 1500 Alliant Avenue, Louisville KY 40299. The train gets underway at 8:30am (CDT). Don’t be left standing at the station!
But wait, there’s more!!!
Come on back Saturday for the main event – Louisville’s SQL Saturday is being held at the Indiana Wesleyan University, 1500 Alliant Avenue, Louisville KY 40299. There are 7 tracks going on, so there’s bound to be something there that you just have to see all day long! The complete session schedule is here, and Jason and I are each presenting throughout the day, so come on out and join one of us!
Jason and I both present regularly at SQL Saturdays. If you are organizing an event and would like to have us deliver our workshop, please contact Jason, myself, or both of us.