Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value

Not another comma separated string blog post I hear you say! I know that this topic has probably been done...

SQL Error 18456

18456 is probably one of the most common errors people come across and in this article we try to cover...

Two Socket Database Servers vs. Four Socket Database Servers

Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of...

SQL Server: Instant Blocking Alert Using WMI in Your Mailbox

As a DBA, it is important for all of us to get real time alert on various issues in our...

SQLTreeo is suspended

Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...

I’m Speaking: PASS Summit 2012 and more…

Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...

Performing Fast Searches of Query Plans

Performing Fast Searches of Query Plans
XML: Fast as a Turtle

I've made blog posts in the past on using the exist()...

Stress Testing Stored Procedures with Free Tools

I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...

Understanding the CDC State Value

If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...

Link List for July 12, 2012

Here are a few things I’ve found/had sent to me recently you may find interesting:
Most Common GRE Words. 400 words...