Stack Exchange Network

Stack Exchange network consists of 174 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
38 views

How can I stop a long running query in SQL Azure Database

I triggered a very inefficient query against a Azure SQL Server instance that has been running now for hours. I have tried looking at the active spid and trying to kill the process that started it but ...
0
votes
0answers
9 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
25 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
24 views

Temp tables not being created in SQL Server Azure

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
14 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 (...
4
votes
2answers
66 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
18 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
1k 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, ...
0
votes
0answers
17 views

Datetime Values Incorrect in Azure SQL Server

I am using an Android app to collect data. I currently have this app set up to send all the data to an Azure SQL Server database upon submission of a completed form. I've noticed that the datetime ...
0
votes
0answers
30 views

Strategies for migrating large highly OLTP SQL Server DB to Azure SQL DB

We are planning to move our main DB to Azure SQL DB. The DB services a highly OLTP(financial/Credit card), 24/7 application with some transactions latency to be as low as below 50ms. The db size is ...
1
vote
1answer
36 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
14 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
19 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
39 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
58 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
57 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
62 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
27 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
8 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 ...
1
vote
1answer
36 views

how azure sql geo replication works internally?

My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup ...
1
vote
1answer
64 views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
1
vote
1answer
37 views

SQL Server (Azure) split comma-separated string into multiple columns?

I have the following data in Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Sep 20 2018 21:40:02 Copyright (C) 2018 Microsoft Corporation) ID Name 1 US_Android_100x200_blue 2 ...
0
votes
0answers
12 views

Open query editor of existing queries in SSAS visual studio

It seems like it's too easy to even ask, but for some reason I haven't been able to find the solution anywhere: I've connected tables from an Azure SQL database to SSAS in visual studio, I've done ...
0
votes
0answers
26 views

Azure SQL Database finding latest available restore point

From reading books online it is clear that there are two types of retention for Azure SQL Database. Backups for point-in-time restore Backups for long-term retention When it comes to restore there ...
1
vote
0answers
20 views

Online migration using Database Migration Services

I wanted to test online migration to azure sql db using azure database migration services. I am following the below link. https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-...
1
vote
3answers
34 views

azure sql - create index, does DB have to be offline?

New to Azure SQL. Simple example to ask question. Table Cars. Want to add an non clustered index to Cars table. Takes a long time, say 30 min during staging test deploy. When upgrading production ...
2
votes
1answer
74 views

Can an application connect to databases from on-premise SQL Server Instance and Azure SQL together?

Can a single application connect to two different databases each of which is in different Instances. One instance has on-premise deployment, the other one is Azure SQL(not SQL in Azure VM). So ...
1
vote
2answers
46 views

SQL Maintenance Tasks on Azure [Ola Hallengren Scripts]

I am trying to implement the SQL maintenance scripts from Ola on my Azure elastic pool databases. I did the steps as provided in this link. I could create the job, but I always get this error after ...
1
vote
1answer
30 views

SQL Server - How to improve/optimize remote scan on a linked server

I'm trying to figure it out how to optimize/improve the following thing, on a VM hosted in MS Azure and a database, also hosted in MS Azure. Besides the instance hosted in MS Azure, there is another ...
6
votes
0answers
202 views

Cardinality estimation on tables with large cardinality variance between keys

Context I have stumbled on an issue in SQL Azure where the Sort-operator is spilling over into TempDB due to poor row estimates. We are querying a master table that is joined with a number of detail ...
1
vote
1answer
43 views

Copy real time data from Azure SQL into Azure Data Warehouse

I would like to copy our data from Azure SQL (OLTP) into Azure Datawarehouse. I want the path to be close to real time. The Microsoft system looks it takes two steps copying data from SQL Server into ...
1
vote
1answer
122 views

Migrate on-premise SQL Server databases to Azure SQL Database

We're in the process of a server migration from an on-premise server (Win2008R2) to Azure PaaS. To move the databases, we used the Microsoft Data Migration Assistant (DMA) tool, which worked great ...
2
votes
1answer
71 views

Difference between Clustered Columnstore Index Table in Azure SQL and Table in Azure Data Warehouse

What is the essential difference between a Clustered Columnstore Index table in Regular Azure SQL, and a table in Azure Data Warehouse? They both have columnar storage, no foreign keys, no primary ...
1
vote
0answers
24 views

Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime

We have a pretty large sql azure database, over 300GB. Many tables have been altered over time and we would like to create fresh indexes, including clustered ones. Of course we would like to minimize ...
1
vote
1answer
229 views

Azure SQL DB vs Azure managed instance [closed]

We are in the early stages of planning to move some of our on-premise database to cloud and wanted to go the PaaS way. I understand that managed instance is in preview. From what I have read, ...
2
votes
2answers
63 views

Permission error when using sys.dm_exec_input_buffer with @@SPID

When I run this blob of SQL on SQL Server 2016 or an Azure SQL DB: --hello world SELECT event_info FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_input_buffer(req.session_id, req....
5
votes
1answer
288 views

Read Committed Snapshot, stale data reads?

I'm running SQL Azure and I have a following case. I have two transactions W (writer) and R (reader). Both are running with RCSI (.net application with TransactionScopes using LTM). The R transaction ...
1
vote
1answer
24 views

cause of / how to fix a table with excessive reserved pages

I have several tables with clustered indexes in azure PaaS sql server which have blown out to be much bigger than their data, with reserved page count several times bigger than the actual amount of ...
1
vote
1answer
46 views

Azure SQL Server External Data Sources

Let me preface this what what I'd like to accomplish and see if this is inline with the expectation of using Azure SQL DB. Currently I use a couple Virtual Machines in Azure that use a linked server ...
0
votes
1answer
32 views

Advanced threat detection vs IP restriction

If we configured IP restriction to allow only internal network, then why we need threat detection? IP restriction already blocks connections from other resources. Moreover, advanced threat detection ...
1
vote
1answer
277 views

GRANT select on function FN_DUMP_DBLOG in SQL Server without GRANTing sysadmin

I'm trying to GRANT permission for an SQL login to access the functions fn_db_log and fn_dump_dblog but GRANTing SELECT on the function still fails with error: Msg 9010, Level 14, State 1, Line 3 ...
1
vote
1answer
84 views

Full Outer Joins Slowing Down Query

I am relatively new to SQL, so I apologize if I ask some basic questions. Our database is setup on Azure, we have automatic indexes turned on. The query I have takes about 6 seconds and gets 2217 ...
0
votes
0answers
64 views

Users are missing in Database restored from .bacpac file

I am creating a new database from a reference .bacpac db file but the issue is that in the new Database, users are corrupted and I cannot login through any of the database users that were there ...
1
vote
0answers
50 views

Azure's New Tiers (2018) - Standard vs Premium

We've done what we can to index things intelligently, but we're beginning to scale up our database usage and have decided scale up (?) from Azure's S4 tier to P1. It looks like P1 has fewer DTUs and ...
0
votes
1answer
59 views

REORGANIZE INDEX blocks other queries

(SQL Server 12.0.2000.8 running in Azure) It has been my understanding that REORGANIZEing an index should not interfere with other operations (that is, it should not block queries on the table ...
0
votes
2answers
79 views

Error 0x80131904 failed to load assembly id 65536 / HRESULT: 0x8013150A for microsoft.sqlserver.integrationservices.server

I am running SSIS Packages through an Agent job and getting error 0x80131904: Message: Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version ...
0
votes
1answer
17 views

A Common Username for Both Database hosted in Azure

I have 2 azure databases created in one SQL Server. I.e. Database 1 = db1 in xsqldb01.database.windows.net Database 2 = db2 in xsqldb01.database.windows.net I would like to create a username or user ...
0
votes
0answers
64 views

Way to link to Oracle DB from SQL Azure DB

We currently get data from our Oracle DB by creating it as a linked server from our on-premise SQL server database. We are considering moving to the Azure SQL and would still require data from on -...
4
votes
2answers
288 views

Azure SQL Server Database Error: 18456, Severity: 14, State: 1

Why can't I login to my SQL Server database on Azure, and how do I correct this? No one in our company has changed the password of our Azure SQL Server database administrator user, yet I'm getting the ...
5
votes
2answers
86 views

How secure is an Azure database within Microsoft?

I am considering moving most of my Databases to Azure SQL server Database, but I am concerned that Microsoft will be able to snoop and look at the data inside the database, which is absolutely not ...