Quick heads-up on a recently published article I did for SQLTeam.com. The article examines SQL Server Integration Services' Fuzzy-Lookup transformation for use in data-cleansing routines. If you're interested, head over to the article - there's even a sample app you can use to take a quick look at how easy SSIS makes it to add robust ...

If you're in to SQL Server Reporting Services, but want better/richer functionality in Word and Excel - then zip out and skim my article at the ASPAlliance: Using SoftArtisans' OfficeWriter with SQL Server Reporting Services 2005. The article provides an overview of what OfficeWriter brings to the table, and includes a number of ...

I love PostXING - now I've just configured it to work with the CS 2.0 upgrade that just happened on SqlAdvice. (I'm actually using the latest version of PostXING - right out of SVN - but it's working great, and setup was a breeze.) Setup was simple. I just put in my username and password, pointed the host at sqladvice.com, and ...