sql for everyone
We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some general info about elastic pools and setting them up. Main points about elastic pools All the…
Last year, I submitted and was accepted to present at the EightKB conference. At first, I thought my current presentation wasn’t advanced enough, but Tracy Boggiano convinced me otherwise. Why did I think my presentation wasn’t advanced enough? I don’t really know. I assumed it…
I had no idea what to do, so I Googled it Found this link below and tried the repair thing as the settings were in the config file as expected: https://dba.stackexchange.com/questions/269450/warning-mysqli-real-connect-hy000-2002-connection-refused-in-var-www-htm But then suddenly, my config file contents became my homepage contents! Including my database…
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…
Building a Terraform module for Azure SQL DB is like packaging your infrastructure magic into a reusable box. It’s the kind of thing that makes your IT life smoother. This approach tidies up your setup, making it easy to manage and reuse across different projects.…
According to Rod Trent, Kusto is named after Jacques Cousteau. He says, “We are exploring the depths of our data” by searching and querying our Azure log data. His book is a great introduction and is helpful even if you’ve been using Kusto Query Language…