I had such a great time at the SQL Saturday in St. Louis. There were about 25 people for my presentation which you can download here. I am thinking of reworking the last portion of it, but you can watch a streamlined version of my presentation here. I really enjoyed George Walkey’s presentation on Using Powershell to Document SQL Server. His scripts from that session are invaluable.
Meet me in St. Louis where I will be presenting my session on “The PROCESS of Queries“. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on Sep 10 2016 at SLU Center for Workforce & Organizational Developement, 3545 Lindell Blvd , Saint Louis, Missouri, 63103, United States.
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.
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.
(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.
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.
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.
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.
The SQL Saturday team of Indianapolis would like to introduce the SQL Starter Track. An entire track of FREE sessions geared towards the ABSOLUTE BEGINNER. Be sure to sign up We have also started the #SQLStarter on Twitter. Find out more information on on our Sway Page.
What an exciting line up of speakers and topics we have for this years’ SQL Saturday pre-conferences on Friday, August 12, 2016. If you are in the Indianapolis area, you definitely don’t want to miss these sessions.
Headed 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
I went to the Chicago SQL Saturday a day early to attend a pre-conference with the one and only Kalen Delaney on Plan Caching in SQL Server. Picking up some really good analogies and system internals information that I can take back to my classroom.
SQL Saturday – Indianapolis is now live. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on August 13, 2016 at Indiana Wesleyan University North, 3777 Priority Way South Drive, Indianapolis, Indiana, 46240, United States
Starting the year off right by travelling down to Nashville to meet up with the #SQLFamily and spread a little information on Batches, Transactions, and Errors. Added an extra 30 minutes to go over Transaction Isolation Levels.
Ready for one more SQL Saturday event of the year. Final stop will be in Providence, Rhode Island. For those attending, here is the powerpoint presentation from my session. Thank you once again for another amazing Saturday.
Stopping by SQL Saturday – Kansas City on my way home from the MCT Summit. One last time for my presentation on The Process of Queries and how this effects Batches, Transactions and Error Handling. You can find the PowerPoints here and the handout of the lecture here.
Another SQL Saturday, this time in Spartanburg, SC. I will be presenting TWO sessions this time. I have uploaded both presentations and sample code files to the SQL Saturday website. But you can always check out my SQL Code section while you are here.
This is my Working with Data Types presentation for the SQL Saturday – Louisville on August 22nd, 2015. Some helpful links.
- Sample Code from Presentation
- Character Data Type Demonstration
- Integer Data Type Demonstration
- Date and Time Data Type Demonstration
- Data Type Conversion Demonstration
- How Rows are Stored in a Data Page
- Data Type Precedence
- SQL Server Data Type Conversion Chart
- CAST and CONVERT Functions
- Parse, Try_Parse, and Try_Convert Functions
- Every Byte Counts by Andy Yun
Once again excited to be speaking at SQL Saturday – Indianapolis 2015. This is my favorite SQL Saturday event, since it is about 2 miles from my house. As always I have attached my presentation as well as the pdf of the demonstrations.