February 2014 – Ramblings of a Crafty DBA

North Haven – SQL Saturday #268

February 24, 2014April 20, 2016 admin

I am totally pumped up about having the opportunity to present at SQL Saturday #268 in North Haven. It will be a good time to meet old friends and make new ones. I hope you have time to attend cool event on March 1st, 2014! Topic: Effective use of temporary tables Abstract: Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query…

Executing Powershell From Cmd Line

February 1, 2014February 17, 2024 admin

In the last article, we verified that Windows PowerShell was installed on my laptop and determined the version of the scripting engine. This tallk will be center around how to execute scripts from the command line. For a simple test case, I created a C:\TEMP directory. Inside that directory is a script named “LIST-ROOT.PS1” that will change the directory to the root node on the C drive. After this action, the contents of the root directory is listed for review.

#
# List root directory
#
cd c:\
dir

# List root directory

cd c:\

dir

Lets try executing the script from a command line.…