Questions tagged [azure-sql-database]

Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

Database Backup/Restore exists in Azure Vs Traditional on-prem SQL Server database?

Just wondering if someone can fill me in on how Azure Native database works in terms of database backup and restore. I cannot see a way to have the DBA options to do a backup and restore using a GUI, ...
4
votes
1answer
2k views

Is it possible to use cross database queries in both Azure and SQL Server 2016?

I'm working on a project that is designed to run on Microsoft's Azure platform. At present we have a few developers working locally on their own machines with the intent of being able to publish the ...
0
votes
1answer
36 views

SqlPackage Import - How to chose vCore purchase model?

I read the following documentation. Properties specific to the Import action Looking at the switch description for DatabaseEdition, I do not see a choice for vCore Azure SQL Database purchase model. ...
0
votes
1answer
36 views

How can I prompt SQL server to use more suitable index in query?

I have a query that somtimes runs longer than the application calling it allows. I've traced it down a clustered index seek on rather larger table. I've created a new index, that better supports this ...
4
votes
3answers
2k views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
-1
votes
0answers
11 views

How can I set up a mysql server to perform nightly reads from Azure SQL using Active Directory?

I am setting up a mysql database as a local data warehouse. We are going to read data into it from a variety of data sources including an on-prem Azure SQL database, however at present in order (for ...
3
votes
2answers
165 views

Permission hierarchy vs. WITH GRANT OPTION

I have an Azure SQL database with this security setup: SchemaUpdater user with db_ddladmin, db_datawriter, and db_datareader roles. The user is used to execute database change scripts during ...
0
votes
1answer
117 views

Does Data Migration Advisor migrate system databases?

I would like to know if Data Migration Assistant copies system databases (master, model, msdb) into the new server.
1
vote
1answer
1k views

MySQL Workbench Unable to Connect to Azure Databases for MySQL

When trying to connect to a MySQL database in Azure I get the following error: ERROR 2026: SSL connection error: socket layer receive error At first I thought it was a firewall/security issue but ...
2
votes
2answers
80 views

Why there's unnecessary 2 index join of the same table?

I have a table named [Job] with 2 indexes as below. (Due to confidentiality, I can't post the whole execution plan with the exact name, sorry about that.) [IX_Job_WillTest] : (ColA ASC, ColB ASC) ...
0
votes
1answer
29 views

understanding Azure Sql Databse Billed VCores

trying to migrate from sql server on-prem to azure sql database and i cant understand Duration and CPU Used and Memory Used of Billed vCores
1
vote
1answer
363 views

What would cause an elastic pool to exhibit high "Sql Server process core percent" metricsj, but low DTU / CPU

Backstory: We have an azure sql elastic pool with several databases in it and around 750GB of data. We've been having some sporadic outages which correlate with the metric "Sql Server process ...
1
vote
1answer
116 views

Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?

I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of sp_set_session_context to make sure that any query only touches records relevant to the current tenant. I ...
0
votes
0answers
30 views

Error when replicating to Azure SQL Database

I've configured transactional replication between my on-prem SQL 2017 instance and an Azure SQL Database. The publisher, distributor, subscriber have all been set up. The snapshot agent has generated ...
0
votes
2answers
201 views

SqlPackage importing of very large bacpacs to Azure

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document. It says that there is a flag called DatabaseMaximumSize=(INT32). I wanted to know if there's a limit that ...
2
votes
1answer
41 views

Azure SQL Database - What is the setting for 'cost threshold for parallelism'

In SQL server the default setting for cost threshold for parallelism is 5. I know that this setting can't be modified in Azure SQL server (as mentioned here). My question is whether Azure SQL server ...
1
vote
1answer
321 views

Azure SQL Database SQL71562 error exporting to blob storage

I am attempting to export an Azure SQL Database on an elastic pool to blob storage via the portal Export selection from the target database. This errors with: One or more unsupported elements were ...
2
votes
2answers
412 views

Why does upsert result in a deadlock?

I'm doing the following upsert, that I run multiple times in a short timeframe: BEGIN TRANSACTION; INSERT AggregationMeasurement (ValueFloat, Date, AggregationConfigurationId) SELECT @ValueFloat, @...
0
votes
1answer
37 views

What The Equivalent Of Oracle Schema Isolation In AzureSQL And PostgreSQL?

The database choices for my new application are Azure SQL and PostgreSQL. It is SaaS and each client will need to be isolated from each other for security reasons. This has to be done at the ...
0
votes
2answers
54 views

How to resolve INSERT contention in Azure SQL Database?

I'm working with an Azure SQL Database that has a very hot logging table. Any time a row in any other table is inserted, updated, or deleted, the web application writes a row to this logging table. ...
1
vote
1answer
472 views

OPENJSON running once per row of an INNER JOIN unnecessarily?

I have a table MP_User with 147 entries, and in order to query it, I am passing in JSON containing an array of "query objects", each of which has a unique ID and either an email address or a ...
9
votes
3answers
340 views

Is it possible to use OPENROWSET to import fixed width UTF8 encoded files?

I have an example data file with following contents and saved with UTF8 encoding. oab~opqr öab~öpqr öab~öpqr The format of this file is fixed width with columns 1 to 3 each being allocated 1 ...
1
vote
1answer
25 views

Finding source query in execution plan of nested views and UDFs

I have a view containing N levels of nested views with UDFs and TVFs that I have to tune and my execution plan has 630+ nodes. I found the performance issue in the plan but I can't find the source ...
0
votes
0answers
64 views

Delay in prelogin response when connecting to Azure SQL

I have set up a linked server to an Azure SQL 2014 managed instance. The vendor gave me a SQL login and password to use. I can open a direct connection in SSMS and run queries. But when I try to run ...
1
vote
1answer
61 views

Isolation level with SQL Server and Azure Sql Database Read-Only replica

I read here and here that, when connecting to a Sql Server read-only replica, the isolation level used is ALWAYS SNAPSHOT. It says it ignores SET TRANSACTION ISOLATION LEVEL statement and any locking ...
0
votes
1answer
306 views

Restoring a managed SQL instance in Azure using PowerShell

I am trying to figure out how to restore a database from one managed SQL instance to another. I'm following the tutorials, but I keep running into inscrutable error messages. Here's my command: ...
0
votes
1answer
236 views

Azure SQL - is it possible to assign CREATE PROCEDURE permission for the master database?

I am trying to add a stored procedure to the master database (I deliberately am trying this for the master db) on Azure SQL. Is this possible? I suspect the answer is "no", but I'd like to ...
0
votes
1answer
106 views

Generate script for all stored procedures in Azure SQL database

I'm trying to create a SQL script that will create all the stored procedures that were exported from another database. Basically navigating in SSMS to the database > Generate Scripts > select ...
0
votes
1answer
254 views

SQL Server Linked Server to Azure SQL using Azure AD

I am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. When we attempt the connection we get this error ...
0
votes
1answer
146 views

Azure SQL database query performance degradation

I have a Azure SQL database (compatibility level = 150). I'm running into a performance problem executing a database query. So after I've rebuilt all my indexes, the query runs fast. When testing, ...
19
votes
5answers
39k views

Azure SQL Database "Login failed for user" in application, but works fine in SSMS

I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me. I created a database called Classifier. I added my ...
0
votes
1answer
44 views

decoding instance_name in sys.dm_os_performance_counters on Azure SQL Database

doing some work with the SQL Perfmon counters and banging my head against the wall trying to work out how to translate the instance_name column to a database name. So if I run a query like the ...
6
votes
2answers
18k views

How to Import a BACPAC file to Azure SQL and Overwrite Existing Database?

Say I have a local database named MyDatabase. I want to move it to Azure SQL and replace an existing database currently residing there named MyDatabase. I know how to create a BACPAC file locally. I ...
2
votes
1answer
113 views

Determine minimal permissions required for a given SQL script or session

For security reasons I need to determine minimal permissions required for a given script or session without having to manually audit activity then work it out by hand. I'm assuming this can be done ...
1
vote
1answer
97 views

FILEPROPERTY not working over linked server to Azure SQL Database

FILEPROPERTY (Transact-SQL) is not working with a linked server pointing from a on-Premise SQL 2017 to a Azure SQL Database. I see the following comment in books online: Returns NULL for files that ...
0
votes
1answer
138 views

Azure Read Replica in Elastic pool performance

We have a Azure Database with a read replica. However the read replica seems to be effected by the load of the primary database. The primary database is in an elastic pool. Does the read replica make ...
2
votes
2answers
2k views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
7
votes
1answer
132 views

Updating rows in Azure SQL Server causing unexpected page splits

I'm getting a lot of page splits in a live environment using Azure SQL Server PAAS that I don't understand. The update that's occurring should not increase the size of the row and therefore never ...
0
votes
1answer
45 views

On-premises SQL to Azure SQL MI Migration

We have a requirement to migrate around 800 GB of data from on-premises SQL Server (2012 and 2017) spread across multiple databases to Azure SQL MI. We have run the DMA on the source data and have got ...
-1
votes
1answer
57 views

Strange behavior with Quotename and substring [closed]

I am seeing some behavior that I cannot figure out. We have a sproc that joins a bunch of tables and filters down some pipe-separated (|) values in a column. We cross apply a string splitter (I ...
2
votes
1answer
135 views

Azure SQL Database - Modify cost threshold for parallelism

I attempted to update the value of cost threshold for parallelism but since my database is an Azure SQL database I can't run the command: EXEC sp_configure 'cost threshold for parallelism', 40 ; GO ...
1
vote
0answers
34 views

Create a specific role in a replicated AZURE SQL database, which is in read mode

Can you give me some help with my Azure Sql, I am having a difficulty with assigning a new role to a database with "geo-redundancy". My current structure is: BD1 in zone_A replicated to ...
0
votes
0answers
37 views

Azure SQL Server table taking unreasonable space

I got a table defined like this: CREATE TABLE [dbo].[INIT_AccessControl]( [timestamp] [timestamp] NOT NULL, [Id] [int] IDENTITY(1,1) NOT NULL, [CustomerID] [int] NOT NULL, [...
2
votes
2answers
47 views

Recalculate and replace large table without interrupting table reads

There's a large table in the database containing statistical information. This table must be read frequently (by lookups which return a single row). This table must be completely recalculated every ...
0
votes
0answers
25 views

Can you bulk upload a file from a remote server to a Azure Managed server

I have a .NET app on a remote server that downloads and processes a file which it then saves to disk, this file is then bulk inserted by SQL and further work carried out. This works a treat when ...
0
votes
1answer
100 views

Why is this SQL Server table using so much space

We have a table in an Azure SQL Server DB that is using about 15x the expected used space for the number of rows x average row size. This is occuring with a customer that uses Azure SQL (not managed ...
0
votes
1answer
14 views

Save changes of records of products in Azure DB in way that we can see historical data

I am curious about "best" model for my purpose of storage of data (include historical changes) in Azure DB that I will be able to see timeline of that changes. Example: We have some company ...
2
votes
1answer
324 views

Is it possible to force an adaptive join with a query hint?

Is it possible to force a query to use an adaptive join? The query in question produces an adaptive join when run as a SELECT, but when run as SELECT INTO instead, it doesn't. I have a parameterised ...
0
votes
1answer
42 views

Azure SQL versioning

While working to restore some SQL 2017 DBs to my Azure SQL DB for some testing we ran into an issue where Azure SQL is running a lower engine version than the VM we pulled the DBs from. Is there a way ...
-1
votes
1answer
18 views

What is the equivalent of on prem ha dr solutions in the azure cloud PaaS and SaaS?

On prem ha dr solutions are: Log shipping Mirroring Replication FCI AG What is the equivalent of each of the above in the azure cloud PaaS (azure sql managed instance) and SaaS (azure sql ...

1
2 3 4 5
17