4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


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://www.brentozar.com/feed/

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.
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.

Blog posts RSS

Reporting From a Log Shipping Secondary in STANDBY mode 28 Jan 2015
I’m a fan of SQL Server’s transaction log shipping. It works in Standard Edition, it’s relatively simple to set up, and you can even make your log shipping secondary readable using STANDBY mode. I’ve worked with some pretty cool, complex … Continue reading → Our ...

Are You Getting the Benefits of Virtualization? 27 Jan 2015
Here’s some of the reasons companies usually virtualize their SQL Servers: Cost savings on hardware Cost savings on Windows OS licensing Cost savings on SQL Server licensing Protect against the failure of a single hardware element Leverage extended features for Disaster Recovery … ...

Querying Extended Events Target XML [Video] 26 Jan 2015
If you’ve poked at Extended Events in the last five years, you know the targets store data as…XML. Has XML been the reason you haven’t adopted Extended Events? Don’t let it stop you! In this video, Jes breaks down her … Continue reading → Our Senior DBA Class of ...

Managing Oracle Performance with Statistics 22 Jan 2015
Oracle maintains statistics about data stored on disk. The statistics and histograms help guide the optimizer during query plan compilation. These statistics are usually helpful. Sometimes the statistics are not helpful. As data changes, the statistics collected by Oracle may … Continue ...

Urgent AlwaysOn Availability Groups Bug 22 Jan 2015
If you’re using AGs, don’t apply these patches: SQL 2012 SP2 CU3 SQL 2012 SP2 CU4 SQL 2014 CU5 until you read this Microsoft post about a breaking bug. Your AG may stop synchronizing due to blocking between user queries … Continue reading → Our Senior DBA Class of 2015 ...