Author Archives: cmille19

I’ve Moved and So Should You

After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own domain. All of the content and comments have been migrated to the new site. Although this site will remain available … Continue reading

Posted in Uncategorized

SQLIse A Powershell Based SQL Server Query Tool

SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of a Powershell Integrated Scripting Editor (ISE) module called SQLIse (pronounced “SQL Ice”). The module provides a basic IDE for T-SQL … Continue reading

Posted in PowerShell | 4 Comments

Querying Oracle from Powershell Part 2

In part one we installed and configured the Oracle client software, in this post we will query an Oracle database from Powershell.  In addition we’ll look at one way to handle storing sensitive password information. Querying and Oracle Database To … Continue reading

Posted in PowerShell | 6 Comments

Querying Oracle from Powershell Part 1

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can run queries against Oracle we need to install the Oracle client on our Windows machine. Unlike SQL Server, the drivers … Continue reading

Posted in PowerShell | 2 Comments

Suncoast Technology Forum Tech Fest Event 2010

I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will provide an introduction to Powershell for IT Pros seeking to automate administration tasks. Specific topics covered configuring Powershell, tips and … Continue reading

Posted in PowerShell

The T-SQL Hammer

The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks like nail” and for database professionals this means using or sometimes misusing T-SQL. Whenever database administrators are presented with a … Continue reading

Posted in PowerShell | 2 Comments

Providing Online Help for Powershell Modules

As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of the help documentation I created from both comment-based and MAML formats. I had two requirements I need to be able … Continue reading

Posted in PowerShell