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

Indexes not appearing in sys tables on Azure Secondary

I'm running the following query on an AZure SQL Read Only secondary to determine which indexes are being used. But some of the indexes are not being returned in the query. I must be missing something ...
1
vote
1answer
13 views

Azure SQL Database vs. error 8152 enhancement

How can I take advantage of the enhancement for error 8152 (https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/) in Azure SQL ...
0
votes
1answer
16 views

SQL Server Full-text search for keywords without prefix matching

I have the following text in my NVARCHAR column "Ich bin eine SuperbProdukt" I have a full-text search enabled on the column and I can search for it by executing the following query that I wrote :...
3
votes
2answers
217 views

Rolling back truncate table

I have a stored procedure that does the following: BEGIN TRANSACTION -- Code to delete updated records from production (dbo) table DELETE FROM [dbo].[factMyTable] WHERE exists (SELECT * ...
0
votes
1answer
20 views

Change Azure Standard to Premium

I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day. Would talk know if I need ...
1
vote
1answer
31 views

Difference between SQL Server Azure and SQL Server 200x

I'm a SQL Server DBA and I can understand the logic behind logins users roles and etc ( login for server access, user for databases and etc ). I've asked some questions here but I think I need to ...
0
votes
0answers
44 views

Question about data type to hold large number

I have a line of data that store on Microsft SQL Server 13.0.4 in numeric(32,16). It looks like this 9642327391274.0000000000000000 I try to migrate that database table to another on Azure SQL ...
1
vote
1answer
34 views

Login failed for user when trying to connect to Azure Postgre database from MSSMS [closed]

I created a database on Azure but can't log to it with MSSMS. I always have the Error 18456 even if I followed this tutorial. TITLE: Connect to Server ------------------------------ Cannot connect ...
0
votes
1answer
27 views

deleting small number of rows hangs in tsql database

So I'm just trying to delete some bad data from a one of our test databases. I've identified the rows to be deleted, and have written a simple query to handle this. However, when run, the query ...
0
votes
1answer
17 views

How do you detect whether you have permission to query sys.dm_os_performance_counters?

According to the sys.dm_os_performance_counters documentation: On SQL Server, requires VIEW SERVER STATE permission. On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission ...
1
vote
2answers
56 views

How do you get the default compatibility level in Azure SQL Database from T-SQL?

In on-prem SQL Server you can check the server version and multiply by 10 to get the maximum compatibility level supported by the server, or check the compatibility level of the model database to get ...
1
vote
1answer
34 views

Azure Sql Serverless Vs Basic Tier [closed]

Does anyone have experience of moving a database from an Azure SQL Basic, or Standard tier, to Serverless? I'm currently investigating whether to do this for our development, UAT and staging ...
2
votes
0answers
148 views

RequestError: Connection lost - read ECONNRESET

I am new to Microsoft SQL Server, please advise. I am receiving the following error message when I deploy code into my development environment (which is hosted on Azure using Node.js (version 10) and ...
0
votes
1answer
37 views

I'm not understanding the concept of login/user on Azure [closed]

So as a SQL Server DBA, I can normally create a user, then inside the database U just create a login pointing to that login and then I give the necessary privileges. I'm trying to understand the ...
1
vote
2answers
72 views

Azure SQL Server Trigger Not Firing

Using Azure SQL Server, on a managed instance (i.e. a single server running multiple databases, where the db in question is one of them). I've created a trigger on INSERT to table A, that performs an ...
2
votes
1answer
45 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
38 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
15 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
60 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
68 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
53 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
30 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
25 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
42 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
34 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
17 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
13 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
127 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
2answers
34 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
77 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
76 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
29 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
129 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
46 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
168 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
31 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
107 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
27 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
16 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
22 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
135 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
26 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
62 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
20 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
11 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
29 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
51 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
64 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
224 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 ...