1 year old sandwich

It's been an interesting day. It was the 1 year anniversary of SQLSandwiches today. It was also my last day working...

Choosing the Right Microsoft Reporting Technology Part 3: PowerPivot

Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...

Execution Plans – Merge Join

The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...

Columnstore Indexs

Columnstore Indexes for Fast DW

The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...

Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012

Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security.  This...

Debugging query timeouts by sampling blocking – part 2

In part 1 I explained how I was hunting for the root cause for some query timeouts that happened every...

#Meme15: On Facebook

This will be my first Meme15 (here’s Jason Strate’s original Meme15 post), and today we’re talking Facebook. The question is:
How...

ColoradoSQL for March 2012

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...

Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...

Agent Jobs Using SSIS

This is a short script to help the DBA with documentation purposes.  This would come in handy especially in those cases where you are consulting or you have taken...