Questions tagged [azure]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...