Posts by Brent Ozar

PASS Summit 2008 Thursday Recap (#sqlpass)

#SQLPass
0
PASS Board Election Results Dribbling In Andy Warren is in!  He talks about it on his blog, and I got a huge chuckle out of this part: I didn’t have any idea what my chances were, I really didn’t do a lot of campaigning (hard to figure out a way to do it that didn’t…
Read More

PASS Summit Keynote by Tom Casey (#sqlpass)

#SQLPass
0
I’ll be liveblogging this morning’s keynotes at the PASS Summit.  Refresh this page for the latest news. 10:02 – Tom’s focusing on the ROI of BI, and suddenly I get it.  The database engine works great.  Now we’re bolting things on top of it to make every end user in the company see the value…
Read More

PASS Summit 2008 Wednesday Recap (#sqlpass)

#SQLPass
1 Comment
Aside from my liveblog of Ted Kummert’s keynote this morning and Jimmy May’s presentation on partition alignment, a few other things caught my eye today. I talked to JC Cannon about his SQL Server 2008 Compliance Guide.  I’ve written here about it before, but it bears repeating.  If you’re not here at PASS, and you…
Read More

Jimmy May explains Partition Alignment (#sqlpass)

#SQLPass, Storage
5 Comments
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!” Get your binoculars out Partition alignment is…
Read More

PASS Summit 2008 Wednesday Keynote (#sqlpass)

#SQLPass
1 Comment
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…
Read More

PASS Summit 2008 Tuesday Recap (#sqlpass)

#SQLPass
1 Comment
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…
Read More

PASS Summit 2008 Monday Recap (#sqlpass)

#SQLPass
3 Comments
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…
Read More

More Thoughts on SSIS Twitter Integration at #sqlpass

#SQLPass
3 Comments
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…
Read More

PASS Summit 2008 Sunday Recap

#SQLPass
3 Comments
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…
Read More

Use SSIS? Like Twitter? Wouldn’t it be great if….

0
@AndyLeonard: “You got your SSIS in my Twitter!” @JessicaMMoss: “You got your Twitter in my SSIS!” That’s right, like peanut butter and jelly, we’ve got a hookup that produces better than the sum of its parts.  Andy and Jessica will be unveiling their magic at their PASS session on Wednesday at 3pm in room 602. …
Read More

PASS Board of Directors Election Update

#SQLPass
0
PASS has posted the list of candidates, but there’s no bio info yet.  Fear not – the community is doing a great job of not just keeping up, but getting ahead!  I love communities in the age of social networking. TJay Belt is doing a great job of centralizing information about the candidates for PASS…
Read More

My endorsements for the PASS Board

#SQLPass
1 Comment
When I was a DBA, before I got this “rock star” job, I didn’t have the time to get involved enough with the SQL Server community to really know the people running for the PASS Board.  I had a “real job”, and when I cast my vote, I was basing my decision off a paragraph…
Read More

So You Wanna Be a Rock & Roll Star

6 Comments
I loved the flash-in-the-pan band Semisonic, best known for – okay, only known for – their hit song Closing Time. I thought the rest of their stuff was just as brilliant (She’s Got My Number is one of my favorite songs ever), but I was in the minority, because they disappeared off the rock radar…
Read More

New SQL Server 2008 Compliance Guide

3 Comments
A while back, Bryan Oliver, David Gugick and I went to Redmond to take part in a SQL Server 2008 auditing and compliance lab.  JC Cannon and other Microsoft SQL Server 2008 pros talked about the new 2008 features that help DBAs with their SOX/HIPAA/PCI/etc compliance needs. I’ve dealt with some of these regulations in…
Read More

What would you ask Microsoft and PASS?

#SQLPass
3 Comments
What if you could sit down with these guys and ask ’em any questions you wanted: Tom Casey, Microsoft SQL Server BI General Manager. Tom’s giving the Thursday keynote about SQL Server’s business intelligence strategy beyond SQL Server 2008.  My guess (and this is only a guess, not based on any behind-the-scenes info) is that…
Read More

Steve Jones on Twitter, private Twitter and Yammer

4 Comments
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…
Read More

Tony Davis disses StackOverflow.com

16 Comments
How many of you work only with Microsoft SQL Server?  No other technologies – not Windows, not IIS, not Visual Studio, not Java, not JQuery, just purely SQL Server and absolutely nothing else? Show of hands? Not too many, I bet.  Heck, my job title is SQL Server Expert, but on any given day, I’m…
Read More

StackOverflow’s SQL 2008 FTS issue solved

Stack Overflow
31 Comments
Whew – the Microsoft folks really came through on this one and tracked down the problem pretty quickly.  I want to personally thank Denis Churin, Nikita Shamgunov and Sundaram Narayanan for their detailed investigation into the issue and helping us get it fixed. I’m going to explain the issue to help anybody else get through…
Read More

Moved to Michigan and got older

9 Comments
Home Sweet Home Erika and I drove up to Michigan this weekend and started moving into our family’s house on White Lake near where I grew up.  I went to high school near here, and I’m pretty familiar with the rough winters.  On our drive up, we drove through freezing rain and snow – Erika’s…
Read More