Monthly Archives: January 2009

Dynamically Register SQL Instances in SQL Server Management Studio 2008

I’ve previously blog, about programmatically registering SQL instances in SQL Server Management Studio (SSMS) and on Dynamically discovering SQL instances through SMS/SCCM. This post combines the two techniques showing how to register any missing registrations from your SSMS 2008 or simply register all … Continue reading

Posted in PowerShell

SQL Saturday Presentation: Using RSS for System Administration

I presented a one-hour session at SQL Saturday Tampa 2009 entitled "Using RSS for System Administration". The session Description:   "Provide an overview using simple tools that generate standard RSS feeds containing information regarding SQL Server jobs; ad-hoc queries and database size … Continue reading

Posted in RSS

SQL Server 2005 Installation and the Power of 2

My colleague John O’Shea ran into an unusual issue installing SQL Server 2005 on 4-socket, 6-core machines, which I thought I would share…   We’ve started using DL 580 G5 4 socket 6-core machines and deployed a few of these boxes … Continue reading

Posted in SQL Server

SQLPSX 1.4 Release

I completed Release 1.4 of SQLPSX which adds 15 new functions for working with SQL Server Integration Services (SSIS). With this release there are now 74 total functions and 10 scripts around SMO, Agent, RMO, and SSIS.   Here’s a few example of working … Continue reading

Posted in PowerShell

SQLServerCentral Article on Getting Data out of SQL Server from Powershell

Using ADO.NET from Powershell has been covered by several articles, blog entries, and discussion group postings; however alternatives methods have not been as widely written about. The article, Getting Data out of SQL Server from Powershell demonstrates three alternative methods … Continue reading

Posted in PowerShell