Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 20d 16h 13mSee the sale

Author: Brent Ozar

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I'm based out of Las Vegas. He/him.

PASS Session on Analytics by Donald Farmer (#sqlpass)

George Box said, "Essentially, all models are wrong, but some are useful."  Donald illustrated this point with a brief history lesson.  Early models of the universe said the sun revolved around the earth, and with that model, marvelous things were possible in architecture, celestial navigation and science.  Even though the model was wrong, it was still extremely useful.  Data modeling holds to that same statement: your models will never be right, but your key is to figure out which ones are useful enough.

Read more about PASS Session on Analytics by Donald Farmer (#sqlpass) 2 comments — Join the discussion

Jimmy May explains Partition Alignment (#sqlpass)

Before attending this session, I've always gone to KB article 929491 article on partition alignment.  I thought I kinda sorta understood what was going on, but Jimmy's presentation drew on the best graphical illustrations to show it.  Not to mention his audio stylings like, "Holy correlated wait stats!" Partition alignment is one of those hidden…

Read more about Jimmy May explains Partition Alignment (#sqlpass) 5 comments — Join the discussion

PASS Summit 2008 Wednesday Keynote (#sqlpass)

I'm liveblogging the keynote this morning on here and on my Twitter feed.  Go to this page and refresh it periodically to get the latest news as it happens.  Updates are at the top of the page to make reading easier during liveblogs, and I'll reverse it tonight for easier reading later.

10:08 - And that's it!  Done.  See you at PASS!

Read more about PASS Summit 2008 Wednesday Keynote (#sqlpass) 1 comment — Join the discussion

PASS Summit 2008 Tuesday Recap (#sqlpass)

PASS Election Update
I'm seeing a theme on the interwebz: lots of endorsements for Andy Warren and Tom LaRock:

Andy Leonard posted his vote on Twitter for Andy Warren, Lynda Rab and Tom LaRock (SQLBatman).
Brian Kelley posted his endorsements on SQLServerCentral for Andy Warren and Tom LaRock.
Steve Jones posted his endorsements on SQLServerCentral for Andy Warren, Louis Davidson (DrSQL) and Tom LaRock.

Read more about PASS Summit 2008 Tuesday Recap (#sqlpass) 1 comment — Join the discussion

PASS Summit 2008 Monday Recap (#sqlpass)

Great SSIS Boot Camp by Brian Knight
Brian's a fantastic presenter - really funny, really engaging, and can answer questions on his feet.  The one-day presentation was a great way to get started, and I ordered his Professional SSIS 2008 book to answer my questions as I start digging into SSIS.

One indicator of a good presentation style: people follow along and ask questions, and the presenter's answer is, "I'm glad you asked.  We're talking about that next."  That happened again and again in Brian's presentation.

Read more about PASS Summit 2008 Monday Recap (#sqlpass) 3 comments — Join the discussion

More Thoughts on SSIS Twitter Integration at #sqlpass

Yesterday, Andy Leonard and Jessica Moss announced that their Wednesday 3pm class on SSIS scripting will cover Twitter integration. In today's SSIS Boot Camp by Brian Knight, I spoke with some DBAs about the Twitter idea.  The initial reaction has been, "Why would you want to do that?  Twitter is so unreliable."

True: us database administrators are conditioned to working with extremely reliable tools, logged transactions, mission-critical uptime, yadda yadda yadda.  Twitter is none of those things - so why would we rely on it?

Read more about More Thoughts on SSIS Twitter Integration at #sqlpass 3 comments — Join the discussion

PASS Summit 2008 Sunday Recap

I flew in yesterday and spent some quality time with some other folks who were lucky enough to fly in early, and by "quality time" I mean eating and drinking.  I only got a handful of photos.
Listening In on DBA Conversations
The funnier momentos were the things we overheard.  If you follow me on Twitter, "OH" means "Overheard", and we type that when somebody won't want to be identified by the quote.  Some examples:

Read more about PASS Summit 2008 Sunday Recap 3 comments — Join the discussion
T-SQL & Development

So You Wanna Be a Rock & Roll Star, Part 2

If my blog entry yesterday about my job as a SQL Server Expert at Quest Software sounds cool, then listen up: I'll let you in on how to get a job like this.
Be Really Passionate About Your Field
I have the coolest job in the world - for me. My job would be absolute torture for some people, but I love it, and I think that's the key.

Read more about So You Wanna Be a Rock & Roll Star, Part 2 2 comments — Join the discussion

Steve Jones on Twitter, private Twitter and Yammer

In the latest Voice of the DBA podcast (love the outtakes at the end, totally awesome), Steve Jones of SQLServerCentral talks about his use of Twitter.  Like a lot of folks I know, he's struggled to find the real-world benefit of it, and I really applaud his honesty.  Twitter's one of those things like MySpace - either you get it or you don't.  (Just for the record, I don't get MySpace.  I'm sure that statement will come back to haunt me later in life.)

Read more about Steve Jones on Twitter, private Twitter and Yammer 4 comments — Join the discussion