New answers tagged

1 vote
Accepted

Can't see table partitions after adding PK

problems When you create a clustered primary key on a heap, it transforms the original heap table that you created, by logically ordering the previously unordered structure by the key column(s) you've ...
Erik Darling's user avatar
  • 40.6k
0 votes

How automate backup and restore in Azure SQL Managed Instance?

You can use an SQL Agent Job to backup and restore a database from a storage account, you just need to create a credential in advance: SELECT * FROM sys.credentials; CREATE CREDENTIAL [https://...
Dragos Miron's user avatar
0 votes

Economical options for long term storage of MS SQL Reporting Data (Currently in Azure SQL)

If it's just for reporting you might consider Fabric Lakehouse/Warehouse. It's mostly SQL Server compatible, and storage only costs $0.023 per GB per month, compared to $0.115 per GB per month for ...
David Browne - Microsoft's user avatar
0 votes

Economical options for long term storage of MS SQL Reporting Data (Currently in Azure SQL)

You can look into a General Purpose Azure SQL Managed Instance, which supports up to 8TB of storage for a minimum of 8 vCores (approx. 2500$/ month), or 16TB of storage for a minimum of 16 vCores (...
Dragos Miron's user avatar
0 votes

Downgrade SQL of a managed instance

With any of the flavors of Azure SQL Database(Managed Instance, DTU-model, vCore, Hyperscale) you cannot disable automatic updates, Azure SQL will always run the latest version and latest cumulative ...
Alberto Morillo's user avatar

Top 50 recent answers are included