A PowerShell script to backup your VSCode settings and extension list to remote storage.
Continue reading Backup Visual Studio Code Settings and Extension List
A list of useful extensions for Visual Studio Code that I’ve found improved how I write code.
Continue reading Useful Visual Studio Code Extensions
After reading a request posted on a programming Discord channel for a way to make a repeated if/else chain cleaner, here is my attempt.
Continue reading Coding Challenge – Reduce “If/Else” Chain
Here is a combination of browser addons that will make YouTube better – automatically picking the highest resolution, and making the video fill your screen.
Continue reading How To Make YouTube Better!
PowerShell script to monitor a specified list of services, attempt to start them if they’re not running, and send you an email if the service won’t start.
Continue reading PowerShell script to monitor service status.
SQL Server likes to log things!
Over time this causes the system databases to grow unnecessarily, and potentially make searching for the log you want slower.
Keep things trimmed and tidy, to make it quicker and easier to find things when you actually need them!
Continue reading Are you keeping your system databases tidy?
Stored procedure to run a SQL Server profile for X minutes, save the trace file and zip it up, and delete old zip files.
Continue reading SP to Run SQL Profile for X Minutes, Zip Trace File, Delete Old Files
Typically with a table in SQL Server if you want to enable compression, you’d have to duplicate the table and have downtime while you get the 2 tables in sync and swap them over. Using computed columns, you can compress a table with no downtime, and without requiring any extra database or disk space.
Continue reading Enabling Compression on a Large SQL Server Table With Zero Downtime
If you have a large number of SQL Server instances with numerical server names, use this script to add a schedule to a job on all the servers that staggers when the job runs.
Continue reading Stagger SQL Server job across multiple servers
If you’ve converted a table in SQL Server to an in memory table with durability turned on, and noticed that the files on disk keep filling your drive up, then it’s time to patch SQL Server Continue reading SQL Server 2016 Memory Optimised Table: High Disk Usage
For SQL Server, the allocation unit size for the drives storing your data files is very important. This script will output the allocation size for each drive on your server. Continue reading Check Disk Drive Allocation Unit Size
While Windows 10 makes it very easy to create a VPN and connect to it, it doesn’t seem particularly stable, and won’t auto reconnect if it does drop out. This PowerShell script will keep your VPN alive. Continue reading Windows VPN Keep Alive