Welcome to SqlAdvice Sign in | Join | Help

Browse by Tags

All Tags » How To's   (RSS)
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: ,
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: ,
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: ,
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...
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...
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...
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:
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...
How to force Named-Pipe connections in SQL Server 2000/2005 and through .NET connection strings. Read More...
357 Comments
Filed under:
A quick solution to a commonly encountered problem. Read More...
3 Comments
Filed under:
An undocumented way to determine if a Check or Foreign-Key Constraint has been turned off. Read More...
5 Comments
Filed under:
Custom T-SQL Templates not only allow you to accomplish your job in a jiffy... they're awesome mnemonic tools. Read More...