This came up one day at my work when a developer was using it. I hadn’t used it before and thought I’d better check it out. It’s off by default in SQL server, but why would you use it? TL;DR Setting XACT_ABORT ON is a…
I thought I didn’t care about linting, and lately, I haven’t written a lot of SQL, but for the SQL I do write, I have SQLFluff to help me format it. A friend of mine is big into SQLFluff and finally talked me into installing…
This may or may not be helpful in the long term, but since I’m doing it to be super cautious, I figured I would blog about it. We migrated to Flex last week, and to be abundantly cautious, we’re putting the last single server backup…
Thank you to Deborah Melkin for hosting TSQL Tuesday this month! I’ve always considered mentoring and sponsorship very structured. Now, I wonder if they’re also small things we do for one another. In the past, I thought mentoring was one-on-one meetings with another person to…
Commenting out code is quick and easy with a keyboard shortcut: Win + / on Windows or Command + / on Mac. You can place your cursor anywhere on the line that you want to comment out, or you can select multiple lines to comment…
This is more complicated than using the Azure Migration method, but because it’s maxed out on resources for the last week in the east regions (and possibly central), and who knows when they will fix it, I had to resort to other methods. I’m getting…
I’ve covered how to create Elastic Jobs in the portal (this one is important to read if you aren’t familiar with elastic jobs already), with Terraform, and with Bicep. Now, I’ll cover how to create them and their associated objects with PowerShell. Don’t do this…
I keep losing track of this wondering where it went. You have to access it at the database level. Adding this post to remind me for later. This came in very handy when my home internet went down and I couldn’t auth on my phone…
Let me start by saying that there are some issues with these scripts. They aren’t deal breakers, but I will loop back after my migrations to fix them—hopefully. You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles are granted to…
It’s easy to do with this query. That’s all I have to say on this topic for now.