REPEATABLE READ

Browse by Tags

SQL Team Article

Posted Monday, January 22, 2007 2:05 PM by michael.k.campbell

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

0 Comments

Filed under: How To's, Misc

AspAlliance Article

Posted Thursday, August 24, 2006 5:33 PM by michael.k.campbell

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

0 Comments

Filed under: How To's, Misc

Yeay PostXING

Posted Friday, May 12, 2006 5:35 PM by michael.k.campbell

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

0 Comments

Filed under: How To's, Misc

Using Virtualization to fight ... Virtualization

Posted Thursday, April 20, 2006 4:54 PM by michael.k.campbell

VPN Software should come with big warning labels: "WARNING: Does not play well with others." As a consultant I frequently need to gain access to remote networks via VPN. This means I'm frequently hosing myself by installing yet another VPN client. That, Read More...

1 Comments

Filed under: Tips And Tricks, How To's, Raves

SQL Server Unit Testing: Sprocs

Posted Thursday, April 06, 2006 9:41 AM by michael.k.campbell

As a consultant, it's not uncommon for me to need to rewrite a poorly performing query or sproc without a full understanding of the underlying biz rules or context. Improved performance is the stated goal, but data fidelity is implied as critical. Enter Read More...

1 Comments

Filed under: Tips And Tricks, How To's, Raves

Nibbling Deletes - Intro

Posted Tuesday, September 20, 2005 11:10 PM by RepeatableRead

So, your application was a success. You're getting oodles and oodles of traffic. Only, it's building up faster than you had anticipated, and after a bit of calculation, you've determined that if the present trends persist, you'll have 24 TB of data within Read More...

10 Comments

Filed under: Tips And Tricks, How To's

Building Clustered SQL Servers on VMWare 5.0

Posted Monday, August 01, 2005 9:59 PM by RepeatableRead

Clustering is just plain fun. Being able walk around with a clustered system on my laptop (and trusty, portable, external USB HD sidekick) is a total hoot. To get an entire cluster working on VMWare 5.0 can be a bit of a bear though, because there's really Read More...

15 Comments

Filed under: How To's

Max Degree of Parallelism

Posted Tuesday, May 24, 2005 5:59 PM by RepeatableRead

In a previous life (actually two previous lives), I was a production DBA. One of the environments that I inherited had some ... issues. There were a number of Clustered SQL Server installations -- oodles of hardware, all churning to keep product inventory, Read More...

1 Comments

Filed under: Tips And Tricks, How To's