Scripting dependencies of User-defined Table Types

I was using user-defined tables types (UDTT) quite intensively despite of their current disadvantages especially their forced READONLY behavior when...

SQL Server “Denali”

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

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