database-tools

When you view PowerShell scripts in Windows Explorer and have the preview pane open, by default you don’t get a code preview for your script...

If you want to eliminate completely empty array elements (and do not need to focus on empty properties), here are some approaches with fundamentally...

Occasionally you come across lists (arrays) with empty elements. What’s the best way of removing empty elements? Let’s first focus on a...

Let’s assume in an array you want to get rid of all elements that are either empty or null. This is what many would do: PS>...

For reporting and similar use cases, scripts may require the first and last day in a given month. The first day is easy, yet the last day depends on...

Whenever you have a true DateTime (and not a string, for example), you have plenty of powerful ways to format. You can get DateTime objects...

Ever wondered how old your Windows installation is? A one-liner can tell: PS> (Get-CimInstance -Class Win32_OperatingSystem).InstallDate Freitag,...

Are you tired of OneDrive icons polluting your file explorer tree view? If you don’t use OneDrive, then here are two handy functions that hide...

PowerShell 5 and later releases come with a cmdlet to automatically add new Windows features, so if you are running a Windows Server and would like...

XPS is a document format similar to PDF from Microsoft. Although it never really was used in a large scale, it can still be a valuable internal...

BOM (Byte Order Mask) is a characteristic byte sequence used in some Unicode encoded text files. If you receive text files with BOM that need to be...

In the previous tip we pointed you to a great compilation of PowerShell cheat sheets. Let’s now check out how easily PowerShell can download...

Here is a great compilation of popular PowerShell cheat sheets, completely free and ready for download:...

Text files can be stored using different encodings, and to correctly reading them, you must specify the encoding. That’s why most cmdlets...

On Windows 10, when you hold CTRL+SHIFT and then move your mouse wheel, you can easily control the transparency of console window, including the...

Here is a one-liner that retrieves your original Windows product key: (Get-WmiObject -Class...

In the previous tip we explained how PowerShell can send PDF documents to the default PDF printer. This generic approach is OK for simple scenarios...