sql for everyone
Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query SQL Server more efficiently to get health, log, or performance information. I will go through them here regarding using them in Azure SQL database since I don’t have any SQL Servers…
I have a Macbook Pro as my personal computer, and I needed to wipe out my Proxmox setup on my Nuc to install Windows instead. It’s a long story why, but it’s what I needed to do. This isn’t meant to be a detailed guide,…
Idea Generation I start with the spark of an idea, usually jotted onto paper. Mainly, it’s just a title at that point. It might be more conceptual or based on a problem I had at work. If I had a problem at work, I would…
I’m not sure where this came from, and I had it in drafts forever ago. I figured might as well publish it to the world so someone else can use these links. I can’t vouch for if they are still available or not. I don’t…
There are plenty of times I’m called upon to fix data. To do this, I must know what dependencies are in the database. Foreign keys are a crucial aspect of maintaining data integrity within relational databases. They establish relationships between tables, ensuring data references remain…