Close
  • Blog
  • About
×
×
  • Blog
  • About
Menu & Search
MSSQL DBA Blog
Category

PowerShell

PowerShell & Windows Admin Blog Archives, by Peter Whyte (SQL Database Administrator). Includes a lot of WSL posts & more...


November 13, 2020
PowerShell
Windows
Install oh-my-posh On Windows

Oh-my-posh is a theme engine for PowerShell that’s separate from your default PowerShell console. It’s powered by posh-git and has status indications for git, failed, and admin commands.

Read More
November 12, 2020
PowerShell
Windows
How to Install Windows Terminal

Windows Terminal is a more modern command-line tool that has many additional features. A major benefit of WT is the multiple tabs feature.

Read More
November 11, 2020
PowerShell
Windows
Install posh-git on Windows

Posh-git is a PowerShell module that integrates with Git to show git status information on the command line, and it comes with tab completion for common commands.

Read More
November 10, 2020
PowerShell
Windows
Install Chocolatey on Windows

This post is a guide on installing the Chocolatey package manager on Windows by running a PowerShell command. Chocolatey allows you to manage software packages on your system with simple ‘choco’

Read More
Enable WSL
September 3, 2020
Linux
PowerShell
Windows
Enable Windows Subsystem for Linux (with Ubuntu 18.04)

WSL allows Windows users to develop and run applications within a GNU/Linux environment. Previous to this feature release we needed VM’s or a dual boot setup.

Read More
Remove Quotes From CSV PowerShell
July 30, 2020
PowerShell
Remove Quotes from a CSV File with PowerShell

This is a post on how to remove quotes from a CSV file using PowerShell. If your dealing with a large CSV file, running the Import-CSV cmdlet below will consume a lot of system resources (RAM mostly).

Read More
ps1 cannot be loaded because running scripts is disabled on this system
July 16, 2020
PowerShell
“.ps1 cannot be loaded because running scripts is disabled on this system” PowerShell Error

When attempting to run a PowerShell script you may receive the following error: cdk.ps1 cannot be loaded because running scripts is disabled on this system.

Read More
Test Connectivity to Remote Server Port PowerShell
May 7, 2020
PowerShell
Windows
Testing Connectivity to Remote Server Ports with PowerShell

All admins need a tool to test connectivity to remote servers on TCP ports. In Windows, this is commonly done using PuTTy or PowerShell.

Read More
Forcing Encryption in SQL Server
May 6, 2020
PowerShell
SQL Server
Windows
Forcing Encryption in SQL Server

If you’re ever planning to allow external connections to a SQL Server, one of the first things to ensure is that the data is encrypted at rest and in transit.

Read More
PowerShell Scheduled Task Daily Reboot
May 3, 2020
PowerShell
Windows
Running PowerShell Scripts as Scheduled Tasks in Windows

When you need something scheduled in Windows, the Task Scheduler is the tool at-hand. Running PowerShell (.ps1) scripts as Scheduled Tasks is done differently than differently than running regular .bat scripts.

Read More
1 2 3 4 5
Peter Whyte DBA

Peter Whyte

Blog Menu

  • Homepage
  • MSSQL DBA Blog
  • SSMS Tips
  • SQL Notes & Links
  • DBA Blog Archives
  • WSL Windows Tips
  • Projects

Categories

  • AWS (5)
  • Linux (34)
  • MySQL (5)
  • Postgres (7)
  • PowerShell (48)
  • RedShift (7)
  • SQL Server (78)
  • Windows (64)
  • WordPress (2)

Tags

Active Directory (AD) (4) AWS CLI (3) CDC (2) Certificates & Encryption (3) Change Data Capture (2) CSV Files (4) Database Admin (54) Database Backups (10) Data Types (2) Deleting Data (2) Error Messages (4) Featured (4) Git (11) Git Commands (4) Git Log (3) Installing SQL Server (10) Linked Servers (3) Linux Admin (2) Measuring Databases (9) MSSQL SPIDs (3) NetFirewallProfile (3) New-Item PowerShell (2) PowerShell Create Folder (2) PowerShell Delete Files (2) PowerShell ForEach (2) PowerShell Tips (20) PowerShell Version (2) Restoring Databases (7) SQL Server Agent (4) SQL Server ETL (2) SQL Server Management Studio (SSMS) (14) SQL Server Processes (6) SQL Server Scripts (3) SQL Tips (19) SSH (2) SSMS Tips (9) Temp DB (2) Windows Admin (21) Windows Firewall (4) WordPress Tutorials (2) WSL (22) WSL1 (4) WSL2 (4) WSL Ubuntu (6) WSL Version (4)