If I stop the database will it cost me in Azure?
If I stop the database will it cost me in Azure?
Handling different date formats in Azure SQL
I need help with writing a stored procedure in Azure SQL that updates datetime values stored as varchar columns with different date formats to a consistent format of 'MM/dd/yyyy hh:mm:ss'. Specifically, the columns whose names end with 'DP' need to be…
How to enable SQL PrivateLink connection when SQL server is behind Active/Passive load balanced firewall pair
We have configured an Edge VNET that contains and ELB with our public IP that goes to a pair of Fortinet firewalls. Those firewalls route traffic to our spoke VNET that contains our SQL server that has a PrivateLink interface. If I leave external access…
need help downloading sql server on my ,mac,
Hi everyone im trying ways to download the sql server and cant do it, need help downloading sql server on my ,mac, provide a info and download link if possible
SSMS UI bug (all versions so far)
Hello there, There is an annoying bug in the SSMS UI that I thought will be found and fixed with the latest version (19.0.1) I just installed. It persists in all the previous versions I used and is available here too. Here is the description: Connect…
How to choose between Azure SQL Always On Availability Groups vs SQL Server Replication
Background: Our production SQL Server database is hosted on Azure VM. We have a nightly process to create a data warehouse environment that is used by our power users to query a day-old data and run reports. We would like to create a (or more in the…
Azure SQL DB Autoscaling issue
Hello, I'm currently facing an issue with automating the scale up/down of my Azure SQL DB. When the DB experiences high DTU usage and the auto scale-up is triggered by an alert runbook, the query that was running on the DB gets interrupted, causing my…
How to view SQL Azure Business Critical Tier - Qurom, replics, etc.
We just scaled from General Purpose Tier to Business Critical in our main production Azure SQL Database (not Managed Instance). Everything is running fine, and I can connect to the read only replica successfully. Besides initiated a manual failover, I…
Unable to deploy SQL Server bicep template using AzureAD Authentication: true
Hi, I am deploying Azure SQL Server with administratorLoginPassword using Incremental mode but it is giving me error (AadOnlyAuthenticationIsEnabled). I need to use the password while deploying and I cannot ignore it. Also, while deploying the sql server…
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
Synapse can't transfer data from parquet file to Azure SQL Database table
Hi! The pipeline in Synapse (workspace) transfers data from parquet files to a database using a copy activity. Everything has been working fine for months, but today it simply times out without a specific error. It seems the problem lies in…
How to translate database content with Azure Translator by ADF or Synapse notebook?
There is an Azure Database table. Some of columns need to be translated from one language to another into additional columns. Such as from English to Spanish, or Portuguese to English, etc. I am exploring how I can use ADF or Synapse notebook to…
How to split rows and columns by using ADF?
How can I retrieve data from the following table by using ADF lookup activity and want to get the result as below? Thanks
Deployment of App service
I am creating an Azure SQL database and after clicking on review and create. But for hours I am getting deployment in progress and I don't know why. Any help?
Logic App - Store query result from Azure SQL in to Sharepoint and retrieve back the link
Hi All, I've very basic requirement but unable to chalk it out, how to do it. I have one standard logic app workflow. It will be http triggered. Once triggered, it will run a stored procedure on one Azuer DB table and store the result as JSON in…
Create a data factory and pipeline using .NET SDK
Hello, this is my first post here and I hope to find a solution. I am working on a web portal (.NET) hosted in Azure Web Apps and need to create a Service Link for Azure SQL Database in Azure Data Factory when I perform specific actions. The problem is…
How to recover lost password for "SQL azure"
Hi, I lost password to my "sql azure" admin account. HOw do i recover access to azure db. Can microsoft suport create a new account for me
Standalone/Serverless Azure DB - DBCC SHRINKDATABASE and DBCC SHRINKFILE throwing "Query execution timed out." after 300 seconds
I have a standalone DB and trying to use "Query Editor (Preview)" to shrink the DB or DB file. It has 500 GB max storage, 410 GB allocated, any only 152 GB used. I want to lower the allocated so that I can also lower the max. Every query…
Migrate Azure SQL server instance to SQL managed instance
Dear forum, We're planning to migrate our DBs on a SQL server instance to a SQL managed instance. We're focussed on migration our dev/test instance first before doing production. The back-ups are done using the Azure Recovery Vault service. We would like…
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…