How to Encrypt password in SQL Server ? TIP #87

Security is always a concern for every database developer. How to secure valuable information is one of the major and...

Identifying Blocking via Extended Events

There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...

Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test

By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...

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...