Azure SQL Database
An Azure relational database service.
6,344 questions
1 answer
Adding users to AzureSQL Databases using SSMS
I am trying to add users to an AzureSQL Database using SSMS 18.9. When right clicking the User tab and choosing New Users, the SQL Editor opens, not the Popup Wizard I am familiar with. In AzureSQL is there a new Wizard or other method for adding…
Azure SQL Database
asked 2021-08-18T17:08:36.26+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, 76%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chris Kellum
1
Reputation point
commented 2021-08-23T10:15:39.047+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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,631
Reputation points
1 answer
Azure SQL DB pre-login handshake provider SSL error 0 the wait operation time out. Microsoft SQL Server, Error: 258
Hi I am getting the following error when I try to connect to some Azure SQL DB, connection from the same machine works without any problem Any help, please? TITLE: Connect to Server Cannot connect to XXXXXXXXXX.database.windows.net. ADDITIONAL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
![](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(188.79999999999998, 99%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
![](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(310.4, 30%, 40%)' 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)
4 answers
One of the answers was accepted by the question author.
Azure SQL Failover Group and Geo Replication Usage
Hello, I have the following application and database configuration: 4 Regions - Region A (main), Region B, Region C, Region D (close to Region A) 3 Web APIs - Region A, Region B, Region C 4 Azure SQL Servers - Region A, Region B, Region C, Region…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-07-25T13:02:12.62+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, 98%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOT%3C/text%3E%3C/svg%3E)
Oleksandr Tedikov
26
Reputation points
commented 2021-08-21T18:27:33.073+00:00
Oleksandr Tedikov
26
Reputation points
4 answers
One of the answers was accepted by the question author.
Create Azure SQL Server with my local time (UTC+8)
experts, i would like to create a azure SQL DB with my local time, when i query select getdate() which need to return UTC+8 result. please provide me the guidance, thanks.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
![](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(124.80000000000001, 10%, 22%)' 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)
1 answer
data trasformation
Hi, I have multiple tables stored in sql database. Using these tables i want to create some other table using sql query and then i want to call these tables in my machine learning pipeline. How can i do this also i need to schedule this process every…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
asked 2021-08-20T08:52:43.223+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(198.4, 10%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rishi singh
1
Reputation point
answered 2021-08-20T12:48:07.337+00:00
Vaibhav Chaudhari
38,921
Reputation points
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
Performance Feedback for Azure SQL MI Linked Service to Synapse Serverless
Has anyone tried a linked service in Azure SQL MI connected to Synapse Serverless as per the approach in this article? What does performance look like for importing millions of rows from parquet files in ADLS?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
![](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(316.8, 12%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Azure SQL DB audit specification and AUDIT_CHANGE_GROUP
Is it really the case that the server audit facility in Azure SQL does not capture changes to the audit itself ? I'm referring to the kind of activities that would be captured by this audit specification group - AUDIT_CHANGE_GROUP. These would…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-18T09:21:15.053+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(118.4, 62%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
backtothefuture
91
Reputation points
commented 2021-08-19T14:16:38.613+00:00
Alberto Morillo
34,676
Reputation points MVP
Volunteer Moderator
1 answer
Stream Analytics - Reference Data
Hi, I have to set a pipe line to get data's into "stream analytics job service" from sql database directedly( should not use other layers/components Ex: Data factory, Event hubs etc between sql db and stream analytics job ) . But no stream…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
397 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
asked 2021-08-12T04:41:37.507+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, 45%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Prabhu Rsp
1
Reputation point
commented 2021-08-18T18:34:49.99+00:00
Sander van de Velde | MVP
36,766
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Azure SQL Database vCore Auto-Scaling
Currently we are using an Azure SQL Database that is 32 gb in size. We have 4 vCores allocated for it, but are not always using the full computing potential of these cores. Is there a way for us to auto-scale our vCore usage? We would like to sit at 2…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-18T16:40:03.713+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(188.79999999999998, 88%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alex Rhomberg
21
Reputation points
accepted 2021-08-18T17:56:25.977+00:00
Alex Rhomberg
21
Reputation points
1 answer
One of the answers was accepted by the question author.
ADF fails to connect to Azure SQL Database using Managed Indentity
Hi, I am trying to connect to an Azure SQL Database but I get a generic connection error: Cannot connect to SQL Database: 'mysqlserver.database.windows.net', Database: 'dwh', User: ''. Check the linked service configuration is correct, and make sure…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
asked 2021-08-17T17:07:32.267+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(131.20000000000002, 31%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFH%3C/text%3E%3C/svg%3E)
Fernando Hidalgo
101
Reputation points
accepted 2021-08-18T10:47:35.877+00:00
Fernando Hidalgo
101
Reputation points
1 answer
One of the answers was accepted by the question author.
Enable geo-replication for Azure SQL Databases
When i try to create a geo replication for SQL Databases. But i can not see the menu geo replication on the left menu of SQL Databases Please help me in this situation Thanks
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-18T06:19:59.7+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(121.6, 73%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nguyen Manh Hung (DPS.VI.ITM)
21
Reputation points
accepted 2021-08-18T07:17:52.487+00:00
Nguyen Manh Hung (DPS.VI.ITM)
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Backup managed instance to storage account
I want to write a .bak of a managed instance database to a blob storage container in a storage account? My idea is to be able to grab that .bak to restore to on-prem DB in case necessary. The following article describes it: …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
![](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(150.4, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
1 answer
Connection String of SQL Managed Instance
I have a scenario where my Azure App Service is connecting to Azure SQL Managed Instance. There are more than one DB inside the Instance. How do I connect to a particular DB so that I can fetch table's values? I see that the connection string in the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-12T10:31:23.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(240, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sai Harsha Pisapati
1
Reputation point
commented 2021-08-17T14:52:50.127+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
External table creation based on table from another server
Hi, I am trying to create an External table in one database server , by accessing some table from another Remote Database server. Creation of External Data source as well as External table was successful. But when I try to query the External…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
asked 2021-08-16T13:20:42.01+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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gowri Shankar
226
Reputation points
accepted 2021-08-17T11:22:58.57+00:00
Gowri Shankar
226
Reputation points
1 answer
Automatic migration of excel files into Azure sql database
I am writing a c# script that calls the third-party website by API and in return, I am getting excel files. I want to execute this script using azure functions at some schedule, which means that those excel files will be replaced every time when the…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,936 questions
asked 2021-08-12T14:46:33.117+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(304, 16%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA2%3C/text%3E%3C/svg%3E)
Asaldin-2272
1
Reputation point
commented 2021-08-17T05:53:58.58+00:00
Anurag Sharma
17,631
Reputation points
1 answer
Is it possible to export a database locally from a disabled sql server due to insufficient credit
Due to subscription ending our sql database server was disabled so we're unable to connect to the database within, is it possible to export the database schema/data from the sql server locally? from what I've read is that the database only allows…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-06T16:20:30.937+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(268.8, 92%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mashura Development Team
1
Reputation point
commented 2021-08-17T05:51:54.997+00:00
Anurag Sharma
17,631
Reputation points
3 answers
Stored Procedure Error
Cannot create Sql Source. Please double check the connection string, stored procedure are set with correct format. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'RunID'
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
asked 2021-08-16T11:42:18.95+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(9.6, 83%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Madhusudan Reddy Mandala
1
Reputation point
commented 2021-08-17T05:46:22.54+00:00
Nandan Hegde
36,151
Reputation points MVP
Volunteer Moderator
2 answers
Is there a way to restore a SQL MI database without breaking the replication?
Hi All, We followed the this link to restore a database in SQL MI, and got an error on the step of altering the new database name to match the original database name. The error says that the original database is in a replication relationship. I don't…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-07-27T03:31:48.087+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(208, 75%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Stanley Young
1
Reputation point
answered 2021-08-16T16:46:43.533+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
Azure SQL Managed Instance - Transactional Replication - Still Public Preview?
Greetings, Simple question that I can only find vague answers to - Is Transactional Replication still a "Public Preview" for Azure SQL Managed Instance? If so, does anyone have any idea when it will become GM? Thanks, Brian
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
asked 2021-08-10T17:39:20.277+00:00
Brian Hawkins
21
Reputation points
commented 2021-08-16T15:01:01.53+00:00
Brian Hawkins
21
Reputation points
1 answer
One of the answers was accepted by the question author.
How to set partition key in SQL API through the .NET SDK
I use .NET SQL SDK for creating the Database and the Container in Cosmos DB. I want to create the container with defining the partition key as 'UserId', but when I use the method CreateDocumentCollectionIfNotExistsAsync() for creating the Container, and…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,344 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,911 questions
Developer technologies | C#
11,579 questions
asked 2021-08-12T16:00:20.07+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(156.8, 8%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAY%3C/text%3E%3C/svg%3E)
Akshar Yadav
21
Reputation points
accepted 2021-08-16T08:04:55.447+00:00
Akshar Yadav
21
Reputation points