Posts by Brent Ozar

[Video] Office Hours in a Hotel Room

Videos
1 Comment
While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:38 Bisal Basyal: What is the best way to manage roles in sql server in Azure VMs (multiple). We want separate logins for each users but it should be same on all Azure SQL…
Read More
Ola Hallengren job configuration with @NumberOfFiles = 4 parameter

Two Tweaks for Faster Backups with Ola Hallengren’s Scripts

Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes. First, set @NumberOfFiles =…
Read More

[Video] Office Hours: 16 Questions

Videos
0
Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio is ever so slightly out of sync in this episode. 00:00 Start 01:26 GuaroSql: Hey Brent! How are you? It is necessary to enable ADR in sql 2019 in order to row versioning work better? Or it…
Read More

Coming in Entity Framework 9: Better Query Parameterization

Development
22 Comments
Hallelujah. With current versions of Entity Framework, when developers add a mix of parameters and specific values to their query like this: C# async Task<List<Post>> GetPosts(int id) => await context.Posts .Where( e => e.Title == ".NET Blog" && e.Id == id) .ToListAsync(); 12345 async Task<List<Post>> GetPosts(int id)    => await context.Posts        .Where(            e => e.Title == ".NET Blog" &&…
Read More

This Is It! The Last 3 Days of My Anniversary Sale.

Company News
0
Every year in May, I look back at when I first registered BrentOzar.com way back in May 2001. Things were so different back then. I struggled trying to find fun, interesting ways to learn about Microsoft SQL Server. My learning options were really dry books, droning videos sold on DVD, or – brace yourself –…
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for May 2024

If you’ve hard-coded installer file names, there’s a big change in this release. There are now just 2 installer scripts: Install-All-Scripts.sql, and a new Install-Azure.sql, which only installs the scripts that are compatible with Azure SQL DB. The old Install-Core scripts are gone because we’ve deprecated sp_AllNightLog, sp_BlitzInMemoryOLTP, and sp_BlitzQueryStore. Read on for why. Wanna…
Read More

[Video] Office Hours: I Feel Like an Amateur Edition

Videos
0
I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling like a SQL amateur! Here’s what we covered: 00:00 Start 01:52 Does Time Really Exist: Hi Brent! What is the best way to ETL? web application, SSIS, linked server, … 03:55 MyTeaGotCold: What is your vision for…
Read More

[Video] Office Hours: Answers for Your Database Questions

Videos
1 Comment
Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office before tackling a client’s performance issues: Here’s what we covered: 00:00 Start 00:45 Eve: When should you/should you not execute the SSMS recommended Missing Index in the execution plan? 02:42 MyTeaGotCold: Logging sp_WhoIsActive and sp_BlitzFirst to a…
Read More

I’m Getting Antsy for SQL Server vNext.

SQL Server 2025
24 Comments
Historically, Microsoft publicly announces the next version of SQL Server about a year before it ships. For example: November 2, 2021, Microsoft announced the private preview of SQL Server 2022. About 6 months later, on May 24, 2022, they announced the public preview. About 12 months after the private preview announcement, on November 16, 2022,…
Read More

Join Me at the PASS Data Community Summit in November!

#SQLPass
4 Comments
On November 4 in Seattle, I’m presenting a new pre-conference workshop! Tuning T-SQL for SQL Server 2019 and 2022 You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans. Your company is now using SQL Server 2019 or 2022 in production, and you want your queries…
Read More

[Video] Database Answers in Hong Kong

Videos
1 Comment
As my time in Hong Kong came to an end, I sat inside on a foggy morning and hit your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:32 MyTeaGotCold: Are there any signs of brain drain from SQL Server to Postgres? It seems that every SQL Server guru agrees that Postgres is…
Read More