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

Denali – Memory: “any size” page allocations

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...

SQL Server DBA Tool Kit

Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...