New answers tagged azure-sql-database
0
votes
Restore a .bak in azure managed Database SQL
Before you have to download the DMA Tool and check if that database is compatible with Azure SQL Database.
Run the DMA Tool against the SQL Server on prem.
- 1,353
1
vote
merge or delete then insert or delete then append when the database is unstable
Besides what Erik said, which is excellent advice because MERGE can be both inefficient and buggy, here's some answers to your other questions:
What if the delete is successful and insert failed due ...
- 30.6k
3
votes
merge or delete then insert or delete then append when the database is unstable
This answer is to dissuade you from using merge. It’s like throwing SQL Server an awful knuckleball and requires a lot of special care and handling to use correctly.
Use Caution with SQL Server's ...
- 36.7k
0
votes
SQLPackage : Import or Export SQL Azure BACPAC without users
I was having a similar problem, but I coudn't find a way to generate the .bacpac without users, there is a workarround if you need the copy in the same suscription, the Microsoft Suport Team guide us ...
0
votes
How can I limit storage space taken up by `wpr_bucket_table`?
You've identified that the wpr_bucket_table is not documented, which means it likely was created by something connecting to the database, not SQL Server itself.
If this is a test db just delete the ...
- 68.5k
-1
votes
multiple percentile_cont with where clause
Try to move from percentile_cont to APPROX_PERCENTILE_CONT
In this example it pushed the speed from ~13 seconds to ~1.5 seconds.
- 1,353
2
votes
Accepted
Will Azure SQL still charge if I don't consume all DTUs that I have allocated?
Answer is Yes.
If you want different behavior, consider using Serverless pricing model:
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=...
- 5,144
0
votes
Bacpac Import fails with error 'The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation'
If you don't want to upgrade/install anything.
Just copy .bacpac file to your Azure storage and try Import Database option available in Azure Portal:
- 1
2
votes
How to update all tables in specific schema in dev database from prod database in sql server?
The SQL Server Import and Export Wizard in SSMS is old at this point, and can be a pain. There's a multitude of ways to copy data between databases but I'll mention the simplest of the two below:
...
- 30.6k
0
votes
Azure SQL Database Sync Login Issue
I ended up having to turn off AAD Auth only and it worked.
0
votes
Get the size of all Azure SQL Databases
I ended up patching a few bits of PowerShell together from various sources. It was pretty slow running, but did the job.
#Connect-AzAccount
#$OutData = @()
$IgnoreDB = @('master', 'SSISDB')
$Subs = @...
- 1,414
Top 50 recent answers are included