Monthly Archives: March 2010

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