Month: July 2008

8 DBAs talk about their jobs

Last Updated February 12, 2017

OdinJobs.com interviewed eight different DBAs from completely different backgrounds and careers. The one thing we’ve got in common is that we blog, but outside of that, we’ve got wildly different points of view about the career and what we like about SQL Server. I shall now copy/paste Jason Massie’s hard work at listing each person’s…

SQL Server support on virtual servers

Last Updated February 13, 2017

Brent Ozar

Virtualization

The Microsoft knowledge base article on SQL Server virtualization support just got an update. Here’s the interesting part: “Versions of SQL Server after SQL Server 2005 will incorporate full support for running on a supported guest operating system that is installed on a Windows Server 2008 Hyper-V virtual machine.” That means SQL Server 2008 will…

Taking a cross-country road trip

Last Updated July 26, 2008

Brent Ozar

We’ve packed up the Honda and we’re heading out this morning on a road trip of epic proportions: Just over 5,000 miles. Erika, Ernie (our miniature Schnauzer) and I are driving from Houston to Memphis today, overnighting there. On Sunday we’re continuing up to Muskegon, Michigan to spend some time with Dad and Caryl, my…

Speaking at PASS Camp 2008 in Germany

Last Updated February 12, 2017

Brent Ozar

#SQLPass

I love my job! When a new version of SQL Server comes out, database administrators want to know what features will make an immediate difference in their lives. They want a very fast recap of what they need to do first, what they need to plan for, and what to tell the rest of their…

Important SQL Server Data Services warning

Last Updated November 1, 2009

Brent Ozar

An important email just came out from the Microsoft SSDS team about this week’s upgrade. The second bullet point in the impact alert is especially important, and everybody needs to take note. Here’s a screenshot: Got that? Good. To be a good DBA, it’s important to be able to read Wingdings.

Tracking the Chicago-Mac race with GPS

Last Updated September 5, 2009

Brent Ozar

A friend of mine is competing in the 100th annual Chicago-Mac race, a sailboat race up Lake Michigan from Chicago to Mackinac Island. This year they gave out GPS tracking devices so you could follow your favorite boat’s progress during the race. Now I’m not saying anybody cheated, but the route of the Hannah Frances…

The Wine Trials: a wine book for donut lovers

Last Updated August 24, 2009

Brent Ozar

Last night, the author & editor of The Wine Trials held a release party at the Caroline Collective, the Houston coworking office where I lay my weary laptop. Robin Goldstein and Alexis Herschkowitsch talked vino, signed books and raised glasses. I liked them, and I liked the book, and I’ll tell ya why. I’m just…

Storage virtualization for SQL Server: friend or foe?

Last Updated February 13, 2017

Brent Ozar

Storage

Storage virtualization is a really slick SAN technology that does for SANs what VMware did for servers: it abstracts away the underlying hardware to make management easier. Multiple SANs can be swapped around back and forth behind the scenes without affecting any servers that store data on those SANs. It’s nowhere near common yet –…

Yes, SQL injection attacks do exist

Last Updated July 17, 2008

Brent Ozar

And here’s a Craigslist ad to prove it:

Coding Horror post about normalization

Last Updated July 15, 2008

Brent Ozar

I’m a DBA, not a programmer, but I subscribe to Jeff Atwood’s excellent Coding Horror blog because it’s well-written, funny and teaches good lessons. In his latest post, he talks about database normalization – when to do it and when to avoid it. Pay particular attention to the links to HighScalability.com – they have great…

Software Development Meme

Last Updated July 7, 2008

Brent Ozar

Jason Massie tagged me, so it’s my turn to answer the questionnaire…. How old were you when you first started programming? Dad and Mom upgraded us from an Atari 2600 to a Commodore 64 when those came out, so I must have been around 9-10. I don’t remember much from those early attempts at programming,…