SQL Azure - Administration

• Topics

  Started by

  Posts

  Last post

• Restore database on Azure VM fails

  I'm trying to restore a database containing memory optimized tables to a standard edition of SQL Se…

  pooyan_pdm

  1 replies

  1 week, 5 days ago

  By: anthony.green

• Get notified for any new Azure SQL db creation in subscription

  Hi All, Is there a way to get notified if someone creates a new Azure SQL db in a particular subscr…

  RPSQL

  1 replies

  1 week, 6 days ago

  By: Grant Fritchey

• Opening Azure database in SSMS

  I triad to open an Azure database in SSMS and it opens fine, I can see data and query tables but I'…

  DaveBriCam

  2 replies

  4 weeks ago

  By: Grant Fritchey

• Memory utilization shown on DMV sys.dm_db_resource_stats

  Hi Guys, Can anyone please bit more details on what is this metric "avg_memory_usage_percent"exactl…

  salamlemon

  1 replies

  1 month, 1 week ago

  By: Grant Fritchey

• Correlation of DTU and RAM in ( GB) allocated to DB

  Hi, Azure portal  and DMV providing   % of memory used by database I want to query  MAX  RAM i…

  ebooklub

  3 replies

  1 month, 1 week ago

  By: ebooklub

• How to move PROD SQL Azure Singleton database from one subscription to another?

  We have our production database (Azure Singleton) up and running in Azure. Due to a few security vu…

  SQLCurious

  3 replies

  2 months, 1 week ago

  By: SQLFlipFlopsDBA

• Azure SQL DB : "Login failed for user." (sys.event_log)

  hi! Please advise where can I get more details on Portal.azure.com about connectivity.connection_fa…

  Andrey

  2 replies

  2 months, 1 week ago

  By: SQLFlipFlopsDBA

• Issue with using Ola Hallengren Backup script

  Hi, I am using OH's excellent scripts, however I have found and issue when it comes to backing up t…

  quackhandle1975

  20 replies

  2 months, 1 week ago

  By: Revane

• Azure DB newbie trying to locate existing Azure DBs

  Hello, I've been tasked with trying to learn more about existing Azure DBs that our company is usin…

  tarr94

  3 replies

  2 months, 1 week ago

  By: tarr94

• Migrate SQL Server Database Off of Azure to on-prem with little downtime

  We have decided to move off of Azure to a local data center and wanted opinions on how to do this m…

  ericwenger1

  1 replies

  2 months, 2 weeks ago

  By: Grant Fritchey

• Impersonating a server principal (login) in Azure SQL MI

  Hi all, I seem to be doing something wrong or trying to do something that's not supported. I freque…

  feersum_endjinn

  1 replies

  2 months, 3 weeks ago

  By: feersum_endjinn

• Backups Best Practice for SQL Server IaaS

  What is considered best practice for SQL backups for SQL Servers (specifically 2017) running in an …

  PhilipC

  10 replies

  2 months, 3 weeks ago

  By: Grant Fritchey

• Does blocking has affect on High DTU utilization ?

  Hi, Does blocking has affect on High DTU utilization ?  (some people advocate that Spike in DTU mi…

  ebooklub

  1 replies

  3 months, 1 week ago

  By: ebooklub

• Migrate Database with column level encryption to Azure

  Hi, We've got an on-premise database that uses column level encryption and are currently investigat…

  gareth.barnes

  13 replies

  3 months, 1 week ago

  By: Steve Jones - SSC Editor

• Metric CPU show 100% , but Query Performance Insight show only 60% same period

  Hi, I am investigation DTU spike for period specific period of time In my case  time period  in q…

  ebooklub

  2 replies

  3 months, 1 week ago

  By: ebooklub