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

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

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

View SQL Server information using Transact-SQL script

Recently one of our clients requested information about their SQL Server infrastructure which we manage. In order to complete this...

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

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

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

Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax

After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...

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

SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...