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

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

SQL PASS Summit 2011: Session Files

SQL PASS Summit 2011: Session Files
PASS Summit 2011

This past week was the SQL PASS Summit 2011 in Seattle, WA. I...

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

The Demise of Jar Jar

Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...

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

PASS Summit, more people and lots of newbies!

Once again I am back at home recovering from another PASS Summit.  This year the attendance has exceeded all expectations...

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