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

SQL Lunch Rescheduled

Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled.  The event will be on March...

SQL Lunch Rescheduled

Due to a few scheduling conflicts the SQL Lunch scheduled for tomorrow as been rescheduled.  The event will be on...

SQL Saturday 103 Recap

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