SMO server based connection vs. “classic” — Take two.

It was pointed out to me today by the lead dev at work, that I can remove two more lines from the script.
I have to confess that I am rather new to object-oriented types of programming. PowerShell is really my first venture into the OO world via .NET. DataSet/Adapters are still a bit [...]

SMO server based connection vs. “classic”

Ok, I said I was going to show an easier way than the ‘classic’ way of connecting to a database server. You’ll be amazed at how much less code there actually is (or needs) for an SMO based connection.
Fire up your trusty PowerShell IDE (mine happens to be PowerGUI made by the folks over [...]

Powershell – Read list & get service information.

This is a PowerShell script that will use SQLCMD to generate a list of SQL Servers on your network, piping the reults into a file.  A “classic” database connection is made and the list is processed using a PSH foreach loop calling Get-WMI in order to retrieve SQL Service information via WMI. As the service information is [...]

Introductions?

I guess I should start off with some form of introduction….
My name’s Gordon Rayburn.   I’m a senior level database administrator using Microsoft SQL Server technologies.  It’s nice to be able to say technologies these days, instead of “Yeah, I’m the guy who runs the database servers”.  I do have a tendancy to introduce myself or [...]