Tag: Windows PowerShell

An Oracle “oraenv” script solution for Windows with PowerShell

The idea Due to the nature of my consulting work, I mostly work in Linux environments and use bash for scripting. But in some cases, I hit a Windows server hosting an Oracle database and all the fancy bash scripts…

Read More >

Pillars of PowerShell: Windows OS

Introduction This is the fifth blog post continuing the series on the Pillars of PowerShell. The previous post in the series are: Interacting Commanding Debugging Profiling The Windows Operating System (OS) is something a DBA should know and be familiar with…

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 >