Multiple CTEs

Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...

Performance Tuning Presentation from October 2012 BRSSUG Meeting

Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night!  I hope everyone...

SQL Server : Index Part 1 : Basics of index

While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not...

SQL Server 2012 SP1 CTP4 Is Now Available !

Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...

Why I Love the SQL Server Community

As many of you are aware, a SQL Server security patch came out this week (MS12-070 - Vulnerability in SQL Server...

Windows Server 2012 and Hyper-V

I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t)...

Gain exclusive control of a database

Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...

Grant Execute Permission on All Stored Procedures

Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...

Lose #5 Before #sqlpass

Win Valuable Prizes!

Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...

PASS 2012 Countdown – 4 Weeks To Go

One week down and we are now 4-weeks from this years PASS Summit.  Hopefully, you have already registered for the...