Stack Overflow
Stack Overflow

Questions tagged [azure-sql-server]

548 questions
0
votes
0 answers

Using "Connection Pooling" or not

Background I'm using Azure-Sql-Server. To host my database and I'm using Entity-Framework (C#) on top of it. I using Standart S3 tier. This pricing tier is limited to 200 concurrent connection to DB. My system working in Micro-services architecture.…
No1Lives4Ever
  • 6,430
  • 19
  • 77
  • 140
0
votes
2 answers

Azure: step by step to upload sql server db dump (small) to azure

hell, I am completely new to azure would like to know step by step to create sql server in azure and import a local db dump to it. Any pointers are appreciated. Thanks
user1464559
  • 29
  • 1
  • 2
0
votes
0 answers

Install "Analysis Services" on Azure SQL Server?

To start off: I know that there is SQL Server Analysis Services and Azure Analysis Services and they are separate products. And I know that: On On-Premise installations I can install the "SQL Server Analysis Services" component on my On-Premise…
msporek
  • 1,187
  • 8
  • 21
0
votes
2 answers

What is the default encryption algorithm used by Azure TDE?

Azure SQL Server offers Transparent Data Encryption (TDE) by default, with the flick of a virtual switch: There is no option to select an algorithm and I am not using "Bring Your Own Key". Which encryption algorithm is being used and what is the…
Widor
  • 13,003
  • 7
  • 42
  • 64
0
votes
2 answers

Azure SQL Server Monitoring/Alerting for Multiple Databases (v12)

What is the best way to monitor a certain metric and alert on it over multiple databases. For example I want to trigger an alert if a database size grows larger than 10 GB. I know you can select a single database and configure this in Azure Monitor…
Dresse
  • 473
  • 6
  • 15
0
votes
1 answer

when copying table from AzureDataLakeStore to ASQLServer string fields appear between double quotes in ASQLServer

I have a table in AzureDataLake, and a table defined in AzureSQLServer. One of the activities in the pipeline copies form one to the other. However, for some reason string fields appear between double quotes screenshot of what I get the table…
Bernat Agullo Rosello
  • 5
  • 2
0
votes
1 answer

Azure SQL Data warehouse - Error while enabling statistics

I am getting below error while enabling stats on Azure Sql DatawareHouse. Using below command alter database [DatabaseName] set auto_create_statistics ON Msg 104434, Level 16, State 1, Line 26 This option is not supported in PDW. I checked…
DevX
  • 725
  • 3
  • 13
  • 26
0
votes
1 answer

Why is it failing to connect to my Azure SQL Server Database?

I have an azure sql server named "myCloudServer" and I created 2 databases in it, DB1 and DB2. I am an admin so I used the server admin "pt_admin" to create and manage those 2 databases. I wanted to give a 'read-access' to another person where he…
Ray
  • 781
  • 2
  • 17
  • 42
0
votes
1 answer

How to grant admin permission to AAD users in Azure SQL Server

Using portal.azure.com I've created SQL Server and SQL Database. I've set myself as the SQL Server admin. I'm able to connect with my AAD account using SSMS. I add another AAD users to my database: use [MyDatabase] CREATE USER…
Liero
  • 25,216
  • 29
  • 151
  • 297
0
votes
1 answer

Azure SQL Server Add Virtual Network

Im trying to Add existing virtual network on the screenshot above in Azure, but when I select the Subscription, the virtual network I want to connect to does not show up. I had a google but couldn't find much to help, can anyone help me understand…
Jeffrey
  • 2,095
  • 3
  • 20
  • 36
0
votes
2 answers

What should the connection string be when using Azure Sql Failover groups?

Ok so I have set up a Azure Sql Failover group at mydatabase.databsae.windows.net which contains 2 servers: mydatabase1.databsae.windows.net mydatabase2.databsae.windows.net I go to connectionstrings.com to get my Sql Azure Connection String which…
JKennedy
  • 18,150
  • 17
  • 114
  • 198
0
votes
1 answer

Autoincrease SQL Azure quota

Is there a best practice on how to handle quota limits on sql azure? maybe some sort of autoincrease?
HoBa
  • 3,442
  • 5
  • 26
  • 33
0
votes
0 answers

Azure SQL Database times out with nothing but a login request

I just migrated a copy of our production database up to Azure SQL. After finishing the migration, I pointed the connection string of our Test instance to the Azure SQL database, then I tried to run the app. Because I had changed the web.config, of…
Casey Crookston
  • 13,016
  • 24
  • 107
  • 193
0
votes
1 answer

Is my database in an elastic pool?

I am trying to set up an Azure SQL Database inside of an elastic pool. I'm not sure if I did it right. Here's my dashboard: And here's the actual database: What makes me wonder if the database is actually inside the elastic pool is what's circled…
Casey Crookston
  • 13,016
  • 24
  • 107
  • 193
0
votes
0 answers

How to permit Active Directory - Integrated authentication and simultaneously prohibit Active Directory - Password authentication

I would like to provide to admin users an MS Access database which includes some ODBC linked tables to an Azure SQL Database. Is it possible to allow Active Directory - Integrated authentication while prohibiting Active Directory - Password…
CalvinDale
  • 9,005
  • 5
  • 29
  • 38
1 2 3
…
36 37