SQLAdm.in

A Blog from a PowerShell wielding, SQLServer DBA.

               

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

Free DBA Superpowers

Free tools that will make people think you have superpowers.

Aug 3, 2021
edited: Aug 11, 2021

What Do I Name My PowerShell Script

We take a look at how to find the right verb for naming our PowerShell commands.

Jul 26, 2021

Make PowerShell 5.1 Use TLS 1.2

Set PowerShell 5.1 Security Protocol to use TLS 1.2

Jul 19, 2021