SQL Cruise! SQL Saturdays! Summit! SQL-SQL-SQL!

We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the...

Not enough available space on destination..495GB available!

I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...

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