Category: PowerShell
PowerShell & Windows Admin Blog Archives, by Peter Whyte, an experienced SQL Server Database Administrator.
-
Get-Command in PowerShell
Get-Command is a cmdlet in PowerShell that lets you retrieve a list of all available commands in your current session. It’s a go to tool for discovering new commands and understanding their usage and capabilities. You can use Get-Command with wildcards to filter results based on patterns. This…
-
Create Folder If Not Exists in PowerShell
The PowerShell script included in this blog post checks if a specific folder exists and then creates it if it does not already exist. It does this by using the Test-Path command to check for the existence of the folder and the New-Item command to create it if…
-
Get-TimeZone in PowerShell
The Get-TimeZone cmdlet in PowerShell retrieves the current time zone of a computer. It can also list all available time zones, which is helpful if you’re planning to make changes to the system’s time zone settings. In this post I’m sharing two examples of how to check the…
-
Get-Service in PowerShell
Get-Service is a command in PowerShell that returns a list of Services on a Computer. This post is a quick guide on running this command in a PowerShell terminal, using a wildcard ( * ) to show me my services with “SQL” in the service name. We can…
-
How to Install and Configure AWS CLI on Windows
This post is a how-to for installing & configuring AWS CLI (Version 2) on Windows. In this guide, we’re going to download the AWS Command Line Interface installation media and run through the simple installation. Once done we’ll configure AWS CLI, which you’ll need an AWS Account to…
-
How to Install Ubuntu 20.04 on WSL
This guide shows how to install Ubuntu 20.04 on WSL (Windows Subsystem for Linux). Before installing a WSL Linux distribution you should have already enabled WSL on your computer. All WSL Linux distributions are available for download in the Microsoft Store. This is the easiest way to install…
-
Show Event Logs in PowerShell
In this post, we will explore how to use PowerShell to view event logs. We will use the Get-EventLog command to accomplish this. Specifically, we will cover the following:– List Event Types Available– Get Most Recent Events– Get Events Between a Date Range List Event Types Available To…
-
Open Current Folder in PowerShell
When working in a PowerShell terminal session, you might want to open Windows Explorer to view the current directory. This guide is a simple guide to demo how to open the current working directory directly from PowerShell. Using Invoke-Item to Open the Current Folder The Invoke-Item cmdlet lets…
-
Create New Files and Folders in PowerShell
The New-Item cmdlet will create new files or folders in PowerShell. Amend the -ItemType parameter to File or Directory and include a Name for the file or folder. This blog post will walk through the process of creating a new file and a new folder using PowerShell. I…
-
Installing oh-my-posh On Windows
Oh-my-posh is a theme engine for PowerShell that enhances your terminal with custom themes. It integrates with posh-git to display useful indicators for Git repositories, failed commands, and admin status. This quick guide will walk you through installing oh-my-posh and setting a theme using choco. Steps to Install…
Recent Posts
- Identify Missing & Unused Indexes in SQL Server
- SQL Server Performance Tuning: Index Fragmentation Scripts
- Show User Activity and Blocking in SQL Server
- Download and Install SQL Server Management Studio (SSMS)
- How to Check and Manage SQL Server Services
Categories
– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server
Tags
Always On Availability Groups (AAG) (3) Certificates & Encryption (3) Change Data Capture (CDC) (2) Database Admin (71) Database Backups & Recovery (12) Database Mirroring (2) Deleting Data (1) Error Messages (4) Git Commands (5) Importing & Exporting Data (2) Linked Servers (3) Linux Admin (2) Logging & Monitoring (1) Measuring Databases (10) Microsoft Patching (2) PowerShell Scripts (1) SQL Server Agent (4) SQL Server Database Files (1) SQL Server Data Types (2) SQL Server Management Studio (SSMS) (14) SQL Server Network Connectivity (2) SQL Server on Linux (1) SQL Server Patching (2) SQL Server Performance (5) SQL Server Permissions (1) SQL Server Processes (5) SQL Server Replication (1) SQL Server Scripts (12) Windows Admin (21) Windows Authentication (2) Windows Automation (1) Windows Events (2) Windows Firewall (4) Windows Subsystem for Linux (WSL) (20)