PowerTip: Store Current Pipeline Value in Variables with PowerShell

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’ -PipelineVariable CounterCategory |  Select-Object -ExpandProperty Counter -PipelineVariable CounterName | Where-Object {$CounterName -match ‘(sec/Transfer|Avg. Disk…


Automating Index Fragmentation Reports

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…


Use PowerShell to Troubleshoot SQL Server via the Error Log

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…