Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
1
vote
0 answers

Does using T-SQL OPENJSON perform faster than returning raw nvarchar value when querying large JSON Arrays?

I have a table in which one of the columns is used to persist a large JSON array. Querying the raw value appears to be much slower than processing the column value with OPENJSON prior to returning. Question: Is OPENJSON actually more performant than…
Stevie
  • 2,000
  • 1
  • 18
  • 28
1
vote
1 answer

Azure SQL. Read-only replicas. Is there a way to manage how many replicas database and configure load balancing across them

What I'd like to achive is to be able to scale out Azure SQL Database. Business Critical tier has this feature to enable several read-only replicas. This is a great feature that would let me offload some traffic over to those replicas The problem…
Stanislav
  • 165
  • 1
  • 15
1
vote
1 answer

Powershell Invoke-Sqlcmd hits wrong database - system, why?

Im deploying mssql server, firewall, database and sql logins (and more) via terraform. Server, firewall and database are deployed correctly, while logins via powershell fails with following error: ': exit status 1. Output: Invoke-Sqlcmd : Database…
Jaroslaw Stadnicki
  • 1,178
  • 1
  • 8
  • 17
1
vote
1 answer

No files were found to deploy with search pattern when trying to SqlAzureDacpacDeployment with Azure DevOps

I try to publish Dacpac file to Azure SQL. I get Dacpac file published correctly to Azure DevOps. I see AzureSQL.dacpac under "drop" of Artifact. However I get error and wondering why file cannot be found. ERROR: No files were found to deploy with…
Kenny_I
  • 2,001
  • 5
  • 40
  • 94
1
vote
1 answer

Azure SQL User Login for one database

I am using azure sql ____.database.windows.net. in this database server I have two databases: DatabaseA / staging DatabaseB / production. i need sql user login for only access to DatabaseB. Is it possible with create new sql user?
umasankar
  • 599
  • 1
  • 9
  • 28
1
vote
1 answer

Import sql query as json document in azure data lake storage

Import data from a SQL Database hosted on Azure virtual machine, convert sql query data as a json document and store it in Azure Data Lake Storage. I am using powershell to create the json document. Hit a roadblock on how to import json documents…
paone
  • 828
  • 8
  • 18
1
vote
2 answers

Azure SQL Database ARM - Parameter 'maxSizeBytes' must be of type 'int'

When downloading a template through Azure Portal for creating a new SQL Database with Basic tier and a new SQL Server you get a parameter called 'maxSizeBytes'. Using this template and parameters with a Azure Resource Group project in Visual Studio…
Ogglas
  • 62,132
  • 37
  • 328
  • 418
1
vote
1 answer

Upload .db file to Azure SQL

I have a .db file, with a bunch of tables and data (and a few one to many relationships), instead of rewriting everything, is there a way for me to just upload this database directly to Azure SQL?
Noe Horowitz
  • 47
  • 6
1
vote
1 answer

Read Azure Key vault secret from on premisis SSIS package

I have my database connection string stored in Azure Key Vault as a secret. My SSIS package which is on-premises needs to read connection string from Azure Key Vault. Usually, when I configure my SSIS package, I configure my connection string at…
SoftLover
  • 101
  • 1
  • 12
1
vote
2 answers

Set-AzSqlServerActiveDirectoryAdministrator : Cannot find the Azure Active Directory object 'service_principal_name'

I am running the following command $sp = az ad sp show --id $env:ARM_CLIENT_ID --query '{objectId: objectId, displayName: displayName}' az sql server ad-admin create --resource-group data-eastus2 ` --server-name data-eastus2-sqlsvr ` …
Alexey Auslender
  • 402
  • 5
  • 18
1
vote
0 answers

Can't access Azure sql with EF Core - Code first, but can with database first

so as the title suggests. I have done the following: Created simple models (c# classes). Added Nugget packages: - Microsoft.EntityFrameworkCore.Design(3.1.3) - Microsoft.EntityFrameworkCore.SqlServer(3.1.3) I Have added the following context:…
Oskar
  • 90
  • 1
  • 10
1
vote
2 answers

How to connect to Azure pass DB from a secure network

I would like to connect to Azure SQL server from a Window server via SSMS. In the “set server firewall” from Azure, I have given my server IP ( from the system I would like to connect). I need to know the destination IP adders of the Azure DB…
AskMe
  • 2,495
  • 8
  • 49
  • 102
1
vote
2 answers

Create a column with universal data type?

Is there a way to create a column which has an "universal" datatype? What I want is a column which can have a different datatype in every row. For each insert, the idea would be to set the datatype (nvarchar, int, bigint, float, decimal), and then…
askolotl
  • 964
  • 1
  • 13
  • 27
1
vote
2 answers

How to migrate Logins from SQL Server to Azure SQL DB

I want to migrate SQL Server logins to Azure SQL. I tried using SQL Server Integration Service "Transfer Logins Links" but it throws "Keyword or statement option 'default_database' is not supported in this version of SQL Server."
Sarvesh Pandey
  • 31
  • 4
1
vote
2 answers

ARM Template, server name already exists but actually it didn't

I'm trying to create a SQL Server using ARM Template. While executing it, its throws an error of: Server Name already exists but it does not. I tried deploying it in many subscriptions and resource group of different regions but outcome is always…
Sarvesh Pandey
  • 31
  • 4
1 2 3
…
36 37