Conferences and Classes

Registration is Open Now for My SQLBits Workshop!

SQLBits
2 Comments
Registration just opened up for my SQLBits workshop on Mastering Parameter Sniffing! Move fast – due to COVID, they’re spacing out the attendees, so there are even less seats available than usual. My workshops usually sell out quickly, so if you want a seat, you’ll need to hustle in. Here’s the session abstract: You’re a…
Read More

I’m Not Ready for Maskless Conferences Serving Finger Food.

At a conference in Belgium this week, Steve Jones posted a video: A real conference experience. Excellent crowd at @datamindsbe pic.twitter.com/TGZmw5PdmC — way0utwest ?? (He/Him/His) (@way0utwest) October 11, 2021 My first reaction was, “That’s an awful lot of people in really close proximity, talking loudly at each other, and none of them are wearing masks.”…
Read More

We Lost Gareth Swanepoel.

Community
21 Comments
Thirteen years ago, I met Gareth Swanepoel (@GarethSwan) for the first time, interviewed him for his first real sysadmin job, and … turned him down. Gareth Swanepoel circa 2007 Thankfully, my manager overruled me and hired him anyway. Thank goodness – and thank goodness Gareth forgave me for my incredibly bad judgment, hahaha. Gareth proved…
Read More

As an Attendee, What’s Important to You In a New Data Community?

Conferences and Classes
51 Comments
With PASS shutting down, it’s time to think about what the community builds in its place. There are a lot of efforts going towards building replacements for PASS, including Microsoft’s own efforts. Because these efforts are often led by active community volunteers, they’re very well in touch with what event organizers, sponsors, and speakers want…
Read More

How to Learn SQL Server in One Year

Conferences and Classes
4 Comments
You’ve been using Microsoft SQL Server for a few years, and it’s becoming increasingly important to your job. You can write a query, but… You feel like something’s missing. You attended a few local user groups or meetups before the quarantines hit, but you were disappointed at how scattered the sessions were. The material was…
Read More

Free Webcast on Dynamic SQL Pro Tips

Dynamic SQL is one of the most powerful tools in the database developer’s arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by leveraging better indexes. However, when done wrong, it’s extremely painful to troubleshoot. I’ve been working with…
Read More
Menu