The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Showing results for Automation - Scripting Blog [archived]

Nov 24, 2015

PowerTip: Store Current Pipeline Value in Variables with PowerShell

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' -PipelineVariab...

Nov 24, 2015

Automating Index Fragmentation Reports

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 Excel fil...