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
0answers
17 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 ...
-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 ...
0
votes
1answer
27 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
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 ...
2
votes
1answer
40 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 ...
2
votes
2answers
408 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, @...
2
votes
2answers
79 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
36 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
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 ...
9
votes
3answers
315 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 ...
0
votes
0answers
63 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
43 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 ...
0
votes
1answer
44 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
129 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 ...
7
votes
1answer
130 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
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, [...
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
98 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
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
16 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 ...
0
votes
0answers
36 views

Azure SQL Server DTU Percentage degrades over time with API Throttling

I've been facing a weird DB behavior when trying to post records to my api. I have a function that throttles requests at a request rate of 10-15 req/s, each request results in a lookup and an insert (...
0
votes
0answers
18 views

script to find info on Azure sql dbs,Azure mysql dbs

I would like to check if we have a powershell script which can fetch all properties of a particular service like logical servername, resourcegroup etc for all azure sql databases (PAAS) and azure ...
0
votes
0answers
16 views

Azure SQL database make AD user see more databases in SSMS

I'm using Azure SQL databases and want to add a user from my company using Active Directory auth, so adding the user from external provider. The problem - by design Azure SQL creates AD users as ...
1
vote
3answers
123 views

Partitioning and existing Indexes

I have a table that consumes almost 900 GB of space and has lots of historical data which are mostly irrelevant. Since performing bulk DELETE is going to cause a lot of heavy-lifting, I'm trying to ...
1
vote
1answer
81 views

Improve performance searching nvarchar values on varchar column

I have a table with order data in an azure sql database. Our web developers (using django) consistently have queries that look like... SELECT col_one, col_two from order_headers where order_number = ...
2
votes
2answers
351 views

Reduce the size of a primary key Index

I'm using Azure SQL DB and noticed that one of my largest databases appears to have a primary key index with a total size of 6Gb. It's a clustered index on a uniqueidentifier. However, the total rows ...
0
votes
1answer
25 views

Copy database backup files from Azure to on-premise network

Goal - Take a database backup in Azure and copy the backup file(s) to company network for archiving. Note that I'm not asking how to copy a database. Research - I have knelt at the alter of Google, ...
0
votes
1answer
13 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 ...
0
votes
1answer
27 views

Azure SQL Database system view/function permissions

I have a diagnostic query that uses these system views/functions: sys.dm_exec_cursors sys.dm_exec_sql_text sys.sysprocesses sys.syslockinfo The actual query is pretty big but I can include it if it'...
3
votes
1answer
215 views

How to tell if an index has OPTIMIZE_FOR_SEQUENTIAL_KEY turned on?

SQL Server 2019 brings the OPTIMIZE_FOR_SEQUENTIAL_KEY option that, as far as I know you specify on index creation or alter using the WITH keyword. But how do you check if the option is already turned ...
0
votes
1answer
63 views

Specific port of Azure SQL Database Serverless

The security rule of our company requires us to change the port from 1433 to another. But is it possible to change the port for serverless SQL? I search a bit and it seems only applicable for ...
0
votes
1answer
63 views

On premise to cloud restore - Automated?

What's the most automatic way to restore a on-premise SQL Server database to Azure SQL Database? Has anybody done or seen such a solution? Scenario: Need to do a weekly refresh of a dev database from ...
0
votes
1answer
40 views

How do I give my non-Azure app access to Azure SQL Server without whitelisting an ip address?

I have an app that is deployed to Vercel. It is registered in Azure AD and uses AAD for authentication. I added my personal ip to the whitelist, and when I run it locally, everything works as it ...
0
votes
2answers
57 views

How can I suppress or disable temporal table history insertion for a single statement or transaction?

I have a table that stores Customer information (your bog-standard CRM stuff): CREATE TABLE dbo.Customers ( TenantId int NOT NULL, CustomerId int NOT NULL, ...
1
vote
1answer
54 views

Alternatives to AzureSQL temporal tables

I have recently been learning about temporal tables in AzureSQL and am considering implementing this into my codebase. However, columnstore indexes are only available for Azure SQL databases of tier ...
0
votes
0answers
10 views

Are FullText catalog indexes managed by Azure SQL?

I know normal indexes are maintained (reindexed) automatically on azure SQL. (without the need of having to create a jschedule job to run it periodically) However, non of the documents are clear to me ...
0
votes
2answers
65 views

insert on table being unnaturally slow

I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns ...
0
votes
1answer
31 views

Azure SQL Read-Only table Indexing

I'm trying to work out the best indexing strategy for a slightly weird pattern I'm forced to use with Azure SQL. Tables are dropped, re-created & loaded with new data daily from ADF Tables are ...
0
votes
0answers
32 views

Row Level Security on Multiple tables/Views

I’m looking for some guidance on implementing multiple row level security policies for different use cases on the same tables/views. Basically, I have a view “ReportView” used for a report which has a ...
0
votes
0answers
11 views

How to configure a Azure MySQL DBMS software configure according to vendor guidance?

We currently in the process of the Implementing below Standards required. https://www.cyber.gov.au/acsc/view-all-content/guidance/database-management-system-software ISM - 1246 - Hardening and ...
0
votes
2answers
34 views

Can I make a short-lived readonly snapshot for reporting in Azure SQL DB?

I have an Azure SQL DB (OLTP), that is under considerable load, let's call it AppDB. AppDB is transactionally consistent, but new rows are written to it constantly. Now I need to populate ReportingDB ...
1
vote
1answer
135 views

Configuring Azure SQL Server and SQL DB instance with MFA/2FA for On-premise AD DS synched account

I've synched my OnPremise AD DS users into Azure using Azure AD connect. How can I enable the user of my Azure SQL Server and Azure SQL DB instance to use MFA/2FA when connecting with SSMS using the ...
0
votes
1answer
34 views

How should I handle Azure SQL hanging when scaling up from General Purpose to Hyperscale?

I'm in the process of scaling up an Azure SQL database from General Purpose to Hyperscale. This has been running for more than 12 hours. When I check the "Ongoing operations" it says that it ...
6
votes
2answers
248 views

Optimize extraction of json data via OPENJSON

I'm attempting to optimize extraction of values obtained from a REST API which returns json values in an array. Here's an minimal, complete, and verifiable example that reflects exactly what I'm doing....
0
votes
1answer
558 views

How to add a login to the dbcreator role?

Using SSMS, I'm having trouble adding a new login to the server dbcreator role on my Azure SQL instance. Here's the syntax I'm using: CREATE LOGIN test WITH PASSWORD = 'SuperSecret!' ALTER SERVER ROLE ...
1
vote
0answers
32 views

Filtering for user transactions in Azure Log Analytics

We have audit logging in Azure Log Analytics set up for an Azure SQL Database we operate. I would like to query these logs to view user transactions to track down queries that have unintended ...
1
vote
1answer
55 views

Azure SQL - Using Copy Database between two subscriptions with private endpoints

If using the tsql "CREATE DATABASE Database2 AS COPY OF server1.Database1;" on an Azure SQL server to copy a database between servers in different subscriptions, then this works fine when ...

1
2 3 4 5
17