Blog: Brent Ozar


209 blogs updated: 27 min. ago
Bad Idea Jeans: Multiple Index Hints
I hate that you can do this Here's the thing: I'm mostly writing this because I didn't know you could do it. But it's cool, because it'll re...
20
26-05-2017 15:54:09 Brent Ozar SQL Server
Building a Faux PaaS, Part 3: What the Ideal Engineering Team Looks Like
Background: I'm working with kCura to build a Faux PaaS: something akin to Microsoft's Azure SQL DB, but internally managed. You can catch u...
22
25-05-2017 15:12:06 Brent Ozar SQL Server
Scalar Functions In Views: Where's The Overhead?
Short winded Quite often people will inherit and rely on views written back in the dark ages, before people were aware of the deleterious ef...
20
24-05-2017 15:46:24 Brent Ozar SQL Server
#DevIntersection Keynote Notes: Jeffrey Snover on Azure Stack
Preface: data professionals, if you're in a hurry, skip this post. Nothing in here is directly relevant to your career in the next couple of...
28
22-05-2017 20:39:13 Brent Ozar SQL Server
This Year is Your Best Chance to Speak at the PASS Summit.
The call for speakers at the PASS Summit is open now. As of this writing, there are less than 120 sessions submitted. To put that in perspec...
24
22-05-2017 14:08:23 Brent Ozar SQL Server
[Video] Office Hours 2017/05/17 (With Transcriptions)
This week, Erik, Tara, and Richie discuss enforcing password expiration for SA logins, keeping things in sync between servers, development/p...
18
21-05-2017 14:49:01 Brent Ozar SQL Server
What Do You Want to See in a Free Query Store Tool?
I love Query Plans No seriously, I love digging into query plans. Even writing XQuery to dig into them in sp_BlitzCache. I was both honored ...
20
19-05-2017 22:45:15 Brent Ozar SQL Server
Do SQL Server 2017's Adaptive Joins Work with Cross Apply or Exists?
I think I've mentioned that the most fun part of new features is testing them with old ideas to see how they react. It occurred to me that i...
18
19-05-2017 16:18:51 Brent Ozar SQL Server
Building a Faux PaaS, Part 2: Choosing and Testing a Cloud Vendor
Background: I'm working with kCura to build a Faux PaaS: something akin to Microsoft's Azure SQL DB, but internally managed. In Part 1 of th...
24
18-05-2017 15:44:23 Brent Ozar SQL Server
Adaptive Joins And Scalar Valued Functions
I know, I know Here we are in 2017, which means we're about two years away from the next Ska revival effort, if my watch is correct. I hope ...
20
18-05-2017 00:09:18 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.