Author: Laerte Junior

A (BIG) Trick Listing Windows updates using PowerShell

If you (like me) are using Microsoft.Update.Session for listing the installed windows updates, you might be surprised about something I spent a lot of time today. Our dream team here is deploying a very cool project for a client where we automated…

Read More >

Challenge Me! Capturing SQL server data with PowerShell

Hello PowerShell lovers! If you are reading this blog post, then you are likely interested in attending my extended session at SQLBITS SUPERHEROES ( Honored to be selected) Any data professional who is responsible for performance tuning, has their way of…

Read More >

Capturing SQL Server IO Latencies for a Period of Time with PowerShell

Today’s blog post is a demonstration of the PowerShell approach to Paul Randal’s recent blog post, Capturing IO Latencies for a Period of Time. Since wait statistics were properly implemented in SQL Server, it turned into a powerful resource to diagnose and troubleshoot…

Read More >