Brent Ozar
Brent Ozar is a Microsoft Certified Master of SQL Server and an MVP. He has over a decade of broad IT experience, performing systems administration and project management before moving into database administration. Brent specializes in performance tuning, disaster recovery and automating SQL Server management. He has worked as a SQL Server expert for Quest Software, and a SQL/SAN/VMware administrator for a $7b wine & spirits distributor.
Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He coauthored SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford, James Rowland-Jones, and Jonathan Kehayias.
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.
Blog posts
|
Hiring a DBA? Need to get a job description for the human resources folks? Here’s how to get started. First, decide whether it’s a production or development DBA. Think of the database in terms of a fridge. When you run a … Continue reading →...Attending a fall conference? ...
|
|
When it comes to indexes, SQL Server is really helpful. It lets you see what indexes queries are asking for both in execution plans, and missing index dynamic management views (“DMVs”). I like to look at the DMV missing index … Continue reading →...Attending a fall ...
|
|
Sometimes, the best stories are the horror stories. Join Brent as he talks about some of the worst situations he’s seen in his years of database administration. He’ll share the inspiration behind some of his favorite entries at http://DBAreactions.tumblr.com. We’ll either … Continue reading ...
|
|
Until recently, database benchmarks have been performed by vendors in carefully controlled labs or by engineers at companies reporting on application specific workloads. TPC benchmarks, like TPC-H, provide metrics about the number of queries per hour and a cost per … Continue reading ...
|
|
Servers are like milk cartons: both need an expiration date printed clearly on the outside. When a project needs a new database server, I ask the business users, “How long does this server need to last?” Inevitably somebody gives the … Continue reading →...Attending a fall ...
|