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

SQLSaturday #158 Event Update & Hotels - Where are you staying?

 Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...

SQL SERVER : SQL Server Scheduler

While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....

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

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

Many speaking engagements!

I have several speaking events coming up, and I would love to see you there!

First of all, I'll be...

Microsoft PivotViewer

Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....