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

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

Denali

Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...