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

Great new Microsoft KB article: Recommended SQL Server Updates and Trace Flags 11 Sep 2014
Got a high performance SQL Server 2012 instance? Check out the brand new KB article for recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads. Make sure you expand the following plus sign … Continue reading → All our ...

Developers: Who Needs a DBA? [Video] 09 Sep 2014
You store data in SQL Server, but you don’t have enough work to keep a full-time DBA busy. In just half an hour, you’ll learn the basics of performance troubleshooting and index tuning from me – a recovering developer myself. … Continue reading → All our scripts, ...

Get in the (SQL Server) Community Spirit [Video] 08 Sep 2014
Thanks for tuning in to our webcast again this week! To join our weekly webcast for live Q&A, make sure to watch the video by 12:00 PM EST on Tuesday, September 9! Not only do we answer your questions, we … Continue reading → All our scripts, checklists, posters, and e-books are ...

Log Shipping Magic: Using A Differential Backup to Refresh a Delayed Secondary 04 Sep 2014
Let’s say you’re a DBA managing a 2TB database. You use SQL Server transaction log shipping to keep a standby copy of the database nice and warm in case of emergency. Lots of data can change in your log shipping … Continue reading → All our scripts, checklists, posters, and ...

Finding Unanswered StackExchange Questions with SQL 03 Sep 2014
You love Q&A sites like StackOverflow.com and DBA.StackExchange.com, but sometimes it’s hard to find interesting questions that need to be answered. So many people just sit around hitting refresh, knocking out the new incoming questions as soon as they come … Continue reading ...