Connecting to SQL Server from VS Code
I am not sure if you have used VS Code but it has quickly become my favorite editor. Being cross platform is a huge draw for me since I can utilize it on my macbook and my windows desktop.
It has a lot of utility for multiple languages, for example I have b...
Checking Database Log Files from Powershell
A while back I had written a post about ahow to check your VLF count for each database on a sql server.
It's all well and good to run this script via ssms, however it does give us some limitations in terms of scripting, and you have to use SSMS. Whi...
Web Scraping with Powershell
Web scraping is about as fun as the name implies. You're scraping a web page to get data that you want to do something with. It's painful, time consuming and sometimes a requirement.
When Invoke-RestMethod can't work becuase a site does not provide a public API, y...
How to check your Transaction Log VLF Count in SQL Server
You can probably throw a stone and hit an article about properly maintaining the transaction log.
In fact here are my favorites:
- A Busy/Accidental DBA’s Guide to Managing VLFs
- Transaction Log VLFs – too many or too few?
- 8 Steps to...
How To Find Query Plans for a Stored Procedure in SQL Server
I got tired of trying to find my script to check this, or search through the monitoring tool that we use to find it. I wanted a lightweight tool that I could use to get that one stored procedure that I was being asked to look into.