Please Throw this Hardware at the Problem

We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems...

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...

Speaking at SQLBits and SQLRally

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...

SQL Cruise Caribbean 2015 Recap

UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....

Automating SSAS Backups

Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your...

Book Review: Virtualizing SQL Server with VMware

It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...

Join me for Dashboards in a Day

Seats are limited – act fast!

This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...

Missing Full Text Extensions in Express

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were...

Security as a Fleeting Thought

Today we have another installment in what is known as TSQL Tuesday.  This month we have an invitation and topic...

“sp_helptext“ – Useful command to view detail TIP #85

 
It might be already known to you but I thought for sharing because I frequently use this command and it...