As the forum does funny things with url's lookup schackenberg Upgrading to SQL Server 2022: Paths, Pitfalls, and Best Practices

Assuming this happens in a non-production environment first.

I don't think the...

Installer: install the busisness intelligence

and also check out the individual components like SSIS components

Some items were added later

Thanks for sharing your experience about downgrading.

I don't think there is one. It will be safe to post in the 2022 forum's as long you mention SQL 2025.

Internet landscape changed. Not really sure if we will...

It's a regular firewall config to allow access from outside.

This forum is funny with links so search for "Configure the Windows Firewall to allow SQL Server access" an ms learn...

Also interested as my data analyst considers parquet files as datasource for the datawarehouse using python / duckdb

Happy 250th anniversary

I don't think this can be done with gpo's like only for ssms . That's more for logon triggers or the network team

It will take, but US software won't be evident anymore due the recent geopolitics. Maybe for new projects one will look to Opensource / Europe for Business Continuity

Migrating the current...

You can have different kinds of SQL Server in Azure ( forum doesn't like links anymore, you can look up the different flavors)

Azure SQL Database (SAAS): no extra sql server...

Stan, they can absolutely trash sql using another sql client like excel powerquery. If they are using SSMS/other client, you can see the application context (if they didn't modify it)...

Code deployments are usually live. We still have shutdowns when windows updates need to be installed

We have some trusted users who work with SSMS, otherwise they would flood the server creating reports without a way of canceling it.

Most of them prefer using excel powerquery for...

After some user complaints we got to upgrade the hardware where the reporting database server runs on, notorious for heavy cpu usage.

Going from 2019 hardware to 2025 gave us a...

It's gonna take time to adjust, same prompt different answer.

As you said, determinism isn't always required when good is good enough. like approx_count_distinct or eventual consistency