Replication – Accommodating Application Inserts

Recently I have been involved in lots of projects involving replication.  I have done some things to make replication work...

SQLSaturday Advisory Council – Second Member Announced

Posted today, Andy Leonard is the second person on the Council, and we’re glad to have him. Read the announcement...

The theft of ideas and content

If you regularly read SQL Server or other technology blogs, you know that the blogs can be a wonderful way...

The Fisherman and the 'C' (City)

 The Fisherman and the "C" ("City") 
Ok, I know when most think about NYC, they think latte-sipping wall-street yuppie (I'm...

devLINK Technical Conference is Biggest Ever

I am presenting a 3-hour session on the SQL Server 2008 Data Collector.

The devLink Technical Conference, held August 13-15, 2009...

Installing SQL Server 2008 on Windows 7

When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL...

Active August – Week 2 Recap

Well, I had a pretty good week this week.  I made an effort and met all my goals:
Eat smaller portions...

SSIS Documentation suggestions on Microsoft Connect

For SSIS developers, the need for proper documentation is crucial.  However, the built-in object for documentation, the annotation, is difficult...

A Couple of Invoke-SQLCMD Issues

In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included...

Evil Code

/*
A couple
of years ago, I wrote the Simple-Talk Prettifier. This is really no more than a stored
procedure that...