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

Author: ayeltsov 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...

Author: ayeltsov 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...

Author: ayeltsov 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...

Author: ayeltsov Date: 06/17/2008