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
7 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, ...
7
votes
2answers
285 views

Online Index Rebuild of large table takes exclusive lock

I'm trying to rebuild the clustered index of a large table (77GB) on Azure SQL Database. There is high concurrent transactional activity on the table so I'm using the ONLINE=ON option. This has worked ...
-5
votes
0answers
16 views

i'm problem with my registration page [closed]

the registration page it has four registration pages the last page where they will submit bottom it is still give the below error message Warning: mysqli::__construct(): (HY000/1045): Access denied ...
0
votes
1answer
24 views

Azure SQL database DTU compute utilization maxing out

I have an Azure SQL database that has gone from a low DUT baseline between 0-3% (avg) to now maxing out at 100% utilization. This is for a LOB application and we need to understand what is causing ...
0
votes
1answer
448 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: ...
1
vote
1answer
200 views

Copy Azure Hyperscale DB

I show there was a question since 1 year ago with no answer. I have the same question now, in this new year 2020. I need to copy an Hyperscale DB to another server in the same region/location, (the ...
4
votes
1answer
161 views

Copy SQL Azure Hyperscale

I wanted to try SQL Azure Hyperscale, after I selected it seems I no longer have the option to move out of it. If I try, I get this message "databases cannot be moved out of hyperscale tier". The ...
0
votes
1answer
49 views

Azure SQL database query performance degradation

I have a Azure SQL database (compatibility level = 150). I'm running into a performance problem executing a database query. So after I've rebuilt all my indexes, the query runs fast. When testing, ...
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
0answers
13 views

SQL Server Persisted Computed Columns, Issues during Mass Insert or Update?

I have a database with a computed, persisted column which validates columns, checks if its an integer, and converts. Sometimes streetnumber is alphanumeric, like 5C, other times it's simply an integer....
1
vote
2answers
63 views

Best practices for providing PHI/PII data to users in organization

I am looking for best practices for how to share data from a SQL Server database that contains PHI/PII to individuals that cannot view PHI/PII. In short, we maintain a SQL server database that ...
0
votes
0answers
17 views

Hybrid SQLServer 2019 Availability Group [closed]

does anyone have experience with Hybrid AGs with Azure SQL? I want to have 2 replicas on prem and 1 on Azure. Is there an actual possibility with SQL Server 2019? On that tutorial the will be expanded ...
1
vote
2answers
53 views

Multiple Indexes and Tuning

I'm utilising Azure SQL Database 2019. Let's say I have columns A-F and the following indexes. Primary Key (clustered): A Index 1: B (ASC),C (ASC) Index 2: B (ASC) If I wanted to run run the ...
10
votes
5answers
710 views

string or binary data would be truncated in table '******', column '******'. Truncated value: '******'

One of our applications report on error message 2628: string or binary data would be truncated in table '******', column '******'. Truncated value: '******' instead of String or binary data would be ...
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 ...
1
vote
2answers
351 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
2k views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
1
vote
1answer
37 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
22 views

Syntax error in adding a job step in Azure SQL Job Agent

I am inserting a job step in Azure Elastic job agent. This is my code: EXEC jobs.sp_add_jobstep @job_name='Sample T-SQL', @command=N' declare @columns varchar(max) select @columns = stuff(( select '],[...
0
votes
1answer
34 views

Alternative methods for client data integration (Azure SQL Database)

I have an application that ingests data from clients on a daily/weekly basis (two different data sets, one daily and the other weekly) into a SQL Azure Database. The clients' data source depends on ...
4
votes
2answers
9k views

Bacpac Import fails with error 'The Element or Annotation class SqlDatabaseOptions does not contain the Property class CatalogCollation'

I want to restore some production azure database on my local machine for development purposes. So I exported the production database to a .bacpack file & downloaded that file on local. Now I am ...
7
votes
4answers
954 views

Experiencing CLR error on SQL Azure DB

Out of nowhere we started seeing this error and it seems to occur fairly frequently when making calls to the database or any other database in our Elastic Pool. The DTUs aren't being maxed out and the ...
0
votes
1answer
53 views

Update large table with millions of rows in Azure SQL Server, in Parallel

We have a large ProductOrders table with many rows, and plan to update it. The table has range of ProductType Ids from 1-1000. Table has around 2 million rows, 15 columns. Common ProductOrders table: ...
0
votes
0answers
20 views

How many tempdb data files required for this

you have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.you scale up the virtual machine has 16 vCPUSs and 64 GB of ...
1
vote
1answer
41 views

Execution plan of on-premises sql server and Azure sql server is not the same

I've been having some problems with moving databases from on-premises (2014 sql server) to Azure sql server. It's using the exact same database structure and data, but for some reason the query uses a ...
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 ...
-1
votes
1answer
22 views

Create store procedure to disable and enable indexes

I have two below queries to, first of all, disable indexes and in another query enable them. Here are my queries --Disabling indexes DECLARE @my_sql2 NVARCHAR(200); DECLARE cur_rebuild CURSOR FOR ...
1
vote
1answer
47 views

High WRITELOG wait on Azure SQL Database

My WaitStats analysis of our Azure SQL Database is showing WRITELOG and HADR_SYNC_COMMIT as counter the highest wait. This is a Premium 250 eDTU resource. Script SELECT TOP (10) wait_type, ...
0
votes
1answer
149 views

Migrating Azure SQL database to Azure sql Managed instance

What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible 1) Azure migration service - Not supporting azure sql ...
3
votes
3answers
299 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....
-2
votes
1answer
22 views

What are some good SQL Server Performance Metrics from System Views?

I am working on a project where I need to collect as many SQL performance metrics as possible, all from system views. I currently have collected, and in parenthesis the system view from which I have ...
0
votes
0answers
38 views

Select Changed Rows in MySQL and Postgres without Timestamp column

I have the following scenario: I have 2 source systems, one running Postgres, the other running MySQL. An ETL process (using Azure DataFactory and Azure Integration runtimes) runs the Extract for a ...
3
votes
2answers
51 views

Can't connect to Azure SQL with error 18456

I'm trying to grant access to my Azure SQL database (on an elastic pool) to an external developer using SQL Authentication. In the database (not master) I ran the following commands: create user [...
0
votes
1answer
278 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
vote
1answer
127 views

SQL Server Web transaction replication to Azure SQL

In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution In attempting to ...
0
votes
2answers
224 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!
10
votes
1answer
487 views

Cardinality estimation on tables with large cardinality variance between keys

Context I have stumbled on an issue in SQL Azure where the Sort-operator is spilling over into TempDB due to poor row estimates. We are querying a master table that is joined with a number of detail ...
0
votes
1answer
25 views

SQL Server Linked Server to Azure SQL using Azure AD

I am trying to set up a linked server from an on-prem SQL Server to an Azure SQL instance. The Azure SQL instance uses Azure AD for authentication. When we attempt the connection we get this error ...
1
vote
1answer
37 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
43 views

Azure tempdb filling up while trying to convert a large table to columnstore… how to mitigate?

I have a large reporting table (approx 6B rows) taking up roughly 400GB of storage on an azure sql db. I've been trying to convert it to a columnstore table using the following commands: insert Logs(...
2
votes
1answer
84 views

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a ...
0
votes
3answers
121 views

How to sync daily the prod database to dev database in Azure SQL Server service?

I have two Azure SQL Database, prod and dev. How can i daily replicate the prod database into dev database? I have tried to automate it by exporting and importing the BACPAC file but it takes too long ...
-1
votes
1answer
36 views

is it a good idea to migrate a SQL Server database that uses a lot of linked servers and external conenctions with different databases to Azure?

We have a 1tb database that use information from other 4 or 5 databases. It has hundreds of procedures using external databases to calculate and etc. we have 0 problems inside SQL Server. I would like ...
42
votes
5answers
46k views

Can I add a unique constraint that ignores existing violations?

I have a table which currently has duplicate values in a column. I cannot remove these erroneous duplicates but I would like to prevent additional non-unique values from being added. Can I create a ...
0
votes
0answers
36 views

Azure mysql user connections with proxy sql

I’ve looked for a couple of days, and can’t find a definitive answer. I have an application running on a kubernetes cluster that wants to connect to an Azure Database for MySQL server via proxysql. ...
0
votes
1answer
49 views

Azure SQL Hyperscale, Very Large Tables, and lack of explicit partitioning

Hyperscale scales to 100TB when it comes to storage. And I understand the page server concept - each server handling 128GB of data, with its own local cache. What I do not understand though is how ...
3
votes
1answer
91 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 ...
4
votes
2answers
534 views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
2
votes
1answer
102 views

Why is my recursive CTE so much slower on Azure SQL?

I have this simple recursive CTE for a hierarchy of folders and their paths: WITH paths AS ( SELECT Id, ParentId, Name AS [Path] FROM Folders WHERE ParentId IS NULL UNION ALL SELECT ...
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 ...

1
2 3 4 5
14