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. Recognizing this, last year my friend Jason Brimhall and I teamed up and created an all-day workshop for SQL training. We will be chugging into Raleigh, NC on the SQL Saturday crazy train to deliver this workshop, titled “Murder They Wrote”, at SQL Saturday #320 on Friday, September 5.

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.

Presented by:

WayneSheffieldWayne 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 //blog.waynesheffield.com/wayne.




JasonBrimhallJason 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 the VP of the Las Vegas User Group (SSSOLV).



Course Objectives

  1. Recognize practices that are performance pitfalls
  2. Learn how to Remedy the performance pitfalls
  3. Recognize practices that are security pitfalls
  4. Learn how to Remedy the security pitfalls
  5. Demos, demos and even more demos – (and the scripts to demonstrate both the pitfalls and their remedies will be provided to attendees!)
  6. Have fun and discuss
  7. 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.

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 24 seats available for this murder mystery theater, so sign up now to ensure that you have a spot saved for you. The cost is a mere $110.

And then, on Friday September 5th, join us at the Courtyard by Marriott Raleigh North at the Triangle Town Center (3401 Sumner Boulevard, Raleigh, NC 27616). The train gets underway at 9am. Yes, it’s at a hotel, which means that if you’re from out-of-town, you can stay here and just wander downstairs.

But wait, there’s more!!!

Come on back Saturday for the main event – Raleigh’s SQL Saturday is being held at Wake Tech Northern Campus, 6600 Louisburg Road, Raleigh, NC 27616. There are 8 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. (If you are staying at the Courtyard, it’s only 3 miles away.)

Related posts:

SQL Saturday RVA recap

History of the SQL crazy train

Shameless plug:

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 to make arrangements.