I attended my first SQL Saturday over the weekend: SQL Saturday #845 - Atlanta 2019
There were so many great sessions on the schedule, I hated to have to narrow my choices to just one per time slot. Unfortunately, I’m not familiar enough with replication to attend multiple sessions at once (feel free to groan audibly).
I wanted to take a minute and say a little bit about each of the sessions I did attend, and some of the people I met while I was there. I’m going to go through the sessions in the order I attended them.
SQL Server Internals and Architecture
I attended this session by Kevin Kline (b|t) for the 8:00 am timeslot. This was a fascinating overview of the different phases that SQL Server goes through when processing and executing a query - from parsing and binding, to compilation and plan caching, to runtime execution, and returning results.
Kevin seemed ridiculously comfortable presenting. I feel like, even for experienced speakers, I can normally hear a little nervousness in their voice at the start of a talk. Not so for Kevin. He also really involved the attendees, asking questions and giving away a copy of one of his books! I also got to chat with him for a few minutes before the session, and he is a super nice dude.
Using the Power platform to radically change your business
Next up was this session from Patrick LeBlanc (b|t) and Adam Saxton (b|t). I’ll be honest, I’ve never used PowerBI. My main reason for attending this session was because some friends said that Patrick and Adam are great presenters, and they absolutely did not disappoint.
These guys are incredibly entertaining, but even more than that, the talk really got me interested in trying out the product. They are obviously passionate about the technology they work with, and telling stories about how they’ve helped businesses solve problems. I have clients that have recently implemented BI solutions, and it would be cool to be able to leverage this tool to help them take even better advantage of the data now at their fingertips.
13 reasons why my query is slow
We were in one of the medium-sized rooms, but clearly Fabiano’s reputation preceded him. All of the seats were full, every wall was lined with people standing, and I was among a group of folks sitting on the floor at the front of the room:
This presentation was great. The creativity that Fabiano had to combine 13 different performance issues into one query is impressive. And especially that all of the fixes were distinct from each other as well (that seems like it would be even trickier to put together). Despite sitting on the floor, it was one of my favorites of the day!
Containers - You Better Get on Board!
After lunch, I went to this session from Anthony Nocentino (b|t). I was really excited about this session - I keep hearing a lot about containers, but haven’t really taken the time to dig in and learn what they’re all about. So, this was a great opportunity to hear about them from a recognized expert on the subject.
The demos were really well put together, and I’m looking forward to downloading the slides and scripts and trying it out myself. But the best part of the session, for me, was the way Anthony explained how containers work, and the philosophical / point of view shift that they represent.
Thinking of applications, even the SQL Server database engine, as “ephemeral” services that can be defined and orchestrated declaratively is such a neat concept. I think the idea behind containers finally “clicked” for me while I was in this session.
HA/DR Solutions Using Distributed Availability Groups (Read-Scalable AGs too!)
Distributed Availability Groups are another SQL Server topic I’ve been interested in learning about, so I was really glad that Jennifer was there speaking on it. I work with Availability Groups quite a bit in my day job (troubleshooting them can be a pain), but just haven’t been able to wrap my head around this extension to the feature.
She did a great job covering the use cases for DAGs, and had thorough demos showing how to set them up. Probably the best part of the presentation was a really cool T-SQL script for checking the health of your DAGs - overcoming current lack of UI around that in SSMS.
Optimizing Data Access: Mixing Entity Framework Core and Dapper
I love the idea of overcoming some of the challenges of EF by writing straight T-SQL with Dapper. I also thought Shawn did a great job showing the pros and cons of both tools - rather than just bashing on ORMs, which are an easy target most of the time.
He also made the (somewhat controversial?) assertion that Dapper is not an ORM. I don’t entirely agree, although I get his point, and it certainly got my attention and made me think during his talk!
Angela reached out to me on Twitter when I tweeted that this was my first ever SQL Saturday. She showed genuine interest in making sure I had a good experience, despite me being a perfect stranger. As a newcomer to the event, and SQL Saturday in general, this meant a lot and made me feel very welcome.
She is easy to spot in a crowd (very cool electric blue hair) - so I caught up with her and her husband between sessions and got to spend a few minutes between chatting with them in person.
Thanks for being kind - you’re the real MVP.
Thanks for reading this non-technical post, I hope you got something out of it! Click through the session links to find slides and scripts, and follow these folks on Twitter and their blogs for some really great content.
I look forward to attending more SQL Saturday’s and other PASS events, maybe one day I’ll even speak at one as well - and help others like all these kind folks have helped me
PS: sorry for the bad pictures, I’m no photographer 😶