database-tools

Working with [FileInfo] Object

Often, code needs to check on files, and for example test whether the file exists or exceeds a given size. Here is some commonly used code: $logFile...

Script Logging Made Easy

Beginning in PowerShell 5, you can use Start-Transcript in any host to log all the output created by your script. Here is how you can easily add...

Multi-Language Voice Output

On Windows 10, the operating system ships with a bunch of high-quality text-to-speech engines and is no longer limited to just the English language....

Precise V9.8.0

We are pleased to announce the general availability of Precise V9.8.0   Here are some of the highlights:   Oracle 12CR2 support on Solaris...

Precise 9.8.0 GA

We are pleased to announce the general availability of Precise V9.8.0   Here are some of the highlights:   Oracle 12CR2 support on Solaris...

Removing Text from Strings

Occasionally, you might read about Trim(), TrimStart(), and TrimEnd() to remove text from strings. And this seems to really work well: PS C:\>...

Addressing License DLL Issue

Upgrade your license library if required Should you determine that you have a problem with your SQL Secure license keys, please follow the procedure...

Uncompressing Serialized Data

In the previous tip you learned how you can use Export-CliXml to serialize data and then use Compress-Archive to shrink the huge XML files to only a...

A Better (and Faster) Start-Job

Start-Job transfers a script block to a new PowerShell process so that it can run separately and in parallel. Here is a very simple sample...

Digitally Signing PowerShell Scripts

In the previous tips you learned how you can create a self-signed code signing certificate, save it to a PFX file, and read it back into memory....

Loading Certificates from PFX Files

In the previous tip we illustrated how you can use New-SelfSignedCertificate to create new code signing certificates, and store them as a PFX file....

Using LDAP Filters in Active Directory

LDAP filters resemble the query language used by Active Directory, and if you have installed Microsoft’s RSAT tools, you can easily use the...

Generating MD5 Hashes from Text

The Get-FileHash cmdlet can generate hash codes for file content. It cannot generate hash codes for arbitrary text, though. And it is available only...

Finding File Duplicates

In the previous tip we explained how the Get-FileHash cmdlet (new in PowerShell 5) can generate the unique MD5 hash for script files. Hashes can be...

Creating MD5 File Hashes

MD5 file hashes uniquely identify file content and can be used to check whether file content is identical. In PowerShell 5, there is a new cmdlet...

1 63 64 65 66 67 159