Implicit Conversions warning

After adding an index,  ensuring that an index is actually used is probably the biggest win you will get in...

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

Guest Appearance in DBA in Space

Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...

PASS Summit 2011: Wrap-Up

Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...

Scaling SQL Server

On Friday, October 14, 2011,  I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...

Performance tips for SSAS

Over the past few years I have developed a list of ways to improve performance in SSAS and in two...

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

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