PowerShell

Use PowerShell to Identify the Process ID for SQL Server Services

Apr 25, 2019 · PowerShell SQL Server ·

I recently saw a blog article on How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185 written by Pinal Dave. While his answer is simple with TSQL, what if you're not a SQL guy? You can also retrieve this information with PowerShell from Windows itself. When it comes to retrieving …

Enable Tab Completion in VSCode for a PowerShell ISE like Experience

Apr 16, 2019 · PowerShell VSCode ·

Share on:

I'm using VSCode for all of my PowerShell development at this point. I reloaded my system from scratch on March 13th of this year. Yesterday was the first time I've opened the PowerShell ISE since then and it was only to determine if something worked differently between the two (I tweeted this out yesterday). One of …

Run SQL Server PowerShell Cmdlets as a Different User

Apr 11, 2019 · PowerShell SQL Server ·

Share on:

One of the ways I practice the principal of least privilege is by logging into my computer as a domain user who is also a standard local user. I typically run PowerShell as a domain user who is a local admin and elevate on a per command basis using a domain account with more access only when absolutely necessary. The …

Audit Membership of the Local Admins Group with PowerShell

Apr 4, 2019 · PowerShell ·

Share on:

Recently, I needed to make sure that specific accounts were members of the local administrators group on several servers along with making sure that no other users were members of it. PowerShell version 5.1 introduced a module named Microsoft.PowerShell.LocalAccounts that contains the following commands for managing …

Backup and Synchronize VSCode Settings with a GitHub Gist

Mar 21, 2019 · PowerShell VSCode ·

Share on:

Earlier this year, I watched a recording of the January 2019 Arizona PowerShell User Group meeting where Tim Warner presented a session on Easing your transition from the PowerShell ISE to Visual Studio Code. One of the things Tim demonstrated was a VSCode extension named Settings Sync where you can synchronize your …

PowerShell Tokenizer more Accurate than AST in Certain Scenarios

Feb 21, 2019 · AST PowerShell ·

Share on:

As many of you know, I've been working on some module building tools. One of the things I needed was to retrieve a list of PowerShell modules that each function required (a list of dependencies). This seemed simple enough through PowerShell's AST (Abstract Syntax Tree) as shown in the following example. 1$File = …

My Solution to Iron Scripter 2019 Preparatory Challenge 1

Feb 16, 2019 · PowerShell PowerShell Summit Scripting Games ·

Share on:

Anyone who has competed in the scripting games before knows that I'm always looking for a challenge when it comes to writing PowerShell code. While the scripting games haven't been held in the last several years, they've somewhat been replaced by the Iron Scripter competition at the PowerShell + DevOps Global Summit …

Unexpected Results when Comparing Different Datatypes in PowerShell

Feb 14, 2019 · PowerShell ·

Share on:

Earlier this week, I saw a tweet from a fellow PowerShell community member who mentioned PowerShell was returning inaccurate results. The command shown in the tweet was similar to the one in the following example. 1Get-AppxPackage | 2Where-Object -Property IsFramework -eq 'False' | 3Select-Object -Property …

What’s a PowerShell One-Liner & NOT a PowerShell One-Liner?

Feb 7, 2019 · PowerShell ·

Share on:

Lately, I've seen a few examples of commands that aren't PowerShell one-liners being passed off as such by people in the PowerShell community who "should" know better. If I were interviewing someone who claimed to be a PowerShell expert with more than five years of experience, I would definitely ask these …

Return a List of the Private Functions in a PowerShell Module

Jan 31, 2019 · PowerShell ·

Share on:

In my quest to build a PowerShell module to convert a non-monolithic PowerShell module from development to a monolithic one for production, I wanted some way to validate that all of the functions were indeed migrated. While I'm pointing my tools to the public and private sub-folders within my development module and …