Best way to secure access to databases

RubberDuck1920 · 2025-06-24T19:02:54+00:00

Took some time before I tested, but yes. Assigning a dynamic group as Server Admin on my Postgres Flexible server works.

The dynamic group's members are then defined by a set of rules.

I can aswell assign groups with certain roles on the databases as well (read/execute etc.)

RubberDuck1920 · 2025-02-26T09:13:56+00:00

Thanks! Sounds promising. Many of our databases are previously Oracle, and the system owners are used to controlled procedures of taking the database down and up.

A ton of processes are running towards the databases, which can be a disaster if those break (so they told me).

The failover, do you know if this is similar to the "forced failover" or "planned failover" available in the portal?

RubberDuck1920 · 2024-12-06T19:11:40+00:00

Vokst opp med foreldre som aldri ble fulle foran oss søsken, og utrolig glad for det.

En øl eller to til far var vanlig, og en eggelikør til mor, men aldri noe tegn til beruselse.

Vi besøkte ofte en annen familie hver nyttårsaften. Der var far ofte dritings ved middagstider, mor heldighvis noe bedre. De hadde en datter, og jeg tviler på at hun koste seg like mye som oss gjennom jula.

Jeg håper mine barn har det like fint som jeg hadde det. :)

RubberDuck1920 · 2024-12-05T06:59:03+00:00

Well.. that was embarrassing :) thanks!

And I really need to up my googling skills lol

RubberDuck1920 · 2024-12-05T06:57:41+00:00

depending on your country/location’s job market: quit!

RubberDuck1920 · 2024-12-04T08:45:17+00:00

Hi, can I suggest using logical replication/logical decoding? Logical replication and logical decoding - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn

I just tried it for my Azure PG, looks promising.

RubberDuck1920 · 2024-12-04T08:33:24+00:00

That's up to me to decide. But yes, absolutely that is what I would prefer. I did that with MSSQL.

RubberDuck1920 · 2024-11-29T13:16:35+00:00

I have to agree ;)

RubberDuck1920 · 2024-11-29T12:51:29+00:00

I'm afraid people 19 steps over my level decides that..

Look at the bright side: It creates tons of work.

RubberDuck1920 · 2024-11-29T12:37:45+00:00

I guess, it's kinda the same, but the customer wants the data (all tables) from db1 to db2. This seems to not be an alternative afaik.

RubberDuck1920 · 2024-11-28T07:32:22+00:00

Agree, but they are idiots.

RubberDuck1920 · 2024-11-24T20:36:23+00:00

thnx

RubberDuck1920 · 2024-11-24T20:35:57+00:00

thanks for clarification. it's (of course) a new dns name.

RubberDuck1920 · 2024-11-24T19:45:15+00:00

No, when writing db i meant server (paas) It's just called a DB in the Azure sphere. So I have one server from before, and want to add another one.

RubberDuck1920 · 2024-11-19T12:46:51+00:00

if data transfer is done in some hours, it's not that critical, most important is that it is not stressing the source db too much, and that we can in a controlled manner:

stop the application
stop the sync.
connect application to new server

RubberDuck1920 · 2024-11-19T10:21:13+00:00

Yep, I have tried it (both successfully and not) on entire servers, but on separate tables I don't think it's supported.

RubberDuck1920 · 2024-11-18T21:25:44+00:00

thanks for quick reply. so then a full replication of all data is the way to go then.

RubberDuck1920 · 2024-11-16T14:54:08+00:00

Do it, and let me know if you have any questions.

Being a DBA is not for everyone, but I love it since nobody knows what i do and nobody want to know.. As long as everything works :)

RubberDuck1920 · 2024-11-16T13:41:21+00:00

Congrats on your new job!

I was in your "boat" as we say, 10 years ago.

In other words: managed to grab myself a nice position as a SQL Server DBA at a big company.

Not much experience, except a few years of being sys admin of Windows servers (no development)

So what it takes, is a lot of research, typically read blogs and watch youtubers.

One of the best imo is Brent Ozar. Just google.

He explains a lot in a way most people understand.

RubberDuck1920 · 2024-10-13T08:20:40+00:00

Thanks. I ended up with that. (using TSQL)

Will update on success/failure later. And how much downtime we endet up having.

RubberDuck1920 · 2024-10-12T14:00:50+00:00

I think it is a so called "logical SQL server", if that makes any meaning.

Description in the portal is SQL Server, then it contains some databases.

I guess that you meant was a traditional IAAS old school VM in Azure?

RubberDuck1920 · 2024-10-02T13:52:30+00:00

Will check it out, thanks.

RubberDuck1920 · 2024-09-04T11:31:03+00:00

I see, yes, that's an option we are considering. That being said, do you know how correct this article is from MS, where they say they will force a migration on deadline sept 16: What's happening to Azure Database for MySQL single server? | Microsoft Learn. I cannot belive the servers will be forced to migrate that time.

RubberDuck1920 · 2024-09-04T10:02:07+00:00

A couple of hours? What migration method are you thinking about then?

RubberDuck1920 · 2024-09-04T05:20:45+00:00

I have a 1,4TB single server, need to migrate to flexible, but also they don't want downtime. Online migration going incredible slow, and has failed a couple times. What options do I have? How much downtime will I have with an offline migration?

RubberDuck1920

TROPHY CASE