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...


Check SQL Server Feature Installed
April 29, 2020
PowerShell
SQL Server
Windows
How to Check What Features are Installed in SQL Server

This is a quick guide on how to check which features are installed on a SQL Server. Open your SQL Server installation files.

Read More
Enable TCP/IP SQL Server
April 25, 2020
PowerShell
SQL Server
Windows
Enabling TCP Connections in SQL Server

Some network protocols are not enabled by default in SQL Server. We need to enable the option and restart the SQL Service to allow TCP connections.

Read More
Adding and Removing SQL Server Features via Command Feature
July 18, 2019
PowerShell
SQL Server
Windows
Adding & Removing SQL Features via Command

This is a quick guide on how to add and remove features from SQL Server via command, following the theme of recent posts.

Read More
Install SQL Server via Command
June 10, 2019
PowerShell
SQL Server
Windows
Install/Uninstall SQL Server via Command

This is a post on installing SQL Server via command; I have a Windows Server 2016 Core running on a local Hyper-V test environment, and I’m installing SQL Server 2019, then uninstalling it.

Read More
Configuring Windows Server Core
June 9, 2019
PowerShell
Windows
Configuring Windows Server Core

Windows Server Core is the CLI only version of the Windows OS. This post is a run-through of configuring a new Windows Server 2016 Core host, detailed in the following steps;

Read More
How to run Update-Help in PowerShell
February 19, 2019
PowerShell
Updating Help Documentation in PowerShell

The Update-Help cmdlet in PowerShell will download the latest help files for PowerShell modules installed on your machine. Running PowerShell as Administrator is a requirement for this one, else you’ll get the following error.

Read More
Count Rows within CSV Files
October 9, 2018
PowerShell
Count Rows within CSV Files using PowerShell

This post contains a script that will help count rows within multiple CSV files using PowerShell. If you have a directory containing CSV files, this demo will walk you through how to count the rows of all CSV files within a folder.

Read More
SQL Script Case When
May 13, 2018
PowerShell
SQL Server
Windows
Show Available Disk Space in SQL Server

This blog post is to share a script that you can run in SQL Server (versions 2008 R2 and above) which shows the available disk space for all local volumes on a SQL Server host.

Read More
1 … 3 4 5
SQL DBA Blog

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)