PowerShell
- PowerShell •
- SQL Server •
2022
-
Check if You Have Old Versions of Modules
•
Sep 29
Simple script to check your installed modules against the PSGallery
-
PowerShell Prompt: Functionality
•
Sep 17
Some handy tips to add extra functionality to your PowerShell session
-
PowerShell Prompt: Colors and Icons
•
Sep 7
Tips and Tricks to improve your PowerShell experience
-
SQLServer, sp_configure and PowerShell
•
•
Jan 7
How to use PowerShell to look at and change sp_configure options.
2021
-
Nth Day of Month
•
Dec 21
Quick script to find the Nth day of a month.
-
Update Portable VSCode
•
Nov 18
Make updating the portable version of VSCode easier.
-
T-SQL Tuesday #143 - Short Code Examples
•
•
Oct 12
My go to scripts for day-to-day tasks.
-
Search SQL Server Errorlog with PowerShell
•
•
Oct 1
Search SQL Server’s errorlog for problems with PowerShell using community tools
-
Stop or Start SQL Server With PowerShell
•
•
Aug 31
How to stop a SQL Server service with PowerShell
-
Free DBA Superpowers
•
•
Aug 3
Free tools that will make people think you have superpowers.
-
What Do I Name My PowerShell Script
•
Jul 26
We take a look at how to find the right verb for naming our PowerShell commands.
-
Make PowerShell 5.1 Use TLS 1.2
•
Jul 19
Set PowerShell 5.1 Security Protocol to use TLS 1.2
-
From SQL to Excel with PowerShell
•
•
Jun 30
Easily get your query from SQL Server into Excel with PowerShell
-
Generate Restore Script with Dbatools
•
•
Jun 21
Use the dbatools PowerShell module to generate a database restore script.
-
Remove Old dbatools Modules
•
Jun 14
A straight forward way to remove old versions of dbatools with just a few commands.
-
Making Long, Complex Passwords You Can Remember
•
Jun 1
We build a tool to create strong passwords that you can to remember.
-
How to Connect to SQLServer with PowerShell
•
•
May 17
Learn 3 ways to connect to SQLServer with PowerShell.
-
Colorize PowerShell Select-Object
•
May 8
Learn a unique technique for adding color to you Select-Object output.