Posts
- 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.
-
T-SQL Tuesday #145 - Conferences
•
Dec 14
T-SQL Tuesday 145 - Conferences.
-
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
-
NT AUTHORITY \ ANONYMOUS LOGON Error
•
Aug 16
What to do if you get NT AUTHORITY\ANONYMOUS LOGON errors with your existing linked server connection in SQL Server.
-
T-SQL Tuesday #141 - Work/Life Balance
•
Aug 10
Some thoughts on maintaining a good work/life balance
-
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
-
T-SQL Tuesday #140 - Container Convenience
•
Jul 13
Explore some of the things you can do with containers.
-
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.
-
T-SQL Tuesday #139 - How Hybrid Am I?
•
Jun 8
In this month’s T-SQL Tuesday, I talk about where I am on my hybrid data journey.