Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [azure-sql]

Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as

  • Relational data
  • JSON
  • Spatial
  • XML

SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

Ask any question related to Azure SQL and read more at https://docs.microsoft.com/en-us/azure/sql-database/

99 questions
0
votes
1 answer

Detect when scaling Azure SQL database via async TSQL command has failed

I have a scheduled task which runs each night to copy an existing production Azure SQL db to a dev environment. Once copied, I scale the database down (actually I put it into an elastic pool to share the cost amongst multiple other dbs) to reduce…
theyetiman
  • 111
  • 5
0
votes
1 answer

Cross reference between azure sql data ware houses

In one sql server instance, I have below 2 data warehouses, sqlwarehouse1 sqlwarehouse2 And in sqlwarehouse2, I have the table "dbo.test". How can I refer this table from sqlwarehouse1? Is this cross data warehouse communication is possible in Azure…
user557080
  • 1
  • 1
0
votes
1 answer

Failed queries in Azure SQL

Finding the failed queries in Azure SQL Description: How can I get all the failed queries in Azure SQL for the last 5 days? Use-case- I need to troubleshoot certain issues
Vikash
  • 1
-1
votes
1 answer

ADO NET Destination has failed to acquire the connection with the following error message: "Login failed for user

Created a SSIS package, it is running fine when I run it on premise but when i try to execute it from sql server agent it gives me error for login failed for user, I am using SQL authentication to connect to the Azure database which are working fine…
Akki
  • 1
  • 1
  • 2
-1
votes
1 answer

How to create (or use the existing) database on an SQL 2017 deployed via Azure VM?

Please note the question is about the SQL 2017 that comes inside an Azure VM, not the Azure Databases. Basically, I deployed an Azure VM with SQL 2017 Enterprise installed on it already, by MS. Now, I want to create some test tables, populate data…
DraxDomax
  • 139
  • 1
  • 5
-1
votes
1 answer

Azure Security Alert - Login from an unusual data center

Azure Security Center generates an alert for a SQL Database that someone authenticated from an "unusual datacenter". Provided IP is Microsoft owned. Hostname is nothing recognizable.
RiverHeart
  • 149
  • 5
-1
votes
1 answer

What additional role should I provision in an Azure resource group so that a contributor can see/accept/fix Azure SQL security recomendations?

We are receiving security recommendations for one of our Azure SQL databases. I'm owner of the subscription and can see those recommendations in the Azure SQL Security Center. I would like to delegate the resolution to one of the resource group…
lpacheco
  • 157
  • 2
  • 9
-1
votes
1 answer

Information about free account Azure and SQL database

I'm using free account and I need to create an instance of SQL database. I have read there is 250 GB of instance S0 Standard of SQL database with 10 DTU in the free tier for 12 months. But, when I try to create it tells me that the estimated cost is…
accountutente
  • 1
-5
votes
2 answers

Troubleshooting corporate DNS

I'm on a corporate network with various mysterious lockdowns including ZScaler My current issue is that when I try to connect to xyz.databases.windows.net (Azure SQL database) I see these symptoms: From SSMS I get No such host is known Trying…
Nick.Mc
  • 155
  • 1
  • 2
  • 14
1 2 3 4 5 6
7