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

2
votes
1answer
46 views

When do Azure SQL Database index rebuilds occur?

Azure backups occur every few minutes as per the documentation for Automated backups: SQL Database supports self-service for point-in-time restore (PITR) by automatically creating full backup, ...
0
votes
0answers
4 views

SSIS: Error from ODBC provider when inserting into Always Encrypted table using CMK in Azure Key Store

I'm trying to use SSIS (Visual Studio 2017) to insert data into an Azure SQL table with a column that's encrypted via Always Encrypted, and a column master key stored in Azure Key Vault, but I keep ...
0
votes
0answers
6 views

Enabling Advanced Data Security (ADS) on Azure

Can somebody please let me know if ADS is turned on, would it have any negative effect on Azure SQL database performance?
1
vote
0answers
31 views

ADD SENSITIVITY CLASSIFICATION on Azure SQL DB fails

I have received "A Vulnerability Assessment scan" email from Microsoft, where it claims I'm missing this line: ADD SENSITIVITY CLASSIFICATION TO [dbo].[Mytable].[creditor_amount] WITH (LABEL = '...
1
vote
0answers
21 views

Azure SQL - Modifying Indexed Views without downtime

We have a SQL Azure database with a large indexed view that supports a website with high traffic during business hours. One of our goals from a DevOps perspective to be able to ship software (...
0
votes
0answers
20 views

Azure Database Encryption (ERROR ON WEB APP)

Currently I have an azure subscription which has a server and database. I already encrypt a column in a table. i am using "always encrypted" method. Now I want to generate a .pfx file after I ...
-1
votes
0answers
12 views

Azure: How to move databases from different Azure SQL servers into Elastic Pool

We have multiple Azure Sql Servers with single database in each. We want to consolidate them to single Azure Sql Server to have an advantage of elastic pool pricing. How it can be done with minimal(or ...
-1
votes
0answers
6 views

Azure SQL Elastic Query by Shard Id

I am wondering if anyone has attempted to filter a query (like a where clause) for an elastic query to use the Shard Id to direct the query to a specific Azure database ? I have reports that are ...
0
votes
0answers
13 views

Azure sql database backup and exporting data-tier application

Currently i have an azure subscription in it has a server and a database. How could i setup azure SQL database backups that will run automatically for example every 15 mins? is there a way? if yes ...
6
votes
2answers
77 views

Altering Column Size On a Super Large Table

I have a table with a column of type NVarChar(Max). I didn't take good precautions before allowing users to add data so right now I have more than 2.5 billion rows and the database is becoming super ...
2
votes
1answer
60 views

Hash Match Spills and Key Lookup causing major performance issue

I have updated the statistics on all the indexes but this query is still taking close to 40 seconds to execute. I need it to be under 20. I am not a DBA and very new at reading execution plans. I ...
0
votes
0answers
15 views

What is a good backup method for Azure SQL?

I maintain a Azure SQL database with the Basic plan. 7 days point in time restore is enough for our daily needs. What we are looking to improve is a daily backup outside Azure in the case that we lose ...
2
votes
1answer
42 views

How do you retrieve the identity value of a row inserted from the OUTPUT of an UPDATE statement?

How do you retrieve the identity value for an inserted row when that row is inserted from the OUTPUT of an UPDATE statement? Neither @@IDENTITY nor SCOPE_IDENTITY() appears to be set properly. ...
3
votes
1answer
78 views

How to find dropped or ghosted columns in Azure SQL DB?

In SQL Server, dropping a column is a metadata only change; the data remains in the index until the index is rebuilt. On prem, I use system_internals_partition_columns to determine what indexes have ...
0
votes
1answer
17 views

Is the limit on the number of databases in an Azure SQL managed instance a hard limit?

I see the documentation for Azure SQL Managed Instance lists a limit of 100 databases per managed instance. I would like to understand if this is a soft limit that is adjustable on request or a hard ...
0
votes
0answers
6 views

Details about existing roles and users in azure sql database

I would like to get details of all users existing in a sql server DB and the respective roles they are part of and the permissions granted/denied for the a role/user. what is the best way to get this ...
0
votes
0answers
51 views

SSIS packages run locally but not on Azure (possible host name issue?)

I am trying to make SSIS packages using Visual Studio 19 that import data from tables in a remote Azure Managed Instance SQL database to a Microsoft Azure SQL DB database, aiming to schedule these to ...
1
vote
1answer
17 views

Azure SQL Database patch and update doubts

It is known that Microsoft automates the patch and update of Azure SQL Database. But, some times applications must be tested before being applied any type of patch or update, because there's a ...
0
votes
0answers
14 views

Migrating database to Sql Azure - “The element Certificate: [CertName] is not supported”

Within my database I use symmetric encryption on certain columns. I'm investigating migrating to SQL Azure, but when I try to migrate my database using the wizard within SSMS, I get a couple of ...
0
votes
1answer
37 views

Overwriting old data in Azure SQL database

I`m currently recieving data from sensor and storing it to Azure SQL database through Azure Stream Analytics job. My question is: how can I overwrite old data from sensor with new data? Sensor has ...
0
votes
0answers
23 views

Azure SQL DB: Can't create table because it already exists, can't drop or write to table because it doesn't exist

I have an Azure SQL DB database that I am copying data into from a source database using SSIS. My SSIS package for one table fails because it can't write to or create a specific table name (it is ...
1
vote
1answer
18 views

Is it faster to truncate destination and copy all source data or lookup and keep only non-matching data with SSIS transfer packages?

I am building an Azure SQL DB database and to do this I will have to regularly (weekly-monthly) pull data from various other servers. I am designing SSIS packages to do this and whilst most of the ...
0
votes
0answers
19 views

How to Decrypt Stored proc in Azure Managed SQL Server

I have created Managed SQL Server in Azure and encrypt some stored procedures. Can any one help me to decrypt the same. Thanks in advance.
0
votes
0answers
20 views

Azure SQL Database encryption

Currently i have an azure subscription in it has a server and a database. How could i encrypt an SQL azure table and when the encryption is done i can still insert some data on the table? I already ...
-1
votes
2answers
30 views

SQL Server 2012 log shipping to Azure SQL

Is there any way to take SQL Server 2012 log shipping files and upload them into Azure SQL Database. We just need the data changes and not to bothered about the recovery side of things.
2
votes
0answers
23 views

How to implement updates from mySQL operational DB to Azure SQL DB for reporting

We have an operational mySQL DB running on AWS for a transactional system and an Azure SQL DB for reporting with PowerBI. Now I'd like to regularly (e.g. every night) do an update of certain tables ...
1
vote
0answers
48 views

How to Measure data consumed by an user in Azure sql server database?

For an Azure sql server MI, we have multiple external users consuming data, I would like to know how much data an user is consuming/extracting from the DB? Can this be checked from, 1.) From SSMS ...
-2
votes
1answer
28 views

Condtional String_Agg In Azure SQL

I have a table of Points. CREATE TABLE Points( ID int IDENTITY(1,1) NOT NULL PRIMARY KEY, Label varchar(50) NULL, Destination bit NOT NULL, PickUp bit NOT NULL, SetDown bit NOT NULL) ) With Data ...
0
votes
1answer
45 views

How to grant permissions to database but restrict to certain schemas?

I am new to database administration and work within a small team of data analysts trying to modernise. We have recently set up an Azure SQL DB server we are accessing using SQL Server Management ...
1
vote
1answer
21 views

Azure SQL Server - Cannot get rid of the sort operator

I'm using Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 3 2019 13:27:00 Copyright (C) 2019 Microsoft Corporation), Premium tier 4 (500 DTUs). Query: offer progress has a history ...
-2
votes
1answer
28 views

Azure SQL Server - big query choosing bad execution plan [closed]

I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out ...
0
votes
0answers
22 views

Database Administrator

If I want to be the only person/department in my organization that can create and administer databases in Azure. What privileges do I need have and make sure no one else has? I will need to give ...
0
votes
1answer
54 views

sp_Blitz Error on Azure SQL Database [closed]

Getting the following error when trying to install sp_Blitz on a Azure SQL Database Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 15] Reference to database and/or ...
6
votes
1answer
93 views

Understanding Plan Choice When Query Store Doesn't Respect Forced Plan

I'm trying to figure out a situation that I encountered last week where, in an attempt to temporarily fix a plan regression during an incident, I forced an execution plan using Query Store, but found ...
7
votes
1answer
71 views

Storing CREATE EXTERNAL DATA SOURCE in a SSDT project without exposing the DATABASE SCOPED CREDENTIAL or MASTER KEY secret;

I have a SSDT project that deploys to Azure SQL DB. Recently I added an external table. This required an external data source as follows: CREATE EXTERNAL DATA SOURCE [data_warehouse] WITH ( ...
0
votes
2answers
79 views

Unable to connect SQL Managed instance in the vnet

One of our team member wanted to create a Managed instance for his testing and was asked to use existing vnet which was already configured to connect remotely and had other Managed instances for POC. ...
0
votes
1answer
36 views

T-SQL to show Azure SQL Managed Instance vs Azure SQL Database

Restated: How can I use T-SQL to determine whether a instance is an Azure SQL Managed Instance or Azure SQL Database?
2
votes
1answer
69 views

Make database writeable (Azure MS Sql)

I have a bacpac file from a read-only database hosted on Azure. When imported to a new server the database is also read-only. I’ve tried looking for answers with no luck. How can I change it to a ...
0
votes
1answer
42 views

Azure SQL Row Level Security Full Index Scan

We have implemented SQL Row-level security using SESSION_CONTEXT. From an architecture standpoint, this is a beautiful paradigm that allows our application to be clueless to the fact that only 1 ...
0
votes
2answers
28 views

Import data tier application in Managed instance

I am using SSMS 18.0 Preview 6 and wanted to import the .bacpac file we have locally stored and accessible. However, seems the function is not supported in the GUI . Any updates/suggestions are ...
0
votes
0answers
50 views

Filegrowth recommendations for Azure Managed Instance

On Azure SQL Managed Instances, im seeing new database getting 16MB filesize growth on database and logfiles (i changed log to 128MB). I haven't been able to find online docs from MS on recommendation ...
3
votes
1answer
143 views

How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?

I have created a SQL maintenance job using Azure Elastic Job Agent with the following step: EXEC jobs.sp_add_jobstep @job_name = @jobName, @step_name = 'Optimize indexes and statistics', @command=N' ...
0
votes
1answer
50 views

Migrate azure sql database to Azure SQL Database Managed Instance

We need to migrate one of the database into MI from Azure Sql. Has anyone done it before.Looking for any documenatation/Guidance on this as not much is available. Will be testing the below method soon....
0
votes
1answer
42 views

SQL Server Always Encrypted - Create an external table containing an encrypted column

I'm trying to create an external table MyTable on server S2 that references the table MyTable from server S1. The table MyTable contains a column encrypted using Always Encrypted. I'd like the column ...
0
votes
1answer
16 views

Are user defined types (UDTs) available in an Azure SQL database managed instance?

Is it possible to create user defined types and user defined table types in an Azure SQL database managed instance?
0
votes
1answer
84 views

Ola Hallengren for Managed instance

How can we configure Ola Hallengren's solution on a managed instance? (We want output file for each run, storing it is an issue) If we want backup retention longer than 35 days for the database in ...
0
votes
1answer
21 views

PaaS Server - Random row order while using aggregate function with group by

Result set of a query with an aggregate function and group by (no order by specified) returns different result or at least in different order almost in each execution. I have a database on Azure PaaS ...
2
votes
1answer
104 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 ...