Platinum Sponsor
Brent_Ozar.png

Brent Ozar

Brent Ozar specializes in making SQL Server faster and more reliable.   He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience.  He coauthored Professional SQL Server 2008 Internals and Troubleshooting, created sp_Blitz™ and sp_AskBrent™, and he loves sharing knowledge at BrentOzar.com.
http://www.brentozar.com/ http://feeds2.feedburner.com/BrentOzar-SqlServerDba

Making your T-SQL fast isn't really all that different from building and driving race cars. Learn lessons from racing icons that you can apply right away in your databases.
Got a slow application or server, and not sure where to start? Brent will explain how to use the two most popular free tools and how to read their results.
These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.
PANIC IN THE DATACENTER! Your databases are approaching - or surpassed - the Terrible Terabyte mark. You're pouring money into the SAN, but your data isn't pouring back out as fast as you want. You're terrified to DBCCs or index maintenance because everything takes forever, and you don't have big maintenance windows.
You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.
How does SQL Server build results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be SQL Server. This session is for people who are comfortable writing queries, but not with indexes, statistics, and sargability.
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries and tries various techniques to make them faster.

Blog posts RSS

Should I Run sp_recompile After I Create An Index? 19 Aug 2014
Making index changes in SQL Server is tricky: you immediately want to know if the new index helped your performance and if it’s being used, but SQL Server execution plans and their related statistics can be are insanely confusing. It can be useful … Continue reading → Register now ...

Watch This Week’s Webcast Today (and Win a Prize Tomorrow) 18 Aug 2014
We always like to innovate — not just with the solutions we design for our consulting customers and in how we teach, but in our free videos, too. Our YouTube channel has become super popular. Lots of folks watch the recordings … Continue reading → Register now to watch Brent and ...

Developers: You Don’t Need a DBA. I’ll Prove It. 15 Aug 2014
That’s right, you heard me, and I’ll prove it on a really big stage. I’m honored to announce that I’ll be the first speaker at this year’s 24 Hours of PASS: Summit Preview Edition. On Tuesday, September 9th, join me for … Continue reading → Register now to ...

The Mysteries of Missing Indexes [Video] 15 Aug 2014
SQL Server is trying to help you – when you run a query, you see a missing index request. Before you run that CREATE INDEX script in production, consider a few things. How helpful will the index be? Is it … Continue reading → Register now to watch Brent and Jes during the 24 Hours ...

Generating Identities 14 Aug 2014
The only thing you ever need to use for database identity is an IDENTITY, right? Well, maybe. There are a lot of different options and they all have different pros and cons. IDENTITY columns The default way to identify objects in … Continue reading → Register now to watch Brent and Jes ...