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
PowerShell
SQLServer

Nth Day of Month

Quick script to find the Nth day of a month.

Dec 21, 2021
PowerShell

T-SQL Tuesday #145 - Conferences

T-SQL Tuesday 145 - Conferences.

Dec 14, 2021
SQLServer

Update Portable VSCode

Make updating the portable version of VSCode easier.

Nov 18, 2021
PowerShell

T-SQL Tuesday #143 - Short Code Examples

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

Oct 12, 2021
PowerShell
SQLServer

Search SQL Server Errorlog with PowerShell

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

Oct 1, 2021
PowerShell
SQLServer

Stop or Start SQL Server With PowerShell

How to stop a SQL Server service with PowerShell

Aug 31, 2021
PowerShell
SQLServer

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
SQLServer

T-SQL Tuesday #141 - Work/Life Balance

Some thoughts on maintaining a good work/life balance

Aug 10, 2021
SQLServer
ProfDev

Free DBA Superpowers

Free tools that will make people think you have superpowers.

Aug 3, 2021
edited: Aug 11, 2021
PowerShell
SQLServer

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
PowerShell

Make PowerShell 5.1 Use TLS 1.2

Set PowerShell 5.1 Security Protocol to use TLS 1.2

Jul 19, 2021
PowerShell