Indy SQL Saturday 2016

finalsqlsatindy That’s a wrap for SQL Saturday Indianapolis 2016. We had record breaking attendance and a great day of excellent training sessions. Thank you again to all the sponsors, speakers, volunteers and of course all the attendees for supporting our most awesome community event. Lessons learned, we will definitely have a bigger room for the #SQLStarter track. They were definitely our biggest sessions and hopefully will be added to other SQL Saturday events. (My session on SQL Certifications was so nice, I ended up doing it twice.) I think our biggest mistake is that we ran out of coffee about an hour before lunch and we almost had a revolt. Fortunately, the caterers arrived just in the nick of time. I hope to see everyone again next year.

SQL Saturday #531

agu6 Had a great time at the SQL Saturday in Louisville, KY. I always enjoy this one because it is only a two hour drive and I get to see the southern contingent of the #sqlfamily. I delivered my presentation on The PROCESS of Queries which seems to have become my most popular session. You can download the demo scripts and powerpoint presentation here or as always watch the abbreviated video version here.  Really enjoyed the great reviews and even picked up some tweets during the session.


Networking at SQL Saturday

530sqlindy (Updated post from last year on the Building Skills at SQL Saturday events: Still holds true today, except the event this year is on August 13, 2016.) Over the past year, I have had the privilege of speaking at several SQL Saturday events, and I have been amazed at the turnout and passion of the SQL Server community. If you have never heard of SQL Saturdays, they are free community-driven, one-day training events for SQL Server professionals. These events rely on local speakers and volunteers to provide a variety of high-quality technical sessions covering all aspect of SQL Server. Click here to read more.

Columbus, Ohio

DeardurffHouse Had a great time in Columbus, Ohio this weekend. Started off early to volunteer at the SQL Saturday event and then right before lunch I delivered my presentation on The PROCESS of Queries. It was standing room only with over 40 people in attendance. I did leave a little early in the day, because I wanted to visit The Deardurff House while I was in town. Built in 1807, it is the oldest standing structure in Columbus and also served as the first post office in Central Ohio.

The PROCESS of Queries

If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it into a video. Just as a reminder, I will be delivering this presentation at the SQL Saturday in Columbus, Ohio on July 16th and then again in Louisville, KY on August 6th. Or you can just take my 20461 SQL Query Writing class at New Horizons and see the three hour version of this presentation.

SQL Saturday Schedule

530sqlindy We had three times as many speaker submissions as we had actual open speakers slots for the upcoming SQL Saturday Indianapolis. It was very difficult to select from so many excellent individuals. However, we have finalized the sessions and Here is our schedule for the August 13th event. We’ve done our best to provide a good mix of topics and skill levels, we hope you’ll find something of interest throughout the day. Our thanks to the speakers for volunteering their time, we couldn’t do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

SQL Saturday – Chicago

484ChicagoHeaded up to SQL Saturday – Chicago for another SQL Saturday. Attached are my powerpoints for my presentation on what you need to know about working with SQL Server Data Types. I will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions. I have my schedule built out for all the sessions I want to attend. I’ve been wanting to see some of these for awhile, but I always seem to be speaking at the time.

  • Turbo Charged Transaction Logs – David Maxwell
  • Regular Expressions for the DBA – Sean McCown
  • Lock, Block, and Two Smoking Barrels – Mark Broadbent
  • Are you Optimistic about Concurrency – Kalen Delaney
  • What is your Character Data Type – John Deardurff
  • Monitoring Counters That Count – Jimmy May
  • Indexes and SARGability – Jared Karney

SQL Saturday – Louisville

This is my Working with Data Types presentation for the SQL Saturday – Louisville on August 22nd, 2015. Some helpful links.