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...

Continue Reading...

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...

Continue Reading...

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...

Continue Reading...

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:

Continue Reading...

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.

Ei...

Continue Reading...