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
1
vote
0answers
28 views

Remove DTC Support From SQL Server 2016

My application is running in Azure SQL which doesn't support DTC. We only use Azure SQL in upper environments. In the local development environments, we're still using SQL Server 2016. I want to ...
0
votes
1answer
23 views

Fastest method to export bacpac file from Azure SQL database

I am aware of all the methods and have used it before. While now we have a 10GB database which we need to export.Which method would take the least duration. Using SSMS Export data-tier application ...
0
votes
0answers
20 views

Importing BACPAC file from azure to SQL creating an empty database

Exported Data-Tier_application from an Azure database to create a BACPAC of it. SQL editions I'm trying to use to import the BACPAC: SQL Server 2016 express. SQL Server 2017 Developer ...
0
votes
2answers
17 views

Azure Database Link to another Azure database

How to query between two databases with the same server in SQL Database? Currently we are aiming to link two azure databases that will update simultaneously. Thanks!
1
vote
1answer
28 views

Incorrect “Sensitive data columns should be classified” report

Every week I'm getting a failed "Vulnerability Assessment" email report from my Microsoft Azure SQL Database that is incorrect. It complains about columns that have is_computed column in sys.columns ...
1
vote
0answers
19 views

Syncing On Prem SQL Server with Azure SQL

We have a SQL 2016 instance running production systems at a pretty healthy load within AWS. On top of this we host instances of production databases in Azure for PowerBI and analysis usage. At ...
0
votes
0answers
13 views

Modeling tabular structure in MSSQL to store data like Excel sheet applying Column inheritance

I've created this database structure to store tabular information (it's a simplification of my real structure but enough to show the point). In it I have Sheets and each Sheet can define different ...
1
vote
1answer
12 views

How To Grant View Definition of Object in SQL Azure

The tsql syntax throws an error about "view" in SQL Azure, but functions on SQL Server: GRANT VIEW ON OBJECT dbo::foo TO [bar] Can access be granted in SQL Azure to view the definition of an object ...
2
votes
1answer
26 views

Cannot set READ_COMMITTED_SNAPSHOT to OFF on Azure SQL

Me and my team are trying to use Azure SQL for our development environment and ran into some critical and unwanted differences in locking behaviour to our production environment. The main problem is ...
1
vote
0answers
19 views

What would be an appropiate BatchSize for bulk insert 34 GB of data (JSON files) into SQL Azure?

I got like 25,000 JSON files whose size (in average) is 1.2 MB (also, the average of records per JSON is 5,000), and the total size is like 34 GB. I have been reviewed the BCP utility from SQL Server, ...
0
votes
0answers
36 views

Azure SQL Data Sync: How to Increase Synchronisation speed after bulk purge/update in Azure SQL Data Sync Service?

I have two tables across two regions in Azure SQL Databases. There is a Bi-directional Data Sync configured between those two databases with automatic frequency of 15 minutes and conflict resolution ...
0
votes
1answer
28 views

Update unpivoted table with one to many relation

Imagin you have a main table like that DECLARE @ExistentData TABLE (ID INT IDENTITY(1000,1), [Row] INT, [Col] INT, Val NVARCHAR(50)); INSERT INTO @ExistentData([Row], [Col], Val) VALUES (1,10,'Value ...
2
votes
1answer
16 views

SQL Replication - Specify Schema on destination Table

wondering if it's possible to replicat into a different schema using Transactional Replication? My situation is that I have 3 DB servers, each hosting it's own instance of our software, in three ...
0
votes
0answers
7 views

Add SQL Server Level Login in master Database using Visual Studio 2019

I'm trying to add sever login in Azure SQL Server using Visual Studio 2019 SQL Project with SSDT and deploy it using Azure Devops by building CICD pipeline. The rest database object (e.g. tables, ...
0
votes
1answer
26 views

Azure SQL - Setting up permissions for users

I'm busy playing around within Azure SQL and have setup replication from my on-prem DB to the Azure DB for some reporting. I would like to ensure as part of this we setup the security correctly. In ...
1
vote
1answer
46 views

Why can members of db_datareader SELECT sys views

In SQL Azure my understanding of db_datareader is that it is allowed to SELECT all user tables. I couldn't find a definition of exactly what a user table is, but I assumed it was all of the non-...
1
vote
1answer
60 views

Is there any reasonable way to determine what executed a query?

I have an S3 SQL Server database in Azure, and I'm having an issue with a specific Entity Framework generated query and how often it is being run. As the numbers below show, I'm getting 160K+ ...
2
votes
2answers
60 views

Restore DIfferential backup on azure managed instance?

I am migrating my database from on-premise to Azure managed instance. In order to move the database I'm using the organization weekly full backup, and I am asking them to take a diff after they take ...
0
votes
1answer
12 views

What's best practices for changing a user's email in an application?

I'm working on a crud for an email application, and I'd like the ability to change "everything". Right now, however, it matches the JSON string to the Database based on the email address. Problem: ...
0
votes
0answers
10 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
44 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
58 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
25 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
23 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
42 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
23 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
27 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
33 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
11 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
30 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
57 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, ...
1
vote
0answers
57 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
11 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
52 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
24 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
32 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
85 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
74 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
18 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
57 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
85 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
8 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
135 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
23 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
21 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
54 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 ...