How can we use insert-update function in synapse analytics notebook while storing data to blob and database
I am beginner to synapse analytics. Trying save data to blob and DB using below code. But showing "AnalysisException: /mnt/usprodannex1/usprodgold_layer/ is not a Delta table." error. Note imported required library( from delta.tables import *)…
Write Operations on primary database latency issue
I have a Azure SQL database replicated to two regions. As per azure documentation secondary databases are read only. In that case all my write operations will be directed to primary. Will that cause latency issue? because my regions are not closer to…
How to assign SPN access to a Azure SQL Database using T-SQL
I already have a SPN and I want to give it access to Azure SQL Database using T-SQL. How to do this.
Is CREATE/DROP INDEX Automatic tuning on the Roadmap for SQL managed instances?
Hello, Azure SQL DB's automatic tuning feature is incredibly helpful for us. Is there any plan to bring these features to SQL managed instances in the future? Thank you, Greg
Not able to connect from my Local Visual Studio 2022 to Azure SQL Server
Azure provided this connection string for ADO.NET: Server=tcp:jeanjhskyblue.database.windows.net,1433;Initial Catalog=MEDISEABLUE;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication="Active Directory Default"; when…
ADF Copy Activity - To Remove records where all cols are Blank
Hi All, I have a copy activity that copies the data from an Excel file to a database table. It seems we are getting some blank rows in the source file for all the columns. In the database table, it is reflected as NULL. We need to restrict these rows…
Column truncate issue - Copy file to DB ADF pipeline
Hi All, I have a pipeline where I am copying data from a file to a database. In the file, I have a few columns with extra spaces that I need to trim or truncate. I am not getting any option to use any transformation or function (dynamic content) on the…
Always Encrypted" column in SQL server
I can't decrypt the "Always Encrypted" column in SQL server using the keys in azure key vault, I am using Go language for the process and I can't find any reference reagrding the decryption, please guide me to decrypt the data in SQL server,…
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 31 October 2025. See our documentation for a detailed list of all…
Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025
I have received the email suggesting that we use these APIs. We have an Azure SQL database that we access using .NET 4.8 linq to entities. The answers provided to two prior questions on this subject are vague at best and seem to not relate to us in the…
Problem Retire Older Version Azure SQL APIs
Hi everyone I've gotten several emails from Azure that says Action required - Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025 followed by the sentence '*You’re receiving this email because you use Azure SQL Database…
Azure sql database - How to set default database
We have AD groups as logins, and a few sql logins in our databases. They all have to switch to the app database as when they use VS or SSMS, they default to the master database. alter login xxx with default_database = [YY] Msg 40517, Level 16,…
Azure SQL Database Created Using 2014-04-01 API - Is this an issue?
I have received the email like everyone else saying "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. As part of this, all version 2014-04-01 APIs will be retired on 31 October 2025. You’ll need to update your resources,…
Not seeing any SQL Security Audit Event on storage account even after configuring Diagnostic setting
I have setup an Diagnostic setting for an SQL Database to achieve SQL Security Audit Event log into storage account but not able to see any container related to SQL Security Audit Event. Am I missing some configuration or setting? Need help regarding…
Action required: Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025
I got an email from Azure: 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 improve performance and security, we're updating Azure SQL Database…
getting error while using SQL Auth for login ssms
I have successfully connect with sql Auth but when i use external table i got an error "External table 'gold.Budget_Master' is not accessible because location does not exist or it is used by another process." but when i login with MFA it…
How to create login credential similar to the SuperAdmin Credential of SQL server with Least Privilege roles
I want to create login credentials that have some permissions similar to super-admin (master credential) in an Azure SQL Database server. following conditions I need: The credentials have login access to all databases present on the server. When a new…
Azure SQL Database: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025.
Got a message that Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. We use dedicated SQL pools, and I am not finding the steps to do this upgrade, can someone assist. Thanks, Girish