Product has been added to your cart.

Conferences and Classes

Free Upcoming Webcasts: Query Store, R, AGs, Encryption, Security, and More

Last Updated November 14, 2017

GroupBy Conference

Here’s the lineup for the next free GroupBy online conference: Friday, December 1: 8:00 AM Eastern – Query Store and Query Optimization on SQL Server 2017 by Dean Savovi? 9:00 – Elegant T-SQL Solutions for Real World Problems by Matan Yungman 10:30 – SQL Server R Services in SQL 2016 by Chris Hyde 12:30 – SQL Server Health Checks…

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

Register Now for Next Friday’s Free GroupBy Conference

Last Updated August 21, 2017

GroupBy Conference

It’s that time again! Register for free now to attend next Friday, September 1. Here’s the lineup: 8AM Eastern – Why Defragmenting Your Indexes Isn’t Helping – Brent Ozar (@BrentO – BrentOzar.com) 10AM – How to Evaluate if SQL 2016 In-Memory OLTP is Right for Your Workload – Ned Otter (@NedOtter – NedOtter.com) Noon –…

Abstracts Open for GroupBy December

Last Updated August 11, 2017

GroupBy Conference

Want to present at the upcoming GroupBy December 1 & 8 online conference? Read the abstracts submitted so far Submit your own abstract Readers will comment on your abstract, helping you improve it (so don’t kill yourself working really hard on the first draft – think of it as a living abstract that you’ll work…

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

How to Join the SQL Server Community Chat in Slack

Last Updated December 11, 2020

GroupBy Conference

Just another day on Slack Slack is a team chat system where you can: Go to SQLslack.com to get a free instant invite, and then join Go to https://SQLcommunity.Slack.com, or download the Slack app Meet cool people and join their chat rooms Chat rooms at SQLCommunity include: #SQLhelp and #PowerShellHelp – very active #FirstResponderKit – questions and…

It’s #GroupBy time! Wanna watch free SQL Server training?

Last Updated April 17, 2017

GroupBy Conference

You voted in a great lineup for this Friday’s free GroupBy.org conference: 8AM Eastern – How to Use Parameters Like a Pro and Boost Performance by Guy Glantser 10AM – Introducing the SQL Server 2016 Query Store by Enrico van de Laar Noon – Worst Practices & Less Known Limitations for Columnstore Indexes by Niko Neugebauer 2PM – Gems to…

Registration is Open for GroupBy.org’s April Free Conference

Last Updated March 18, 2017

GroupBy Conference

GroupBy.org is our community training initiative where your votes pick the session lineup. Here’s the lineup you chose for GroupBy April: Friday, April 21: 8AM Eastern – How to Use Parameters Like a Pro and Boost Performance by Guy Glantser 10AM – Introducing the SQL Server 2016 Query Store by Enrico van de Laar Noon – Worst Practices…

Vote Now to Pick the #GroupBy April Lineup

Last Updated February 28, 2017

GroupBy Conference

GroupBy.org is a new free online conference by the community, for the community. You get to pick the session lineup. Yes, you. We just run whatever you wanna see. Here’s how to do vote: Open one browser with the list of abstracts for details Open another browser with the GroupBy voting page If you haven’t…

GroupBy Registration is Open for 3 More Days

Last Updated December 22, 2016

GroupBy Conference, SQL Server

GroupBy is a new community-driven conference where your voting picks the lineup. Here’s the sessions you chose: Friday January 13th: 8AM Eastern: SQL Server 2016: It Just Runs Faster with Bob Ward 9:30: SQL Server and PowerShell: Let’s Get Serious with Drew Furgiuele 11:00: Keep It Simple, Make It Fast: The SQL Server Strategy at…

Vote Now to Pick the GroupBy Conference Lineup

Last Updated February 14, 2017

GroupBy Conference

Voting closes soon at GroupBy, the new free online conference where YOU pick the lineup. Here’s the sessions up for votes – there’s a lot of them, so maybe focus on rating the sessions you find the most interesting – quantity of votes counts for a lot here: Analytics and Business Intelligence: High-Performance SQL Server…

Announcing Group By: A New Kind of Free Community Conference

Last Updated November 26, 2016

GroupBy Conference

Let’s try something new. Let’s build a free event by the community, for the community, where: Speakers submit abstracts publicly online. Anybody can submit an abstract on any topic – community members, software vendors, even Microsoft’s Bob Ward has submitted a session on 2016: It Just Runs Faster. Attendees suggest tweaks to the abstracts. You…

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