Blog: Brent Ozar

210 blogs updated: 6 min. ago
Does an Index on Just The Clustering Key Ever Make Sense?
Say you've got a table in this case, I'm using the Stack Overflow Posts table, which holds all of the questions and answers: See the cluster...
20-04-2018 15:35:30 Brent Ozar SQL Server
So You Wanna Debug SQL Server Part 2
Birth Control Debugging, and, heck, even learning about debugging, is a time-consuming and often unhelpful process when it comes to tracking...
19-04-2018 20:43:41 Brent Ozar SQL Server
Index Key Column Order And Supporting Sorts
Whatever Man When tuning queries that need to sort large amounts of data, sometimes it makes sense to stick the ordering elements as the lea...
18-04-2018 16:33:11 Brent Ozar SQL Server
Parking Garages And Predicates
Hotels on Wheels Parking garages and predicates have a "lot" in common. GET IT? No no but seriously. They do. If you've ever lost your ticke...
17-04-2018 16:06:55 Brent Ozar SQL Server
Building SQL ConstantCare®: The Database
I bet, dear reader, that this is the post you've been really curious about in my behind-the-scenes posts. Back in the post about the data we...
16-04-2018 16:14:11 Brent Ozar SQL Server
[Video] Office Hours 2018/4/11 (With Transcriptions) with Special Guest Edwin M Sarmiento
This week @EdwinMSarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-premises se...
15-04-2018 16:49:11 Brent Ozar SQL Server
Training Week: Data Science Fundamentals with a Real Project
When Steph Locke first ran her Data Science Fundamentals with R class, I was amazed at the work she put into the hands-on labs for the stude...
13-04-2018 15:53:56 Brent Ozar SQL Server
Training Week: Announcing Ben Miller's PowerShell for DBAs: Level 2
Drew Furgiuele s PowerShell for DBAs class has been getting rave reviews, including: "Fantastic class! This is the best online training I've...
12-04-2018 15:50:35 Brent Ozar SQL Server
Training Week: Announcing Edwin's New Class on Failover Clustered Instances
This week, we've got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group c...
11-04-2018 19:43:51 Brent Ozar SQL Server
Training Week: PASS Summit 2018 Pre-Con: 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 slid...
11-04-2018 13:00:28 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.