Questions tagged [azure-sql-database-v11]

The original version of Azure SQL Database.

4 questions
14
votes
2 answers

How do I get Brent Ozar's sp_BlitzIndex to run on Azure?

I downloaded the SQL Server First Aid Kit from Brent Ozar's website. When I tried to run the sp_BlitzIndex script against my master database via Microsoft Sql Server Management Studio while logged in as the Azure database server level admin and I…
Erik
  • 4,833
  • 4
  • 28
  • 57
1
vote
1 answer

Update large table with millions of rows in Azure SQL Server, in Parallel

We have a large ProductOrders table with many rows, and plan to update it. The table has range of ProductType Ids from 1-1000. Table has around 2 million rows, 15 columns. Common ProductOrders table: ProductOrderId, ProductId, ProductTypeid,…
0
votes
1 answer

Is there any way to recover lost table data on sql server without backups?

Unfortunately some tables are completely deleted with important data. The database is hosted on azure, but there is no back up for past 1 month as well. Is there any way I can get the lost data? The database is azure SQL v 11.
APALALA
  • 1
  • 1
-1
votes
1 answer

Not able to configure DataSync in azure sql

Trying to configure DataSync for Azure sql db with on premises SQLServer DB. Got this error.The sync database specified (sqlserver1\sql-syncmeta-prod-east-001) does not match the existing sync database (sqlserver2\sql-syncmeta-prod). Only one sync…
Vijaya
  • 69
  • 2
  • 10