Self Service BI and PowerPivot

Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally...

Extended Events Data

I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...

SQL University Lesson 3 Page Compression

Lesson 2: Internal Structures, Vardecimal, & Row Compression

Welcome to Lesson 3 on Compression and welcome back Dear Reader.   I want...

Understanding Kerberos, Part I

A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...

Simple XML exist performance enhancement

I came across this really simple best practice from BOL for the xml method exist which when used will give...

SafePeak version 2.1 for SQL Server Performance Acceleration Released!

Our friends at SafePeak has released a Major Update: Introducting SafePeak version 2.1 for SQL Server Performance Acceleration!
This unique caching solution offers...

PASS Summit 2011 recap

Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...

Setting up SSIS Auditing Part 1

Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...

SQL PASS Summit Final Day (Sessions)

Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...

SQL PASS Summit–Day 4 (BI Sessions)

Here is the summary of the session I attended while at my 4th day at the Summit. (Technically, this is...