Cody Konior
@codykonior.bsky.social
Expert at scaling SQL Server and PowerShell. Happily married with 4 cat children 😻
Twitter is down. Hi again 🤣
November 18, 2025 at 12:08 PM
Twitter is down. Hi again 🤣
@markwitton.bsky.social Hi can I ask about King Tyrant. Is there anything in there about Nanotyrannus?
Thanks.
Thanks.
November 8, 2025 at 12:45 PM
@markwitton.bsky.social Hi can I ask about King Tyrant. Is there anything in there about Nanotyrannus?
Thanks.
Thanks.
September 23, 2025 at 4:55 AM
August 20, 2025 at 3:56 AM
It’s sad that Azure SQL Database resource locks are completely bypassed by a T-SQL DROP DATABASE.
July 15, 2025 at 1:13 PM
It’s sad that Azure SQL Database resource locks are completely bypassed by a T-SQL DROP DATABASE.
July 15, 2025 at 1:12 PM
July 7, 2025 at 2:00 AM
It’s a bit of an old programmers joke but I do actually spend a lot of the day waiting for things to compile or deploy these days 😅
June 24, 2025 at 5:04 AM
It’s a bit of an old programmers joke but I do actually spend a lot of the day waiting for things to compile or deploy these days 😅
If a logging process goes crazy and starts spinning up sessions dumping into a table, you could disable the user temporarily waiting for the other side to die, or add an instead of insert trigger for a little while that just does a return 😛
June 16, 2025 at 2:15 AM
If a logging process goes crazy and starts spinning up sessions dumping into a table, you could disable the user temporarily waiting for the other side to die, or add an instead of insert trigger for a little while that just does a return 😛
TIL if you have an empty folder you want to keep in git (so you don’t need to test and recreate it in every script that touches it) the convention is to use an empty .gitkeep file in there.
May 26, 2025 at 4:15 AM
TIL if you have an empty folder you want to keep in git (so you don’t need to test and recreate it in every script that touches it) the convention is to use an empty .gitkeep file in there.
I had resorted to doing all users in a post-script in SSDT but it turns out you can add a publish flag that lets you create the users but not deploy the fake logins you define for them.
That stuff is important when you want to drop all users not defined in your project.
That stuff is important when you want to drop all users not defined in your project.
May 24, 2025 at 11:54 AM
I had resorted to doing all users in a post-script in SSDT but it turns out you can add a publish flag that lets you create the users but not deploy the fake logins you define for them.
That stuff is important when you want to drop all users not defined in your project.
That stuff is important when you want to drop all users not defined in your project.
If you’re using the JSON data type in Azure SQL Database they pushed a change for GA which has broken it.
Good luck.
Good luck.
May 20, 2025 at 2:42 AM
If you’re using the JSON data type in Azure SQL Database they pushed a change for GA which has broken it.
Good luck.
Good luck.
If you open SQL Prompt and the dropdown menu only has 3 items on it (about, check version, something else), it means it has lost its license information.
Don’t bother messing with the folders or reinstalling. Click the about and it’ll log you back in to authenticate 🤦♂️
Shame it doesn’t tell you!
Don’t bother messing with the folders or reinstalling. Click the about and it’ll log you back in to authenticate 🤦♂️
Shame it doesn’t tell you!
May 19, 2025 at 2:25 AM
If you open SQL Prompt and the dropdown menu only has 3 items on it (about, check version, something else), it means it has lost its license information.
Don’t bother messing with the folders or reinstalling. Click the about and it’ll log you back in to authenticate 🤦♂️
Shame it doesn’t tell you!
Don’t bother messing with the folders or reinstalling. Click the about and it’ll log you back in to authenticate 🤦♂️
Shame it doesn’t tell you!
Some are just born with that rizz #sqlcatfamily
May 11, 2025 at 12:31 PM
Some are just born with that rizz #sqlcatfamily
I think I found a weird optimiser error in Azure SQL Database.
You can do a SUBSTRING CHARINDEX CHARINDEX with valid values and it’ll barf with a length error even though it’s 100% valid.
If you add a WHERE clause with that CHARINDEX > 0 to act as a filter, it works even though it’s not NULL/0/-.
You can do a SUBSTRING CHARINDEX CHARINDEX with valid values and it’ll barf with a length error even though it’s 100% valid.
If you add a WHERE clause with that CHARINDEX > 0 to act as a filter, it works even though it’s not NULL/0/-.
May 6, 2025 at 4:35 PM
I think I found a weird optimiser error in Azure SQL Database.
You can do a SUBSTRING CHARINDEX CHARINDEX with valid values and it’ll barf with a length error even though it’s 100% valid.
If you add a WHERE clause with that CHARINDEX > 0 to act as a filter, it works even though it’s not NULL/0/-.
You can do a SUBSTRING CHARINDEX CHARINDEX with valid values and it’ll barf with a length error even though it’s 100% valid.
If you add a WHERE clause with that CHARINDEX > 0 to act as a filter, it works even though it’s not NULL/0/-.
Small reminder that changing elastic pools on an azure sql database is fine but can kill any active connections so like maybe don’t do it when that’s important.
May 6, 2025 at 6:40 AM
Small reminder that changing elastic pools on an azure sql database is fine but can kill any active connections so like maybe don’t do it when that’s important.
Be careful trusting Set-AzSqlServer to enable or disable identity types of SystemAssigned/None.
Shit doesn’t work. Only the portal works. What a fucking piece of shit. No error or anything either.
Shit doesn’t work. Only the portal works. What a fucking piece of shit. No error or anything either.
April 30, 2025 at 5:40 AM
Be careful trusting Set-AzSqlServer to enable or disable identity types of SystemAssigned/None.
Shit doesn’t work. Only the portal works. What a fucking piece of shit. No error or anything either.
Shit doesn’t work. Only the portal works. What a fucking piece of shit. No error or anything either.
Reminder that putting an identity value on a SQL table doesn’t make it a clustered index automatically 🤭 It’s still a heap.
April 24, 2025 at 7:08 AM
Reminder that putting an identity value on a SQL table doesn’t make it a clustered index automatically 🤭 It’s still a heap.
If you have access to Azure SQL firewall rules, you can create one that, when deleted, deletes your server.
www.varonis.com/blog/malicio...
www.varonis.com/blog/malicio...
Burning Data with Malicious Firewall Rules in Azure SQL Server
Exploiting a security gap in firewall rule-naming can suddenly delete entire servers and targeted assets when combined with admin actions.
www.varonis.com
April 16, 2025 at 5:25 AM
If you have access to Azure SQL firewall rules, you can create one that, when deleted, deletes your server.
www.varonis.com/blog/malicio...
www.varonis.com/blog/malicio...
I’m putting a 100% tariff on SQL Elastic Jobs.
You know how you can tie a job to databases in an elastic pool?
Well if one of those steps fails but is between retries, you can move the database to another pool and that step will still retry and complete.
But tomorrow it won’t because wrong pool.
You know how you can tie a job to databases in an elastic pool?
Well if one of those steps fails but is between retries, you can move the database to another pool and that step will still retry and complete.
But tomorrow it won’t because wrong pool.
April 11, 2025 at 1:49 AM
I’m putting a 100% tariff on SQL Elastic Jobs.
You know how you can tie a job to databases in an elastic pool?
Well if one of those steps fails but is between retries, you can move the database to another pool and that step will still retry and complete.
But tomorrow it won’t because wrong pool.
You know how you can tie a job to databases in an elastic pool?
Well if one of those steps fails but is between retries, you can move the database to another pool and that step will still retry and complete.
But tomorrow it won’t because wrong pool.
It bothers me when I look at an online store and get an automated email, “Hey, we noticed you checking out the store, did you want XYZ item?”
Yeah? Did you notice me looking at your products and they’re all out of stock in my size, which is Medium?
The lack of data analysis everywhere sucks.
Yeah? Did you notice me looking at your products and they’re all out of stock in my size, which is Medium?
The lack of data analysis everywhere sucks.
April 6, 2025 at 11:42 AM
It bothers me when I look at an online store and get an automated email, “Hey, we noticed you checking out the store, did you want XYZ item?”
Yeah? Did you notice me looking at your products and they’re all out of stock in my size, which is Medium?
The lack of data analysis everywhere sucks.
Yeah? Did you notice me looking at your products and they’re all out of stock in my size, which is Medium?
The lack of data analysis everywhere sucks.
I always wanted to be the Raul Julia version of Gomez Addams in life.
April 4, 2025 at 12:50 PM
I always wanted to be the Raul Julia version of Gomez Addams in life.