Monthly Archives: January 2009

Dynamically Register SQL Instances in SQL Server Management Studio 2008

Posted on January 27, 2009 by cmille19

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 | Leave a comment

SQL Saturday Presentation: Using RSS for System Administration

Posted on January 25, 2009 by cmille19

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 | Leave a comment

SQL Server 2005 Installation and the Power of 2

Posted on January 22, 2009 by cmille19

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 | Leave a comment

SQLPSX 1.4 Release

Posted on January 16, 2009 by cmille19

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 | Leave a comment

SQLServerCentral Article on Getting Data out of SQL Server from Powershell

Posted on January 2, 2009 by cmille19

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 | Leave a comment