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

Nov 25, 2015
0
0

PowerTip: Create Function List and Find PowerShell Files

Doctor Scripto
Doctor Scripto

Summary: Use Windows PowerShell to create a function list and find files.  How can I use Windows PowerShell to avoid repetitively typing “ls . –r *.ps1” to get a list of PowerShell files and then           “ls . –r *.ps1 | sls function” to search the content of those files ...

Windows PowerShellPowerTipguest blogger
Nov 25, 2015
0
0

Introducing the PowerShell Excel Module

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

Nov 25, 2015
0
1

Introducing the PowerShell Excel Module

Doctor Scripto
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 Exce...

Scripting Guy!Windows PowerShellguest blogger
Nov 24, 2015
0
0

PowerTip: Store Current Pipeline Value in Variables with PowerShell

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

Scripting Guy!Windows PowerShellPowerTip
Nov 24, 2015
0
0

Automating Index Fragmentation Reports

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