Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session

Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...

First take on PowerPivot

What is PowerPivot for Excel? PowerPivot brings the power of Data Modelling into your PC. Traditionally, the DataWarehouse is built...

Is There Interest in SQL Server Security Pre-Cons?

I’m very passionate about security, especially database security. As the numbers with regards to data breaches continue to climb, this...

A Rickety Stairway to SQL Server Data Mining, Part 14.5: The Predict Method

By Steve Bolton
…………In order to divide the Herculean task of describing custom algorithms into bite-sized chunks, I omitted discussion of...

sp_BackupDatabases v1.2

I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...

Fixing Cardinality Estimation Errors with Filtered Statistics

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Cardinality Estimation is...

PASS Summit 2013

Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast!  I...

Query Tuning in Dallas

Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...

Startup Weekend Orlando

Startup Weekend comes to Orlando on Nov 22-24, 2013. I haven’t been (and not sure I will make this one)...

The times they are a-changin’

This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.

The...