Product has been added to your cart.

Posts by Brent Ozar

Brent Ozar
2449 posts
https://www.brentozar.com
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

Features SQL Server Needs to Add (And Drop)

Brent Ozar
SQL Server
30 Comments
When you work with the same database server day in and day out, you can get a bit blinded by your assumptions. You might just assume that the way SQL Server does it is how every database does it. But check out these features from other database platforms: Cache query results – SQL Server only caches…
Read More

How to Set Up Standard Edition Always On Availability Groups in SQL Server 2016

Brent Ozar
Always On Availability Groups, SQL Server
191 Comments
SQL Server 2016 adds Availability Groups in Standard Edition. While the licensing details can obviously change right up to release date, here’s what was announced at the Ignite conference: Limited to two nodes only (a primary and a secondary) Like mirroring, you can’t read from the secondary, nor take backups of it But like database…
Read More

Join Us at SQLSaturday Pittsburgh for a Pre-Con

Brent Ozar
SQL Server
0
Brent & Jeremiah are coming to Pittsburgh on October 2-3, 2015. We’re doing a one-day pre-con, and then sticking around to present at SQLSaturday Pittsburgh too. Developer’s Guide to SQL Server Performance – Live! Developer’s Guide to SQL Server Performance – Live at PASS Summit 2013 You’re stuck with a database server that’s not going…
Read More

Announcing SQLServerUpdates.com

Brent Ozar
SQL Server
55 Comments
After the SQL 2014 SP1 mess, I thought, “How are people with a real job supposed to keep up with updates?” Go try to find the most recent SQL Server service packs and cumulative updates on Microsoft.com. It’s miserable – they’re scattered all over the place. Eventually, a lot of us started relying on SQLServerBuilds.blogspot.com,…
Read More

Watch Brent Tune Servers [Video] #MSIgnite

Brent Ozar
SQL Server, Videos
11 Comments
Last week at Microsoft Ignite 2015 in Chicago, I demonstrated how to tune a few SQL Server workloads with my favorite process: Measure how fast the SQL Server is going Check its bottlenecks Apply some easy-to-tweak configuration settings and measure the difference There’s no camera in this hour-long video, just a screen capture, so you’ll have…
Read More

#MSIgnite SQL Server Unplugged Q&A Summary

Brent Ozar
SQL Server
0
This afternoon, we had one of my favorite sessions: the off-the-cuff Q&A with some of Microsoft’s best and brightest. I probably missed somebody, but for sure we had Conor Cunningham, Joe Yong, Jos de Bruijn, Kevin Farlee, Luis Carlos Varga Herring, Mike Weiner, Sunil Agarwal, and Tiffany Wissner. Hubba hubba. SQL Server Unplugged These sessions are fun to…
Read More

Microsoft Ignite SQL Server Keynote Liveblog #MSIgnite

Brent Ozar
SQL Server
5 Comments
Yes, there are actually multiple keynotes here at Ignite, Microsoft’s new infrastructure conference. With so many products (Windows, O365, SharePoint, Dynamics, mobile, Azure, etc.) and so many attendees (over 20K), they had to break things up a little. This morning, CEO Satya Nadella and friends delivered the overall keynote. This afternoon, Microsofties have delivered a…
Read More

Reading the SQL Server 2016 Data Sheet

Brent Ozar
SQL Server
42 Comments
The SQL Server 2016 PDF data sheet is out, giving us the first public look at the next round of features in Microsoft’s database product. Quick disclaimer: I’m a Microsoft MVP and Certified Master, and we’ve got clients that work with Microsoft. As such, I’m bound by a few non-disclosure agreements. For this post, I’m…
Read More

Microsoft Ignite Morning Keynote Liveblog #MSIgnite

Brent Ozar
SQL Server
0
Summary: Microsoft announced SQL Server 2016, with the first public preview coming this summer. The SQL Server 2016 release dates for the download were not announced. Here’s the SQL Server 2016 PDF data sheet, and here’s the SQL 2016 announcement. As it happened: 8:00AM – Good morning, folks. This week, Microsoft’s new infrastructure conference, Ignite, opens…
Read More

New sp_Blitz® and sp_BlitzCache® Updates

Brent Ozar
SQL Server
16 Comments
Ah, spring, when a young man’s fancy lightly turns to thoughts of updating his DMV queries. sp_Blitz®, our free health check stored procedure, brings several new checks and a whole crop of fixes and improvements. I’d like to call your attention to one in particular. Julie Citro fixed check 1, THE VERY FIRST CHECK IN THE…
Read More

How to Evaluate NoSQL Case Studies [Video]

Brent Ozar
SQL Server
3 Comments
Every now and then, one of our clients considers adopting an alternative database platform – sometimes NoSQL, sometimes a brand new relational database. They’ll ask for our help in evaluating the vendor’s solution. One of the best ways to do it is ask the database vendor to set us up on a WebEx or GoToMeeting with…
Read More

“Breaking” News: Don’t Install SQL Server 2014 SP1

Brent Ozar
Always On Availability Groups, Breaking News, SQL Server
24 Comments
Yesterday, Microsoft announced availability of Service Pack 1, saying: As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments via the download links below. Yeah, about that commitment to software excellence. This morning, the download is gone: Notice: The SQL SSIS…
Read More