Questions tagged [azure]
The azure tag has no usage guidance.
184
questions
0
votes
0answers
8 views
Azure Sql Server VPN connection
I saw a couple of questions already submitted 1 or 2 year ago, without a clear answer. I'd like to know if I can connect my private Network, or whatelse to an Azure Sql Server.
Point-to-Site VPN
I'd ...
0
votes
1answer
7 views
SQL Server 2017 in Azure Cloud config DB Mail
I have set up a SQL Server 2017 in Azure cloud. I have created a new GMX email address and enabled it for pop3 external programs
I have set up db mail on the SQL Server but I am getting the following ...
0
votes
0answers
10 views
How to decrease MySQL database on Azure storage amount
I have increase the storage amount of Azure MySQL storage. But I cannot reduce it. How can I reduce the storage amount?
1
vote
1answer
30 views
Copy Azure Hyperscale DB
I show there was a question since 1 year ago with no answer.
I have the same question now, in this new year 2020.
I need to copy an Hyperscale DB to another server in the same region/location, (the ...
0
votes
2answers
28 views
Installation and shell to move physical and logical SQL Server in azure IaaS VM
Firts of all excuse my english is not my primary language.
We are creating an azure template to deploy an IaaS machine with disks C and D with windows server, and the idea is also deploy an ...
1
vote
0answers
11 views
Elastic queries with encrypted columns in tables using symmetric keys
I have elastic queries running cross-subscription for everything except tables with encryption.
Now I need to tackle tables that are encrypted.
How (if at all possible) do I open the keys on the ...
1
vote
1answer
35 views
Elastic queries across subscriptions in Azure SQL
Is it possible to run cross-database, actually cross-subscription, in Azure SQL?
I have three subscriptions (Dev, Test and Prod) and I need to need to keep Test up to date with Prod.
Unless I'm not ...
0
votes
2answers
41 views
Copy SQL database with encryption from one Azure subscription to another
I need to copy an entire Azure SQL Database from one subscription to another.
The challenge I have is that it has a certificate with symmetrical key and if I try to export it to a .bacpac file I get ...
0
votes
0answers
12 views
how to identify cross login in azure synapse analytics?
In my environment user are logged in to SQL server via MFA authentication with their email id.
Its possible for single user to log in to multiple laptops with same credentials.
Can we track user ...
0
votes
0answers
8 views
Push delta changes from Azure Data lake gen 2 to Azure Data warehouse using Azure Databricks
I have been trying to use Azure Databricks to push changes happening at azure data lake (source) to azure sql dw (destination). If someone could help to list down the steps involved and how can it be ...
2
votes
0answers
39 views
When sys.dm_db_index_usage_stats is cleared in Azure SQL Database
In my solution I need to check when there where some last change done in table/index to determine data freshness.
I'm using Azure SQL Database and the best option (and maybe the only one without ...
1
vote
0answers
18 views
MS Azure remote back up with SqlPackage
I wanted to do an export of a .bacpac file from MS Azure database, from local machine, with command like this:
sqlpackage.exe /Action:Export /ssn:tcp:<ServerName>.database.windows.net,1433 /sdn:...
0
votes
0answers
8 views
Neo4j: Connection closed after few minutes: defunct connection Address (Python)
I have a server (hosted in Azure) in which the connection is opened (python):
self._driver: Driver = GraphDatabase.driver(credentials["uri"], auth=(credentials["user"], credentials["password"]), ...
0
votes
1answer
20 views
Change Azure Standard to Premium
I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day.
Would talk know if I need ...
1
vote
1answer
47 views
Login failed for user when trying to connect to Azure Postgre database from MSSMS [closed]
I created a database on Azure but can't log to it with MSSMS. I always have the Error 18456 even if I followed this tutorial.
TITLE: Connect to Server
------------------------------
Cannot connect ...
4
votes
1answer
82 views
Power BI on-prem data gateway for Azure devops pipeline?
I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is ...
0
votes
2answers
36 views
How do you detect whether you have permission to query sys.dm_os_performance_counters?
According to the sys.dm_os_performance_counters documentation:
On SQL Server, requires VIEW SERVER STATE permission.
On SQL Database Premium Tiers, requires the VIEW DATABASE STATE permission ...
1
vote
2answers
127 views
How do you get the default compatibility level in Azure SQL Database from T-SQL?
In on-prem SQL Server you can check the server version and multiply by 10 to get the maximum compatibility level supported by the server, or check the compatibility level of the model database to get ...
1
vote
1answer
76 views
Azure Sql Serverless Vs Basic Tier [closed]
Does anyone have experience of moving a database from an Azure SQL Basic, or Standard tier, to Serverless?
I'm currently investigating whether to do this for our development, UAT and staging ...
1
vote
0answers
21 views
Sharded Azure SQL Database Split-Merge Tool
Background
I am developing a multi-tenant application that supports each Tenant having its own database and/or sharing a database with other Tenants.
The design is similar to this, though I doubt ...
2
votes
0answers
177 views
Linked server from Azure managed instance
I have my Managed Instance (MI) setup and can connect from SSMS on-premises. There is limited functionality this way (you only see databases and security) - so I have a VM in the v-net where I can ...
4
votes
0answers
23 views
Can Azure Backup Server backup databases participating in Log Shipping?
We have a number of log-shipped SQL 2017 databases which we wish to start backing up using Microsoft Azure Backup Server (locally and to the cloud) on a 15 minute schedule.
Does anyone know if it is ...
0
votes
1answer
90 views
Validate deployment failed deny policy in SQL managed instance Azure
I am trying to create a manged instance within an existing subnet in Azure. I have configured the subnet with the script provided by Microsoft which tells me the subnet is prepared.
When I create ...
2
votes
1answer
76 views
How to determine MAXDOP setting when using DTU in Azure SQL
I have previous experience of setting MAXDOP settings for on premise OLTP & OLAP servers when you know the number of cores at your disposal. e.g. if I knew I had 16 at my disposal I'd set my ...
2
votes
2answers
116 views
Is DB mail supported on SQL Server hosted on Azure VM (IaaS)?
Is DB mail present in SQL Server hosted on Azure VM (IaaS)?
If DB mail is not supported, then what are the features available?
2
votes
1answer
58 views
Azure SQL: Azure SQL Database traffic migration to newer Gateways
I have been assigned a task to look at this: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-gateway-migration. I got an email about it:
I have a pretty standard setup, with a Azure ...
0
votes
1answer
91 views
Optimize Large Query Performance
I have this query that I can't seem to speed up at all. My running theory is that I need to fix some indexes or something.
I am running the database through the Azure and that does auto indexes, so I ...
0
votes
1answer
146 views
Managed backups in Azure SQL Managed Instance
The Managed Instance allows the admin to ENABLE Compress backups at the instance level.
Does that affect the managed backups?
How does the Managed backups work? as i don't see any record in ...
1
vote
1answer
91 views
Getting Nested query result from Cosmos DB with property named “Value”
I have Cosmos Db collection, I am trying to query the "Key" "Value" pair from.
Working query:
SELECT ed
From c
JOIN ed IN c.ExtendedData
Where ed.Key = "MembershipTypeId"
And got result:
[
{
...
0
votes
1answer
18 views
Azure database - unable to locate in my Azure account
I have an Azure account where a developer that used to work with me has set up an MSSQL database on an Ubuntu VM.
The PHP (CodeIgniter) system I am working on logs in (so database queries work ...
0
votes
1answer
21 views
Azure Analysis Service Cube Sizes Changed Since July
we have come across very strange thing the over all size and individual sizes of all AAS cube databases where reduced with out any changes happened. Did anyone saw this change dip and any cause?
0
votes
0answers
17 views
Find DB principals accessing a table in Azure SQL
My use case is as follows:
A table in my database is accessible by application A, B, C, etc each of whom has their own database principal. We want to start limiting the principals that can access ...
1
vote
1answer
65 views
Are VM snapshots enough to backup SQL?
I have a Microsoft SQL DB running on Azure VM
I have daily snapshots of the VM and this is currently my only backup mechanism.
Is this considered best practice? Am I risking something here?
0
votes
0answers
23 views
SSMS cannot determine if remote computer is connected to domain
I've recently set up a new server with an SQL instance running on it (2017), I am able to connect to the server remotely using SSMS, but when I try to add a new login, I receive the attached error. ...
1
vote
2answers
47 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
14 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 ...
2
votes
1answer
177 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
99 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
159 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
55 views
Moving from Azure to Hyperscale
Does Azure Hyperscale allow for Memory optimised tables and does it allow/have rollback facilities
2
votes
2answers
171 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
1answer
53 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
101 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
259 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
42 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
54 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
40 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
87 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
50 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 ...
1
vote
0answers
29 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 ...
