SQL Rally 2012 Vote For Me!

Hello Dear Reader!  Last year I tossed my hat in the ring on the world of Presenting.  This was a...

Why Every DBA is a Clown

It’s late, really late and you’ve got a mountain of work to get through to meet the deadline. To add...

A Script A Day - Day 5 - Database Owner Permissions

Today's script will list all principals with membership in the db_owner fixed database role.

/*      -----------------------------------------------------------------       Database Owner Permissions      -----------------------------------------------------------------            For more SQL resources, check...

SQL Express and the Curse of the Perfmon Counters

On a dark and spooky night in the land of SQL Server make-believe, a young warrior was asked to slay...

Thread Synchronization/Locking In .Net

When you are creating multiple threads that need to access a shared resource then you need to implement some form...

A Script A Day - Day 4 - Estimated Time Left

Today's script allows you to keep track of how long left a statement has before it completes.  I find this useful...

Dundas Dashboard – My observations

Dundas Data Visualization Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated...

List SQL Server Instances using Powershell and Get-ItemProperty

This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.
The Get-ItemProperty...

Sarasota IT Pro Camp

Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies...

..This operation must be performed in the master database."

"Cannot alter a server audit from a user database. This operation must be performed in the master database."

If you're trying...