Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
2
votes
1answer
26 views

How to determine MAXDOP setting when using DTU in Azure SQL

I have previous experience of setting MAXDOP settings for on premise OLTP & OLAP servers when you know the number of cores at your disposal. e.g. if I knew I had 16 at my disposal I'd set my ...
0
votes
0answers
37 views

Does SQL server support an in-built mechanism to copy a row to a log or history table when it is updated?

Is there an in-built mechanism that copies a row to a log or another table when it is updated. Or is the only option to write a custom trigger on update.
0
votes
0answers
14 views

Group by with no aggregation expresssion is not supported

I need help i am getting an error to the following query on azure sql. SELECT illuminance as illuminance, temperature as temperature, (select to_char(sysdate,'DD/MM/YYYY HH:MI:SS AM') ...
0
votes
0answers
26 views

How to find the MAXSIZE for user databases from a connection to master in Azure SQL Database?

While it is simple enough to SELECT DATABASEPROPERTYEX(@DatabaseName, 'MaxSizeInBytes') when connected to a user database, I have been unable to find how to get this information for all of the ...
2
votes
2answers
47 views

Is DB mail supported on SQL Server hosted on Azure VM (IaaS)?

Is DB mail present in SQL Server hosted on Azure VM (IaaS)? If DB mail is not supported, then what are the features available?
2
votes
1answer
47 views

Azure SQL: Azure SQL Database traffic migration to newer Gateways

I have been assigned a task to look at this: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-gateway-migration. I got an email about it: I have a pretty standard setup, with a Azure ...
1
vote
1answer
19 views

How To Fix High DTU Usage on Specific Query

I have a query that runs every few seconds on a Microsoft SQL Azure Database. It is from a web job that checks if there are actions that need to be done based on rows in a specific table (its a ...
0
votes
0answers
23 views

Dynamic script to alter a column type having an index

I am writing a script to update the datatype of a column in SQL Server on a list of tables, if the existing column are not yet of the desired type. The column should be converted from a VARCHAR to a ...
0
votes
0answers
14 views

TCP Provider, error: 40 encountered during a first time usage of Azure Data Studio on macOS Mojave

I've newly installed Azure Data Studio on macOS Mojave and tried to connect to the database which is the first login screen that opens upon opening the application. I've watched videos online ...
0
votes
1answer
31 views

Is a Clustered Index Scan bad for performance?

I have a complex query (see below) which performs badly on a large database. I'm now analyzing the query by removing the joins, look at the actual plan and step by step add the joins back. I see ...
0
votes
0answers
16 views

Find DB principals accessing a table in Azure SQL

My use case is as follows: A table in my database is accessible by application A, B, C, etc each of whom has their own database principal. We want to start limiting the principals that can access ...
0
votes
0answers
12 views

Azure Sql database AAD user not getting created

I need to create an AAD user for a Windows security group that was recently synchronised with Azure AD. This security group has spaces in its name. I am using the below SQL script but it keeps ...
0
votes
0answers
98 views

Import bacpac containing security policies and temporal-tables with schemabinding

I've created a bacpac backup of my database (both Azure and local with SSMS). Trying to import the bacpac to same or another machine (again both Azure and local) the import always fails with this ...
1
vote
1answer
19 views

Creating my first Elastic Database Job on Azure

On https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview it says that there is a new replacement for SQL Agent. However, I cannot get it to work. I had problems ...
1
vote
1answer
34 views

Azure SQL - dataspace used vs max dataspace

I have a single Azure SQL database in Azure with the following database data space As I read the documentation: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management ...
0
votes
0answers
37 views

Azure SQL Database Locking/Blocking

Environment: Azure SQL Snapshot Isolation: Off Read Committed Snapshot: On We're currently encountering SQL blocked calls on all tables when running an Update statement, not just the tables being ...
0
votes
1answer
22 views

Can we migrate Azure SQL Database's objects to In-Memory OLTP?

Can we migrate Azure SQL Database's objects to In-Memory OLTP? IF yes then how to perform this step by step?
2
votes
1answer
62 views

Azure Managed Instance - Is it possible to send Sql Logs To Log Analytics?

Is it possible to stream a Managed Instances SQL logs into log analytics? I need a single location for all Azure based monitoring so that multiple teams have visibility/access to log information for ...
1
vote
0answers
43 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
0answers
63 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
23 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
66 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
24 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
15 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
16 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
57 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
25 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
45 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
29 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
19 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
28 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
48 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
62 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
143 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
13 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
15 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
48 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
118 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
25 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
53 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
28 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
29 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
36 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
15 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
84 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
83 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, ...