Indianapolis #629

Ladies and Gentlemen! SQL Saturday of Indianapolis is now live. I am so excited to once again be able to organize the biggest and best SQL Saturday in the Midwest. We will have 45 of the top SQL professionals and speakers from around the country joining us to share their time and experience with you. And remember we are moving our venue 15-20 miles north this year to be able to accommodate a growing number of attendees. So don’t worry about getting waitlisted this year and be the first kid on your block to register for our August 12th, 2017 event. http://www.sqlsaturday.com/629/EventHome.aspx Also, if you would like to be a sponsor for our great event, please visit the sponsor sign up page on our website.

Nashville #581

 It is a very cold and rainy day for the first SQL Saturday of 2017. Nashville is one of the events I attend every year as there are many members of the #SQLFamily that also attend. I am getting to do two sessions this year. First up at 8:30 am is my presentation on “The PROCESS of Queries”. This is the one I have been requested to present the most often. It is a very beginner level into how queries are optimized and how this effects batches, transactions, and errors. The second session will be at 1:30 pm and is a brand new presentation for a SQL Saturday, “The Basics of Data Manipulation”. This is from one of my favorite chapters from the T-SQL courses that I teach and I am really excited to put it into a one hour session format.

SQL Saturday Atlanta #578

Attached is my presentation on SQL Server Certification that will be presented at SQL Saturday Atlanta: BI Edition this weekend. I have also provided useful links in getting certified on SQL Server.

Speaking about SQL

tsql2sday150x150I can’t believe it, I am finally joining the T-SQL Tuesday blog post party started by Adam Machanic (b|t). This month Andy Yun is our TSQL2sDay #84 host who has selected the subject of “Growing New Speakers”. Specifically, to talk about preparing,  presenting, and speaking at local user groups, virtual PASS chapter, SQL Saturdays and/or the PASS Summit. As a Microsoft Certified Trainer(MCT), this topic really hits home. Click here to read more.

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.

2tweet

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