Questions tagged [azure]
The azure tag has no usage guidance.
204
questions
0
votes
1answer
24 views
SQL Server 2019 Always On using Distributed Network Name
We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
0
votes
0answers
33 views
SQL Azure Indexes need Rebuilding for Foreign Keys to work
We have a product that runs off SQL databases.
Until recently, each of our clients had their own fileserver running SQL Server, however we have now started hosting on Azure for some existing and some ...
0
votes
0answers
45 views
SQL Server Error - The wait operation timed out (provider: TCP Provider, error: 0 - The wait operation timed out.) [duplicate]
I'm running a couple web applications on the same set of servers. In my logs across a number of different queries in both apps (as well as calls to the ASPState session state database) I see errors ...
0
votes
1answer
32 views
CHECKDB problem - SQL files (mdfs,ldfs etc.) in Azure Files
Anybody out there using Azure Files (https://docs.microsoft.com/en-us/azure/storage/files/storage-files-introduction) for SQL data and log file storage? I've got one SQL Server using an AF share in ...
-2
votes
1answer
20 views
Trigger for last inserted value [closed]
Can anyone help me create a trigger that appends the last record from table Sensordata into Lastsensordata. I only want 1 value per ConnectionDeviceId and the value needs to be the last inserted one. (...
0
votes
1answer
23 views
After a point-in-time restore, is there any way I can get the transactions during restore time?
The hypotethical scenario:
Imagine that I have to do a point-in-time restore of a Azure SQL database, the original one is called DatabaseA and the restored is after restore called DatabaseA_restored.
...
2
votes
1answer
51 views
Can you create a clustered DB in Azure using Windows 2003 and SQL Server 2005?
We need to replicate an environment in Azure, running a clustered DB. The current physical environment is running on Windows 2003 and MS SQL Server 2005 R2.
We know that there's no OS/DB support but ...
1
vote
1answer
15 views
Backup with date to azure blob storage url
Im trying to do backups to an azure blob storage that have the date when the backup is made, that way the job does not fail when the backup is generated with the same name, I am concatenating convert(...
0
votes
0answers
9 views
MS Access - used locally, want to move to use remotely
In my company we have an (old) MS Access software. (Used mainly to manage customers & invoices).
In the software it's possible to choose the data file to work against (.mdb file).
The goal is to ...
0
votes
0answers
7 views
Access database on Azure Files
Would an MS Access database, hosted on an Azure Files share, work essentially like an Access database on a Windows Server share?
1
vote
0answers
26 views
Shrinking 150 TB data warehouse instance is feasible option?
We are using azure SQL data warehouse(azure synapse analytics) with size of 150 TB among which 75 TB is used and we are planning to shrink database with help of MS. What are the challenges should we ...
0
votes
1answer
28 views
Restoring a managed SQL instance in Azure using PowerShell
I am trying to figure out how to restore a database from one managed SQL instance to another. I'm following the tutorials, but I keep running into inscrutable error messages.
Here's my command:
...
0
votes
0answers
8 views
Regions available now for deployments for Azure
Seems due to the over load in demand for cloud deployments the regions are not available for deployments from free tier. Anyone aware of available regions as of now?
1
vote
0answers
60 views
How to hide SQL Server connection string and SQL login password from Developers
We are using Microsoft Azure App Services to host some of our Web Apps.
Web Apps connect to on-premises SQL Server over hybrid connections.
When new Web App needs access to the on-prem SQL Server, a ...
0
votes
0answers
12 views
SQL Server and Agent Services not starting automatic in AZURE IaaS
We migrated an on-premise database to azure IaaS and the machines is on between 7am and 7pm that way we save money in the night when the users are not querying the database, but every time the machine ...
0
votes
0answers
14 views
Where is the mask/unmask functionality exposed with respect to Azure Data Lake?
I read this documentation on Azure Data Lake Gen2 ACLs. There is mention of a feature called mask/unmask which overrides default POSIX permissions on child items.
I cannot see where this ...
2
votes
2answers
40 views
Azure elastic pool: Can I create as many databases as I want?
I am sitting here trying to figure out what the elastic pool in Azure gives me. I have a customer that wants a guess on pricing if they move to Azure. They have 3 databases, on a server. The server ...
0
votes
3answers
71 views
How to sync daily the prod database to dev database in Azure SQL Server service?
I have two Azure SQL Database, prod and dev. How can i daily replicate the prod database into dev database? I have tried to automate it by exporting and importing the BACPAC file but it takes too long ...
0
votes
1answer
65 views
Selecting preferred row in database based on condition
I'm new to SQL coding and I'm struggling to find a solution to my issue.
I have a database with contractors that have worked at our organisation on and off.
The database contains the contractors ...
0
votes
1answer
127 views
Backup from Azure SQL Managed Instance and restore on an On-Prem version
As per my understanding Azure SQL MI runs SQL Server under the hood. So a backup from MI can be restored on latest version of SQL Server (2019). I have a task to find a rollback strategy if the move ...
0
votes
1answer
88 views
Backup from dacpac file extracted using SSTD
I tried method given in this answer by Ramankant Dadhichi but deploying failed.
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have my database in managed ...
0
votes
2answers
110 views
Database mail in Azure VM with SQL Server installed on it
We migrated 4 servers with SQL Server instances to Azure VM around 2-3 months ago. We configured "database mail" the same way we did for the on-prem servers. Mail worked fine immediately. All of a ...
2
votes
0answers
125 views
DNS CNAME for a SQL Managed Instance (Azure)
I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server.
I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
2
votes
1answer
21 views
Azure SSIS Deploying in SQL Azure
Does deploying SSIS really required an azure data lake house when deploying on Azure database?. I am currently working on an SSIS project that its database is currently deployed on Azure and I am ...
0
votes
1answer
17 views
Azure Data Sync Between Two Azure Databases
I would like to ask if I use Azure data sync with my two azure databases is there any way that I can still download data tier and install it on my local machine. I am planning to create a sync between ...
0
votes
1answer
172 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
18 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
13 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
116 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
32 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
111 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 ...
1
vote
2answers
195 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 ...
1
vote
0answers
21 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
14 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
67 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 ...
2
votes
1answer
109 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
37 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
26 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
127 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
145 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
65 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
278 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
367 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
35 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
727 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
35 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
244 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
214 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
365 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?
