Posts by Brent Ozar

Brent Ozar

1884 posts

https://www.brentozar.com

I make Microsoft SQL Server go faster. I love teaching, travel, and laughing. I live in California with my wife Erika.

Unveiling the 2020 Black Friday Sale Lineup

October 29, 2020

Brent Ozar

Company News

I love Black Friday sales. I would never normally just go buy a TV out of nowhere – unless mine was broken or something – but as Black Friday approaches, I find myself scanning all the upcoming ads, reading reviews, and comparing features. It’s a fun diversion, and gives me an excuse to avoid work…

How to Learn SQL Server in One Year

October 26, 2020

Brent Ozar

Conferences and Classes

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…

New Music Friday: Killa DBA’s New Release Just Dropped

October 23, 2020

Brent Ozar

Humor

Familiar readers will know that I don’t actually do New Music Friday here very often. Okay, ever. I don’t do it ever. Because frankly, nobody writes music about us. Nobody except Homer McEwen, aka Killa DBA (YouTube – @KillaDBA). You may remember him from The SQL Server 2017 Song, and if not, you should go…

If Your Trigger Uses UPDATE(), It’s Probably Broken.

October 21, 2020

Brent Ozar

T-SQL

In yesterday’s blog post about using triggers to replace computed columns, a lively debate ensued in the comments. A reader posted a trigger that I should use, and I pointed out that their trigger had a bug – and then lots of users replied in saying, “What bug?” I’ll demonstrate. We’ll take the Users table…

Using Triggers to Replace Scalar UDFs on Computed Columns

October 20, 2020

Brent Ozar

T-SQL

Your database is riddled with computed columns whose definition includes a scalar user-defined function. Even up to & including SQL Server 2019, which boasts faster scalar function processing, any table that includes a scalar function cause all access to that table to go single-threaded. In that case, a trigger can actually be a great replacement.…

Building SQL ConstantCare®: What Database Growths Do You Care About?

October 16, 2020

Brent Ozar

SQL ConstantCare

SQL ConstantCare® alerts you when your databases have unusual growths. No, not like that one on your neck. And you should really get that checked out. No, I’m talking about a database that suddenly jumps in size, making you suspicious about whether somebody created a backup table or built a set of ridiculously large indexes.…

Updated First Responder Kit and Consultant Toolkit for October 2020

October 15, 2020

Brent Ozar

First Responder Kit Updates

In preparation for this month’s new Fundamentals of Columnstore class, sp_BlitzIndex has a few cool new tricks! I’ll show you how to use ’em for free in the upcoming How I Use the First Responder Kit class, too. Columnstore indexes are kinda like an index on every column (called a segment), and plus they’re kinda…

Free Webcast on Thursday: Avoiding Deadlocks with Query Tuning

October 14, 2020

Brent Ozar

Locking, Blocking, and Isolation Levels

To fix blocking & deadlocks, you have 3 tools: Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.) Use the right isolation level for your app’s needs. (I cover that in the Mastering Server Tuning class.) Tuning…

Databases Are Like Walk-In Coolers. #tsql2sday

October 13, 2020

Brent Ozar

Production Database Administration

#tsql2sday

In the back of a restaurant, there’s a walk-in cooler (or a few of ’em.) When a chef needs to make something, she goes into the walk-in cooler, gathers the necessary ingredients, and then comes out to the kitchen to do the cooking. She doesn’t cook inside the walk-in – that wouldn’t be efficient. She just…

Free Live Fundamentals Classes, Registration Open Now

October 12, 2020

Brent Ozar

Videos

Update Oct 29th – classes are over. Thanks for joining in! Well, this quarantine just isn’t letting up, so it’s time for another round of free training. I’m running 3 free live classes on October 26-28: October 26: Fundamentals of Index Tuning – 9AM-5 Eastern – iCal October 27: Fundamentals of Query Tuning – 9AM-5 Eastern– iCal October 28: How I Use the First Responder…

Woohoo! We Hit 25,000 YouTube Subscribers.

October 10, 2020

Brent Ozar

Videos

As I finished this weekend’s live stream, I noticed that we crossed a big number. The Brent Ozar Unlimited YouTube channel now has over 25,000 subscribers. Well, that’s kinda awesome. I’ve had a great time doing all kinds of free live streams during the quarantines, and it’s been super fulfilling seeing so many folks show…

What Is the SQL Server CEIP Service?

October 8, 2020

Brent Ozar

SQL Server

The CEIP Service is the Customer Experience Improvement Program that sends telemetry data back to Microsoft. When you install Microsoft SQL Server, the CEIP Service is installed too. You can’t disable it during installation: it shows up in your services list whether you want it or not. You know it’s high quality when they can’t…

Poor Man’s Resource Governor: Database-Scoped Configurations

October 6, 2020

Brent Ozar

Bad Idea Jeans

Let’s say you had report queries that were going wildly parallel, and you wanted to put a stop to it, but you couldn’t afford SQL Server Enterprise Edition. You could do is create databases with different MAXDOP settings: CREATE DATABASE [MAXDOP4] GO USE [MAXDOP4] GO ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 4; GO CREATE…

Free Webcast on Wednesday: The New Robot DBAs in SQL Server 2017, 2019, and Azure

October 5, 2020

Brent Ozar

Conferences and Classes

The robots are really just people wearing metallic masks. You’ve been hearing about all these robots that are coming to take your job. They’re going to automate all the performance tuning and make your life way easier, right? Or harder, I guess…since you’ll be looking for a job. Thing is, most of that is just…

Want to use columnstore indexes? Take the ColumnScore test.

October 1, 2020

Brent Ozar

Columnstore Indexes

When columnstore indexes first came out in SQL Server 2012, they didn’t get a lot of adoption. Adding a columnstore index made your entire table read-only. I often talk about how indexing is a tradeoff between fast reads and slow writes, but not a lot of folks can make their writes quite that slow. Thankfully, Microsoft…

Announcing a New Class: Fundamentals of Columnstore

September 29, 2020

Brent Ozar

Columnstore Indexes

Your report queries are too slow. Will columnstore indexes help? You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your growing data. It’s already up over 250GB, and they’re not letting you purge…

Building SQL ConstantCare®: Warning You About New Large Tables & Indexes

September 28, 2020

Brent Ozar

SQL ConstantCare

When I’m doing a SQL Server health check, one of the things I like showing clients is a list of their top tables by size. Inevitably, there are a bunch of tables that: Tables whose names start with “temp” or “backup” or “just_in_case” Tables with no clustered index that were clearly created with a select-into,…

The 4 Presentations I’m Proudest Of, and What Inspired Them

September 24, 2020

Brent Ozar

Videos, Writing and Presenting

I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are some of the free public presentations I’m the most proud of, and the stories of how they came to be. #4: Watch Brent Tune Queries (2014)…

I Would Love a “Cost Threshold for Recompile” Setting.

September 23, 2020

Brent Ozar

Parameter Sniffing

I’m tired of sniffing your parameters. In environments where complex queries can get bad plans due to parameter sniffing, it would help to say that all queries with an estimated cost over X should be recompiled every time they run. For example, in environments where most of my workload is small OLTP queries, I’m fine…

SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases.

September 22, 2020

Brent Ozar

Backup and Recovery

Snapshot backup tools like Azure Site Recovery and Veeam are great for sysadmins. They let you quickly replicate a virtual machine to somewhere else without knowing too much about the server’s contents. To pull it off, they use the Windows Volume Shadow Copy Service to do snapshot backups – often referred to as VSS snaps.…