Conferences and Classes

It’s time for another day of free training for the community, by the community. Here’s the lineup you voted in for next Friday’s free GroupBy.org conference: 8AM Eastern – Not just polish – How good code also runs faster by Daniel Hutmacher 9:15 – The Perfect Index by Arthur Daniels 10:30 – Be My Azure DBA (DSA) by…

Announcing a Very Special #SQLFamily Webcast with Dr. David DeWitt

June 8, 2018

Conferences and Classes

On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special presentation: SQL Query Optimization. Why is it so hard to get right? Dr. David DeWitt The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the…

Performance Tuning in 21 Demos at the PASS Summit 2018

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

Attending our SQLBits Pre-Con? Prepare Your Laptop Now.

February 12, 2018

SQLBits

If you’re joining Erik & me at our SQLBits precon, Expert Performance Tuning for SQL Server 2016 & 2017, you’ll be able to follow along with the demos on your laptop. We’re going to be showing you some common and not-so-common query anti-patterns, and explaining how they’re easier to solve with SQL 2016 & 2017.…

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

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…

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

November 17, 2017

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

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

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

September 25, 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

August 22, 2017

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

August 12, 2017

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

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

July 19, 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: Last Season's Performance Tuning Techniques from Brent Ozar Fill…

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

June 22, 2017

bad hair decade, fashion

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

June 15, 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.

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.

April 19, 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

April 18, 2017

groupby, slack

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: #general – super active, general chat where everybody…

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

April 17, 2017