#SQLPass

On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and 2022 You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans. Your company is now using SQL Server 2019 or 2022 in production, and you want your queries…

This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year – you gotta be there in person.) If you’ve attended in person before, you already know the value: it’s like a family reunion for the Microsoft data community. It’s your chance to see the authors you’ve read…

I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about last week’s conference in Seattle. I liveblogged the keynotes, but I wanted to talk about the conference overall. This was Redgate’s first time running an in-person Summit after the professional organization folded in December 2020. Redgate bought…

I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. This year, now that Redgate owns the Summit event, they’re doing the day 2 keynote. Gotta pay the bills, I suppose! Redgate’s CEO, Jakub Lamik, is leading a team of speakers for the keynote, and here’s the…

If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something from Hugo Kornelis. Hugo is the wildly productive and selfless guy behind the Execution Plan Reference, SQLServerFast.com, tons of SQLBits sessions, videos on YouTube, and he’s @Hugo_Kornelis. He’s unbelievably upbeat and positive. He loves what he does, and…

I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. This is the first in-person Summit since the pandemic, and the first since Redgate took over ownership from the old PASS organization. I’m really excited – this is like a family reunion for me. Microsoft’s Rohan Kumar…

I’m so excited to see everybody again at the PASS Data Community Summit in Seattle on November 14-18. I’M BACK IN PERSON! Here’s the crazy part: I’m not going to attend a single session. Not one. (Well, except the ones I’m teaching, and the keynotes.) Instead, I’m gonna spend every single conference hour hanging out in…

The lineup for the PASS Data Community Summit is out, and in addition to my pre-conference workshop on Mastering Parameter Sniffing, I’m also teaching two sessions: Everything You Know About Parallelism Is Wrong. Just because you see parallelism icons on execution plans doesn’t mean the query went parallel. SQL Server doesn’t load-balance work across CPU cores.…

At the PASS Data Community Summit in Seattle on November 12th, I’m teaching a one-day pre-conference workshop. This year, the Summit is a hybrid event: you can either attend in-person in Seattle, or online via live streaming. If you attend online, PASS is recording the live stream, and you’ll be able to re-watch it during the…

For years, the biggest conference in the Microsoft data platform community has been the PASS Summit. This November 15-18, it’s coming back to the Seattle Convention Center. You can attend in person, or virtually. I’m going to be there in person. It’s not a decision I take lightly – I still get nervous when I…

The PASS Summit is November 15-18 in Seattle this year. This time around, it’s a hybrid conference, with both speakers and attendees in a mix between in-person and remote. I’m really excited to get back to in-person events. I recently attended SQLBits in London, and I actually got emotional at the sight of so many…

Succeeding as a data professional is all about placing the right bets at the right times. The more you know about what’s happening around you, the better bets you can place. I’ve been working with databases for over two decades. In this session, I’ll invite you into my home to have a frank, honest discussion…

This afternoon, PASS announced that their operations will cease in January: We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular operations, effective January 15, 2021. We encourage you to take full advantage of any access that you have to PASS content between now and January 15,…

Our industry’s biggest conference, the PASS Summit 2020, just opened their pre-conference workshop call for speakers. I’m going to submit a couple of sessions, but I want to hear from you first: if you were going to try to convince your boss to buy you a pre-conference workshop at Summit, what would be the topics…

Today is the second day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Yesterday, we got the marketing keynote that caught attendees up with the current state of SQL Server 2019 and Azure services. The attendees I talked to yesterday were impressed with the demo amounts & topics, too. Today is…

Today is the opening day of the 2018 PASS Summit, the largest annual gathering of Microsoft data professionals. Every year, thousands of us gather at the Seattle Convention Center to connect, learn, and share. On this first day of the conference, all the attendees go to the same room to watch the keynote speech. To…

So you’re going to the PASS Summit in Seattle this week, and you’re overwhelmed with the number of session choices. You’re not alone – it overwhelms me too. There are some slots where I wish I could clone myself and attend several sessions at once. Here’s how I do it. First priority: paying back your…

The SQL Server community is known for its welcoming acceptance of everyone, regardless of their experience or background. The SQL Server family actively reach out to help others and bring folks together. A great example of that is the LGBTQ Meetup organized by Andy Mallon (@amtwo.) Whether you identify as gay, lesbian, bisexual, transgender, questioning,…

At Summit, on Wednesday at 1:30PM in room 6C, I’m presenting “Getting Better Query Plans by Improving SQL’s Estimates.” Add to GMail Calendar ICS file for Outlook or other calendar apps Here’s the abstract: Like Books Online, but with jazz hands You’ve been writing T-SQL queries for a few years now, and when you have…