I can’t believe I have not been to a SQL Saturday in almost two months. I missed Cleveland last month so I could catch up on some of my college workload. But this weekend I will be attending SQL Saturday – Chicago delivering a presentation on how to get SQL Server Certified.
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://
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.
It is time for T-SQL Tuesday #85 and this month the party is being hosted by Kenneth Fisher from SQL Studies.This month’s topic is Backup and Restore and I will be discussing the differences between database Restore and Recovery.Click here to read more.
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.
- Mastering Microsoft Certification Exam Prep
- Microsoft Learning – SQL Server Certifications
- Larry Kaye announces New Streamlined Certifications
- MTA – Exam 98-364: Database Fundamentals
- Why get Microsoft Certified
- Online Proctored Exams
- Microsoft Certification Study Groups
- Channel 9 SQL Server videos
- Microsoft Exam Question Types
I 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.
Headed back down to Atlanta on December 10th for another SQL Saturday. It is the Business Intelligence Edition, but I will be talking about the new Streamlined Microsoft Certifications and how you can become certifiable.
I couldn’t make it to the PASS Summit this year. But I am watching the highlights on PassTV. So many great sessions so far on the first day, I definitely know how I am spending my weekend.
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.