Blog: Brent Ozar

208 blogs updated: 33 min. ago
sp_AllNightLog: Poll Vaulting
Carry on It turns out that the only thing harder than checking for new databases restored to a SQL Server, is checking a folder for a backup...
21-07-2017 16:07:32 Brent Ozar SQL Server
What Do You Think About ORMs?
I was recently asked what I thought about ORMs (Entity Framework, NHibernate, Dapper, etc) while we were looking at implicit conversion warn...
20-07-2017 16:31:29 Brent Ozar SQL Server
Last Season's Performance Tuning Techniques: Slides & Demos
Right now, Erik and I are presenting at the 24 Hours of PASS. We're talking about Last Season's Performance Tuning Techniques. You can regis...
19-07-2017 14:15:18 Brent Ozar SQL Server
SQL 2016 SP1 Shows You Wait Stats in Execution Plans. Or Does It?
SQL Server 2016 Service Pack 1 brought us performance tuners all kinds of shiny goodies like the ability to see wait stats inside a query's ...
19-07-2017 05:50:23 Brent Ozar SQL Server
sp_BlitzCache: Eventual Compatibility With Azure
Better than nothing Yesterday it was announced that global temp tables were available in public preview for Azure. That means that unmodifie...
18-07-2017 22:25:43 Brent Ozar SQL Server
SQL Server 2017 Release Date: October 19, 2017?
Eagle-eyed @NikoNeugebauer (who you should definitely be following on Twitter) noticed something interesting in one of Lenovo's recent TPC-H...
18-07-2017 14:56:56 Brent Ozar SQL Server
[Video] Office Hours 2017/07/12 (With Transcriptions)
This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query...
17-07-2017 15:07:53 Brent Ozar SQL Server
Sliding Scale Parallelism: Why Stop At DOP?
This is a thought experiment Just fair warning, you're probably not going to learn anything new here. This also isn't hidden in a CTP of SQL...
14-07-2017 16:21:15 Brent Ozar SQL Server
What I Love About the Stack Overflow Database
I've been using the Stack Overflow public database for my performance tuning demos for a few years now, and I just keep finding more reasons...
13-07-2017 16:21:03 Brent Ozar SQL Server
New Online Course: The Fundamentals of Database Administration
Remember that very first day when you officially became a Database Administrator? Remember how the Senior DBA sat you down and gave you clea...
12-07-2017 15:23:15 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.