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
4 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
41 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
36 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
45 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
68 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 ...
1
vote
2answers
2k views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
0
votes
1answer
29 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
23 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
13 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
2k views

Is it possible to log ship from on-premise SQL server to Azure SQL Managed Instance?

From the docs, it would seem that restoring a full database backup file is possible, but can one also restore transaction logs? (the idea is to minimize downtime in a migration from on-prem to MI). ...
2
votes
1answer
218 views

Developing an Azure Sql Database backup strategy [closed]

I know Azure databases are backed up and kept for a retention period, which I believe the default is 30 days. I'd like to come up with a plan to mimic our current strategy with a physical SQL Server ...
3
votes
2answers
244 views

SSRS Azure SQL Database Active Directory - Universal with MFA

Does anyone know when support for Active Directory - Universal with MFA will be included in Reporting Services? It's available in SSMS. Visual Studio 2017 Data Source Properties Reporting Server ...
0
votes
1answer
233 views

How to create multiple azure sql database in an elastic pool using powershell script?

I want to create a sql server and deploy the elastic pool on that server. Then create multiple azure sql database in that elastic pool using powershell script.
-2
votes
2answers
57 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
1answer
35 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
29 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
293 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 : ...
1
vote
1answer
160 views

Transfer data from the cloud to a local database [closed]

I have an SQL Server 2016 Azure database in the cloud called XCLOUD, with many tables big and small, and a local SQL Server 2016 database with the same tables and data called XLOCAL. In all databases ...
0
votes
0answers
27 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 ...
7
votes
2answers
457 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
28 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
1k 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
52 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' ...
0
votes
1answer
463 views

Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors

I'm trying to import a .bacpac created from SQL Azure into a SQL Server 2016 server that has no existing databases beforehand. It will run but run into issues such as: Unhandled Exception: ...
4
votes
1answer
42 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
37 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
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 ...
0
votes
2answers
25 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
23 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 ...
1
vote
1answer
1k views

MySQL Workbench Unable to Connect to Azure Databases for MySQL

When trying to connect to a MySQL database in Azure I get the following error: ERROR 2026: SSL connection error: socket layer receive error At first I thought it was a firewall/security issue but ...
0
votes
1answer
29 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> ...
1
vote
2answers
491 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 ...
3
votes
2answers
82 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 ...
0
votes
1answer
42 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
58 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 ...
3
votes
3answers
354 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....
0
votes
2answers
38 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
13 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
61 views

encrypting live data in SQL Azure

We are using webjob in azure which imports data every 2 hours into the tables I've created in the cloud. As I read it from here, I can encrypt the db very easily using azure TDE feature. But I am ...
0
votes
1answer
29 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
52 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?
1
vote
1answer
123 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 ...
0
votes
0answers
102 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
vote
1answer
76 views

Is it good practice to have relationship between the tenant table and all other tables in a multi tenant application?

I am developing a multi tenant SaaS that uses Azure SQL for data storage. I make use of sp_set_session_context to make sure that any query only touches records relevant to the current tenant. I ...
0
votes
0answers
53 views

Azure SQL Db to DB2 Sync

I need to automatically synchronize changes made in an Azure SQL database to our DB2 system. Whenever a change is made in Azure, DB2 should also be modified. Azure DB creation is not started and ...
7
votes
6answers
861 views

Are duplicated NVARCHAR values stored as copies in SQL Server?

I'm designing a table that will contain a lot of rows. So need to be careful not to store to much information. One of the columns is a NVARCHAR(MAX) column and it contains the address of our customers....
6
votes
2answers
222 views

Identifying Unused Indexes on SQL Azure

I have a large SQL Azure database (P6 nearing 1TB in size). I want to do a cleanup/removal of any unused indexes. For the past 30 days, we've captured the 2 following sets of information. See: https://...
1
vote
1answer
51 views

Need Help Normalizing a Database for Media Website

I've created a media website where visitors can watch trailers, view pictures, etc. Along the way, I've found that I've needed additional images for sharing, etc. I went the "easy" route and ...
1
vote
1answer
610 views

Azure Sql Server VPN connection

I saw a couple of questions already submitted 1 or 2 year ago, without a clear answer. I'd like to know if I can connect my private Network, or whatelse to an Azure Sql Server. Point-to-Site VPN I'd ...

1
2 3 4 5
15