database-tools

The Best Ways to Download Script Files

Occasionally, PowerShell scripts are made available via direct download. Let’s find the most efficient way to download text-based files via...

Colorizing Cmdlet Output

Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this...

Using Colors in PowerShell Console

Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this...

Output Log Messages in the Same Line

Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this...

Dealing with Database Security

Nearly every month there is another announcement about a company disclosing a data breach in which sensitive customer data was exposed. Last week,...

Using Underlined Console Output

Starting in PowerShell 5.1, the PowerShell console supports VT escape sequences that can be used to position and format console text. Note that this...

Safely Embedding Variables

When you use double quotes in PowerShell, you can add variables to a string, and PowerShell automatically replaces these with their content –...

Synthesizing Speech (Part 1)

In the previous tips, we explained how PowerShell can generate acoustic signals by playing system sounds or WAV sound files. PowerShell can also use...

Playing Sound Files

In the previous tip we explained how PowerShell can play system sounds. For a bit more flexibility, PowerShell can also play arbitrary *.wav sound...

Playing Sounds

If all you need is a beep, then PowerShell can help you easily: $frequency = 800 $durationMS = 2000 [console]::Beep($frequency, $durationMS) If...

The RDBMS is Dead

 If you suspected the title of this blog is click-bait, then you would be correct.  But bear with me anyway on a little retrospection of...

Sort IPv4 and IPv6 Addresses Correctly

When you try and sort IPv4 addresses via Sort-Object, this fails: PS> '10.1.2.3', '2.3.4.5', '1.2.3.4' | Sort-Object 1.2.3.4 10.1.2.3 2.3.4.5...

Sort IPv4 Addresses Correctly

In the previous tip we published a super-fast function called Test-OnlineFast, and this function was able to ping an entire IP segment in record...

Final Super-Fast Ping Command

In the previous tip series, we developed a new function called Test-OnlineFast that can ping multiple computers in record time. For some reason, the...

Backing Up Event Logs

There are a number of useful cmdlets to manage event logs, however one functionality is missing: PS> Get-Command -Noun EventLog CommandType Name...

SQL Inventory Manager Reporting

We have heard a number of our DBA customers ask for reporting of SQL Inventory Manager data for a number of reasons - (be able to provide executive...

Easy Logging by Using Event Logs

Often scripts need to log what they do, and PowerShell scripters invest a lot of thought and time on logging information to text files. As an...

1 58 59 60 61 62 159