Questions tagged [azure-sql-server]
548 questions
3
votes
0 answers
Ways to transfer data to OMS
I am trying to gather all the possibilities through which I can import the data occasionally to OMS in Azure from Azure SQL database and Azure App Insights.
The only possibility that I could find is using the SQL Server connector for importing data…
Harry
- 55
- 2
- 10
3
votes
2 answers
Database per country/region architecture
Currently we have a website which includes a SQL DB. Both are hosted in one region in Azure
I have a business request to store all data for our US clients in a US datacentre, no replication. Therefore we need multiple databases (identical schema,…
Jamie
- 380
- 8
- 19
3
votes
0 answers
OData Azure API erratic response time
We have several OData API's using Entity Framework and AutoMapper. These connect to an on-premise SQL database through a VNet. The GET requests of this API are not asynchronous per example found here. The scaling is set to S2. We have enabled always…
Vqf5mG96cSTT
- 2,561
- 3
- 22
- 41
3
votes
2 answers
External table in Blob Storage in Azure SQL(Not Azure SQL DW)
Here is my script which I am trying to run in Azure SQL Database:
CREATE DATABASE SCOPED CREDENTIAL some_cred WITH IDENTITY = user1,
SECRET = '';
CREATE EXTERNAL DATA SOURCE TEST
WITH
(
TYPE=BLOB_STORAGE,
…
HimalayanNinja
- 421
- 3
- 11
3
votes
0 answers
Azure Data Factory HDI on demand custom metastore transient failures
We have an Azure Data Factory with around 40 pipelines in it, each pipeline has an activity to run a hive script using a HDInsight on demand linked service.
We've since added a custom metastore which uses an azure SQL instance as a storage linked…
Nosmadas
- 632
- 3
- 9
- 17
3
votes
2 answers
Azure SQL, Copy most of a database into an existing one (not new one) same server
I know I can clone DB into a new one with
CREATE DATABASE Database1_copy AS COPY OF Database1;
(https://learn.microsoft.com/en-us/azure/sql-database/sql-database-copy-transact-sql)
and this goes flawesly, except in Azure, where db properties are…
pGrnd2
- 514
- 1
- 5
- 14
3
votes
1 answer
Why there is no "additional_data" in Azure SQL sys.event_log table?
I have Azure SQL Data Base
Server version V12
Pricing tier Basic (5 DTUs)
After a few deadlocks, there is no info in the column additional_data in table sys.event_log.
Running the following script on the "master" DB:
SELECT * FROM sys.event_log…
Guy Assaf
- 888
- 9
- 24
2
votes
1 answer
Connection was denied since Deny Public Network Access is set to Yes
I have created a Private Endpoint but I am still unable to connect from VMs on the same subnet using SSMS.
The error returned is
Cannot connect to dbserver.database.windows.net.
===================================
Reason: An instance-specific…
Mike Fleming
- 107
- 1
- 9
2
votes
2 answers
Using spark MS SQL connector PySpark causes NoSuchMethodError for BulkCopy
I'm trying to use the MS SQL connector for Spark to insert high volumes of data from pyspark.
After creating a session:
SparkSession.builder
.config('spark.jars.packages',…
warreee
- 437
- 4
- 12
2
votes
1 answer
Login failed during Azure Release Pipeline DACPAC deployment
I am trying to deploy a dacpac to a database in Azure SQL server using a release pipeline in azure devops. I was able to deploy a dacpac to one database successfully by adding Azure Object Name as db_owner of that database.
I repeated the same step…
user10486706
- 137
- 9
2
votes
1 answer
Azure Databricks JDBC Error: java.sql.SQLException: No suitable driver
I've dug through as many similar posts I can find on this issue, and the closest is this question:Apache Spark java.sql.SQLException: No suitable driver for my Azure SQL Server however I tried that user's solution in the comments and I'm still…
alaskanloops
- 123
- 3
- 15
2
votes
1 answer
Azure Pipeline Running SQL against a server with no public access
We have a SQL instance in azure which until recently was publicly available with access restricted based on IP whitelisting. We have recently ticked the "Deny public access" checkbox and set up private endpoints for the server.
We also have build…
5NRF
- 401
- 3
- 12
2
votes
1 answer
PyODBC takes 6 seconds to establish a connection with Azure SQL Server
PyODBC takes ~7 seconds to establish a connection with Azure SQL Server, is there a way to minimize this?
import os
import sys
import logging, logging.handlers
import getopt
import pyodbc
from database import *
# set up…
One Developer
- 99
- 5
- 43
- 103
2
votes
1 answer
Where to find Azure SQL Database backups?
I have created an azure SQL database, single database. I would like to see where my backup files are saved. I know in Data Management > Backups I can see my database and can configure retention policies. My question is where are the backup files? I…
E. Erfan
- 1,239
- 19
- 37
2
votes
1 answer
What happens when the Azure Sql server dtu exceed?
What happens when the Azure Sql server dtu exceed the limit?
I am facing the below issue, not sure if this is due to high DTU usage?
I have a spring batch application that uses Azure SQL server, it runs without any issues and updates the Database…
One Developer
- 99
- 5
- 43
- 103