I need remove the all comments in a SQL view created in Azure SQL Data Warehouse. Create the query without comments (/* */ ; -- , ...); regular expression functions not working Query: CREATE VIEW [dimension].[v_dim_customer] AS SELECT -- primary…
I have a C# .NET 8 isolated Azure Function App that I am trying to connect to a SQL database, but I am having trouble trying to locate the problem. The SqlException: A network-related or instance-specific error occurred while establishing…
For one of our clients I'm configuring a build and deployment pipeline in Azure DevOps for an Azure SQL database. We have done this many times before without issue, but this is the first time I'm using a service connection…
I have created a bacpac backup from Azure SQL database and I want to restore it to AWS RDS SQL server. But when I try to import the .bacpac file to RDS, I get the following error. Error SQL72014: Core…
I have a pretty large (250gb) Azure SQL database which is mostly used for a multi-tenant transactional point of sale system. We have a lot of business reports which are essentially stored procedures sitting behind a reporting framework (Telerik Reports).…
I have a group of linux web apps with VNet Integration enabled on a subnet called web-tier and an azure server with private link configured on another subnet called data-tier. I have also added nsg rules to the data-tier subnet…
I've setup an AzureSQL failover group using a bicep, with very simple settings. The first deployment works as expected. If I deploy again, without making any changes, I get this error: The property targetServer of the read-only endpoint must be…
I accidentally deleted a table manually from my Azure SQL Server database in an ASP.NET Web API & Entity Framework project. How can I restore it? Migrations won't update because it thinks the database is up to date, unaware of…
I have rows containing Json like: [{"Qty": 1, "Amt": 2.99},{"Qty": 3, Amt": 4.50}] How do I get a sum of Amt per row? Reproduction Code: DROP TABLE IF EXISTS dbo.SqlQueryResults; CREATE TABLE dbo.SqlQueryResults( Id INT, Result nvarchar(max) ) GO INSERT…
I am using Azure Static Web App with Azure SQL database. When filtering the data, I want to use the in instead of the eq operator. So far the eq operator is working as expected: async function filterProducts() { const…