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)
Author: Protiguous
C# Software Developer, SQL Server DBA, Father, and seeker of Truth.
Faith in God and Science
I’ve tried to say this before, so please be patient with me: Faith in God and Science are not mutually exclusive concepts. Science, as of yet, cannot prove or disprove the existence of any godlike creature. Personally, I don’t believe there is an all-knowing white guy sitting on a throne demanding to be worshiped. What… Continue reading Faith in God and Science
Bits o’ Good
How to create unsigned data types in SQL Server
Script to create unsigned data types in SQL Server.
List Cached Data Per Object in Memory
Personal Growth: Believe it.. or not?
Don’t just accept your beliefs.. Challenge them! Protiguous, 2021
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
My Main Rules For Life
Don’t Lie. Be Kind. Not Yours? Don’t Touch. Always Learn. Leave things better than you found them. These pretty much cover every action I take (or don’t take). I know they’re not “Earth Shattering” or “Complex“. But I believe in their simplicity and earnestness, and I hope that by sharing them I can bring some… Continue reading My Main Rules For Life
A Visual Explanation of Joins
100% Confidence
Oh, to have the confidence of a moron! Protiguous 2021
