Month: November 2011

Brent’s 2012 Conference Schedule

Last Updated February 12, 2017

I feel like the luckiest guy in the world: I get to take part in six major SQL Server events in 2012. Here’s where I’m going and why: January 26-Feb 4: SQLCruise Miami SQLCruise is the highlight of my year. This year, we’ve transitioned SQLCruise completely to Tim Ford – he owns the event start…

3 SQL Server Book Review Short Takes

Last Updated February 13, 2017

Brent Ozar

Book Reviews

Here’s what I’ve been reading lately on the SQL Server front. I’d like to thank all three authors and publishers for providing these books for review. Securing SQL Server by Denny Cherry Paperback – Kindle Denny’s a jack of all trades, and a Microsoft Certified Master of SQL Server to boot. I’ve had the pleasure…

Three Things That Rock About SQL Server

Last Updated November 22, 2011

Kendra Little

When something remarkable is around for a while, it becomes easy to take it for granted. Today, I’ll share three awesome things about SQL Server with tips to give you an edge when using each one. #1. The Free Online Documentation is Mind Blowing SQL Server is a huge product. We’ve got the database engine,…

Virtualization and SAN Basics for DBAs Video

Last Updated November 13, 2012

Brent Ozar

SQL Server

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…

Third Normal Form is Snake Oil

Last Updated October 29, 2011

Jeremiah Peschka

Step right up, ladies and gentlemen, and I will sell you the solution to all of your database needs. That’s right, it’s Doctor Codd’s Third Normal Form, guaranteed to cure all ailments of the schemata, pragmata, and performata. Doctor Codd’s Form will make your data performant and compressive. Accept no substitutes or imitators; Doctor Boyce’s…

Unless you're running Developer Edition in production. Arrr, pirates!

Local Backups Are The New Offsite Backups

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery

Years ago, Microsoft’s Jim Gray said that memory is the new disk, and disk is the new tape. (You can read more in his 2006 “Tape is Dead, Disk is Tape, Flash is Disk” PowerPoint presentation or the Google Quick View.) Many of the things he predicted have come to pass, and it’s time we…