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 “Denali”

SQL Server “Denali” is the code name for the next version of SQL Server.  The CTP1 of Denali was released...

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

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

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

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

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

Tampa PowerShell Presentation

The presentation material from the Tampa PowerShell User Group 6/21/2011 meeting on PowerShell ETL is available here:
 

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