Scripting Blog

A place to learn about PowerShell and share stories of automation

Automation - Scripting Blog

PowerTip: Store Current Pipeline Value in Variables with PowerShell

November 24, 2015 Nov 24, 2015 11/24/15
Doctor Scripto
Summary: Use PowerShell to store current pipeline values in variables. How can I use Windows PowerShell to improve my code by storing the current pipeline value into variables? Use the new PipelineVariable common parameter, for example:Get-Counter -ListSet 'LogicalDisk','SQLServer:Buffer Manager','SQLServer:Memory Manager' -...

Automating Index Fragmentation Reports

November 24, 2015 Nov 24, 2015 11/24/15
Doctor Scripto
Summary: Guest blogger, Laerte Junior discusses how to use PowerShell to automate an index fragmentation report and generate an Excel file.One of the day-to-day tasks of a DBA is to maintain your environment. This task includes checking the fragmentation of indexes. In this post, I will show how to automate this collection and generate an ...