Building a SQL Server Inventory – Part 2
Last time I went through my script to gather server information for my inventory. Today I’m going to go through my script to collect SQL Server instance data. So, I think I made it clear last time that I’m not a Powershell guru, and there are probably countless ways in which this script can be [...]
May 31, 2012
Tags: inventory, powershell, SQL Server Posted in: Powershell 
18 Comments
Building a SQL Server Inventory – Part 1
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with you my script for gathering server-level information as part of my SQL Server inventory. Now, I want to make one thing perfectly clear before we begin, and I can’t emphasize this enough: I am not [...]
May 29, 2012
Tags: inventory, powershell, SQL Server Posted in: Powershell 26 Comments
The Importance of a SQL Server Inventory
Pop quiz! It’s time to true-up with Microsoft, what are your current license counts? Operations needs to schedule maintenance on ServerY, what applications will be impacted? A developer wants to change the password for a certain login, what linked servers will be affected? Are there any databases that haven’t been backed up in a week [...]
April 23, 2012
Tags: automation, inventory, SQL Server Posted in: General 11 Comments
