SQL Roundup – 03/16-2012

Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...

Help I'm not Sysadmin!

I am currently working on some client servers to upgrade multiple SQL 2008 R2 Express instances to 2008 R2 Standard. ...

March #Meme15 – Facebook

It’s the early morning of the 16th, and time to write my #meme15 post.  Remember, these are due on or...

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