Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
1
vote
1 answer

Where are my Azure SQL Backups (geographically)?

I have a number of Azure SQL databases, all getting backed up both Point-in-Time and Long-term_Retention. All works fine. After assuring my client that these are backed up extremely well and come with Microsoft's read-access geo-redundant storage…
PaulTheCyclist
  • 1,227
  • 10
  • 10
1
vote
2 answers

Polybase: Azure Sql DB cannot import blob storage

Is it true that Azure SQL cannot import blob storage? (SQLDW can and also stand alone instance) as given in this document, it cannot. But the document is from 2018. Has things changed after that?
Blue Clouds
  • 7,295
  • 4
  • 71
  • 112
1
vote
0 answers

Azure SQL scale(vertical) only one shard(from horizontal scaling/partitioning)

Can I scale vertical(add CPU or RAM) only one particular shard(shard = horizontal partitioning/scaling) ? I know that whatever partition logic I`ll use, there is a high chance that one shard will be very big(I know you can re-partition using…
Pacurar Stefan
  • 235
  • 4
  • 9
1
vote
1 answer

Not able to connect to Azure database for MySQL server from databricks cluster using jdbc and spark connector

I am trying to connect to Azure database for MySQL server using databricks clusters. I tried using 2 ways described below- using jdbc val jdbcHostname = ".mysql.database.azure.com" val jdbcPort = 3306 val jdbcDatabase = "" val…
Sonali Sharma
  • 23
  • 5
1
vote
1 answer

Import bacpac file into local SQL Server

I'm able to restore a database from a .bacpac file using SqlPackage.exe import functionality. However is there a way to achieve the same functionality using SQL command? sqlpackage.exe /a:Import Thanks in advance.
Sandeep Reddy Pinniti
  • 371
  • 1
  • 4
  • 6
1
vote
1 answer

How to connect azure analysis services with azure sql db for 250GB table size data?

we have a view which generated around 250GB data and connected with power bi but the performance is bad. Now we are thinking to connect this view via azure analysis services and connect with power bi. But when i see the pricing tiers there is no…
Pradeep Kaja
  • 115
  • 1
  • 16
1
vote
1 answer

What is Azure SQL Database automatically grows rates

On a normal SQL server we can tell it how to grow.  The default is 10% each time, so the database grows by 10% its current size. Do we have any insight on how the Azure SQL database is growing other than it grows automatically? Azure SQL server…
Sakaldeep Yadav
  • 392
  • 1
  • 6
  • 20
1
vote
1 answer

Create Azure SQL Server VM including backup

I'm trying to deploy a SQL Server VM via ARM template and set backup in the same template. I've managed to set up the VM and added the VM to backup but not the databases. I've tried to use some of the quickstart templates on Github, but I don't find…
Santa
  • 71
  • 7
1
vote
1 answer

Is Azure table storage data retrieval faster than Sql Azure

There is a requirement to store data (xml data) in some storage. As it is mentioned it stores large XML data, each record (row) size nearly 1MB. The doubt is which storage we are going to use to store the data means Azure Table storage (Storage…
Manas Kumar
  • 2,411
  • 3
  • 16
  • 23
1
vote
0 answers

Azure SQL DB throwing "This operation requires a connection to the 'master' database"

I have an ASP.NET MVC application migrated to Azure. Mostly it's running fine but in some pages following error is thrown and hence no data is fetched: This operation requires a connection to the 'master' database. Unable to create a connection…
Hafsa Khan
  • 25
  • 5
1
vote
1 answer

Recommended practices for the amount of rows you can have in an Azure Database

Is there any guidelines or practices around how much a SQL Database can handle? If you have a single table with following columns: Id, int Update, bit Status, nvarchar(256) Path, nvarchar(256) Category1, nvarchar(256) Category2, nvarchar(256) All…
Thomas Segato
  • 4,567
  • 11
  • 55
  • 104
1
vote
2 answers

How to check if an Azure Sql Server server principal (Login) already exists

I'm using ARM templates to instantiate a new Sql Server resource on Azure and, as part of the setup, I need to create a few user logins. It seems that ARM templates do not offer the options to create new user principals therefore I'm considering…
simoneL
  • 602
  • 1
  • 7
  • 23
1
vote
1 answer

How to get session history in Azure sql server?

Someone deleted my azure database tables and procedures. Now I want to know from which workstation/ip this has happened.The person used db owner Id. Azure portal activity logs don't give any details as deletion is done through sql queries. I know…
Shipra Trivedi
  • 129
  • 10
1
vote
2 answers

How do Jobs in Azure Sql Server Databse?

I'm trying to create jobs in Azure Sql Database but I don't know how to do that. Is It possible do them inside de Sql Server Management Studio?
jnoguerm
  • 147
  • 1
  • 1
  • 15
1
vote
2 answers

Failed to execute query. Error: Execution Timeout Expired

Azure SQL query timeout It happened days ago and lasted for hours, today it happened again. Seems the error occurs when I try to execute query like "select * from table" or "select name from table where time<.....", which scans the whole table. But…
Chen
  • 171
  • 3
  • 14
1 2 3
…
36 37