@jason Carter Can you post a URL to the interview...

Was confronted by a trigger just yesterday, wonderful use of nested cursors. Just had to post it as an example.

It is supplied by a vendor (Sage \ SalesLogix) so dont...

Sorry this is a old post few months old. Thought I would post the answer in case anyone else ends up here due to a google search.

This page has a...

Seeing that there are no additional comments I will add one...

Today I just setup Kerberos authentication to allow a linked server to work between sql 2008r2 and a legacy sql...

Have you looked at SQL Native Client aliases...

An alias is an alternate name that can be used to make a connection. The alias encapsulates the required elements of a...

Great editorial and intelligent follow up comments. I need to get the manager of the dev team to read this.

The job matters to me... I will always attempt to complete tasks that are allocated to me to the best of my ability, even tasks that I don't see as...

How about better admin / monitoring tools. I know that 2008 R2 is a step in the right direction with the UCP… however it is only available for customers with...

I am using the SSIS Monitoring tool that was published on the SQL Mag site http://www.sqlmag.com/Articles/ArticleID/97840/97840.html. I guess using SSIS is a common way of building a SQL...

I am after somthing similar... I actually wanted to append the server name + Database Name to the output of dbcc showcontig. I was then going to insert this into...