SQLAdm.in

A Blog from a PowerShell wielding, SQLServer DBA.

               

Check if You Have Old Versions of Modules

Simple script to check your installed modules against the PSGallery

Sep 29, 2022

PowerShell Prompt: Functionality

Some handy tips to add extra functionality to your PowerShell session

Sep 17, 2022

PowerShell Prompt: Colors and Icons

Tips and Tricks to improve your PowerShell experience

Sep 7, 2022

SQLServer, sp_configure and PowerShell

How to use PowerShell to look at and change sp_configure options.

Jan 7, 2022

Nth Day of Month

Quick script to find the Nth day of a month.

Dec 21, 2021

T-SQL Tuesday #145 - Conferences

T-SQL Tuesday 145 - Conferences.

Dec 14, 2021

Update Portable VSCode

Make updating the portable version of VSCode easier.

Nov 18, 2021

T-SQL Tuesday #143 - Short Code Examples

My go to scripts for day-to-day tasks.

Oct 12, 2021

Search SQL Server Errorlog with PowerShell

Search SQL Server’s errorlog for problems with PowerShell using community tools

Oct 1, 2021

Stop or Start SQL Server With PowerShell

How to stop a SQL Server service with PowerShell

Aug 31, 2021

NT AUTHORITY \ ANONYMOUS LOGON Error

What to do if you get NT AUTHORITY\ANONYMOUS LOGON errors with your existing linked server connection in SQL Server.

Aug 16, 2021

T-SQL Tuesday #141 - Work/Life Balance

Some thoughts on maintaining a good work/life balance

Aug 10, 2021