database-tools

Adding New PowerShell Commands

PowerShell is just a scripting platform and can be extended with new commands. A great source for new commands is the public PowerShell Gallery. You...

Are Statistics Being Used?

You know those tweets that you see once but can never find again? I remember seeing one a while ago where someone tweeted to #sqlhelp asking if the...

Getting Help for WMI Objects

WMI is extremely powerful but a little underdocumented. To change this, a group has formed and is creating a PowerShell-specific WMI reference:...

IDERA Newsletter April 2020

The Latest News from IDERA Product Release Updates, Vote IDERA, and Learn Something New Introducing SQL Inventory Manager v2.6 Get Complete...

Ensure Database Health

Keep multiple database platforms running with a single tool. Organizations react to rapidly changing demands because of the escalating crisis while...

Reading Chassis SKU

In Windows 10 and Server 2016, WMI added a new property that simplifies collecting chassis or enclosure SKUs. This one-liner reads the SKU for you:...

Managing Automatic Reset

When a Windows system crashes, it typically reboots immediately. This is called “Automatic Reset Capability”, and with this one-liner...

Using Custom Validation Attributes

Beginning in PowerShell 5, you can create your own attributes, i.e. custom validators. They can be applied to variables (and parameters), and once a...

Testing for Metered WLAN

Ever needed to know whether you are currently connected to a metered (costly) network? Here is a quick way to check: function Test-WlanMetered {...

Using WMI Instance Paths (Part 2)

In the previous tip we showed that the new Get-CimInstance command is missing the important “__Path” property that was returned by...

Using WMI Instance Paths (Part 1)

Generally, it is the best to move away from the old and deprecated Get-WmiObject command and instead use the modern and faster CIM cmdlets like...

Installing PowerShell 7

PowerShell 7 is a portable app and can run side-by-side with Windows PowerShell. You just need to download and install it. This part is easy because...

Enabling Clickable PowerPoint Actions

Using clickable actions in PowerPoint presentations can be super useful to launch Visual Studio Code or PowerShell ISE, and seamlessly open and demo...

1 29 30 31 32 33 159