Hadoop and Data Warehouses

I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution.  Hadoop should...

How to Fix that Never-Ending Join Dragging Down the Whole DB Server Instance – Pre-Populate the Largest Bugger in Temp with Indexes

Now that it has been a
good five years I have been blogging away here and on SSC, the editors recently thanked
us...

Import export wizard at the commandline

TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...

Last Weeks Top “Reading” Links #83

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Making a Difference – #SQLFamily

When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...

Notes From SQLSaturday #298

The trip didn’t start smoothly for this one. Wed night I was really sick with some kind of stomach flu....

Presentation slides for Houston SQLSaturday

Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info).  Here are the abstracts and PowerPoint links:

Best...

SQL Saturday Houston

I spoke for my first time at a SQL Saturday in Houston this past week. I had a lot of...

What is MongoDB?

How does MongoDB Store Data?
What is MongoDB?  MongoDB is a document oriented database.  This means it stores its data in...

Writing Another Question of the Day

The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...