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

Cannot Change Azure SQL QueryStore Parameters

I change QueryStore parameters (such as MAX_STORAGE_SIZE_MB) on any of our Azure SQL Server managed instances. But then the parameter change back to default the next day. What could be the reason(s)?
0
votes
1answer
17 views

Copy large database from one server to another

I want to copy a database from one server to another. The source database is a geo-replicated read-only secondary. In case it matters, I want to use this as the source to avoid loading up the ...
1
vote
1answer
49 views

Reason for failed query plan executions in SQL Server

We are using Azure SQL Database and recently we have experienced a severe performance degradation on our production database. When looking into Regressed queries in Query Store to find out the ...
0
votes
1answer
21 views

OPENJSON running once per row of an INNER JOIN unnecessarily?

I have a table MP_User with 147 entries, and in order to query it, I am passing in JSON containing an array of "query objects", each of which has a unique ID and either an email address or a ...
0
votes
0answers
19 views

Scope of memory optimized table variable

I have a stored procedure Schm.tmp_Sproc where I'm using memory optimized table variable @memTableVariable CREATE PROCEDURE Schm.tmp_Sproc @user INT, @data VARCHAR(100) AS BEGIN DECLARE @...
1
vote
1answer
26 views

How to apply Static Data Masking With Replication of Database

We used to have multiple environments for applications such as Production, Staging, UAT, Dev, and Sandbox. It is a regular task for the DBA to refresh the lower (staging, test, UAT etc.) environments ...
0
votes
1answer
17 views

User cannot select from table when having SELECT permissions if CONTROL is denied

I'm setting up my database on an Azure SQL Server instance. (I know the principal names are terrible, it's just a dry run test) I created a login ("Test"), a user ("Test"), a ...
0
votes
1answer
44 views

Forced Parameterization generating duplicate plans

https://www.brentozar.com/pastetheplan/?id=H1qoS7BSu I am using Azure SQL 18 vCore db with Forced Parameterization, and MAXDOP 8. The vCore count may change much lower for other dbs but for the same ...
0
votes
2answers
28 views

How do I delete a user from the master database when the user has been deleted from the Server Logins using the SSMS Object Explorer

I am using an Azure SQL Database. I deleted some users from a Azure SQL database after I saw them mentioned in a Vulnerability Assessment report. Here's how I deleted them: Log in to SSMS Expand the ...
0
votes
0answers
19 views

Azure Elastic Job step to a privatelink sqldatabase target fails with “target principal name is incorrect” (Trust Server Certificate works in SSMS)

My first Elastic Job Agent jobstep to a privatelink sqldatabase target fails with "target principal name is incorrect." I can connect to servername.privatelink.database.windows.net and the ...
1
vote
0answers
39 views

Why is SYSDATETIMEOFFSET precision decreased on Azure SQL?

SELECT SYSDATETIMEOFFSET() When I run the query on a local SQL Server 2019 instance, I get values like this: 2021-03-24 14:32:32.5811589 -05:00 2021-03-24 14:32:37.8169216 -05:00 2021-03-24 14:32:42....
0
votes
1answer
30 views

Can SQLServer implicitly combine clustered and nonclustered index for queries that hit the NCI with a WHERE and the CI with an ORDERBY?

I recently asked a question about the best indexing strategy for a table that must record events, in order, against a GUID. The GUID is a nuisance but it's unavoidable because it's an FK to elsewhere. ...
0
votes
0answers
15 views

Azure Database for MySQL - mysqlimport command

So I'm trying to accomplish the goal of performing a mysqlimport on a Azure MySQL 8 database and I get the following error: mysqlimport: Error: 1227 Access denied; you need (at least one of) the SUPER,...
0
votes
2answers
24 views

Azure SQL Elastic Pools - When to Create a new one versus upping the eDTU?

I've tried to Google looking for others with the same question for about an hour now and can't find anything close, so hoping someone here might be able to offer some insight! I'm a many-hat admin ...
1
vote
1answer
37 views

Netezza migration to Azure Synapse - Stored Procedures?

I have looked everywhere for useful documentation that comprehensively gives me the differences between Netezza stored procedures and functions so I can find Azure Synapse equivalents. Is there any ...
0
votes
0answers
14 views

Tablesize makes no sense between enviroments

We are currently building a GatewayAPi which hold some data required to intergrate with legacy grids. This means these tables hold some bulk data until the legacy components are removed. Our database ...
1
vote
1answer
29 views

Azure SQL Database - dedicated administrator connection (DAC)

If you check the setting in any of your Azure SQL databases, you will see that the value_in_use column value is zero for Remote admin connections. Meaning ‘Remote admin connections’ are not allowed ...
0
votes
2answers
42 views

Count distinct instances of a SKU and count all items in all instances containing that SKU

This is on MSSQL/Azure SQL. I have the following Sales Table: Line_Item_ID Sales_Order_ID SKU 1 1 4 2 1 1 3 2 4 4 3 1 5 3 7 6 3 4 7 4 4 8 5 1 9 5 8 I am trying to get an output that shows ...
0
votes
1answer
52 views

Azure SQL | Granting Security Groups DB Role permissions

I am trying to grant a Security Group within our company's Azure environment that is found in Azure AD. I have successfully granted users' rights to the db_datareader, writer, owner roles. But I am ...
2
votes
1answer
36 views

Hide schemas from users in MSSQL

I'm creating a database with a few different schemas. 99% of users connect using Excel, and when they do they see all the system stuff: This just confuses the users and I would like to configure SQL ...
0
votes
0answers
41 views

Error = [Microsoft][ODBC Driver 17 for SQL Server]Unable to open BCP host data-file

I have a table in my Azure SQL database named "tablex". I want to bulk insert the content of a csv file in that table (the csv file has the same columns as tablex in the Azure DB) This is ...
0
votes
0answers
8 views

Tenant catalog pattern - logical/physical separation of catalog database

In a multi-tenant sharded database model the catalog provides the application with a way to discover which databases stores the tenant of the current interest. If you take a closer look of Microsofts ...
1
vote
4answers
53 views

Azure sql database how to track table schema change

So someone dropped a column in a Azure sql db. How to show the table schema before the change? Restore to a previous version is not a option as that would override everything.
0
votes
2answers
47 views

SqlPackage importing of very large bacpacs to Azure

I want to import a database from a .bacpac file to a SQL Server in Azure. I read the document. It says that there is a flag called DatabaseMaximumSize=(INT32). I wanted to know if there's a limit that ...
0
votes
1answer
52 views

Partition switching vs schema transfer

I'm designing a database whose data will be generated daily by an ETL. After some research, I found that one can use partition switching or schema transfer to maximize the uptime of the "live&...
2
votes
2answers
82 views

How can I query on-premise SQL Server database from Azure SQL database using stored procedure?

I have a Azure SQL database and it has a stored procedure from where I am trying to join a table which resides in on-premise SQL server database. Essentially, I am trying to query a table which sits ...
0
votes
1answer
38 views

Is the BACPAC from a TDE encrypted DB also encrypted?

If you create a BACPAC of an encrypted database, will the data in the BACPAC be encrypted? We're currently using on-prem SQL Server and use TDE to encrypt our customer databases. We also have a ...
1
vote
1answer
28 views

Delayed or Asynchronous DML Trigger Execution

I have created a DML trigger (AFTER INSERT, UPDATE, DELETE) on a table Trigger's logic takes about 30 seconds to execute So if you change even 1 row, it takes ~ 30 seconds due to trigger execution ...
0
votes
1answer
14 views

Contained User on View - Select permission denied on object 'table1', database 'Database1', schema 'test'

As an example, I have a database called 'Database1' on Azure SQL Server 12.0.2000.8 I needed to setup an account that could only access a view in the database (eg. View1). This was achieved by the ...
-2
votes
2answers
59 views

Cost of reading and sorting 10GB table at cloud providers [closed]

Say I have a 10 GB table and I need to read it and then sort it by some column. How much does such an operation cost at cloud providers, say AWS or Azure if the pricing is variable? I just need a very ...
0
votes
0answers
30 views

Auto running SQL script with Azure database server

I am trying to automate a report that is generated from the database on Azure database server. I am using below script in the batch file but I get the error. Script: osql -U firstname.lastname@company....
0
votes
1answer
70 views

Should I provide db_owner principal role to the user of the Azure SQL of my Azure Web App?

I have an Azure Web App connected to an Azure SQL database. Let's call the app ACME. The application has it's own Role and User called ACME, and I gave that User db_owner principal roles. The ...
0
votes
0answers
28 views

How to migrate SQL2014 to Azure SQL in short time (scripting)? [duplicate]

Context: The new application is ready to be used (Azure SQL). The old application is still used (MS SQL 2014). The switch from the old to the new is to be done during one night. The size of data is ...
9
votes
2answers
775 views

Should I drop dbo from the database role db_owner?

I did a Vulnerability Assessment for my database today. I found VA2108 and it suggests me to ALTER ROLE [db_owner] DROP MEMBER [dbo] But it's the default setting of any SQL instance. Should I go for ...
0
votes
2answers
29 views

Compatibility levels and reported engine versions

I'm seeking a bit of clarification around SQL Azure versions and upgrades. Upon trying to use some specific functionality it came to my attention that the compatibility level of the database was 100 (...
-3
votes
1answer
62 views

sp_blitz script not working on Azure sql database [closed]

sp_blitz script not working on Azure sql database Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 3] Reference to database and/or server name in 'master.sys.all_objects' ...
4
votes
1answer
48 views

sys.dm_tran_version_store_space_usage reports always zero space used

I was learning about RCSI when I discovered something strange on Azure SQL Database. The DMV sys.dm_tran_version_store_space_usage always reports 0 as the space used by the version store, even if I ...
-1
votes
1answer
42 views

Creating contained users for Azure SQL Database

What's the difference between these two commands? CREATE USER abc FROM EXTERNAL PROVIDER CREATE USER abc FOR EXTERNAL PROVIDER
0
votes
2answers
29 views

Vertical Elastic Query is not identifying Object

I did create an External Datasource, identical to the guide described here https://www.sqlservercentral.com/articles/cross-database-queries-in-azure-sql-database .The process is pretty simple, so just ...
0
votes
1answer
24 views

SQLBulkCopy & InMemory tables

helping out on a project where the data loading is done using C# & SQLBulkCopy to normal rowstore tables - does anyone know if there are any issues or gotchas with continuing with SQLBulkCopy but ...
0
votes
1answer
42 views

Trying to work out how to escape a hyphen in an XML Tag in Azure SQL Analytics

working with Kusto / KQL to try and parse the deadlock xml in Azure SQL Analytics and getting stuck with escaping the tag name process-list as follows So the deadlock xml looks like <deadlock> ...
0
votes
1answer
58 views

Azure SQL Database Pricing: Standard vs Premium tier [closed]

I was checking pricing for Standard tier and Premium tier concerning Azure SQL Database and I am a bit confused: Knowing Standard tier has 1-4 IOPS per DTU and Premium tier has 25 IOPS per DTU (doc), ...
-4
votes
1answer
19 views

Parameterization in SQL Server [closed]

I am struggling on understanding the need of Parameterization in SQL Server. I read, there are two types of parameterization but didn't understand its working and what are it effects on SQL Server or ...
1
vote
1answer
92 views

issues updating records in ssis using lookup and oledb command

im working on an ssis project loading data between two sql azure databases that is updating matching records and inserting new records between them using a lookup and ole db command but I'm getting an ...
0
votes
2answers
42 views

In what range can you expect a cloud based Sql Server data reading in mb/s? [closed]

Say everything is optimized, queries are simple, indexes are good, etc. Should a SQL (Azure) database where you spend about 150 to 300 euros per month easily handle data reading with about 250-500 mb ...
0
votes
1answer
17 views

is the only way to create a user for an azure database, to use SQL query?

Azure databases are contained databases (right?) then I need to use this to create a user: CREATE USER UserName WITH PASSWORD = 'hardPass'; ALTER ROLE [db_owner] ADD MEMBER UserName ; is there a way ...
1
vote
1answer
450 views

azure db export to blob storage failed

i am trying to simply export BACPAC file from azure db to azure blob storage as mentioned here : https://docs.microsoft.com/en-us/azure/azure-sql/database/database-export but it is failed with error : ...
0
votes
1answer
33 views

Generate script for all stored procedures in Azure SQL database

I'm trying to create a SQL script that will create all the stored procedures that were exported from another database. Basically navigating in SSMS to the database > Generate Scripts > select ...
0
votes
1answer
70 views

Cross Database Query between Azure SQL Database and SQL Server Database

Can we built a Cross database query for Insert, Update and Delete between SQL Server and Azure SQL DB and vice versa?
0
votes
0answers
172 views

Azure SQL Server export via sqlpackage produces Error SQL71501 (Unresolved reference to object MS SyncAccount

I have an Azure SQL Server database with a Geo-replication on Azure, which I would like to regularly backup via sqlpackage.exe (s. command below) using the replicated read-only database. However, when ...

1
2 3 4 5
15