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)
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
Run these commands on the Windows Server to open the ports for listening on a named instance of SQL Server.Note: Remember to enable TCP in the SQL Server Configuration Manager. For more help, refer to SQL Server & Windows Firewall.