Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [azure-sql]

Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as

  • Relational data
  • JSON
  • Spatial
  • XML

SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

Ask any question related to Azure SQL and read more at https://docs.microsoft.com/en-us/azure/sql-database/

92 questions
1
vote
2 answers

How to accomodate very large SQL database in Azure?

I have a database with a growth of more than 100 Gb per week, and 5 TB yearly. Since this is financial data, we can't purge it. If we keep this data for at least 10 years, size will become 50 TB. Please suggest how we can accomodate this amount of…
user397401
  • 11
  • 2
1
vote
1 answer

What cross-subscription communication & connectivity is possible in Azure?

I work in a large distributed org, and several divisions have purchased their own subscription to Azure. I am a co-administrator to all the accounts, and can see all the resources in all subscriptions. Is there a per-resource description of what…
makerofthings7
  • 8,821
  • 28
  • 115
  • 196
1
vote
1 answer

Move SQL 2008 database to Azure

I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file. Trying to use Tasks --> Export data-tier application from this…
Andreas
  • 299
  • 1
  • 5
  • 15
1
vote
0 answers

Azure VPN cannot connect to sql server

We have setup our VPN connection in Azure to our on-premises database, the connect is working with no problems. I have written a MVC app that tries to connect to our on-premise database in SQL Server and am getting the following…
user142617
  • 111
  • 2
1
vote
1 answer

Azure SQL bacpac Restore Over Existing Database

I want to restore a bacpac file over an existing Azure SQL database using PowerShell. Past with experience with restoring bacpac files in Azure requires creating a new database altogether when restoring the bacpac file. I'm looking to avoid that and…
jrd1989
  • 628
  • 10
  • 35
1
vote
1 answer

ARM Template - Azure SQL Database Diagnostics & Log Analytics Workspace

Using an ARM Template I want to enable diagnostics settings for my Azure SQL Database and have that data stored in a Log Analytics workspace I created. I want to enable the errors, timeouts, blocks and wait statistics logs and the basic metric…
jrd1989
  • 628
  • 10
  • 35
1
vote
1 answer

My Azure Data Factory Linked Service can't see my SQL Managed instance

We're using Azure Data Factory and have an Azure hosted Integration Runtime as well as a SQL Managed instance where our databases live. I'm having trouble getting a data set from our Managed Instance - when I configure the Linked Service, I'm…
R2Bleep2
  • 29
  • 6
1
vote
0 answers

How to set up firewall rules for hosted Azure SQL cross database query using external tables

I have a hosted Azure SQL Server instance with an elastic pool that contains multiple databases. I want to do a cross database query between two of those databases. I understand that the only way to do this is with External tables (rather than…
Andrew Marshall
  • 11
  • 1
1
vote
1 answer

Can't identify where SQL backups are being initiated from

A little background on my skill: I am new to running SQL on Azure and, although I've done a bit of development on SQL Server, I would still consider myself a novice with SQL Server as well. We recently deployed a Windows VM in Azure that is running…
Chris76786777
  • 969
  • 4
  • 20
  • 35
1
vote
0 answers

Azure SQL PIM like access

We are implementing PIM across our Azure setup and whilst it works well I cannot see a way to restrict access to the SQL databases in a way that allows a user to request elevation to access the database. I was thinking we could use the "Active…
mattb
  • 115
  • 3
0
votes
1 answer

Can you remove SQL Server from an Azure SQL VM?

I am migrating our SQL Server (Web 2017) instance our of our Azure VM (Windows Server 2019) into Azure SQL. After this I obviously do not want to be paying for SQL Server on the VM any more. The VM also acts as a web server so I would prefer not to…
Ben
  • 113
  • 5
0
votes
1 answer

Azure SQL Watchdog for Analytics

unsure if the right place for my question. In the Azure portal there are many tools for Analytics and Monitoring; however they all seem to be for server related metrics such as CPU usage, query times, etc. I'm looking to write my own queries that…
gompertz
  • 113
  • 1
  • 4
0
votes
1 answer

Azure CLI list Azure SQL Server DB backups

I'm trying to make an automated script that restores from the latest LTR backup of an Azure SQL server database. Using this command: az sql db restore --dest-name $newdbname --name $dbname--resource-group $resourcegroup --server $servername In docs…
robliv
  • 101
  • 1
0
votes
1 answer

Azure Monitor Metrics

About 4 weeks ago we had a development SQL database on azure and it was great as we could see the CPU and other information. After doing what we needed to do to make our database work with Azure, we created a new resource group, and SQL database…
Rodney Ellis
  • 101
  • 2
0
votes
2 answers

TDE vs Disk Encryption

We are a small business that host applications and data for clients. Some of our clients are requesting we protect their data with 'encryption at rest' - although it's never very clear if they know what this really means. The data is currently on an…
userSteve
  • 1,503
  • 4
  • 20
  • 32
1 2
3
4 5 6 7