Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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).

0
votes
0answers
6 views

Azure MariaDB log_bin_trust_function_creators

I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters. I've checked and ...
0
votes
0answers
36 views

How to check when a record is replicated in SQL Server

I have configured a database installed On-Premise to replicate certain tables on a Cloud SQL Server database hosted on Azure. The replication task is scheduled to run at specific time everyday and I ...
0
votes
0answers
17 views

Move from SSIS to Azure

I have an ETL solution which we have been doing in conventional SSIS. The job of SSIS is just to create star schema from the application database to dimension and fact tables. There is very little ...
2
votes
1answer
57 views

Does Batch Mode only apply to Agg Functions on ColumnStore Index

Azure SQL Database - Standard Edition (S3 Service Tier) Why does Batch Mode only come into effect when using Aggregate Functions? DROP TABLE IF EXISTS dbo.TransCS CREATE TABLE dbo.TransCS ( ...
1
vote
1answer
35 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 ...
1
vote
1answer
62 views

Sql server deadlock when insert and update in one transaction

I'm using Azure SQL + Java + Spring Boot 2. Currently I'm trying to understand the reason why deadlocks occur. In transaction I'm doing insert and later update on the same table by different rows. ...
0
votes
0answers
25 views

Azure Managed Instance Log file Larger than Data File

Good Afternoon, I am working with the Brent Ozar tools on an Azure SQL Server Managed Instance. Once of the things that came up when I ran the sp_Blitz procedure was that I had several databases that ...
1
vote
1answer
31 views

How to get EstimatedRows values from SQL Server execution plan nodes

When I execute the following code in an Azure SQL Database (v12) or SQL Server 2016 instance, I get values in the EstimatedRowsRead column, but not in the EstimatedRows column, and I'm not seeing why. ...
1
vote
1answer
32 views

Can I on purpose lock the admin out of an Azure SQLDB (as admin)

Can I on purpose lock the admin out of an Azure SQLDB (as admin) As this may sound as a strange question on first sight. The goal is to only have sql users with data reader & writer rights on the ...
0
votes
1answer
14 views

Contained User within a Non-Contained Azure SQL Database

While granting access to Azure SQL databases I have been creating Contained Users directly in the SQL database like so:- CREATE USER [email@domain.com] FROM EXTERNAL PROVIDER; As this has been ...
2
votes
1answer
38 views

Why does elimination of an if-statement cause notable speed up in my function?

I have the following table: CREATE TABLE [dbo].[StateChanges] ( [RecordId] uniqueidentifier NOT NULL, [LinkedObjectId] uniqueidentifier NOT NULL, [ChangeType] TINYINT not null, [...
0
votes
0answers
9 views

Concern on Active Directory Users on Azure SQL Server

I was able to add Azure Active Directory Users to Azure Sql server. My question is not related in including or removing an Azure AD user, but its existence after the user ceases himself/herself. My ...
0
votes
1answer
43 views

install FirstResponderKit in Azure SQL DB?

I've just downloaded the newest version (20190128) of FirstResponderKit from BrentOzar.com, and tried to install it on Azure SQL DB. I'm getting these errors: Msg 40515, Level 15, State 1, Procedure ...
0
votes
1answer
16 views

Performance recommendations stuck on 'Validating'

I have been tasked with migrating a 'database from hell' to Azure SQL. It has some complicated and long-running queries (20 seconds on the S6 tier, >600 seconds on S4 tier) and I'd like to optimise ...
0
votes
1answer
59 views

How to identify columns order in a table, bis

So I'm asking a question similar to many but actually what I'm specifically asking hasn't been addressed. This one is the closest (How to identify columns order in a table) but not quite. I have a ...
2
votes
1answer
23 views

Excessive log throttling on Azure SQL on business critical tier

We moved from the Biz Critical vCore Gen4_8 tier to Gen5_8 over the holidays. We had to move because our log growth is constantly pushing us into the 1 TB limit of Gen4. Not only are our queries ...
-2
votes
1answer
30 views

Database Backup to URL fails with Device I/O Error [closed]

I'm using Ola's Maintenance Solution to backup my databases to a URL. Most of my databases backup just fine but I have one 2 TB database that continues to fail with a device I/O error. Has anyone ...
0
votes
1answer
29 views

FK relationships between schemas in azure SQL don't work

I'm having an issue with migrating my SQL 2014 database to an azure database. I'm able to get everything migrated except for any FK relationships between tables that aren't the in same schema. for ...
0
votes
3answers
71 views

Slow performance matching columns to lists of values

I've made a stored procedure to get all results which match specific students and objectives. CREATE PROCEDURE [dbo].[GetResults] @students [IdList] READONLY, @objectives [IdList] READONLY AS SELECT ...
0
votes
1answer
27 views

deploy data from sql 2016 backup to azure database

I've got backup data from a SQL 2016 server that i want to move/restore onto an azure database. I'm not seeing an in-house option to do this anywhere, so it looked like the best option was to restore ...
1
vote
1answer
65 views

How to troubleshoot “BCP copy in failed”

I have a table that looks something like this in a SQL server database in Azure: CREATE TABLE [dbo].[TableName]( [col01] [int] IDENTITY(1,1) NOT NULL, [col02] [varchar](255) NOT NULL, [col03] [...
3
votes
2answers
64 views

Azure SQL cross-database queries returns too many rows with joins

I have a problem with Azure SQL cross-database queries, it looks like if we join data across databases the join is not distributed as input to the external database. Currently I tried to implement a ...
0
votes
2answers
41 views

Azure sql database grant select on certain tables

I have created a user in a Azure sql database in SSMS. Now trying to give select permission to certain tables in a db to this user. The security control options seems quite different than on premise ...
1
vote
1answer
39 views

“Keyword not supported: Server” error when using ADO.NET connection string to connect to Azure DB

I have an ASP.Net project that I am running. I have added a database to Azure, and Azure generated a connection string for the database. When running the application I however get an error stating ...
3
votes
1answer
78 views

Managed Instance Restart

Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are all grayed out, so that’s really. It an option. Any thoughts? Thanks...
0
votes
1answer
13 views

How to analyze compression options for Azure SQL Database?

What is the most efficient way to determine whether row or page or columnstore compression (or none) would be most effective for each index in an Azure SQL Database (standard or premium tier) used for ...
0
votes
1answer
20 views

What type of data ingestion does Azure Data Factory use?

This article data-ingestion says that there are two types of data ingestion Data can be streamed in real time or ingested in batches. What type of data ingestion does Azure Data Factory's ...
3
votes
2answers
77 views

Can't stop execution of “ADD PERIOD”

I'm trying to conditionally execute an ALTER TABLE command (this one, to be precise). However, I can't get the ADD PERIOD to be conditional and I suspect this might be a bug. Here's what I've tried ...
0
votes
0answers
17 views

Where can I find the failover history for an Azure SQL Database with geo replication?

We have an Azure SQL Database that is geo replicated to another region. I suspect that they have swapped which is primary and which is secondary and would like to find information about when that has ...
6
votes
1answer
157 views

Error 666 on clustered primary key

I am receiving error 666: the maximum system-generated unique value for a duplicate group was exceeded. I am experiencing this on an Azure SQL Managed Instance. However, I shouldn't be getting ...
2
votes
1answer
43 views

Is CREATE EXTERNAL DATA SOURCE Azure PaaS elastic databases broken?

I have set up Azure elastic database queries before by using the following on Azure PaaS databases: On the data source database: CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<encryption key>'; ...
2
votes
1answer
32 views

Why are there multiple plans for query under forced parameterization?

I see the following query in an Azure SQL Database (that has Forced Parameterization = FORCED, Parameter Sniffing = ON, and Query Optimizer Fixes = ON) from within Query Store: delete from [...
1
vote
0answers
91 views

Improve parallel running of bulk copy insert and stored procedures

I have a Java message listener, which upon receiving a message starts bulk inserting thousands of records into a table. After that it calls a few stored procedures sequentially that make some updates ...
6
votes
1answer
314 views

Why would a Clustered Index Seek return a higher “Actual Number of Rows” than there are rows in the underlying table?

I'm troubleshooting an issue related to SQL Server (Azure SQL Database technically) occasionally choosing a bad execution plan, presumably due to skewed stats. sp_updatestats fixes it every time, ...
0
votes
0answers
37 views

Accessing the token passed to SqlConnection.AccessToken

Lets say I use JWT authentication to connect to an Azure SQL DB. From inside my T-SQL session, can I see access the token?
1
vote
0answers
48 views

What are the requirements for SQL Replication on Azure SQL DB Managed Instance?

We are seeing if it is feasible to setup Azure SQL DB Managed Instance (SQL MI) and an Azure VM with SSMS installed for this replication scenario: We have a vendor who needs access to our SQL Server ...
0
votes
1answer
28 views

Temp tables not being created in SQL Server Azure [duplicate]

I have created a stored procedure that creates multiple temp tables for use in the sproc and then drops them at the end of the sproc. The problem I am encountering is I can execute the stored ...
1
vote
1answer
19 views

Snapshot Azure database for fast revertion to snapshot

I have spent a considerable amount of effort creating a set of Azure SQL databases and importing data. Importing the data with the DMA tool took the best part of two days. This is on an 'SQL Server (...
5
votes
2answers
162 views

SSMS can't connect to Azure database

I got a new Windows 10 machine and installed the latest version of SQLEXPRESS and then the latest version of SSMS (17.9.1). When trying to connect to my Azure database, I'm getting the following ...
1
vote
0answers
27 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...
8
votes
1answer
2k views

TOP(1) BY GROUP of very huge (100,000,000+) table

Setup I have a huge table of ~115,382,254 rows. The table is relatively simple and logs application process operations. CREATE TABLE [data].[OperationData]( [SourceDeciveID] [bigint] NOT NULL, ...
1
vote
1answer
44 views

Merging the sysdb database (a dependency due to conversion from Oracle) into my SQL Server 2014 Express Database

I am looking to convert my SQL Server 2014 Express Database to Azure SQL Database. My SQL Server database was automatically converted from Oracle a number of years ago, and needs the sysdb database (...
1
vote
0answers
22 views

Copy SQL Azure Hyperscale

I wanted to try SQL Azure Hyperscale, after I selected it seems I no longer have the option to move out of it. If I try, I get this message "databases cannot be moved out of hyperscale tier". The ...
1
vote
0answers
25 views

RTO, Azure SQL DB, 1Hour?

I am going through this page to try to understand how a geo replicated DB would fit into our RTO and RPO and I was surprised to see RTO of 1H. I am even more confused as it says the RTO is equal to ...
1
vote
2answers
43 views

How do you know when it's time to upgrade a RDBMS/SQL database infrastructure? What metrics to follow? [closed]

In my specific case, I have just deployed my side project to AWS and using AWS MySQL Tier 2 Micro instance, which is within AWS' Free Tier; https://aws.amazon.com/ec2/instance-types/t2/ It has: 20 ...
1
vote
0answers
126 views

Service Principal as SQL Active Directory Admin, does it use Graph API?

I'm looking to use a service principal as the server admin, so it can be used in a release pipeline to create further active directory users. I'm successfully able to make the service principal the ...
2
votes
2answers
61 views

ALTER TABLE command with no default value taking forever?

I'm attempting to add a NOT NULL constraint to a table I have (so I can use it as part of a primary key, so I can create a spatial index...) but it is taking a really long time - 1 hour 31 minutes and ...
1
vote
0answers
63 views

Why are my statistics getting out of date so quickly?

I've got a large table (300 million rows), with about 1 million rows added per day. This is time-series data, so I have the following setup: CREATE TABLE Readings ( Id INT PRIMARY KEY, ...
0
votes
1answer
50 views

Azure SQL Synonyms with On-Premise

I have an on premise database that I can't move to the cloud due to it not being our software, though I have a website that ties into it using synonyms and views. Is there any way to allow the Azure ...
0
votes
0answers
15 views

Azure SQL database AAD user can't connect

I've read through the documentation and have tried many, many things to get this to work but am still having trouble. The AAD user is a member of a group that has been provisioned Contributor ...