Blog: Brent Ozar

210 blogs updated: 64 min. ago
How to Throttle Logins to SQL Server
So, uh, you can use WAITFOR in a logon trigger: [crayon-5a8c36a16b9140730 75893/] You probably don't want it to be TOO long, lest their app ...
20-02-2018 15:57:59 Brent Ozar SQL Server
The Many Levels Of Concurrency
"Concurrency is hard" When designing for high concurrency, most people look to the hardware for answers. And while it's true that it plays a...
19-02-2018 15:36:24 Brent Ozar SQL Server
[Video] Office Hours 2018/2/14 (With Transcriptions)
This week, Brent, Tara, and Richie discuss the lack of backward compatibility for SQL Server backups, deploying SQL Server on VMs with share...
17-02-2018 19:25:38 Brent Ozar SQL Server
Then Why Doesn't SQL Always Seek?
Scan The Man There seems to be a perpetual battle waged against the Index Scan. At some point it was declared that scans were inferior to se...
16-02-2018 15:26:45 Brent Ozar SQL Server
New SQL Server Management Studio 17.5: It's Classified
SQL Server Management Studio 17.5 is out, and new in this release is a SQL Data Discovery & Classification feature. The idea is that it'll s...
16-02-2018 02:02:38 Brent Ozar SQL Server
Memory Grants: SQL Server's Other Public Toilet
Sharing Is Caring When everything is going well, and queries are behaving responsibly, one need hardly think about memory grants. The proble...
15-02-2018 15:18:04 Brent Ozar SQL Server
How to Suck at Database Admininstration
This isn't about having a sucky job, this is about you sucking at your job. There's a big difference. You could be sucking at your job becau...
14-02-2018 16:29:48 Brent Ozar SQL Server
#TSQL2sday: What I'm Passionate About – Sas Christian's Art
For this month's T-SQLTuesday, Aaron Bertrand asked what we're passionate about but outside of the tech community, and asked for pictures. S...
13-02-2018 14:59:19 Brent Ozar SQL Server
Attending our SQLBits Pre-Con? Prepare Your Laptop Now.
If you're joining Erik & I at our SQLBits precon, Expert Performance Tuning for SQL Server 2016 & 2017, you'll be able to follow along with ...
12-02-2018 15:03:34 Brent Ozar SQL Server
The Annals of Hilariously Bad Code, Part 2
You're Crazy In Part 1, I showed you code that I think has some anti-patterns in it. In case you didn't recognize it, it's actually code tha...
09-02-2018 15:23:57 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.