Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

Archives: March 2010

Powerscripting Podcast 2

I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second time coming on the show and it was great to be back. In the interview we talked about the PowerShell changes in SQL Server 2008… Read more

0 comments, 1,146 reads

Posted in Chad Miller on 25 March 2010

Goodbye Live Spaces, Hello WordPress

After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain here to Sev17.com. As an aside, the meaning of Sev17 is described in the About section. All of the content and comments have been migrated from my old blog Read more

0 comments, 250 reads

Posted in Chad Miller on 25 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 I will no longer update with new posts comments have… Read more

0 comments, 215 reads

Posted in Chad Miller on 21 March 2010

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 that includes the ability to edit, execute, parse and format… Read more

1 comments, 412 reads

Posted in Chad Miller on 10 March 2010

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 query an Oracle database we’ll use a function called Get-OLEDBData Read more

0 comments, 1,258 reads

Posted in Chad Miller on 1 March 2010

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 for connecting to Oracle are not included with the operating… Read more

5 comments, 1,679 reads

Posted in Chad Miller on 1 March 2010