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
14 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
28 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
57 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
73 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
13 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
95 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
18 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
20 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
155 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
62 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
52 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
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 ...
0
votes
1answer
119 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
120 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 ...
11
votes
1answer
759 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
107 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
397 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
22 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
29 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
36 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
147 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
118 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
22 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
21 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
273 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
55 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
28 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
131 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
220 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
2k 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 ...
3
votes
3answers
2k views

How to create a JOB for Azure SQL?

I'm trying to create some jobs for our Azure servers (for sql databases). I'm reading about it on the internet and tried to find some questiosn here with no success. Theres a link saying I need to ...
1
vote
1answer
36 views

Stored procedure to set value to a column must accept returned values from functions

I created a very simple table in Data Mart to store ETL diagnostic information: CREATE TABLE [internal].[etl_status] ( [property_name] VARCHAR(100) NOT NULL PRIMARY KEY, [property_value] ...
1
vote
1answer
199 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 ...
0
votes
2answers
32 views

Installation and shell to move physical and logical SQL Server in azure IaaS VM

Firts of all excuse my english is not my primary language. We are creating an azure template to deploy an IaaS machine with disks C and D with windows server, and the idea is also deploy an ...
1
vote
3answers
307 views

How to quantify or locate command timeouts in Azure SQL

I am trying to if confirm query timeout in Azure. Our frontdoor is reporting a 503 response at 30 Seconds response, as its the SQL server default value, I am trying to confirm if these are indeed ...
0
votes
0answers
119 views

How to configure transactional replication for managed instance as a publisher and a subscriber for two different sql server at the same time?

The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher). I then want this subscriber to be a publisher to another subscriber....
0
votes
0answers
30 views

What happens to the transactional replication if azure sql Vm(publisher and distributor) is stopped and restarted from portal?

I am a newbie...I have azure sql vm and sql managed instance. I have setup transactional replication between them. Now if I stop the vm from the portal will the replication still continue after ...
1
vote
0answers
11 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
2answers
336 views

Copy SQL database with encryption from one Azure subscription to another

I need to copy an entire Azure SQL Database from one subscription to another. The challenge I have is that it has a certificate with symmetrical key and if I try to export it to a .bacpac file I get ...
0
votes
0answers
88 views

Can you update statistics on a sys change tracking table

I'm tracking down some poor query times doing the typical query to get changed records: select StoreItemId from changetable(changes [dbo].[StoreItem], @clientChangeTrackingVs) as ChangedRow where [...
0
votes
1answer
58 views

What are the downsides of using varbinary[max]?

I want to set up a table to store waveform data from an oscilloscope. The table would have a column of varbinary[max] because the waveform data from the scope is returned as a binary sequence that ...
0
votes
2answers
83 views

what are the best ways to sync two databases in sql server or azure sql db?

I have a question like syncing two different databases available on two different servers/instances. lets say Source be the source server and sourcedb is the source database. destinationdb is the ...
0
votes
1answer
234 views

How to create a master key on the master database?What are the roles required to GRANT to the login and user of the master db for the same?

I am trying to create a master key on a master database of my azure sql datawarehouse. But my user does not have required permissions to do so. What are the roles need to be assigned/granted to the ...
0
votes
1answer
24 views

Login failed for newly created user

I just created my first database yesterday. It is now set up and I can write to it from my C# application using the admin user login. I would now like to use a limited write only user so my admin ...
0
votes
1answer
181 views

Sql server/azure connection string parameter for readonly access?

Is there a specific parameter that can be used in a SQL server/azure connection string to specify that the connection should be readonly? In other words, only SELECT queries should work but INSERT/...
2
votes
0answers
93 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
89 views

Importing a single large table in Azure

I have an existing DB called MyDb in Azure SQL Server. I have a bacpac of another DB with several tables in it. I'm interested in importing one single table (that table has no FK, it makes things ...
0
votes
0answers
27 views

Indexes not appearing in sys tables on Azure Secondary

I'm running the following query on an AZure SQL Read Only secondary to determine which indexes are being used. But some of the indexes are not being returned in the query. I must be missing something ...
2
votes
1answer
51 views

Azure SQL Database vs. error 8152 enhancement

How can I take advantage of the enhancement for error 8152 (https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/) in Azure SQL ...

1
2
3 4 5
14