Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Automation - Scripting Blog [archived]

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.(image)  How can I use Windows PowerShell to improve my code by storing the current pipeline value into variables?(image)  Use the new PipelineVariable common parameter, for example:Get-Counter -ListSet 'LogicalDisk','SQLServer:Buffer Manager','SQLServer:Memory ...

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