How to save some Emergency Drive Space for SQL Server (or other Servers)

Photo by Pixabay on Pexels.com

Running out of disk space on a SQL Server server is something that you should never allow to happen, but it can happen. If you need to be the emergency Fireman putting out the fire, here is a way to “reserve” some drive space ahead of time. It is literally a dummy file that you… Continue reading How to save some Emergency Drive Space for SQL Server (or other Servers)

How to update and query an SQL Queue table with multiple consumers

First, create the test table and populate it with some data. The data itself isn’t too important; we just want a table that will be updated while also concurrently be queried and then deleted. Now open a second tab and paste this next query. This one will make random changes to the queue table every… Continue reading How to update and query an SQL Queue table with multiple consumers