Questions tagged [azure]
The azure tag has no usage guidance.
153
questions
1
vote
0answers
12 views
Creating my first Elastic Database Job on Azure
On https://docs.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview it says that there is a new replacement for SQL Agent. However, I cannot get it to work.
I had problems ...
0
votes
1answer
12 views
Azure PostgreSQL pg_dump impact on backup “chain”
I'm a SQL Serve DBA new to PostgreSQL. Does pg_dump have an impact on the backup chain, i.e., in SQL Server if I needed a copy of a database I would peform a COPYONLY backup so as not to break the ...
1
vote
1answer
11 views
Azure SQL - dataspace used vs max dataspace
I have a single Azure SQL database in Azure with the following database data space
As I read the documentation: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management ...
1
vote
2answers
40 views
Migration to SQL Database using Transaction Replication - down time?
I am looking to migrate two on-prem SQL Servers into Azure Hyperscale. Both 28 cores, 1.5 TB of RAM with 10TB data disks.
I can NOT afford any downtime during the migration and have heard transaction ...
2
votes
1answer
39 views
Azure Managed Instance - Is it possible to send Sql Logs To Log Analytics?
Is it possible to stream a Managed Instances SQL logs into log analytics?
I need a single location for all Azure based monitoring so that multiple teams have visibility/access to log information for ...
1
vote
1answer
41 views
Moving from Azure to Hyperscale
Does Azure Hyperscale allow for Memory optimised tables and does it allow/have rollback facilities
2
votes
2answers
34 views
Azure blob storage container vs VM managed disk for SQL on Azure VM database files
Are there benefits specific to SQL Server on Azure VM when using the SQL Server Data Files in Windows Azure feature? Aka using Azure blob storage container for database files versus an Azure VM data ...
1
vote
0answers
36 views
Availability Group Read Only Routing Not Working for Azure App Service that connects over Hybrid Connection
We have following config of Availability Group On-Premise:
server1.domain.com - primary
server2.domain.com - sync secondary
server3.domain.com - async secondary
sql-listener.domain.com - ...
1
vote
2answers
50 views
Is it bad practice to automate the updating of statistics and re-making of query plans on a relatively small SQL Azure database?
I have a SQL Azure database that's about 500MB in size. Every 2-3 weeks the database will suddenly start to run slow and some queries (generated by LINQ) will timeout. There is no gradual increase in ...
0
votes
0answers
28 views
Importing BACPAC file from azure to SQL creating an empty database
Exported Data-Tier_application from an Azure database to create a BACPAC of it.
SQL editions I'm trying to use to import the BACPAC:
SQL Server 2016 express.
SQL Server 2017 Developer ...
0
votes
2answers
18 views
Azure Database Link to another Azure database
How to query between two databases with the same server in SQL Database?
Currently we are aiming to link two azure databases that will update simultaneously.
Thanks!
0
votes
1answer
51 views
Replicate SQL Server 2008 across domains
I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, ...
1
vote
1answer
23 views
Sharded Mongodb stalls randomly
I have setup Sharded MongoDB cluster using hashed sharding in kuberenetes.I first created the config server Replicaset and then created 2 shard replicasets. Finally created mongos to connect to the ...
0
votes
0answers
39 views
Azure SQL Data Sync: How to Increase Synchronisation speed after bulk purge/update in Azure SQL Data Sync Service?
I have two tables across two regions in Azure SQL Databases. There is a Bi-directional Data Sync configured between those two databases with automatic frequency of 15 minutes and conflict resolution ...
1
vote
0answers
27 views
SQL User vs AAD for Azure SQL Managed instance
It appears the app response is much slower when it uses the AAD account to access the Managed instance compared to using a SQL user (SQL Auth).
Can anyone please shed some light on whether this is ...
0
votes
0answers
24 views
Read performance of SQL Server data files data from Azure BLOB
I have a setup where there is SQL Server on premises (MS SQL Server 2016 13.0.5366.0) but database files (log and data) are stored in cloud storage account. Setup described here.
The interesting ...
0
votes
0answers
26 views
Azure ARM template SQL backup deployment intermediate failure
I am having an intermittent error when trying to deploy a backup solution during provisioning. The error I get sometimes is:
Deployment failed. Correlation ID: bb100978-3c7b-46f4-bcca-8b9abb490a98. {...
0
votes
0answers
21 views
Azure VM Security
With the move to Azure Cloud things are moving fast! I have a question based on Azure VM with a shared SQL Server containing multiple instances.
For example if a Azure VM has 5 instances on there ...
0
votes
0answers
31 views
Restoring database created with Ola's tools from Azure blob
I'm exploring using Ola Hallengren's excellent backup tools to backup to an azure blob. Is there a simple way to do a restore of the latest backups on a fresh MSSQL 2017 database directly from azure ...
1
vote
1answer
30 views
Setting up sp_AllNightLog using Azure Blob Storage [closed]
Has anyone setup Brent Ozar's sp_AllNightLog using Azure Blob Storage? Trying to start incorporating both but not sure of the steps or how to get started. Any tips or links to similar operations?
0
votes
1answer
44 views
TRY .. CATCH sometimes fails to catch PRIMARY KEY VIOLATION
I wrote code to upsert records to the database. The database is Azure DB, S4 tier.
Updates and inserts are sometimes are highly concurrent since it's coming from the application that doing too many ...
0
votes
1answer
27 views
Load data from a temporal table to another temporal table in Azure
Currently we have only a Live Database where all our data resides. I have created a separate Azure server and DB for development.
The DEV DB should be some what up to date with the Live DB for ...
2
votes
1answer
50 views
Recommendation on changing Azure SQL Database tier weekly [closed]
We have an Azure SQL Database of size 50GB in the S6 tier. On weekends, the usage is very minimal.
Is it okay to change the tier to S0 every weekend for cost savings, and change back to S6 on Monday?
...
0
votes
0answers
26 views
Importing dbatools module into Azure Automation Account
Has anyone managed to import dbatools module into Azure Automation Account? I tried to do it in several ways, but every time the installation fails:
different versions checked from 0.9.* to the ...
1
vote
1answer
27 views
Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database
We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says
Column mycolumn in object mytable contains type Date, ...
0
votes
0answers
12 views
Azure Managed Instance MSOLAP OLE DB connector
We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, ...
0
votes
2answers
52 views
Auto scaling MongoDB as a service in Microsoft Azure
I see a MongoDB service in Microsoft Azure but that deploys a VM and installs MongoDB in that. I am guessing this will not auto scale and also charge me for the entire VM and MongoDB management (not ...
1
vote
0answers
56 views
SQL Server Database auditing not working
I'm setting up auditing on a SQL Server Managed Instance in Azure (Version = Microsoft SQL Azure (RTM) - 12.0.2000.8). Following the instructions in the link, everything worked for server-level ...
0
votes
0answers
9 views
Azure Storage Account access
What is the difference between SAS token and access keys (internally)?
Which is the better way of accessing the storage?
SAS keys do have expiration so admins do have control for how long it will ...
0
votes
0answers
14 views
Enabling Advanced Data Security (ADS) on Azure
Can somebody please let me know if ADS is turned on, would it have any negative effect on Azure SQL database performance?
0
votes
0answers
11 views
MABS - Synchronization frequency for New Protection Group is not showing up for a user database
I am trying to create a user database policy that does incremental 15 min log backup, however when I get to "Specify Short-Term Goals" in the "Create New Protection Group" wizard, the "Synchronization ...
0
votes
0answers
22 views
SSMA Migration data failed from Oracle to Azure Database
I'm having an issue with the migration between an Oracle database and an Azure Database using SSMA v7.10.0.
I can connect, convert the schema and synchronize with the Azure database with no problem.
...
0
votes
0answers
24 views
Azure Database Encryption (ERROR ON WEB APP)
Currently I have an azure subscription which has a server and database.
I already encrypt a column in a table. i am using "always encrypted" method. Now I want to generate a .pfx file after I ...
0
votes
0answers
20 views
Postgres INSERT slows down over time until server is restarted
I have a Rails app backed by an Azure-managed Postgres database and I use NewRelic for monitoring. What I've noticed is that the INSERT performance degrades almost linearly over time - what started ...
0
votes
0answers
5 views
Changing of Azure domain to another location
I would like to ask few items on transferring our azure domain.
Below are the items for confirmation.
Steps on how to transfer domain?
What is the risk in transferring our domain?
What will be the ...
0
votes
0answers
51 views
Azure sql database backup and exporting data-tier application
Currently i have an azure subscription in it has a server and a database.
How could i setup azure SQL database backups that will run automatically for example every 15 mins? is there a way? if yes ...
1
vote
0answers
11 views
SQL Server 2016 query Azure AD
I need to query our (Azure) AD to get a user username based on on an email address I am being passed and then write it to a table ideally via an SP.
From my brief bit of reading, Azure AD supports ...
2
votes
1answer
27 views
SQL Azure “hot” table query slowdown over time
I have an Azure SQL Database table that is acting as a "prioritized queue". As such, it gets heavily written to and deleted from over time. What's happening is that after a week or two, the DB size ...
0
votes
0answers
20 views
How to use sendgrid smtp in azure DB
When I tried to configure DBMail using SendGrid SMTP, the below error occurs:
The mail could not be sent to the recipients because of the mail
server failure. (Sending Mail using Account 2 (2019-...
0
votes
0answers
22 views
Azure SQL Database encryption
Currently i have an azure subscription in it has a server and a database.
How could i encrypt an SQL azure table and when the encryption is done i can still insert some data on the table?
I already ...
0
votes
0answers
22 views
Database Administrator
If I want to be the only person/department in my organization that can create and administer databases in Azure. What privileges do I need have and make sure no one else has?
I will need to give ...
0
votes
0answers
23 views
How to use the Percona Toolkit to connect to Azure Database for MySQL when SSL is enabled
I am attempting to use the pt-show-grants to connected to a MySQL instance with SSL enabled.
$ pt-show-grants --version
pt-show-grants 3.0.9
If I attempt to connect to my database without any ...
0
votes
1answer
49 views
Access control on Azure SQL Data warehouse
Access Control setup on Tables inside dbo schema.
We are Denying select permission on some tables inside dbo schema as these tables have some critical data.
Issue: Even when Select query fails on ...
3
votes
1answer
292 views
How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?
I have created a SQL maintenance job using Azure Elastic Job Agent with the following step:
EXEC jobs.sp_add_jobstep @job_name = @jobName,
@step_name = 'Optimize indexes and statistics',
@command=N'
...
0
votes
1answer
150 views
Ola Hallengren for Managed instance
How can we configure Ola Hallengren's solution on a managed instance? (We want output file for each run, storing it is an issue)
If we want backup retention longer than 35 days for the database in ...
2
votes
1answer
55 views
Only 'master' inside the system databases in Azure Managed instance
During our POC we saw the system databases(model,msdb and tempdb) lying outside the system databases group.
Any specific reason behind it?
0
votes
0answers
40 views
Any way to get a key stored in the Azure Key Vault when retrieving Always Encrypted data through SSRS?
If you are using Always Encrypted and the key is stored in the Azure key vault, is there any way to use on-prem SSRS to view the encrypted data? Obviously with the client application this can be coded....
2
votes
1answer
259 views
what is the maximum capacity allowed for SQL managed Instance?
I am looking in option to migrate to SQL Managed Instance but found on MSDN that it supports max of 8 TB in General tier and 4 TB Business critical. what are option for databases greater than 8 TB?
...
0
votes
0answers
64 views
Azure MariaDB log_bin_trust_function_creators
I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters.
I've checked and ...
0
votes
1answer
44 views
Ephemeral disk on Azure LS series
I am little confused about the ephemeral disk on LS series Azure VM.I want to suggest L32s_v2 series vm for a customer due to high iops and throughput that the nvme disks provide but there is a catch....
