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).

152 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
2k views

SQLPackage : Import or Export SQL Azure BACPAC without users

I know how to use SQLpackage.exe. I can export from SQL Azure and create a bacpac. I can also Import to SQL Server via SQLPackage.exe. I want to export or import without the users in the database. The ...
5
votes
1answer
2k views

Export sql azure DB as bacpac file without including data for certain tables

When I export a sql azure database as data tier application from sql server management studio I get the option to tick off certain tables but then these tables are not included in the resulting file. ...
4
votes
0answers
187 views

Azure SQL DB migration from Visual Studio raises collation error

I want to run a migration in my Azure hosted database. The migration works perfect in several local machines. When I try targeting the Azure database it raises the following exception: Column X is ...
4
votes
1answer
1k views

SQL Server data files in Windows Azure: filegroups and partitioning still applicable?

I just created a database using the new functionality "SQL Server 2014 data files on Windows Azure" and this works quite well. However, I have a table with a billion records and in our local ...
3
votes
0answers
36 views

SQL Azure HashBytes performance - recent degradation/variability

[copied from S/O since it was closed as 'not a programming question'; hoping the community can help me here...] Up until a few days ago, T-SQL code we have running in SQL Azure that generates an MD5 ...
3
votes
2answers
107 views

Permission hierarchy vs. WITH GRANT OPTION

I have an Azure SQL database with this security setup: SchemaUpdater user with db_ddladmin, db_datawriter, and db_datareader roles. The user is used to execute database change scripts during ...
3
votes
3answers
381 views

Permission error when using sys.dm_exec_input_buffer with @@SPID

When I run this blob of SQL on SQL Server 2016 or an Azure SQL DB: --hello world SELECT event_info FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_input_buffer(req.session_id, req....
3
votes
1answer
2k views

How do I run a long-running stored procedure on SQL Server, even if I get disconnected?

I have a stored procedure in an Azure SQL Database that does not return a result and can take several hours to run. It takes one parameter, and I am running it through the query editor window in ...
3
votes
1answer
99 views

Determine minimal permissions required for a given SQL script or session

For security reasons I need to determine minimal permissions required for a given script or session without having to manually audit activity then work it out by hand. I'm assuming this can be done ...
3
votes
1answer
2k views

Is it possible to use cross database queries in both Azure and SQL Server 2016?

I'm working on a project that is designed to run on Microsoft's Azure platform. At present we have a few developers working locally on their own machines with the intent of being able to publish the ...
3
votes
0answers
335 views

How to set minimal permissions to change SQL Azure Firewall rules

I have a desktop app that connects to SQL Azure database. Some users have dynamic IP addresses, and it is not possible to get them to use fixed addresses. I've written an ASP.NET page hosted on the ...
3
votes
0answers
194 views

How do I back up and restore a SQL Azure database?

How do I back up and restore a SQL Azure database? For that matter, how do I back up and restore an entire Azure account? Let's suppose I am working at a company and I buy a 3 month trial account ...
2
votes
0answers
34 views

Migrate Mysql to Azure Sqlserver db

I read some articles and also tried SSMA, linked server and other things, but not help. I have one client's mysql Db (later we need other too) in my local pc and have Azure DB which used for SAAS-...
2
votes
1answer
38 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 ...
2
votes
0answers
106 views

Partitioning Help Needed for Azure SQL

Myself and some peers had some discussion about the approach for an issue regarding the care and feeding of a very large table in a Azure SQL database. I understand that the main issue they are trying ...
2
votes
0answers
152 views

When sys.dm_db_index_usage_stats is cleared in Azure SQL Database

In my solution I need to check when there where some last change done in table/index to determine data freshness. I'm using Azure SQL Database and the best option (and maybe the only one without ...
2
votes
1answer
44 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 ...
2
votes
0answers
1k 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 ...
2
votes
0answers
41 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 ...
2
votes
0answers
60 views

Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?

Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle? What if the publisher database is in PostgreSQL? If ...
2
votes
0answers
242 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...
2
votes
0answers
219 views

Is there a way to programmatically get the version of a .bacpac file without unzipping and inspecting the xml?

The situation is that we get a copy of the latest production bacpac, then restore it locally when setting up our dev environment. During the setup, we do an explicit check for the DacFX dll but target ...
2
votes
0answers
213 views

Help in understanding how to avoid a page-level deadlock

I have the following deadlock xml <deadlock> <victim-list> <victimProcess id="process9b7ade24e8" /> </victim-list> <process-list> <process id="...
2
votes
0answers
113 views

Backup or export Azure SQL Database with Row-Level Security

I'm having difficulties exporting a Sql Azure database using Row-Level Security. When using the Export method the following error occurs: Error encountered during the service operation. Could not ...
2
votes
0answers
2k views

Something similar to GENERATED ALWAYS for a DEFAULT? (SQL Server / Azure SQL)

Question: Is there any way to force a column to always use the default value definition? I would like to always have the user_id populated on an insert/update (I know delete might be a bit different) ...
2
votes
0answers
207 views

Stage database in SQL Azure

I am designing a data warehouse using Azure Databases (not Azure Data Warehouse though), I have 2 databases: the main data warehouse and a staging database. As in a traditional ETL process, the raw ...
2
votes
0answers
763 views

Connection to Azure SQL from Java

I try to connect to Azure SQL with MS JDBC driver: import java.sql.*; public class ExampleSQLJDBC { public static void main(String[] args) { // Setting. String connectionUrl = "...
2
votes
0answers
549 views

Unable to use select top N shortcut on Azure SQL Database via SSMS

Yesterday morning I was able to query my Azure databases via SSMS and the Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the ...
2
votes
0answers
82 views

Create multiple databases dynamically in Microsoft Azure

I am a newbie in Microsoft Azure platform. I want to create multiple databases dynamically (We are developing multi-tenant model. So, Each organization should have their own database. Whenever an ...
2
votes
0answers
72 views

Azure SQL: Unexplainable Database size

Last month we upgraded our Azure database from Business to S1 plan. S1 plan was chosen based on an article on MSDN giving guidance on how to choose the best plan for us. Also, Azure by itself ...
2
votes
0answers
141 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
1
vote
0answers
48 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....
1
vote
0answers
42 views

What is the current recommended way of changing the collation of an Azure SQL database?

We would like to switch to using the Latin1_General_100_CI_AI_SC_UTF8 collation in our Azure SQL database. Altering the collation of individual columns aside, if this were on-premise SQL Server 2019, ...
1
vote
1answer
44 views

Why Azure SQL Server table used space is too high?

I have two tables in my SQLServer database (azure managed), and the structure of two tables as below (for easy reference renamed them) dbo.TABLE1 CREATE TABLE [dbo].[TABLE1] ( [ID] ...
1
vote
1answer
164 views

What would cause an elastic pool to exhibit high “Sql Server process core percent” metricsj, but low DTU / CPU

Backstory: We have an azure sql elastic pool with several databases in it and around 750GB of data. We've been having some sporadic outages which correlate with the metric "Sql Server process ...
1
vote
0answers
36 views

Secure connection strings to a Azure MSSQL server

Forgive me, because I'm playing monkey-in-the-middle here. I write data migration systems. A customer has their data in a private MSSQL DB that is managed by a 3rd party. The 3rd party agreed to send ...
1
vote
0answers
35 views

Shrinking 150 TB data warehouse instance is feasible option?

We are using azure SQL data warehouse(azure synapse analytics) with size of 150 TB among which 75 TB is used and we are planning to shrink database with help of MS. What are the challenges should we ...
1
vote
0answers
12 views

Elastic queries with encrypted columns in tables using symmetric keys

I have elastic queries running cross-subscription for everything except tables with encryption. Now I need to tackle tables that are encrypted. How (if at all possible) do I open the keys on the ...
1
vote
3answers
565 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
0answers
398 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
0answers
142 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 ...
1
vote
0answers
60 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 ...
1
vote
0answers
370 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, ...
1
vote
0answers
455 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 ...
1
vote
0answers
39 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 (...
1
vote
0answers
403 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
0answers
56 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 ...
1
vote
1answer
75 views

FILEPROPERTY not working over linked server to Azure SQL Database

FILEPROPERTY (Transact-SQL) is not working with a linked server pointing from a on-Premise SQL 2017 to a Azure SQL Database. I see the following comment in books online: Returns NULL for files that ...
1
vote
0answers
75 views

Where can I find the failover history for an Azure SQL Database with geo replication?

We have an Azure SQL Database that is geo replicated to another region. I suspect that they have swapped which is primary and which is secondary and would like to find information about when that has ...
1
vote
0answers
453 views

Improve parallel running of bulk copy insert and stored procedures

I have a Java message listener, which upon receiving a message starts bulk inserting thousands of records into a table. After that it calls a few stored procedures sequentially that make some updates ...