database-tools

Test Whether Applications Exist

Here is a simple one-liner that can test whether PowerShell 7 is installed on your system (or any other application): # name of application you want...

Converting File Paths to 8.3 (Part 2)

In the previous post we explained how you can use an old COM component to convert default long path names to short 8.3 path names. While...

Converting File Paths to 8.3 (Part 1)

Many years ago, file and folder names had a maximum of 8 characters, and these short path names still exist. They can even still be useful: short...

Using Online Help (Part 2)

In the previous tip we mentioned that many PowerShell users prefer the online help over locally downloaded help. To use the online help documents by...

Making Time Using Temporal Data

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...

Using Online Help (Part 1)

PowerShell supports both local help files and online resources. Take a look at the differences: # outputs help in same console window # level of...

Updating Help without Admin Privileges

In Windows PowerShell, updating help used to require Administrator privileges due to a design flaw: help had to be stored in the location where the...

Checking Profile Scripts (Part 2)

In the previous script we came up with a one-liner that checks which profile scripts actually exist. This solution works per host only, though,...

Normalization Heuristics

Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an...

Checking Profile Scripts (Part 1)

PowerShell uses up to four profile scripts. When they exist, PowerShell silently executes any content when it launches. It’s important to know...

Using Profile Scripts

Profile scripts work like autostart scripts in PowerShell. They do not need to exist, but if they do, PowerShell executes its content silently...

Identifying User Profile

Be careful when using $env:userprofile or $home to create paths to user files. When a Windows box is set up for OneDrive, the documents folder may...

Get Rid of Get-EventLog

The Get-EventLog cmdlet provides easy access to event log entries in the primary Windows event logs, however it neither can access the many...

1 23 24 25 26 27 159