Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...

Webcast: What Are You Waiting For?

What was the number one question from today’s webcast on wait statistics?  Where can the slides and sample code be...

Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR

I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...

Distinct Count in Analysis Services

Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...

Happy #Pi Day

Here’s wishing you a Happy Pi Day…

If my picture isn’t good enough, here’s a better representation of pi.

3.14159265358979323846264338327950288419716939937510
Related posts:Happy Pi...

How Resilient Is Your Recovery Plan?

In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...

Idera ACE Program

On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...

Looking for a DBA? Looking for a New Job?

Ryan Recruiter meet Dave DBA…
As a contractor and consultant I get to speak to many agents and recruiters and over...

Ownership Chains in SQL Server

Someone asked the question recently about allowing a user to run a process,but not execute the individual pieces of the...