Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off a SQL Server week (Nov 1st 2010) with my guest blog post. The post, Use PowerShell to Collect Server Data and Write to SQL, demonstrates my number one use case for database related PowerShell activities—loading data into a SQL Server table. I’ve used the techniques described in the post to build many solutions including:

• A data dictionary
• Disk and database space forecasting
• Backup reporting

Each problem comes down to one thing—get the data into a SQL Server database! Learn the basics and you can easily create your own PowerShell-based solutions.