Monthly Archives: December 2008

Installing Visual Studio Team System 2008 Database Edition

I’ve been following Visual Studio Database Edition (VSDB) aka Data Dude, since the initial release over two years. The best overview of VSDB I’ve seen recently is a presentation given by Gert Drapers at PDC2008. Until recently I’ve only been able to look at … Continue reading

Posted in SQL Server | 1 Comment

Disable Windows Server 2003 Scalable Networking Pack

For the last several months I’ve been having Windows 2003 Server Pack 2 applied to all SQL Server in my envronment in order to bring them inline with a single build and have ran into an issue with Windows Server 2003 … Continue reading

Posted in SQL Server | 3 Comments

Registering SQL Servers in 2000 EM, 2005 SSMS, and 2008 SSMS

I support hundreds of SQL Servers and rather than manually registering SQL instances through the GUI I prefer to register SQL instances programmatically for each version of SQL Server. This is particuarlly true with SQL Server 2000 which offers no built-in way to … Continue reading

Posted in PowerShell | 3 Comments

SQLServerCentral Article on Importing Powershell Output into SQL Server

The question of how to load Powershell output into SQL Server has been frequently asked in Powershell forums. The article, Loading Data With Powershell is my attempt to answer the question by providing three methods you can use to load the … Continue reading

Posted in PowerShell

SQLPSX Release 1.3

I completed Release 1.3 of SQLPSX which adds 21 new functions for working with SQL Server Replication via RMO. With this release there are now 59 total functions and 10 scripts around SMO, Agent, RMO.   Here’s a few example of working … Continue reading

Posted in PowerShell

Dynamically Discover Microsoft Cluster Server Information

As mentioned in my post Inventory SQL Server Databases with PowerShell most server management tools including SCCM/SMS are unware of Microsoft Cluster Servers. This presents a problem as I need an up-to-date list of clusters, physical nodes, and virtuals and … Continue reading

Posted in PowerShell