Blog: Brent Ozar

211 blogs updated: 4 min. ago
Thank you, #sqlfamily, for donating to The Trevor Project.
A couple of weeks ago, we told you about how Andy Mallon's LGBTQ Meetup was raising money for The Trevor Project, and how we'd match up to $...
22-10-2018 22:09:14 Brent Ozar SQL Server
Announcing The Team Membership
You have a team of database developers and DBAs SQL Server professionals who want dedicated help. You want a predictable bill that includes ...
22-10-2018 15:22:11 Brent Ozar SQL Server
[Video] Office Hours 2018/10/17 (With Transcriptions)
This week, Brent, Erik, and Richie discuss small vendor apps, "Slow in the Application, Fast in SSMS?", virtualization, licensing, msdb back...
21-10-2018 17:36:43 Brent Ozar SQL Server
Is Cost Threshold for Parallelism Measured in Seconds?
SQL Server automatically chooses when to divide your query's work across multiple CPU cores. It makes that decision based on your query's co...
19-10-2018 15:34:00 Brent Ozar SQL Server
What Should We Change About the Data Professional Salary Survey for 2019?
Every year, we publish an open Data Professional Salary Survey. Last year, 3,113 folks from 73 countries answered, so we're doing it again t...
18-10-2018 16:32:48 Brent Ozar SQL Server
Skewing Parallelism For Fun And Profit
What Is Skewed Parallelism? When queries go parallel, some assumptions get made: There's enough work to keep multiple threads busy Each thre...
17-10-2018 16:16:02 Brent Ozar SQL Server
Index Tuning Week: Missed Missing Index Opportunities
A Reminder With a new baby in the house, I often find myself comparing her to various things. Barnacles. Ham. Pugs. No, I swear, I love her....
17-10-2018 06:45:12 Brent Ozar SQL Server
[Video] Office Hours 2018/10/10 (With Transcriptions)
This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is ...
17-10-2018 00:00:38 Brent Ozar SQL Server
Using NOLOCK? Here's How You'll Get the Wrong Query Results.
Slapping WITH (NOLOCK) on your query seems to make it go faster but what's the drawback? Let's take a look. We'll start with the free StackO...
16-10-2018 17:11:07 Brent Ozar SQL Server
Building SQL ConstantCare®: Separating Out the Videos
When we started offering SQL ConstantCare , our mentoring service, I wanted to make our web site as simple as practical. Too many choices ca...
16-10-2018 10:37:24 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.