Scripting Blog

A place to learn about PowerShell and share stories of automation

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

Use PowerShell to Troubleshoot SQL Server via the Error Log

June 29, 2012 Jun 29, 2012 06/29/12
Doctor Scripto
Summary: Guest blogger, Laerte Junior, discusses using Windows PowerShell to troubleshoot SQL Server by parsing the SQL error log.  Microsoft Scripting Guy, Ed Wilson, is here. Today we have another guest blogger, Laerte Junior. Here is a little bit about Laerte. Laerte Junior is a SQL Server specialist and an active member of WW SQL ...