Wrap-up catch-up

Thanks to all who have attended my recent sessions!  This has been quite a busy summer with a number of firsts, some of which I’ll talk about in this post.

In June, I presented two sessions at my home SQL Saturday in Iowa City: “SQL Server Features That Will Blow Your Mind!” and “Get Involved”.  I had fantastic crowds for both with a lot of great questions.  I also had the privilege of participating in a panel discussion with my friend David Klee about discussing infrastructure needs with your admins; that experience was a first for me, but it certainly won’t be the last.  All in all, we had a great crowd at our sixth SQL Saturday, and we had a great time putting on the event!

One person asked me after the “Features” session in Iowa City if I had any suggestions for books to get more information on the topics.  I’m very late with the answer (and I sincerely apologize for that), but I haven’t forgotten!  For those wanting to find out more about these features, I would highly recommend two books that are always at hand on my bookshelf: Itzik Ben-Gan’s Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions is all about window functions and how they can be used to your advantage; and Kalen Delaney’s excellent SQL Server Internals books (Microsoft SQL Server 2008 Internals and Microsoft SQL Server 2012 Internals) contain sections on sparse columns, filtered indexes, and snapshot isolation.  Grant Fritchey’s SQL Server Query Performance Tuning also contains a short but well-written section on filtered indexes, and Microsoft’s Books Online also has good information on all four features.

In July, I spoke for the first time at Iowa Code Camp in Iowa City.  Iowa Code Camp is a similar event to SQL Saturday but is focused on a wide array of developer-oriented topics.  I met quite a few new people and attended sessions on several topics that were new to me.  I presented the “Features” session at this conference to a large group that was very engaged with the topic.  Thanks for all of the great questions!  While I can’t make the fall event, I’ll definitely be submitting to Code Camps again next year.

On September 13, I spoke at SQL Saturday in Kansas City, my second trip to that event.  I presented the “Features” session to that group, as well, and also had a great group there.

And finally, on September 20, I spoke for the first time at SQL Saturday in Denver, presenting “Service Broker: The Queue Continuum”.  The attendance was smaller for this session, but no less interested in the topic.  Thanks for the great questions and feedback!  I spoke to a few of you after the session, and I have some great ideas for revisions to the session that will help it become even better.

One question was also asked in the Denver session about whether Database Mail could be throttled. At the time, I said that I wasn’t sure but that I thought that you could. I was incorrect; Database Mail does not have any direct control over that. However, you could work around that by creating a holding queue in Service Broker and only releasing a certain number of messages per hour. I apologize for the confusion!

The slides and demos for the latest versions of both sessions are on my Presentations page.  Thanks again to all who attended, and thanks to the organizers and volunteers for all these events!

 

Ed

Ed Leighton-Dick helps small and midsize businesses solve their most challenging database performance, resiliency, and data security issues at Kingfisher Data, the consulting firm he founded in 2014. He has taught thousands of people at over 200 events, including the world's largest Microsoft data platform conferences, and he has been a leader in the Microsoft data community since 2008. Microsoft has recognized Ed seven times as a Data Platform MVP for his expertise and service to the data community.