A PowerShell script to backup your VSCode settings and extension list to remote storage.
Continue reading Backup Visual Studio Code Settings and Extension List
Useful Visual Studio Code Extensions
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
Coding Challenge – Reduce “If/Else” Chain
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
How To Make YouTube Better!
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 service status.
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.
Are you keeping your system databases tidy?
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?
SP to Run SQL Profile for X Minutes, Zip Trace File, Delete Old Files
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
Enabling Compression on a Large SQL Server Table With Zero Downtime
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
Stagger SQL Server job across multiple servers
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
SQL Server 2016 Memory Optimised Table: High Disk Usage
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
Check Disk Drive Allocation Unit Size
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
Windows VPN Keep Alive
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