Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008

In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...

SQL Server 2008 R2 - Release May2010

SQL Server 2008 R2 now has a release date...May 2010.

Check out the microsoft site for more details...link to follow

SQL Server Resource Governor

I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
 

The Architectural Journal

Somehow had completely missed this one, The Architectural Journal is published quarterly in PDF format. Issue 22 seems to be...

What Would You Like to See in a New Book on Indexing?

I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...

Windows Azure Platform Training Kit

Everyone interesting for Windows Azure Platform Training Kit - December Update, can find it from Microsoft location here.
There are lot of...

Windows LiveSynch

After a while, most people who work with SQL have accumulated quite a few scripts that they use for investigation,...

Collaboration Patterns – Part 1

I’ve been thinking a lot lately about how to be more effective at collaborating, usually in the context of a...

Goals and Theme Word for 2010

I was warned by my father when I turned 21 that, although it seemed like it took a long to...

Out Of My Comfort Zone: Building a Web App

If you read Fundamentals of Storage Systems – Stripe Size, Block Size, and IO Patterns you know I built a little...