Random thoughts by SQL DBA/System Administrator
Powershell function to add system path
Was automating some installs and noted that powershell does not have a built-in function to add path...
Date: 12/12/2008
out-sql Powershell function - export pipeline contents to a new SQL Server table
Recently I needed to take output of command-line tool and cross-reference it with information in the...
Date: 10/03/2008
Optimize MERGE statement when only a “slice” of target table is affected
Note: This post assumes reader is familiar with SQL Server 2008 MERGE statement (refresher). In...
Date: 06/18/2008
Why should you install SQL 2008 from the command line
If a project needs several SQL Servers, I believe that command-line setup is the way to install SQL...
Date: 06/17/2008