Blog: Brent Ozar

213 blogs updated: 78 min. ago
Does low fill factor affect SELECT performance?
Sometimes good intentions lead to big problems. Imagine a system where page splits were thought to be causing a big enough performance probl...
12-12-2018 18:29:44 Brent Ozar SQL Server
Tell Us What You Make: The 2019 Data Professional Salary Survey
It's time for our annual salary survey to find out what data professionals make. You fill out the data, we open source the whole thing, and ...
11-12-2018 16:07:44 Brent Ozar SQL Server
Have Availability Groups Gotten Easier Lately?
Easy Lover I don't blog a lot about AGs. If we're being honest (and I do try to be honest with you, dear reader), I just like performance tu...
10-12-2018 15:07:32 Brent Ozar SQL Server
[Video] Office Hours 2018/12/5 (With Transcriptions)
This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading ser...
08-12-2018 22:35:40 Brent Ozar SQL Server
"Surely this one will get a clustered index scan."
I love building demos for our training classes because I'm constantly in a battle of the minds with SQL Server. I try to guess what he's goi...
07-12-2018 15:24:14 Brent Ozar SQL Server
Azure SQL DB is Slow: Do I Need to Buy More DTUs?
You've got an Azure SQL DB, and your queries are going slow. You're wondering, "Am I hitting the performance limits? Is Microsoft throttling...
06-12-2018 16:21:30 Brent Ozar SQL Server
Indexed View Matching With GROUP BY And DISTINCT
Bit Of A Kick I've been playing with indexed views a little bit lately for some demos in my Bits Precon. There are a whole bunch of limitati...
05-12-2018 21:09:50 Brent Ozar SQL Server
Indexed View Creation And Underlying Indexes
Accidental Haha While working on some demos, I came across sort of funny behavior during indexed view creation and how the indexes you have ...
04-12-2018 20:32:18 Brent Ozar SQL Server
How to Log Active Queries with sp_BlitzWho
Queries are running when you're not around. They're wreaking havoc maybe they're filling up your TempDB, or causing blocking, or flushing yo...
03-12-2018 15:52:58 Brent Ozar SQL Server
[Video] Office Hours 2018/11/28 (With Transcriptions)
This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the ...
02-12-2018 16:55:38 Brent Ozar SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.