Red Gate SQL in the City: Chicago

Back at the first Chicago Free-Con event in 2011, Brent Ozar was talking about how wonderful the SQL Saturday movement is and prophesized that in the near future we'll be seeing similar free training events put on by individual vendors instead of community volunteers. Eighteen months later I found myself at Red Gate's SQL in the City, a multi-city tour which fit very well into Brent's prediction. The Chicago event took place on Friday, October 5.

The Event

SQL in the City The tagline for SQL in the City was "Free SQL Server Training the Red Gate way." I'm happy to say that the Red Gate way was a great improvement over what I'm used to. I've been to plenty of dog and pony shows put on by vendors where they demonstrate how you can create an entire website, database, and private cloud with zero keystrokes and only 4 mouse clicks. You are then sent home, usually with more questions than you came with. Here there was plenty of time for meaningful questions and conversation, which made a significant difference.

As with many events, the day was divided into sessions and tracks covering a wide variety of SQL Server topics. Many sessions centered around Red Gate tools and problems that could be solved by using them. I thought all the presentations I attended were very fair in that they discussed not only how Red Gate tools could help in certain situations, but also covered cases where they might not be as helpful and you may be better suited by utilizing native SQL Server functionality. I really appreciate it when a vendor isn't ashamed to talk about the limitations or tradeoffs associated with using their tools.

I was also very impressed with the number of UK-based staff that Red Gate brought on this tour. There were developers, project managers and experts for all their products available to answer questions and do demos. Several of these "Red Gaters" were presenters throughout the day. Some local experts were also invited to present, including Allen White (blog | @SQLRunr), Jes Schultz Borland (blog | @grrl_geek), and Brent Ozar (blog | @BrentO).


Red Gate is a supporter of the SQL Server community in many ways, including sponsorship of SQL Saturdays, sending swag to user groups, and running And while putting on events like these is an excellent way to bring people together to learn from presenters and each other, they went one step further and included breaks in the schedule for even more socializing. Attendees were encouraged to grab a snack, a drink, and network amongst each other and the Red Gaters. At the end of the day there was a reception with more drinks, snacks, and prize drawings. Everyone also got a goodie bag and their choice of a book from Red Gate's published collection – there were tons to choose from!

Prettier than the average auditorium


Like most people who have lived near Chicago their entire life, I rarely visit any of the tourist attractions in the city. I was happy that the Field Museum was chosen as the venue since I've only been there a handful of times, mostly on school field trips long ago. I was surprised to find that the museum had a beautiful auditorium and smaller lecture halls available for hosting an event like this. There was plenty of space for everyone as well as award-winning restrooms.


A huge thank you to Red Gate for taking the time to put on this excellent event for the community. To plan this tour, give away lots of free stuff, and bring their employees over from Cambridge is clearly a costly undertaking, but it's also a tremendous demonstration of Red Gate's commitment to community. I got a ton of knowledge out of it and learned a bunch more about their products, including some I didn't know existed. I was able to meet lots of new people and see some familiar faces as well.

I'd also like to thank Annabel Bradford, event manager for the SQL in the City tour. While all the Red Gaters were clearly working very hard to ensure this was a success, it was evident that Annabel was in charge as she spent most of the day being in multiple places at once and keeping everything running smoothly. Well done!

I'd also like to thank my employer for allowing me to attend. I talked to a disturbingly high number of people who had to take personal or vacation time so they could come. One attendee told me management wrote it off as "just another vendor event", while someone else said their boss told them "if you want free training, pick a book off my shelf". I also spoke with some people who were unable to attend because work decided they've been to "too much training" this year. I find that incredibly upsetting – if someone has no meetings to attend and is otherwise caught up with their work I see no reason why they shouldn't be able to go attend a free local event that will probably show them at least one way they can get their job done better/cheaper/faster. I'm very grateful to work in an environment where training is supported and encouraged.

It's Not Over Yet

If SQL in the City sounds like something you'd like to attend, there's still 1 more event left in Seattle on November 5, right before the PASS Summit. As of this post going live, registration is still open. Sign up – you'll have a great time!