can anyone suggest how to create the logic app for failed connections in azure to send mail automatically, diagnostics setting in logs log analytics enabled, f
Since Day X (which is inconveniently just outside my DB recovery plan), I have been experiencing a significant performance degredation on an o
we have an SP where the SP executes and returns multiple result set with change in column number as below: create proc test ab as select 1 as num1 select 1 as
I have a table about shipping that has information about the arrival (country and date) to a port. Now I need to extract the country where it departed from usin
In my following python code I successfully can connect to MS Azure SQL Db using ODBC connection, and can load data into an Azure SQL table using pandas' datafra
This resource states that a Azure SQL database may be attached to a database by using the following command: WITH IDENTITY='SHARED ACCESS SIGNATURE', SECRET =
A data file is imported to a SQL Server table. One of the columns in data file is of text data type with values in this column to be integers only. The correspo
I've tried to implement sensitive data masking with dynamic data masking from Azure Portal. Inspiration came from this article: https://joeydantoni.com/2016/11
A data file is imported to a SQL Server table. One of the columns in data file is of text data type with values in this column to be integers only. The correspo
I'm trying to connect my local database with online database. I've followed the full procedure but Database Sync Group is showing a log error of following type
It's my understanding that lookups and joins in Azure data flows can only be performed between identical/similar formats. For example, between dedicated SQL poo
For the below calculation, the expected result is -0.0000671. But the result of the code is -0.00006800000. declare @V_A decimal (38,11) = 99.99329,
I'm trying to connect to an Azure DB via JDBC using authentication mode ActiveDirectoryServicePrincipal. Connection string: jdbc:sqlserver://xxx.database.window
I want to execute the stored procedures from the logic app. I have added an SQL connector for it. but in the 'Procedure name' dropdown, that particular procedur
I'm trying to set up automated pipeline for database creation and need to open access for all users of some AD group. Last part is done through CREATE USER [Gro
I am testing some workflow in azure on which I have some web apps api connecting to a SQL Database using a service principle. Everything works fine and the web
I would like to know what would be the best way to keep and transfer my SQL Server database scripts (views, trigger, ...) and my files (dataset and reports) fr
I have the below data in my sql server table Name Value ValueHash country aaa zzz lastname ccc yyy email [email protected] xxx firstName bbb www And I want the below Js
I have a table currently with 100M+ rows of telemetry data. The table often receives duplicate records. I can identify duplicate records using a row_number() pa
I want to use ASP.NET migrator to connect a backend (the backend used to work with local database, but now, there is no local database)to an Azure database, but