Understanding the concept of SQL Server Failover Cluster

Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...

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

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

SQL Saturday 103 Recap

SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean.  I was fortunate enough to be able...

Idera ACE Program

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

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a couple of different queries that I like to use....

Table Size and Missing FK Indexes

I am bringing an oldie back with another twist.  I recently ran into the need to correlate information between a...

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

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

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