Determining Language Packs (Part 1)

Determining Language Packs (Part 1)

Let’s assume you need to find the installed language packs for a Windows machine. In this three-part series, we use PowerShell’s features to tackle this problem. non-PowerShell command In part 1, we simply try and solve the issue by looking for a native non-PowerShell...

Determining Language Packs (Part 1)

Running $PSScriptRoot in Selected Code

One of the big pitfalls in PowerShell code is the automatic variable $PSScriptRoot which always holds the path to the folder the current script is located. This however requires that (a) the current script is in fact already saved to file, and (b) you are executing...

Determining Language Packs (Part 1)

Pasting Multiple Lines in PowerShell

Unexpected Behavior When Pasting Multiple Lines of PowerShell Code When you copy multiple lines of PowerShell code and paste them into a shell window, the result often is not what you expect. PowerShell starts executing the first line and won’t execute the pasted code...

Determining Language Packs (Part 1)

Cleaning Up PowerShell Modules (Part 2)

In part 1 we looked at removing PowerShell modules that were originally installed via “Install-Module”. You can as well remove PowerShell modules manually if you no longer need them. After all, they are just folders. PowerShell Modules Here’s code that lists all...

Determining Language Packs (Part 1)

Cleaning Up PowerShell Modules (Part 1)

There are plenty of scripts available that promise to read the original Windows 10 product key from the registry by converting a series of binary values. In the first part of this mini-series, we’ll check out where PowerShell keeps its modules, and what you can do to...

Determining Language Packs (Part 1)

Quickly Finding Outdated PowerShell Modules

In the most simplistic case, you can check all your installed modules for updates with just a one-liner (remove -WhatIf to actually perform the update): PS C:\> Get-InstalledModule | Update-Module -WhatIf Get-InstalledModule lists all modules that were installed in...

Determining Language Packs (Part 1)

Analyze blocking for SQL Server

Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set of data at one time. The problem with blocking is if SQL Server blocked a session for a long period, this can cause...

Determining Language Packs (Part 1)

Using Efficient Lists in PowerShell

By default, PowerShell uses simple “object arrays” when you define lists, when commands return more than one result, or when you otherwise need to store more than one thing in a variable. Default object arrays are OK but they cannot grow once you created them. When...

Determining Language Packs (Part 1)

Out-GridView with Custom Columns

Out-GridView can be a universal dialog when you use the -OutputMode or -PassThru parameters. When you do, a grid view window displays additional buttons in its lower right corner so you can choose items and pass them on to additional cmdlets. This line could help...

Determining Language Packs (Part 1)

Converting Ticks to DateTime

Occasionally, date and time information are stored as “Ticks” in the format of a so-called “FileTime”. Ticks are 100-nanosecond units since 01/01/1601. Active Directory internally uses this format, yet you can also find it elsewhere. Reading Windows Installation Time...

Top 5 Benefits of Universal Database GUI

Top 5 Benefits of Universal Database GUI

Universal database graphical user interfaces (GUIs) are among the most productive tools available to database administrators (DBAs) and developers. A well-crafted universal database GUI can greatly assist team members to maintain and implement new features to their...

Determining Language Packs (Part 1)

Unlock Additional PowerShell Modules in Windows 10

PowerShell Modules in Windows 10 for Server Management Windows 10 comes with a number of PowerShell modules that you can use to control Server functionality - like WSUS Update Management which is only one example of many. In earlier Windows 10 builds, these PowerShell...

Determining Language Packs (Part 1)

What Is Non-Uniform Memory Access (NUMA)?

Bare metal to cloud hosted virtual machines Non-Uniform Memory Access (NUMA) is a four-letter word in every sense, well beyond simply the number of characters in the acronym to many data professionals, particularly those in an operational database administrator (DBA)...

Determining Language Packs (Part 1)

Using BITS to Download Files (Part 1)

What Is BITS (Background Intelligent Transfer System)? BITS (Background Intelligent Transfer System) is the technique used by Windows to download huge files such as operating system updates. You can use the same system, too, to download large files. As an extra...

Determining Language Packs (Part 1)

Repairing Install-Module (PowerShellGet)

With Install-Module, you can easily download and install additional PowerShell modules from the PowerShell Gallery (www.powershellgallery.com). However, on Windows systems this command may be broken. Many Windows systems still ship with the outdated version 1.x, and...

1 3 4 5 6 7 16