Category "azure-sql-database"

SQL Server Reporting Service (SSRS) on Azure SQL Database [closed]

Azure SQL Database supports Full recovery model and we can't change the recovery model of Azure SQL Databases. As mentioned here while making

Azure SQL Database: Full text index on certain emails does not work

I have a full text index defined on user table's username column. When there is any character following + symbol in email in the search query there is no result

How to add Azure SQL server to Grid.js table data attribute

I've been struggling for a couple of days trying to link my Grid.js to Azure SQL database. My SQL database query function returns the data, but I can't link it

Authenticate with Azure AD account while using Read-SqlTableData to read AzSQL tables

What other properties does one need to add to the ConnectionContext while connecting to AzSQL using an AzAD account? $srv = new-object ('Microsoft.SqlServer.Man

Escape '\' in dynamic content in Azure Data Factory

I am hitting a query through lookup activity on DB2 Database using ADF. Query is: But when I execute the query the '\' count gets double. The output is provide

Sporadic Azure SQL Semaphore Timeout/Handshake error when connecting as login, but login@servername seems to work?

I am having issues reliably connecting to Azure SQL Databases from on-prem. (so yes, firewalls involved). When I connect (SSMS or invoke-sqlcmd) using just mylo

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