To connect to Azure SQL Database using MFA (which is in SSMS as "Active Directory - Universal") Microsoft recommends and currently only has a tutorial on connec
I am using Python to query Azure SQL database. I tried connecting using SSMS 2018 and it works. Also, I have ODBC 17, 18 drivers installed. But when I try from
I am generating an XML using SQL Server and I need the following name space: xmlns:ns0="http://www.w3.org/2001/XMLSchema-instance" ns0:noNamespaceSchemaLocation
In an Azure DevOps 'release pipeline', I provision Azure resources - including SQLServer databases - and try to configure access to databases using managed iden
While creating replica of Azure DB for my SQL Server using powershell getting the below error. Please help me to fix. Command to create replica of DB server: 1s
I am looking to create an audit table for my database in Azure SQL Database. The best method I have across so far in order to do this is to use triggers. I have
Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance?
We have a large SQL Database running on Azure which is only generally in use during normal office hours, although from time to time, overtime/weekend staff will
We have a large SQL Database running on Azure which is only generally in use during normal office hours, although from time to time, overtime/weekend staff will
I am in middle of finalizing database for our company. Though I have gone through multiple readings but there are couple of questions which i am still confused
I have a problem, I have a web app that is using fast_executemany in order to insert into the database. When running it on localhost it works with no problem, b
Is there a way to check the progress percent of azure point in time restored databases? I started a restore of a 750 Gb database, and i do not know whether it h
Resources | where type has "microsoft.compute/disks" | extend diskState = tostring(properties.diskState) | where managedBy == "" or diskState == 'Attached' or d
We have a azure hyperscale sql db. We want to restore it to general purpose. Is anybody know to restore azure hyperscale sql database to general purpose databas
We are using a trial version of Azure. We are trying to perform cross server queries from our SQL Server 2012 in-house. We seem to have our local 2012 linked wi
I have one SQL Agent maintenance job which checks the index fragmentation within a database and rebuilds indexes if required. This is running well in my test se
I implemented the dynamic data masking in my current project, for that I created the Azure SQL database and table. After that I went to dynamic data masking opt