Category "azure-sql-database"

How to view the roles and permissions granted to any database user in Azure SQL server instance?

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?

How to programmatically change tier of Azure SQL Database

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

How to programmatically change tier of Azure SQL Database

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

Data replication from prod to read replicate in Azure SQL MI

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

'pyodbc.Cursor' object has no attribute 'fast_executemany'

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

Azure point in time restore - Query for checking progress

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

Azure Graph Query in az graph query command

Resources | where type has "microsoft.compute/disks" | extend diskState = tostring(properties.diskState) | where managedBy == "" or diskState == 'Attached' or d

Hyperscale to general purpose

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

Cannot get Linked Servers to work in Sql Azure

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

How can I schedule a SQL job in Microsoft Azure SQL Database?

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

Social security number format missing under masking field format

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