Archive for June, 2008

Three scripts of mine at SQLServerCentral.com

June 12, 2008

Since I can’t publish them myself for thirty days (I did agree to the sites rules about re-publishing)…
Delete files older than N-days via T-SQL:
Script
Powershell “unload and archive table” script:
Script
SQL Server “Quick n dirty” Restore Generator:
Script

SMO & Connection Pooling (and how to avoid it).

June 12, 2008

First, I’d like to apologise for not being as active the last week or so. I caught some very nasty food poisining from a local restaraunt chain. I won’t give names but thier initials start with “Chipotles”. ;)
I’d like to discuss connection pooling with SMO…
In my process’ that I’ll be demonstrating with, [...]