Setting a Unique Index on a Bit Field

Can you set a unique index on a bit field? Well, you can, but you’d end up with a very...

SQL Server Separation of Duties

Microsoft published a white paper named "SQL Server Seperation of Duties". Security always an important problem for DBAs and many...

The Proxy Auto-configuration URL was not found

When configuring Merge Replication for Web Synchronization it's common to encounter the error The Proxy Auto-configuration URL was not foundand
...

Google as the Ultimate SQL Repository

A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to...

Taking Script of Sql Server Jobs for Migration

when migration sql server database to a new server, i use the following powershell script to take all sql server...

Red Gate’s SQL Source Control and better SQL objects organization

Red Gate’s SQL Source Control (RGSSC) is very decent solution source control solution for database development. I am personally using...

Creating A User Group Daily Paper

A few months back, I was asked if there was a way that the information shared by the Twitter users...

find...underlings...

find.....underlings.....
searching......
underlings found......

I recently was given the task to create a stored procedure to find people who are under other people...

Three must-have tools you should use everyday

There are three tools I use every day without exception.  They all save me valuable time in surfing the net:
Delicious...

Presenting For South Florida SQL Server UG Tonight

Tonight, June 22, at 6:30 PM EDT I'm presenting Paging DR Availability, You're Wanted In The Recovery Room for the...