Scripting Blog [archived]

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

November 2015 - Page 3 of 15 - Scripting Blog [archived]

Introducing the PowerShell Excel Module

November 25, 2015 Nov 25, 2015 11/25/15
Doctor Scripto
Summary: Guest blogger, Doug Finke talks about his PowerShell Excel module. The PowerShell Excel Module is a brand new, exciting, and better way to interact with Microsoft Excel from Windows PowerShell. Plus for bonus points, you don’t need Excel installed on the target machine to create the spreadsheet. Many users of this module ...

Introducing the PowerShell Excel Module

November 25, 2015 Nov 25, 2015 11/25/15
Doctor Scripto
Summary: Guest blogger, Doug Finke talks about his PowerShell Excel module.The PowerShell Excel Module is a brand new, exciting, and better way to interact with Microsoft Excel from Windows PowerShell. Plus for bonus points, you don’t need Excel installed on the target machine to create the spreadsheet. Many users of this module generate...

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