database-tools

Preferring WLAN Connections

When you are connected both to a LAN and a WLAN, and would like to prefer one network over the other, you can adjust the network metric. The lower...

Locking the Screen with PowerShell

Here is a PowerShell function called Lock-Screen that can lock the screen and prohibit user interaction. There can be a custom message, and the...

Blocking User Input

If a PowerShell script needs to perform critical steps, and user interaction must be prohibited, you can use API calls to temporarily disable all...

The Impact of Cloud on DBA

The DBA is the information technology professional responsible for ensuring the ongoing operational functionality and efficiency of an...

Passing Arguments to Encoded Commands

Encoding PowerShell code is a great way to run PowerShell code outside the PowerShell environment, i.e. in batch files. Here is some sample code...

Repairing PowerShell Context Menus

When you right-click a PowerShell script in File Explorer, you typically find a context menu entry called “Run with PowerShell” which...

Repairing PowerShellGet Publishing

If you are using Publish-Module to publish your modules to a PowerShell repository, and you keep getting exceptions about unsupported commands, it...

Sending Mails via Outlook

To send mails via PowerShell, you can use Send-MailMessage. However, this requires that you have access to an SMTP server, and mails sent this way...

How to tune SQL Server in the cloud

As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...

Mind Jogging Generator

The human mind can read sentences even if the characters are scrambled as long as the first and last letter of each word stays intact. Here is a...

Speeding Up the PowerShell Pipeline

PowerShell scripts can grow very slow when you (a) need to process a lot of items and (b) you are using the PowerShell pipeline. Let’s today...

Colorful ASCII-Art from Images

In the previous tip we showed you how you can take any image or photo and turn it into a black&white ASCII art. Today, we have a revised...

1 44 45 46 47 48 159