database-tools

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...

Inverting Bits

Occasionally it is necessary to invert the bits for a number. Most often, this is part of custom algorithms or checksum calculations. It raises the...

1 44 45 46 47 48 159