Questions tagged [azure-sql-server]

0

votes
1

answer
26

Views

Change “Allow access to Azure services” settings of Azure SQL Server using powershell

I want to modify (enable/disable) 'Allow access to Azure services' settings of Azure SQL Server using powershell, based on a value from my JSON configuration I do have referred couple of StackOverflow, all the answers are to create a firewall rule '0.0.0.0' to enable and '255.255.255.255' to disable...
Manjunath Rao
1

votes
1

answer
816

Views

Connect to Azure SQL Server through Azure VPN Gateway

I have an Azure SQL Server & Azure SQL Database, a virtual network with two subnets, a vm and an Azure VPN Gateway. The VM is on Subnet1. Azure VPN Gateway uses GatewaySubnet. In the Azure SQL Server > Firewalls and virtual networks > I have added both subnets. Now if I VPN into my virtual network,...
Jeffrey
1

votes
0

answer
172

Views

TCP Keep Alive in windows is running but the program is not affected for Azure SQL

To keep Azure SQL alive MS have provided this workaround , After following this workaround the keep alive messages are sent I traced over wireshark . But still my application is facing Connection Reset after 30 minutes .. I have made a normal connection to azure using jdbc libs provided by microsof...
Arun Kumar G R
1

votes
0

answer
122

Views

WHERE clause not evaluated remotely when querying Azure SQL external table

I'm pulling bits of data from one Azure SQL database to another, using the external tables feature. As described under 'performance improvements', it's important to ensure WHERE clauses are evaluated on the remote server. This ensures only the required rows are returned, as opposed to returning the...
NinjaCarr
1

votes
2

answer
334

Views

How to replicate Azure sql db in cross subscription

Is there any way we want to replicate sql db in other subscription To copy data from one subscription to another subscription The job should do incremental copy daily.
Tariq
1

votes
1

answer
401

Views

Azure SQL Server - How cost will be calculated

I have created SQL Server resource in SQL Server and then using import database option, I created database using local bacpac file. I was able to perform this action and my database was created in SQL Server. I looked at Azure SQL pricing but not very much clear on how much cost would be incurred wi...
Manish Joisar
1

votes
0

answer
195

Views

New login and user cannot login to database right away but works after random periods of time - Azure SQL Server

Command - 1 (Running on 'Master') *CREATE LOGIN [login_Name] WITH PASSWORD=N'XXXXXX'* Command - 2 (Running on 'Database_name') *ALTER USER [User_name] WITH LOGIN= [login_name] EXEC sp_addrolemember N'db_owner', N'Database_Name'* When I try logging to 'Database_Name' or try to make a connection to th...
Amber Gupta
1

votes
1

answer
54

Views

What is the purpose of failover group for Azure SQL if it already is highly available?

According to documentation below, Azure SQL databases are already a high-availability service. If that's the case, then what is the purpose of configuring failover groups? https://docs.microsoft.com/en-us/azure/sql-database/sql-database-high-availability Are failover groups more for when you have...
Geekn
1

votes
1

answer
67

Views

How to delete Azure SQL audit logs using PowerShell?

My Azure SQL Server has been storing the audit logs for over a year, and storage size is in the TBs. I would like to keep the logs for 3 months max and delete the rest, how can I do this using PowerShell? Would setting the RetentionInDays parameter of Set-AzureRmSqlServerAuditingPolicy cmdlet to 90...
Hassan K
1

votes
1

answer
92

Views

NSG and routing details to connect a Microsoft Flow with Azure SQL database in a VNET

I have a SQL Server DB in a VM in a VNET in an Azure Subscription . Currently it does not have any connection open to the Internet . My application team has designed a Microsoft Flow application that will read some emails , parse them in some way and push those files into the sql server database (...
Turja Chaudhuri
1

votes
0

answer
70

Views

How can I query multiple databases by name that reside on a Azure SQL server using SSMS?

I want to be able to run some ad-hoc queries to get some fast results. The following will return the number of rows in table foobar from two databases that have identical structures. USE Master GO select count(*) from MyFirstDB.dbo.foobar; select count(*) from MySecondDB.dbo.foobar; This works fine...
WhiskerBiscuit
1

votes
0

answer
39

Views

Error when running Data Profiling Task with Azure SQL Server data

When running a Data Profiling Task in SSIS with data from an Azure SQL Server, I receive the following error message: System.Data.SqlClient.SqlException (0x80131904): USE statement is not supported to switch between databases. Use a new connection to connect to a different database. I am unsure how...
Michelle Turner
1

votes
1

answer
27

Views

Azure SQL Data-Sync. Issue with Syncing more than 30 Onpremesis Databases to single server

I have run into an issue when trying to sync more than 30 on premises DBs on a single Azure SQL Database. It is giving me the following error. Whats the best workaround for this error. We need to setup more than 30 SQL Databases (on-premises). Also, how can we achieve a data warehouse for more that...
Waqar
1

votes
1

answer
871

Views

Azure SQL DW - Control Resource Class on Query Level

I am running some ETL on my Azure SQL DW at DW500 so I have 20 concurrency slots available some of my queries would require RC xlargerc, some largerc, etc so the expected load can vary from query to query is there any option to control the assigned RC in the query directly? e.g. using OPTION or any...
Gerhard Brueckl
1

votes
1

answer
58

Views

Maintaining relationships between data stored in Azure SQL and Table Storage

Working on a project in which the high volume data will be moved from SQL Server (running on an Azure VM) to Azure Table Storage for scaling and cheaper storage reasons. There are several foreign-keys within the data that is being moved to Table Storage, which are GUIDs (Primary-key) in SQL tables....
Sunkist
1

votes
1

answer
221

Views

Adding vnet rule through AZ cli fails with 500 errors

I'm experimenting with Azure AKS, and I'm running into problems with adding a vnet rule for my SQL server via the Azure CLI. It dies with an error: Error occurred in request., RetryError: HTTPSConnectionPool(host='management.azure.com', port=443): Max retries exceeded with url: /subscriptions/...pat...
Will I Am
1

votes
1

answer
1.1k

Views

Is there a limit on how many databases Azure Sql Server (PaaS) can have? And/Or is there a size limit on how much data an Azure Sql Server can hold?

Is there a limit on how many databases Azure Sql Server (PaaS) can have? And/Or is there a size limit on how much data an Azure Sql Server(PaaS) can hold?
Andrew Taylor
1

votes
1

answer
259

Views

Why is query speed Azure Analysis Services versus direct SQL queries lower

For testing purposes I deployed: an Azure SQL DB with some data a Tabular Model in Azure Analysis Services connected to the SQL DB to get the data The test was meant to compare the speed of the queries against the Azure SQL DB with those against the Tabular Model. The Tabular Model in the tests cons...
sdec
1

votes
1

answer
697

Views

SQL Azure elastic pool max DTU per database

We are using SQL Azure and we have our databases in Elastic pool. It has following parameters: Number of DTUs allowed for the entire pool is 400. Maximum allowed DTUs per database is 100. Number of databases in pool is 50 Simply said 4 of 50 databases can be at its peak load at the same time. Quest...
jabko87
1

votes
1

answer
178

Views

Unable to connect to SQL Server Analysis Services using Azure Hybrid Connection

We have configured the Azure Hybrid Connection in the App Service which we want to access the SQL Server Analysis Services from On-Prem server. The port configured in Hybrid Connection is 2383. The connection status is showing connected on both the Azure and in the Hybrid Connection Manager of the...
Narsimlu K
1

votes
1

answer
315

Views

ODBC SQL server not found in R Studio Server

I'm trying to connect an Azure SQL instance to my R Studio Server that is served on Ubuntu. library(DBI) library(odbc) con_string
billmanH
1

votes
1

answer
127

Views

Set Client IP address to the azure sql server automatically using vso powershell task

Issue : When i create the new sql server and DB. My next task is to connect with DB but it breaks due Client IP not added in the firewall of sql server. I don't want to add it manually. Is there any way to set it using Powershell? and it should be the exact same IP which i am able to see inside azur...
rAJ
1

votes
1

answer
405

Views

SQL DELETE is taking too much time

I have an Azure SQL server (standard tier, S3) with tables. I have a specific query that takes very long time to be executed: DELETE FROM MyTable WHERE [email protected] This table has 150K rows. The delete query takes +-10 minutes. I tried to understand why. First check is how fast is locate this row in SELE...
No1Lives4Ever
1

votes
1

answer
0

Views

Enabling MEMORY_OPTIMIZED tables on VCores environment

I am trying to run some tables in memory (MEMORY_OPTIMIZED ) and I've found this documentation. I want to work with Vcore environment, and based on the documentation I've expected to be able to work with it. I've just created an empty database and the query below returns 0 (not supported) while I...
Ashkan Sirous
1

votes
1

answer
0

Views

How to check all access rights for specific user in Azure SQL Database?

I have below questions about schema/privilege: May User have multiple DB roles(schema)? What is db_denydatareader used for? (it seems can have different DB roles among databases, right?) What are difference between db_datareader and db_denydatawriter if only want user to read data in particular data...
DaiKeung
1

votes
1

answer
0

Views

How to configure mail on Azure SQL Database

We are moving from Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) to Microsoft SQL Azure (RTM) - 12.0.2000.8 Previously we send mail from database mail if a particular table have not updated in a particular time interval. But i tried to do the same on Azure mail but seems like this functiona...
GauravRatnawat
0

votes
0

answer
5

Views

Querying SQL Database returned an error: Login failed for user 'Free Trial

so currently I am doing a connection from Azure IoT Hub - Data Stream Analytic - SQL Database. and when I wanted to test the output connection that I have declared in Stream Analytics Job, suddenly error popped-up 'Querying SQL Database returned an error: Login failed for user 'Free Trial'enter imag...
andrew sunartio
1

votes
1

answer
658

Views

Using Polybase to load data into an existing table in parallel

Using CTAS we can leverage the parallelism that Polybase provides to load data into a new table in a highly scalable and performant way. Is there a way to use a similar approach to load data into an existing table? The table might even be empty. Creating an external table and using INSERT INTO ......
Gerhard Brueckl
1

votes
2

answer
452

Views

XML File Validation Against Azure SQL Server in Azure Data Factory

My XML File (LOCATED IN Azure Blob Container) 2 XXX 12 My Azure SQL Server Table Table Name : UserTABLE ID | NAME | AGE | GENDER 1 | JAY | 12 | MALE 2 | XXX | 11 | MALE I want to compare the from XML file against the Above Azure SQL server (UserTABLE),if Matches then i want to Up...
Jayendran
1

votes
1

answer
307

Views

How to set AuditingType as Blob using ARMtemplate in AzureSqlServer

I am deploying AzureSqlServer using ARMTemplate. I want to enable Auditing & Threat Detection using ARMTemplate. Below is the code that sets auditingtype as 'Table': { '$schema': 'https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#', 'contentVersion': '1.0.0.0', 'paramete...
Amruta
1

votes
1

answer
239

Views

Calling functions of master DB from other DB on the same Azure SQL Server

I have Azure SQL DB Server + one Azure SQL database on it. Within this DB I have functions which call some functions of master DB as a part of their logic. Example: CREATE FUNCTION [dbo].[EncryptByKey] ( @EncryptionKeyId nvarchar(1024), @ValueToEncrypt varchar(MAX) ) RETURNS VARCHAR(MAX) AS BEGIN RE...
Vladimir Glushkov
1

votes
1

answer
286

Views

Cannot set Azure SQL Database Long-term backup retention

I'm trying to re-configure long term backup retention for my Azure SQL Database from a previously deleted recovery services vault (via Powershell) to a new recovery services vault Now when I try to configure it gives me an error saying TemplateBladeVirtualPart SQLAZUREEXTENSION Here is the script I...
Frank Fu
1

votes
1

answer
38

Views

Azure SQL Server Location list is restricted

SQL Server Location list on Enterprise is very limited Why is it that the list is much more limited than when using a student license? Student license has larger list Edit: Seems like it was a temporary issue. It wasn't just the graphical interface, I was making HTTP Requests and even those would fa...
Anh-Duc
1

votes
2

answer
163

Views

Error Migrating SQL Server Database to Azure

So I am completely new to .Net Core development, and was given a codebase that I am trying to host on Microsoft Azure. I have the local database file (.mdf) in SQL Server Management Studio, and am trying to deploy it to an Azure Database, However it keeps failing during migration and giving me this...
Kevin Marin
1

votes
1

answer
497

Views

SQL Deployment with ARM Templates including schema and table (dacpac, PowerShell)

I want to deploy a Azure SQL Database with schema and table using PowerShell, Azure Resource Manager Templates and dacpac. How can I do that?
quervernetzt
1

votes
1

answer
279

Views

VIEW SERVER STATE equivalent in Azure Sql Server

All, I'm trying to connect Silk Test Workbench to Azure Sql Server. However, they only give instructions for connection to Sql Server. I figure it might work, and it seems to, as it was able to create all of its tables in the database, and use them.. however.. Silk Test needs to be able to run som...
KevinDeus
0

votes
0

answer
5

Views

Permission Issue on Bulk Insert in Azure SQL Server

User is getting below error while running bulk insert command in Azure SQL Server. I am using Azure SQL Server and not SQL Sever. Most of the commands related to Bulk Insert grant permission is not working in Azure SQL Server. Error You do not have permission to use the bulk load statement. Commands...
Josh......
3

votes
4

answer
2.3k

Views

How to set Azure SQL to rebuild indexes automatically?

In on premise SQL databases, it is normal to have a maintenance plan for rebuilding the indexes once in a while, when it is not being used that much. How can I set it up in Azure SQL DB? P.S: I tried it before, but since I couldn't find any options for that, I thought maybe they are doing it automat...
Ashkan Sirous
4

votes
2

answer
1.6k

Views

Assigning an Active Directory Administrator to an Azure SQL instance through ARM Templates

Is it possible to assign an Active Directory Administrator to an Azure SQL Instance within an ARM resource template? I'm trying to automate the deployment of a database server, but I only seem to be able to specify the local server administration credentials. 'properties': { 'administratorLogin':...
mclark1129
2

votes
2

answer
257

Views

how to find if replication role of Azure SQL database

I am trying to find the replication role of Azure SQL DB (Primary or Secondary). I used : Get-AzureRmSqlDatabase command but could not find the replication information. Is there a different powershell command to find replication role ?
K.Pil

View additional questions