I wrote an article for SQLServerCentral entitled “Database Space Capacity Planning” that demonstrates a database and volume (disk) capacity planning solution I use in my production environment. Some highlights of the solution: Powershell is used to collect database and volume space information from a list of SQL Servers, which is then loaded into a consolidated reporting database A…
Tag Archive: SQLServerCentral
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of the solution: Powershell is used to collect backup information from a list of SQL Servers which is loaded into a consolidated reporting database A series of queries are used to look for missing backups and report various backup…
SQLServerCentral Article on Getting Data out of SQL Server from Powershell
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 to ADO.NET for querying SQL Server from Powershell. The approaches demonstrated are simplier than ADO.NET…
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 output of any Powershell command into a SQL Server table. The methods are: Export-CSV/BULK…
SQLServerCentral SQLPSX Articles
I wrote a two part article on SQL Server PowerShell Extensiosn (SQLPSX) installation and usage. SQLPSX Part1 SQLPSX Part2 Check out the discussion area for each article: Part 1 Discussion Part 2 Discussion In Part 1 a reader had a question on creating PowerShell scripts to execute SQL queries with parameters using the SQLPSX function Get-SqlData….
