Product has been added to your cart.

#SQLPass

PASS Summit 2018

PASS Summit 2018 Keynote Day 2: Live Blog

Last Updated November 24, 2018

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…

PASS Summit 2018

PASS Summit 2018 Keynote Day 1: Live Blog

Last Updated November 7, 2018

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…

PASS Summit 2018

Picking #PASSsummit Sessions to Attend

Last Updated November 5, 2018

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…

Thank you, #sqlfamily, for donating to The Trevor Project.

Last Updated October 22, 2018

#SQLPass, Company News

A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for The Trevor Project, and how we’d match up to $5,000 of your donations. This weekend, you did it. You hit the $5,000 mark. I’m so proud of you. This is the caring, welcoming community that I love.…

LGBTQ Meetup at the PASS Summit

Last Updated October 8, 2018

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,…

Going to Summit? Here’s a Calendar Invite for My Session.

Last Updated September 6, 2018

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…

Performance Tuning in 21 Demos at the PASS Summit 2018

Last Updated October 21, 2018

#SQLPass, Company News

Performance Tuning in 21 Demos You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. You don’t like learning by watching slides or reading white papers – you want to jump right into the code and see what happens. You’re the kind of person who loves watching…

Tom Roush, the SQL Server community’s best storyteller.

Last Updated January 30, 2018

You, dear reader, know a lot of SQL Server community names from their blogs, webcasts, podcasts, presentations, books, etc. It can feel pretty overwhelming – there’s so many sites to keep up with, so much good technical material. But even still, you’re only seeing the tip of the iceberg. There are so many wonderful people…

#PASSsummit Day 2 Keynote: Dr. Rimma Nehme on Azure Cosmos DB

Last Updated November 2, 2017

#SQLPass, Microsoft Azure

Dr. Rimma Nehme Summit day 2 keynotes have become special. Over the last few years, Microsoft has dedicated the day 2 keynote to a technical dive into an advanced, future-looking topic. Past examples have included future-looking guidance on Hekaton, columnstore indexes, and how Azure SQL DB protects data. I love Microsoft for doing this. It costs…

#PASSsummit Day 1 Keynote Live Blog

Last Updated November 1, 2017

Good morning, folks, and welcome to our annual live blog of the PASS Summit Day 1 keynote. Open the free live video stream at PASSsummit.com in one browser tab, and then refresh this page every couple/few minutes. I’ll be adding my thoughts at the end of the page, in chronological order, for easier reading later. Today’s…

#PASSSummit Expert Performance Tuning Pre-Con: Stretch Goals

Last Updated October 6, 2017

Sure, they look trustworthy Eric and I are doing a PASS Summit pre-con class called Expert Performance Tuning for SQL Server 2016 & 2017. To encourage signups, we’re giving every attendee a free Enterprise/Everything Bundle, plus some other surprises you’ll get during the event. Response has been absolutely bonkers – over 300 of you have…

[Video] Last Season’s Performance Tuning Techniques

Last Updated August 1, 2017

#SQLPass, Development, Videos

You’re kinda-sorta comfortable doing performance tuning on SQL Server. You’ve read a few blogs, you monitor Page Life Expectancy, you rebuild your indexes, and you add an index here or there. However, you haven’t been to a day-long performance tuning class yet, and you’re wondering what you’re missing. Thing is, in SQL Server, performance tuning…

Last Season’s Performance Tuning Techniques: Slides & Demos

Last Updated August 1, 2017

#SQLPass, Development

Right now, Erik and I are presenting at the 24 Hours of PASS. We’re talking about Last Season’s Performance Tuning Techniques: Wanna play along with us as we show how your performance skills might be a little out of date? Here’s the demos and the slides: https://www.slideshare.net/BrentOzar/last-seasons-performance-tuning-techniques Fill Factor: Doing the Page Splits You can…

24 Hours of PASS: Last Season’s Performance Tuning Techniques

Last Updated June 22, 2017

Brent, last season (and I have so many good bad photos to share) I’m excited to announce that Erik and I are presenting the opening session at this year’s free online 24 Hours of PASS webcasts! Here’s our session: Last Season’s Performance Tuning Techniques You’re kinda-sorta comfortable doing performance tuning on SQL Server. You’ve read…

New #SQLPASS Summit Pre-Con: Expert Performance Tuning for SQL Server 2016 & 2017

Last Updated October 6, 2017

#SQLPass, Company News

Going to the PASS Summit in Seattle this year? Join me & Erik Darling on Tuesday, the day before the conference, at our pre-con session, Expert Performance Tuning for SQL Server 2016 & 2017. Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out.…

This Year is Your Best Chance to Speak at the PASS Summit.

Last Updated May 22, 2017

#SQLPass, Writing and Presenting

Me presenting, photo by John Martin The call for speakers at the PASS Summit is open now. As of this writing, there are less than 120 sessions submitted. To put that in perspective, in 2016, there were 758 sessions submitted overall, and about ~175 general session spots. Your chances have never been better. Get in…

Wanna speak at the PASS Summit? Here’s how.

Last Updated April 16, 2017

#SQLPass, Writing and Presenting

The PASS Summit is the biggest SQL Server community event, and a lot of us speakers have “present at PASS” on their bucket list. Getting in is legendarily difficult because competition is fierce. Many sessions are submitted for each one that’s accepted, and you have to work hard to stand out from the pack. This year’s Call…

Reminder: Rate Your Summit Sessions (and Watch Mine Now!)

Last Updated April 9, 2017

PASS Summit attendees, we need your feedback. The greatest gift you can give back to your volunteer speakers is your comments to help them get better. Ratings are good – but what we really like is constructive comments. Don’t be polite – if you hated a session (mine included!), say why. Presenters really want to get better,…

My How to Think Like the Engine Class is Now Free – and Open Source

Last Updated April 9, 2017

#SQLPass, SQL Server

You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. You’ve never had a formal database internals class, and you don’t really have the patience to read a book on it – but you…

Quentin Clark

Thoughts About the #SQLSummit Day 1 Keynote

Last Updated February 12, 2017

Quentin Clark I’ll be honest, dear reader: I usually hate the holy hell out of the Summit day 1 keynote. As an example, check out the last keynote I liveblogged – go to the bottom and then read up. (Sorry, I won’t do that style again.) It was awful, one of the worst two hours…