SQLAdm.in

A Blog from a PowerShell wielding, SQLServer DBA.

               

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

T-SQL Tuesday #140 - Container Convenience

Explore some of the things you can do with containers.

Jul 13, 2021

From SQL to Excel with PowerShell

Easily get your query from SQL Server into Excel with PowerShell

Jun 30, 2021

Generate Restore Script with Dbatools

Use the dbatools PowerShell module to generate a database restore script.

Jun 21, 2021