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
1answer
21 views

Check constraint age 18< [closed]

Hello I need to create a constraint that chekc the user is 18< before listenning to certain songs but idk how... I tried this : ALTER TABLE Historique_ecoute DROP CONSTRAINT IF EXISTS ...
0
votes
1answer
41 views

Same query but different plan on different server

I have recursive CTE query, it was taking 30s to execute, after investigation I found out that a column (Name) with datatype nvarchar(MAX) was the problem so I changed it to nvarchar(1024). After ...
0
votes
1answer
20 views

Azure SQL: Should Manual Indexes be Applied with automatic tuning?

Should Manual Indexes on tables be applied in AzureSQL Cloud Database? We read that AzureSQL does automatic tuning, so are manual indexes even required? We read, there can be cases where AzureSQL ...
0
votes
0answers
11 views

Is 'data corruption occurs in the clustered index' still open?

Based on sp_Blitz Result: DBCC CHECKDB Not Run Recently, there is a reported bug in SQL Server 2012 & 2014, Data corruption occurs in the clustered index when you run online index rebuild in SQL ...
4
votes
1answer
162 views

How can I log which queries are in a distributed transaction on an MS SQL server?

I am looking at migrating a database from a self-hosted cluster to Microsoft Azure SQL. I am aware that there are a few distributed transactions involved, which isn't supported on Azure SQL. Is there ...
0
votes
0answers
18 views

Query store : same sql text with different query_text_id?

I'm investigating some issues with parameterization for our app, which uses Sql Azure. I'm using the query store and analyzing the following 2 queries, which are similar. See following image: There ...
0
votes
1answer
35 views

Does auto increment on Primary Key prevent concurent inserts? [duplicate]

I have a Sql Server logging table, that continuously is being inserted into, I want to revise the design of this table. Currently, we are using a GUID as the PK, because the software can generate ...
2
votes
1answer
51 views

Optimization of a query to retrieve records randomly with multiple joins and filters

I have the following schema: This question was posted also in StackOverflow, but I want to consult also to specialists more focused on DB administration because the nature of my project. Sorry if ...
0
votes
0answers
16 views

Why is @@VERSION different from Compatibility Level in Azure SQL?

I have just created a new Azure SQL database and when checking the SQL Server version in the Object Explorer tab I noticed it says it's 12.0.2000.8. However, I thought all Azure SQL databases are "...
-2
votes
1answer
20 views

Trigger for last inserted value [closed]

Can anyone help me create a trigger that appends the last record from table Sensordata into Lastsensordata. I only want 1 value per ConnectionDeviceId and the value needs to be the last inserted one. (...
3
votes
1answer
95 views

Complex key constraint: allow only if uuid is new or another column matches

For my use case I am trying to get something like this to work with Azure Data Factory (ADF) but I'm also interested in this question from a theoretical perspective. Is it possible to do something ...
0
votes
1answer
23 views

After a point-in-time restore, is there any way I can get the transactions during restore time?

The hypotethical scenario: Imagine that I have to do a point-in-time restore of a Azure SQL database, the original one is called DatabaseA and the restored is after restore called DatabaseA_restored. ...
1
vote
1answer
43 views

Reducing table size during initial load with ADR in SQL Server

When a table is created, and loaded with data from scratch based on a file, the table size changes significantly when Accelerated Database Recovery is on in SQL Server (realized based on my question ...
1
vote
1answer
48 views

Table size in Azure SQL Managed Instance vs On Premise SQL Server

In doing a test, I have observed that the size of the same table with the same exact DDL (created from scratch) with the same exact data (10M rows) varies drastically in our Azure SQL Managed Instance ...
1
vote
0answers
25 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 ...
0
votes
0answers
14 views

SQL Server internal memory get full on SQL Azure database

We have a SQL Server database hosted in Azure. Recently we have seen the avg_memory_usage_percent showing 100 percent. And it remains there. We checked in sys.dm_db_resource_stats DMV. Database size ...
2
votes
0answers
42 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 ...
3
votes
1answer
118 views

How can I improve the performance of this query on a table with millions of trigrams?

In an effort to make searching across many string fields in certain tables faster, I've been attempting to use trigrams. I've created a separate table to hold them, and a query to search against them ...
0
votes
0answers
25 views

Migrating SSIS to Azure - Looking for some help

We are thinking to migrate on-prem sql server to Azure. We have lots of SSIS ETL built internally that run at night. These SSIS PKG's connect to other on-prem SQL Servers or Oracle Database. It's ...
0
votes
0answers
12 views

How to compare EF core code-first database with existing Azure Sql Server database

we have multi-tenants databases and we have special stored procedure to compare the structure of the tenents after each release. Now, we are moving to Azure SQL Server and the stored procedure is not ...
1
vote
0answers
26 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 ...
0
votes
1answer
28 views

Restoring a managed SQL instance in Azure using PowerShell

I am trying to figure out how to restore a database from one managed SQL instance to another. I'm following the tutorials, but I keep running into inscrutable error messages. Here's my command: ...
0
votes
0answers
41 views

Are online index REBUILD operation possible on every Azure SQL database?

I am trying to find informations about the possibility to operate online index REORGANIZE/REBUILD on a database. What I actually found in the Microsoft documentation is that: Reorganizing an index ...
0
votes
1answer
12 views

Is it possible to migrate Sharepoint 2016 and all it's databases from SQL SERVER2012 to AZURE?

we are in a process to migrate our website to azure. we have those tons of sharepoint databases : Is it possible to migrate all user databases + sharepoint to azure? I could migrate some user ...
0
votes
2answers
51 views

Linked Server from On-Premise to Azure SQL Database

I am using: SSMS-18.4 SQL Server-SQL 2019 CU3 Windows 10 I was able to create a linked server successfully from on-premise SQL 2017 to the Azure SQL database without exposing my password. --Read ...
0
votes
0answers
17 views

How to solve Parameter Sniffing problem in a query with 'in' operator

I have a parameter sniffing problem in this Azure SQL Server query with in operator: Select Col1, Col2, ..., Coln from T1 Join T2 On T1.Id = T2.T1Id Where T2.Col2 in ('uniqueIdentifier_1'...
0
votes
1answer
17 views

Using Azure MSSQL “contained database” how do you force a user to reset their password?

I'm setting up new users in an Azure MSSQL Contained Database. I want new users to be forced to reset their password on the first login. I see the ability to set a new password documented https://...
0
votes
1answer
78 views

Encrypt connection when using sqlcmd

Trying to connect database with an encrypted connection, tried below sql queries: sqlcmd -N -E -S tcp:SQLSERVER,1234 -U username -P password -d Database -Q "INSERT INTO table1 VALUES(1,2,2) ERROR:...
2
votes
2answers
40 views

Azure elastic pool: Can I create as many databases as I want?

I am sitting here trying to figure out what the elastic pool in Azure gives me. I have a customer that wants a guess on pricing if they move to Azure. They have 3 databases, on a server. The server ...
0
votes
0answers
37 views

sqlpackage RegisterDataTierApplication errors with Azure SQL Database

I am trying to run sqlpackage from an locally hosted Azure Function inside a Docker container (so Linux), I have downloaded the latest 18.4.1 sqlpackage and running the following :- sqlpackage /a:...
0
votes
0answers
29 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 ...
0
votes
1answer
65 views

Invoke-ProcessASDatabase fails with “Cannot connect to server”

Occasionally I'm getting this error: Cannot connect to server 'myASCube'. Client with IP Address 'x.x.x.x' is not allowed to access the server. To enable access, use the Firewall settings in Azure ...
0
votes
0answers
16 views

Efficient way to copy, using SQL DML, content's of a table between to Azure Sql Databases

Trying to optimize a copy of table's content between two azure sql databases. Currently, one DB has an external table setup: CREATE EXTERNAL TABLE [dbo].[Database2_TableA] ( [Col1] [varchar](...
0
votes
3answers
71 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 ...
10
votes
1answer
414 views

SQL 2019 install…what is AzureAttestService?

We started the installation and configuration of SQL Server 2019 on Windows 2019 and noticed after install a new service named 'AzureAttestService' was running and set to automatic. Services list the ...
0
votes
0answers
51 views

Best way to archive old data from SQL Azure?

I have an app that stores event data. We use SQL Azure. Right now it's very expensive. Over $800/month to host. Once the event is over, I want to move the data to a DB that has a lower cost. Thus this ...
0
votes
1answer
181 views

Check partition function if list of value exists, if not iterate through list and add new partition value to the partition function?

I have an azure sql db with a partitioned table with a partition function on varchar datatype. In an Etl process I will get a list of partiton values as a parameter that i will the need to: check ...
0
votes
1answer
21 views

inaccurate statistics in multitenant database

We are using Azure SQL and have "multi tenant" database. All tables have tenantid + entityid pk. Some tenants have a lot of data and some tenants quite small. Also auto update statistics is enabled. ...
0
votes
0answers
27 views

Database primary key Guid as clustered index alternative

I've red a couple of blogs/stackoverflow posts about not using a Guid as primary clustered key. Unfortunately we have at the moment and due to this we're experiencing performance degradation (with 900....
0
votes
2answers
35 views

Reporting services 2008 reports connection to azure sql database

Due to the end of support of sql server 2008 R2 we are planning to move the database to azure as a paas service (azure sql database). Right now the application server has reporting services 2008 R2, ...
0
votes
1answer
113 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 ...
-1
votes
3answers
105 views

What are the reasons you would not migrate a SQL Server Instance to SQL Azure?

I have some servers and some databases on SQL Azure and as much as I like this idea, I would like to know some good reasons to migrate a SQL Server instance to the cloud and what reasons would be a ...
2
votes
1answer
21 views

Azure SSIS Deploying in SQL Azure

Does deploying SSIS really required an azure data lake house when deploying on Azure database?. I am currently working on an SSIS project that its database is currently deployed on Azure and I am ...
0
votes
1answer
17 views

Azure Data Sync Between Two Azure Databases

I would like to ask if I use Azure data sync with my two azure databases is there any way that I can still download data tier and install it on my local machine. I am planning to create a sync between ...
0
votes
1answer
169 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 ...
2
votes
2answers
52 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
26 views

SQL stored procedure to produce custom XML text

I have around 30 tables from which I need to generate a specific XML format, which is consistent through the tables. With my current solution I have a stored procedure for each 30 tables where I do: ...
0
votes
1answer
76 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.
0
votes
1answer
85 views

How does CALs Licenses work with Azure SQL [closed]

I looked all over the web for concrete information regarding CALs licenses in Azure SQL but couldn't find much event on Microsoft Azure site. Is this included within subscription ? Or Is it part of ...
0
votes
2answers
763 views

Alter role shows role does not exists

Running alter role db_ddladmin add member sqlloginname gives the error message: Cannot alter the role 'db_ddladmin' because it does not exist or you do not have permission. This statement I am ...

1
2 3 4 5
14