Hi friends. Just because it’s the end of the year doesn’t mean things are slowing down. If you are close by, I encourage you to come to see me at one of these three upcoming events:
- Tuesday, December 3rd – Philadelphia SQL Server User Group, Session: Top 10 DBA Mistakes on SQL Server.
This is an evergreen and very popular topic. As shown by the session title, I’ll take you through the 10 most common mistakes both technical and professional made by DBAs who keep SQL Server up and running. And I promise that even long-term, highly experienced DBAs will learn a couple new things. For a bit of added fun, I’ll raffle off a couple copies of my bestseller, “SQL in a Nutshell,” and maybe something even better – like free software! - Saturday, December 7th – Charlotte SQL Saturday, Session: SQL Server Internals & Architecture.
Again, another evergreen and very popular topic, perhaps the most popular in my repertoire. If you’ve ever wondered what SQL Server does “behind the curtain” after you send it a query, then this session is for you! This session will teach you about the way SQL Server manages internal resources, like memory and I/O, and the various processes that control SQL Server’s behavior, from the lazywriter to checkpoints to SQLOS. I get frequent comments from Devs, DBAs, and other Data Pros that this was their favorite session at a SQL Saturday or other IT event.
I’m excited about this event because Charlotte is the corporate headquarters for SentryOne, and many of my SentryOne teammates will be attending. By the way, if you haven’t stopped by to see our new award-winning office in the LoSo area, you definitely should! We’ll give you a tour!
- Wednesday, December 11th – New England SQL Server User Group in Boston, Session: Query Tuning Internals for the Advanced SQL Developer.
This session isn’t for the person who dabbles in writing queries. It’s for experienced SQL coders who know how to read execution plans to troubleshoot a problematic piece of SQL code. I will provide a very quick overview of the basics of reading execution plans and the red flags to look for. But from there we go much deeper into the SQL Server query optimizer and discuss how SQL Server goes through the process of building an execution plan and the way in which it evaluates alternatives, including looking at the internal memo structure that the SQL Server query processor uses to quickly deliver an optimized execution plan.
Also, there are two more things to be aware of if you’re in the Boston area.
First, don’t forget about the Boston Azure Data and AI Fest on December 10-11th. If my calendar works out, I plan to spend some time at the event just hanging out and taking in some sessions and chatting with attendees and speakers. 😃 Last time I checked, there were only 20 seats left out of 250.
Check out all the session and speaker details at https://azuredatafest.github.io/bostonDecember2019/ and join in on this nearly sold-out event!
Second, my colleague Denis McDowell and I are presenting a full-day, invitation-only event at the Burlington Microsoft Technology Center (MTC) on Thursday, December 12th for decision makers and top-level data professionals entitled, “De-risk Your Move from On-premises SQL Server to Azure.” The seminar takes you through deep dives into the most critical considerations for moving your data and databases into the cloud, with special attention paid to those who are deploying to the Microsoft Data Platform in Azure, especially SQL Server. If you are interested, please email me directly at kkline@geeksforgeeks.org.
If you are active on social media, I also humbly ask that you promote these events to your friends and coworkers.
Cheers!
-Kev
