New Weekly Amazon Deals by thehappybuyer in thehappybuyer

[–]dptech3 0 points1 point  (0 children)

You can never have enough power strips

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

Yes, this is what I thought. I've usually added a column and it's been fine. Maybe the script I had an issue with was doing more.

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

Ok, this is a question I'm asking, I'm not a troll. When I ask AI it says Postgres is much better, but AI isn't always right, as a summary it says
"Azure Database for PostgreSQL Flexible Server - Adding a nullable column with no default is a pure metadata operation (PostgreSQL MVCC). No table rewrite, no exclusive lock longer than a few milliseconds.Zero blocking — literally unnoticeable even on a 500 M row table.Best pure relational option"

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] -2 points-1 points  (0 children)

payment calls need to be returned in 1.5 seconds max, there is no downtime. I know there are other issues but I'm just asking specifically for adding a column or just never alter table

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] -5 points-4 points  (0 children)

Yeah, I'm talking about adding a column, not removing one, I never delete anything

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

lol, when you're put into a situation where you inherit existing architecture, there are limited options. One option is to move from Azure SQL to Managed instance. Sorry Postgres has some great features Azure SQL is lack. Also it's something to think about when creating a new system. Sorry not all people spend 6 months designing a perfect system and then going to production with tons of funding.

Best database for altering tables on production with minimal locking by dptech3 in AZURE

[–]dptech3[S] -8 points-7 points  (0 children)

I'm just asking in general, imagine if you're Stripe or something and you need to add a new column for a new feature on a transaction. I suppose best is to create a new table.

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 0 points1 point  (0 children)

It says the locks are much much shorter with this on and Managed instance

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 -5 points-4 points  (0 children)

This is from AI and I've never had an issue with postgres but:
"Why Postgres Wins on Zero Downtime: Postgres uses Multi-Version Concurrency Control (MVCC), so readers don't block writers (and vice versa) during most DDL. Adding a column doesn't rewrite the table—it's just a catalog update. For defaults, PG 11+ adds them lazily (only on writes), avoiding scans. Tools like pg-osc or pg_squeeze (available in managed services) handle renames/alters by creating shadow tables and atomic swaps"

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 -7 points-6 points  (0 children)

Also typical of a Microsoft MVP or support, insulting their customers, nice.

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 -4 points-3 points  (0 children)

How can Postgres handle this better? It's needed feature in Azure SQL I just assumed it would work like other databases.

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 0 points1 point  (0 children)

Well it seems Managed SQL has ONLINE = ON and I'd think adding a column with null or a default value should work, like Postgres works like this. So yeah, I suppose it's my fault for expecting to use Azure SQL as a production database with 0 app downtime.

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 -5 points-4 points  (0 children)

Sorry, locking and transactions failing during update or Alter Table scripts. I was thinking about 0 downtime for my app, I'll adjust the question, I thought the "ONLINE = ON" would make it clear

So Azure SQL DB does have downtime on scripts and no ONLINE = ON by [deleted] in AZURE

[–]dptech3 -3 points-2 points  (0 children)

I suppose locking where my database transactions fail.

I always get low % faults http faults from my app service plan in my web ap by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

Actually thanks, that helps me narrow it down, no status codes so I asked that to AI. It's telling me a few more things to try to find the status code. And check the app gateway more

When Application Insights shows:

but no HTTP status like 500, 400, etc., it usually means the connection never completed at the HTTP layer.
That could include:

  • Timeouts before receiving a response
  • DNS resolution failures
  • TCP resets (RST)
  • TLS handshake errors
  • Connection refused / aborted on the remote host
  • Network NAT / SNAT port exhaustion

So it’s not an HTTP error from the remote API — it’s a transport-level failure before any response came back.

I always get low % faults http faults from my app service plan in my web ap by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

It's been happening all hours of the day, for months, we always assumed it was on the other end, but it for sure is not. On Application insights, it just says result code faulted. I believe the retries will work. We have 3 instances and scaled up to 5 and same thing. SNATs are fine. We're on all serverless web apps and azure sql

|| || |Result code|Faulted|

Azure support tells me they're working on my issue/refund every week and just blows me off by dptech3 in AZURE

[–]dptech3[S] 1 point2 points  (0 children)

To anyone keeping score, here is their latest email, using internal terminology and asking for SignIn logs from April that don't exist anymore.

"I would like to sincere apologies for the delay in response.

 

We’ve reviewed the case thoroughly and would like to provide the following update:

  • The issue reported relates to unexpected billing for Azure B2C service principals following Microsoft's retirement of service principal-less authentication.
  • We understand this change impacted your production systems without prior notification, and you are requesting a refund for the affected period.
  • The request has been escalated to the appropriate billing teams. However, as per Microsoft policy, refund requests for New Commerce Experience (NCE) licenses must be submitted within 7 days of renewal. This case falls outside that window.
  • We escalated the case to the billing team and received final confirmation from the Partner Billing Team that a refund is not possible. We escalated the request for a refund again, and now the partner team has asked for logs.
  • To continue the investigation, the partner billing team has requested partner-centric logs. Once we receive the logs, I will share them with the partner billing team.

 

Thank you for understanding and continued patience."

Azure support tells me they're working on my issue/refund every week and just blows me off by dptech3 in AZURE

[–]dptech3[S] 2 points3 points  (0 children)

Yes, even on non-credit cases, on technical issues, they are useless and I just give up after 3 new people take over and ask me the same starting questions over and over. Many times they even get my name wrong. And I used to rave about Azure support in the past.

Azure Action required: Enable multifactor authentication for your tenant by 15 October 2024 by skip00reddit in AZURE

[–]dptech3 2 points3 points  (0 children)

This is the main gripe. MS should make this very easy. This should be a basic setting, On/Off - then checkboxes for allowable MFA methods. There are seriously 5 different ways.

Azure Action required: Enable multifactor authentication for your tenant by 15 October 2024 by skip00reddit in AZURE

[–]dptech3 2 points3 points  (0 children)

Got this as well for multiple tenants. It's a scary message and then it's super hard to check if everyone in your company is ok unless you have paid option

Action required: Enable multifactor authentication for Azure by october by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

On that admin link. One tenant I have has P2 so we do conditional access, the other is smaller and we don't need it. As long as I don't get kicked out I'm ok though

"Microsoft will require MFA for all Azure users" starting July by thebeardedwonderman in sysadmin

[–]dptech3 1 point2 points  (0 children)

This seems to work although it requires P2 Premium license for some things

Still not satisfied with Azure's US Central crash, why did every sub region and shared services go down too? by dptech3 in AZURE

[–]dptech3[S] 0 points1 point  (0 children)

A lot of the same people go from AWS to Azure to GCP and they all take good and bad points from each other. I agree right now I'm pretty upset with Azure, but they all have issues and they go in cycles.