When I scan my database, it shows one of the result like VA1143 'dbo' user should not be used for normal service operation in A Vulnerability Assessment scan They have suggested to "Create users ...

I got a message from Microsoft in the last few days Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. You're receiving this email because you use Azure SQL Database APIs. To i...

I have an EF6 solution that I would like to add a trigger on a table to log changes to a new table. This is due to an integration we are doing to an external database. Basically, they want a log of...

I have a data set that I want to place in a clustered column store and optimize it for segment elimination when accessing it by a column called SubjectId which is defined as uniqueidentifier type. ...

In Azure Data Studio (ADS), is it possible to reuse SQL parameters from query to query? Not sure if I'm jumping out of the intended purpose of ADS but it would be really great if I could declare a ...

I am using a json coming from logicapp events which has datetime properties in below format "startTime": "2017-07-12T17:14:16.0500772Z", "endTime": "2017-07-12T17:14:17.2939322Z", in a stored ...

I have an Azure SQL Server and can SSMS into it. I also have an Azure Active Directory with a user named [email protected]. I want to add this user to have permissions to a database in my Azur...

> ADDITIONAL INFORMATION: Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid. You must make sure the service...

I exported my Azure database using Tasks > Export Data-tier Application in to a .bacpac file. Recently when I tried to import it into my local database server (Tasks > Import Data-tier Application)...

I use GitHub actions to spin up Azure resources from scratch using Infrastructure as Code (IaC). In my case Bicep, but it could be Terraform. This includes an Azure SQL Server, a SQL Database, and ...

I'm facing this issue intermittently now, where the query (called from stored Procedure) goes for CXSYNC_PORT wait type and continues to remain in that for longer time (sometimes 8hours in stretch)...

I'm doing my best an deleting rows and rebuilding indexes but the size of the database is growing really fast and I can't see the effect of my operations. Is there a cause for this and is there a ...

I have an ASP.NET Core app [Microsoft.AspNetCore.App 2.1.4] with EF Core 2.1.4 [DbContext pooling enabled] and data stored on an Azure SQL database. Occasinaly [once in 1-2 days] I get unrecoverab...

I have a setup in azure with a bunch of resources combined in a resource group. I want my services to be located in west-europe, so all my resources are there (where possible) I just noticed that ...

Since updating Windows 10 to 1803, I have begun receiving this error anytime I run an EF query that joins against a table-valued function that takes in a scalar parameter. Message: The incoming ...

I have implemented Power BI embedded in a web app with direct query using Azure SQL as data source. The Azure SQL database is being updated by webjobs and if I leave open the Power BI embedded web...

I have MSSQL .BAK file, and for logistical reason (the DB being huge for my infra) I want to convert the same to BacPac file, so that I could upload the same to Azure. All this while I thought .BA...

I have a set of large CSV files with many columns each that I need to import into a SQL Azure database. Ordinarily I would use the import wizard in SQL Server Management Studio. However, the wizard...

I am using Visual Studio 2015 and having an issue in my SQL Server database project with STRING_AGG WITHIN GROUP. SELECT [Continent], STRING_AGG([Country], ', ') WITHIN GROUP (ORDER BY [Country])...

I have SQL server & web app hosted over Microsoft Azure platform. I am constantly getting above error when ever i run web application (and try to connect azure sql server) from my local network...

I get the following error message, when I try to connect to SQL Azure. Windows logins are not supported in this version of SQL Server I'm using an Azure connection string. On development I'm r...

Is there any way to stop a SQL Azure DB so that it doesn't charge anything towards our account? I don't want to delete it, just while in testing and it's not being used than we set it to "stopped" ...

I have a stored procedure that I want it to run in every mid nigh but my data base is in aZure How can I schedule a task using sql agent?

{ "errorCode": "2200", "message": "ErrorCode=FailedDbOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: ...

I am trying to connect to an Microsoft Azure SQL server database. This is how i am trying to connect: conn = pyodbc.connect('DRIVER={SQL Server};SERVER=%s' % (self.config.get("Sql", "DataSource...