Category "azure-sql-database"

Can I use the System.Data.SqlClient provider to establish a connection with an Azure SQL Managed Instance? How about other SQL DBs?

Can I use a connection string with the System.Data.SqlClient provider to connect to an Azure SQL Managed Instance? Or just to a Microsoft SQL Server? If so, sho

SQL: STATUS column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause [duplicate]

Hi Just want to GROUP BY my table without using the status column. but I keep getting the error and I can't figure out to resolve it. SELECT *

How to copy connection security firewall rules,SSL,TLS from one azure DB for mysql to another azure DB for my sql server using powershell

I have restored Azure Database for MySQL single server using powershell script below. Now, post restore the DB I had to copy all the firewall rules and other se

Azure api works locally but not in Azure deployment, for the endpoint which need data from Azure sql db. Endpoint with hardcoded data is fine though

i have deployed a .net core web api to Azure App service. one endpoint of API which does not have anything to get from Database works fine. [Route("api/[contro

Unable to Connect to Azure SQL-Server: sun.security.validator.ValidatorException

Created an Azure SQL server machine and I am able to rdp as well as connect via the local SQL Server Mgt Studio client. However I cannot connect to the same i

Is it possible to have a read replicas of azure flexible postgresql server with a subset of data?

Is it possible to replicate a specific subset of data (certain schema,dbs') to a readonly copy of Azure postgres flexible server. Thanks Brian

Executing Stored Procedure in Databricks when using Azure Apache Spark connector

Following example from Azure team is using Apache Spark connector for SQL Server to write data to a table. Question: How can we execute a Stored Procedure in an

Azure SQL Networking Configuration

I am trying to configure the network setting for Azure SQL server. I have got three services interacting with SQL. They are VM, Azure Data Factory and Web Servi

Enabling public access to SQL Server in Azure devops release pipelines

In order to run migrations on my Test Azure SQL which is configured with PrivateLink I temporarly enable public access and then disable it again. Set-AzSqlServe

Connect to Azure SQL - Token Based

I've tried this over on the Rstudio forums and they've suggested i post here/azure support. Azure doesn't seem to be helping right now so if anybody has any sug

List available PricingTiers for Azure SQL Database Resource

Is there any way to read list of available Pricing Tiers (SKUs) for Azure SQL Database Resource? The list of availabe SKUs (DTU and vCores) available here. Bu

How to add multiple client IP addresses at time in Azure SQL Server using Azure ARM Templates?

Currently I am working on to deploy the Azure SQL Database by adding multiple IP addresses under Firewall rules using Azure ARM templates. This is the code for

Error while running Scala code - Databricks 7.3LTS and above

I am running databricks 7.3LTS and having errors while trying to use scala bulk copy. The error is: object sqldb is not a member of package com.microsoft. I hav

Flow: Dynamics 365 and Azure SQL Server

I have a database in Azure and I would like to bring over all the data from there into Dynamics 365. I have listed the following scenarios. I want to know if th

Connect to Azure SQL in Python with MFA Active Directory Interactive Authentication without using Microsoft.IdentityModel.Clients.ActiveDirectory dll

To connect to Azure SQL Database using MFA (which is in SSMS as "Active Directory - Universal") Microsoft recommends and currently only has a tutorial on connec

Issue - Cannot open server requested by the login. The login fails when connecting to Azure SQL database with Python

I am using Python to query Azure SQL database. I tried connecting using SSMS 2018 and it works. Also, I have ODBC 17, 18 drivers installed. But when I try from

Generating xml with SQL Server with child namespace

I am generating an XML using SQL Server and I need the following name space: xmlns:ns0="http://www.w3.org/2001/XMLSchema-instance" ns0:noNamespaceSchemaLocation

Invoke-Sqlcmd with AAD authentication

In an Azure DevOps 'release pipeline', I provision Azure resources - including SQLServer databases - and try to configure access to databases using managed iden

Create replica of Azure DB for my SQL Server using powershell

While creating replica of Azure DB for my SQL Server using powershell getting the below error. Please help me to fix. Command to create replica of DB server: 1s

EVENTDATA() for DML Triggers?

I am looking to create an audit table for my database in Azure SQL Database. The best method I have across so far in order to do this is to use triggers. I have

Other Categories