Blog: Brent Ozar

210 blogs updated: 44 min. ago
Updating Paste The Plan to use the Serverless Framework
I just updated PasteThePlan, and the change you'll notice first is that we're using the latest version of Justin Pealing's html-query-plan. ...
18-06-2018 16:17:15 Brent Ozar SQL Server
[Video] Office Hours 2018/6/13 (With Transcriptions)
This week, Brent and Richie discuss using full-text index, Elasticsearch, server restart issues, sp_blitzfirst, Always On availability group...
17-06-2018 18:14:58 Brent Ozar SQL Server
Can Non-SARGable Predicates Ever Seek?
Cheating At Candy Crush The short answer is that yes, they can. But only with a little extra preparation. Before I show you what I mean, we ...
15-06-2018 15:35:14 Brent Ozar SQL Server
Why You Should Stop Depending On SQL Server Versions In Code
It Used To Be That when you wrote scripts that had to work across different versions of SQL Server, you were pretty safe. Microsoft would re...
14-06-2018 16:15:45 Brent Ozar SQL Server
Nodes Offline: Why Your SQL Server VM Can't Use All Its Virtual Hardware
When you install SQL Server Standard or Web Edition in a virtual machine with more than 4 cores, things can look like they're just fine when...
13-06-2018 15:40:23 Brent Ozar SQL Server
New Stack Overflow Public Database Available (2018-06)
@Taryn and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and mo...
12-06-2018 22:51:11 Brent Ozar SQL Server
Indexing Strategies For Cross Apply
Slicked Brad The apply operator remains one of my favorite tools, but much like CTEs and windowing functions, they're not totally magical un...
12-06-2018 16:22:45 Brent Ozar SQL Server
Building SQL ConstantCare®: Why People Aren't Using Query Store
When Microsoft first talked about Query Store, I was wildly excited. It's basically a black box flight data recorder for SQL Server, trackin...
11-06-2018 15:45:59 Brent Ozar SQL Server
[Video] Office Hours 2018/6/6 (With Transcriptions)
This week, Brent, Erik, Tara, and Richie discuss index maintenance, stats updates, the acquisition of GitHub, using linked servers to move t...
10-06-2018 17:37:05 Brent Ozar SQL Server
Announcing a Very Special #SQLFamily Webcast with Dr. David DeWitt
On Thursday, June 28th, at noon Eastern (see in your local time zone), join us for a very special presentation: SQL Query Optimization. Why ...
08-06-2018 22:43: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.