On March 23rd, I’ll be the guest of honor at the first SQLFriends Lunch in Chicago. For just $30, you get lunch at Buca di Beppo on Rush Street plus two hours of talking about SQL, virtualization, blogging, consulting, the MCM program, you name it. And you really do name it – on the SQLFriends…
Author Archives: Brent Ozar
SQL Server 2012 BareMetal Workshop
Last week Brent, Jeremiah and Kendra attended the SQL Server 2012 BareMetal workshop at Microsoft Headquarters. This was a special train-the-trainer style event where Microsoft Program Manager Dandy Weyn (blog | twitter) brought MVPs, Microsoft employees, and MCMs together. We talked about implementing SQL Server, training the community to use new features, and helping people…
DBA Darwin Awards: Log File Edition
Right after the DBA says “Uh oh,” they call in the consultants. We get to see some really amazing acts of career suicide. You wouldn’t believe some of the stuff we’ve seen, and some of these things are probably happening in your environment right now. In this session, we’ll talk about some of the most…
SQL Server Interview Questions and Answers – Book Review
I read a lot of technical books – stuff on SQL Server, VMware, storage – and they all start to blend together. Within the first few pages of reading SQL Server Interview Questions and Answers by Pinal Dave and Vinod Kumar, though, it jumped out and grabbed me because it’s really different. When buying this…
Anatomy of the SQL Server Database: Settings and Secrets Video
What are the key settings for a SQL Server database? What are some lesser-known settings that may have unexpected consequences? Kendra Little checks out a lot of databases in the wild– she finds loads of cases where database settings are dragging down performance or not protecting the database properly. If you’re a database administrator or…
SQL Server Can Run Databases from Network Shares & NAS
Geeks love duct tape. Sure, we pride ourselves on building a rock-solid solution the right way, but when the brown stuff hits the moving metal stuff, we love to show off our ingenuity. We carry our money in duct tape wallets, wear duct tape shirts, practice ductigami, and hang our duct tape from custom metal…
The Art of the Execution Plan
There’s beauty everywhere – even in SQL Server. I was just staring at this plan when I was struck by its beauty: Oh, sure, it’s ugly, and I recoiled in horror at first, but when you get over that reaction, there’s an amazing amount of stuff there. Someone – probably many someones – poured every…
What 2012 Work Scares You?
Right now, this very moment, there’s an ugly piece of work tapping on your shoulder – and I don’t mean your boss. You agreed to do it months ago during the 2012 planning sessions, but you never really expected January 2012 to arrive. Now that it’s here, you’re starting to get nervous because you’ve never…
My Easy New Year’s Resolutions (Guest Post)
Hi! I’m your SQL Server. I know you don’t usually listen to me, so I’ve decided to take a drastic step and find you where you spend all your time – Brent’s blog. Seriously, you need to spend less time on the intertubes and more time on the error logs. You’re lucky this post is…
SQL Server High Availability and Disaster Recovery Basics Webcast
If your boss wants you to make your SQL Server more reliable, there’s a lot of confusing options. I’ll walk you through the pros and cons of each method and show you how they can help make queries go faster too. We’ll finish with a list of books and blogs I’d recommend for each option….
