Azure SQL Database
An Azure relational database service.
5,144 questions
1 answer
Using MS Access ODBC with Azure AD
Hi, Is it possible to connect our MS Access DB to our Azure SQL Server using ODBC and Azure AD? Our end users login to their devices using their AD credentials. Is it possible to allow to MS Access DB to authenticate with Azure AD by using the…
asked 2020-07-06T08:18:04.243+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
T West
136
Reputation points
answered 2020-07-06T08:19:33.197+00:00
Leon Laude
85,666
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Hyperscale - Memory
I have an database on Azure Hyperscale. Right now the configurations of Hyperscale are as follows: (1) Gen5 16 VCore (2) 80 GB memory It seems memory is not sufficient for our workload, can i just increase memory keeping vcores as 16 ??
asked 2020-07-01T07:05:09.317+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Scalability Experts
21
Reputation points
accepted 2020-07-05T09:55:24.503+00:00
Scalability Experts
21
Reputation points
1 answer
Replication server restart
I wanna restart a Sql server running on a vm which host replication on it, is it safe to just stop the log and snapshot reader and restart the server or do I also have to disable the publisher and distributor
asked 2020-07-04T07:59:06.443+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 75%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK2%3C/text%3E%3C/svg%3E)
kK-2020
46
Reputation points
commented 2020-07-04T09:12:32.203+00:00
Leon Laude
85,666
Reputation points
2 answers
Set up and use Azure SQL
Hi team, I need guidance on the steps to get an Azure Microsoft SQL for SQL database and SQL programming. Especially the requirements, services, and steps to take to achieve this for a database below 500MB. Any help will be greatly appreciated. …
asked 2020-06-03T00:57:55.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 89%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Roland Okorie
51
Reputation points
answered 2020-07-03T03:17:13.217+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
strikersree
21
Reputation points
2 answers
SQL2008 Server R2 License/Product Key availability
I need SQL 2008 Server R2 Installation package with valid product key. Is it possible that I purchase SQL Server 2016 Standard edition software and use the product key for 2008 R2 installation.
asked 2020-07-02T10:05:16.243+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Prashant Joshi
1
Reputation point
answered 2020-07-02T11:37:06.543+00:00
Leon Laude
85,666
Reputation points
2 answers
One of the answers was accepted by the question author.
Monitor SQL Short Term Retention Backups
Is there a way to monitor Azure SQL Short Term Retention Backups? Unfortunately, I don't find any options in the metrics and nothing in the Microsoft documentation. Is it even necessary to monitor this type of backup (because its SAAS) ? I want to be…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 60%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
2 answers
Azure SQL database system design
Looking for some advice We have two applications which in current form the front end application runs on PCs, and talks to a SQL database which runs on an on-prem server. If we are to move the SQL database into Azure SQL PAAS, what is the most…
asked 2020-07-01T00:24:01.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 28.000000000000004%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mark Anyon | Fission IT
0
Reputation points
answered 2020-07-02T08:12:21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
SQL elastic job not starting and no logs as well
Hello Team, we are using sql elastic job from past few months and we are seeing no issue but all of sudden , we see that our job are not running and even if we manually start the job , then it states moves to create but it not running and there is no…
asked 2020-06-18T18:12:13.617+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rocky420
21
Reputation points
answered 2020-07-01T22:44:03.6+00:00
Mustafa Elmasry
76
Reputation points
2 answers
How to export data from SQL server to a storage container
Hi All. I will like the output of a SQL query to be stored in a storage container in Azure, was wondering what is the best/secure way of doing this in an automated fashion. This can be one output file for each day, the output is a json type. Ideas…
asked 2020-06-29T20:21:02.647+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 39%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MrFlinstone
481
Reputation points
answered 2020-07-01T07:07:59.44+00:00
Vaibhav Chaudhari
38,601
Reputation points
1 answer
Export Azure DB (but disable encryption)
Hi I know this sounds like a bad idea, but I have a legit reason for this. BUT.... all our DBs have TDE enabled but I'd like to be able to perform a couple of backups without encryption being enabled. Beyond enabling/disabling TDE via the portal for…
asked 2020-06-22T21:59:05.873+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 36%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
Ken Faulkner
1
Reputation point
commented 2020-07-01T01:27:35.907+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Which is easiest solution to get connected to Azure SQL database without SIGN in and saving an Client IP everytime?
I have created SQL server, SQL database in azure.I dont have VM,Azure directory,virtual network.Whenever i want to connect to azure SQL database i need to sign in SQ server management studio,then set IP and also in azure portal i need to save my client…
asked 2020-06-30T11:55:25.233+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 38%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Manali
1
Reputation point
answered 2020-06-30T12:37:11.73+00:00
Ronen Ariely
15,096
Reputation points
2 answers
Azure SQL Performance Recommendations taking long time
Yesterday I found 7-8 Index Recommendations for my Azure SQL Databases. I applied few recommendations which is High impact. But it is taking some time - more than 18 hours. Is it not the recommended way? Or should we apply the recommendations…
asked 2020-06-29T02:27:03.247+00:00
Anuraj
166
Reputation points MVP
answered 2020-06-30T09:23:03.617+00:00
KalyanChanumolu-MSFT
8,316
Reputation points
2 answers
Azure SQL Server Connection failure issue when running SSIS package Jobs
Hi, I am facing the following error while loading data on Azure SQL Server: First error: Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: ;Microsoft OLE DB…
asked 2020-06-05T03:21:51.023+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 19%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dhara Prajapati
1
Reputation point
commented 2020-06-30T04:27:20.373+00:00
Dhara Prajapati
1
Reputation point
1 answer
remove filegroup, file
I tried deleting files and filegroups. But it is not deleted. Need help...T T do not remove file, filegroup and filestream DBCC SHRINKFILE(FILENAME,EMPTYFILE) DBCC SHRINKFILE for A_MOD_1 is aborting. MEMORY_OPTIMIZED_DATA container is not…
asked 2020-06-30T01:39:54.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 60%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MKH
1
Reputation point
answered 2020-06-30T04:21:56.187+00:00
Ronen Ariely
15,096
Reputation points
2 answers
Data transfer between two forms
I use Visual Studio, I have a 2 form. First form login, second form inside.. MsSQL inside; name, psw, age, number, gender I want, one user login in his own name later form2 he see informations. Name: Albert Age: 28 Number: 100-02-233 …
asked 2020-06-25T21:40:23.103+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 27%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDU%3C/text%3E%3C/svg%3E)
Doğukan Cantuğ
1
Reputation point
answered 2020-06-29T17:12:35.283+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why do ports 11000-11999 need to be open for an Azure VM to connect to an Azure SQL Database?
We just ran into an issue where a connection from an Azure VM to an Azure SQL Server failed with the following error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP…
asked 2020-06-24T22:28:23.887+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 59%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
skreebydba
26
Reputation points
commented 2020-06-29T15:12:09.303+00:00
skreebydba
26
Reputation points
2 answers
Log shipping
Dear experts I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can connect automatically to DR database…
asked 2020-06-29T05:40:19.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 62%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
mukki mehra
1
Reputation point
answered 2020-06-29T12:55:40.187+00:00
Ronen Ariely
15,096
Reputation points
1 answer
Hang after C# calls ExecuteReader to read big data multiple times
1.Create a thread and call ExecuteReader string conStr = "server=.;uid=sa;pwd=123456;database=itcastdb"; SqlConnection con = new SqlConnection(conStr)； SqlCommand cmd =con.CreateCommand()； con.Open(); cmd.CommandText = “SELECT TOP…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 19%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Can somebody hack the Azure SQL database from other Azure subscription ?
Hello everyone, I have a question about settings of our Azure SQL database. We are using default settings. Allow Azure Services and resources to access this server = YES And we also have defined some IP addresses, which can connect to the…
asked 2020-06-24T07:00:35.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 0%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFE%3C/text%3E%3C/svg%3E)
František Langer
1
Reputation point
commented 2020-06-28T22:10:10.837+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
2 answers
SSIS import Excel - something strange is going on
Hi, I am importing and .xlsx and the SSIS package does not fail, there are no error messages what so ever . But it is only loading a portion of the total file .. There are over 1,000 records in the file, but it only loads 964 .. Again no…
asked 2020-06-26T16:27:53.527+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 17%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Richards Jr, Robert H HHHH
1
Reputation point
answered 2020-06-26T17:19:36.537+00:00
Ronen Ariely
15,096
Reputation points