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
15 views

does azure GEO replication has the same slow down problem as in this article? [on hold]

I contacted microsoft support, but haven't got a concrete answer yet. Basically we use Azure sql P range with GEO replication, one primary one secondary readonly. As it is P range, we have the read ...
0
votes
0answers
9 views

best option for moving from SSRS to Power BI?

One of my customers have an On Premise SQL Server Express edition, using a few SSRS reports for about 20 users. In order to maintain their system, I need one of their PCs to login to their intranet. ...
0
votes
1answer
35 views

TRY .. CATCH sometimes fails to catch PRIMARY KEY VIOLATION

I wrote code to upsert records to the database. The database is Azure DB, S4 tier. Updates and inserts are sometimes are highly concurrent since it's coming from the application that doing too many ...
0
votes
3answers
47 views

Sync between two database on azure

I would like to ask a question how to setup azure syncing of two database on azure i need real time data replication to the other database
1
vote
1answer
23 views

Regularly Archiving Data to Azure

I have a database – call it Jacob. Every day a SQL Agent job copies all records older than 15 days to another database called Jacob_Archive I would like to move Jacob_Archive to Azure, I’ve created a ...
0
votes
0answers
21 views

Migrating SQL Server 2012 Web Edition to Azure

I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
2
votes
1answer
34 views

Recommendation on changing Azure SQL Database tier weekly [closed]

We have an Azure SQL Database of size 50GB in the S6 tier. On weekends, the usage is very minimal. Is it okay to change the tier to S0 every weekend for cost savings, and change back to S6 on Monday? ...
0
votes
1answer
22 views

What is the best way to unpack JSON objects in SQL Server?

Part 2 of my foray into JSON, I'd like to add a user to multiple groups: insert an JSON array into a table. Ideally, the JSON would look like this: '{ "Email": "WMogh@starfleet.gov", "...
0
votes
0answers
28 views

What is the best way to update a table from a JSON string?

I'm fiddling around with JSON and SQL, and I need to update a record based on a new JSON string. Here's what I've got, but to be honest, It seems like an awful lot of code: create procedure ...
1
vote
1answer
26 views

Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database

We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says Column mycolumn in object mytable contains type Date, ...
0
votes
0answers
32 views

String to integer pre-processing error

I have converted age [0-10), [10-20), [20-30) etc. in Azure Machine Learning to 0, 10, 20 etc. with Convert to Dataset, but when all the binned ages are converted, the Edit Metadata doesn't work when ...
0
votes
0answers
9 views

Azure Managed Instance MSOLAP OLE DB connector

We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, ...
1
vote
1answer
25 views

List user-defined schemata

If I create schemata using... CREATE SCHEMA [schema_name] AUTHORIZATION dbo ...is it possible to obtain a list of these user-defined schemata? I can see that there's an INFORMATION_SCHEMA.SCHEMATA ...
0
votes
1answer
20 views

Assigning Permission on Azure SQL Database

I have an azure SQL Database. I already created a new login and user on the database. Question is i want to assign permission on the said user. Permission that will restrict the user to drop table, ...
2
votes
1answer
54 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
16 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
8 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
39 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
23 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
22 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 ...
0
votes
0answers
18 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
81 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 ...
3
votes
1answer
66 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
51 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
83 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
83 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
19 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
18 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
41 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
29 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
23 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
39 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
46 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
31 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
76 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
97 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
98 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
121 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
51 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?