Questions tagged [azure-sql-database]
Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
707
questions
0
votes
0answers
45 views
Migrating SQL Server 2012 Web Edition to Azure
I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
0
votes
0answers
32 views
What is the best way to update a table from a JSON string?
I'm fiddling around with JSON and SQL, and I need to update a record based on a new JSON string.
Here's what I've got, but to be honest, It seems like an awful lot of code:
create procedure ...
0
votes
0answers
98 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
0answers
252 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 ...
0
votes
0answers
40 views
What is a good backup method for Azure SQL?
I maintain a Azure SQL database with the Basic plan. 7 days point in time restore is enough for our daily needs. What we are looking to improve is a daily backup outside Azure in the case that we lose ...
0
votes
1answer
47 views
Is the limit on the number of databases in an Azure SQL managed instance a hard limit?
I see the documentation for Azure SQL Managed Instance lists a limit of 100 databases per managed instance. I would like to understand if this is a soft limit that is adjustable on request or a hard ...
0
votes
1answer
17 views
Details about existing roles and users in azure sql database
I would like to get details of all users existing in a sql server DB and the respective roles they are part of and the permissions granted/denied for the a role/user.
what is the best way to get this ...
0
votes
0answers
858 views
SSIS packages run locally but not on Azure (possible host name issue?)
I am trying to make SSIS packages using Visual Studio 19 that import data from tables in a remote Azure Managed Instance SQL database to a Microsoft Azure SQL DB database, aiming to schedule these to ...
0
votes
1answer
338 views
Overwriting old data in Azure SQL database
I`m currently recieving data from sensor and storing it to Azure SQL database through Azure Stream Analytics job.
My question is: how can I overwrite old data from sensor with new data? Sensor has ...
0
votes
0answers
208 views
How to Decrypt Stored proc in Azure Managed SQL Server
I have created Managed SQL Server in Azure and encrypt some stored procedures. Can any one help me to decrypt the same.
Thanks in advance.
0
votes
0answers
28 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
2answers
295 views
Import data tier application in Managed instance
I am using SSMS 18.0 Preview 6 and wanted to import the .bacpac file we have locally stored and accessible. However, seems the function is not supported in the GUI . Any updates/suggestions are ...
0
votes
0answers
216 views
Filegrowth recommendations for Azure Managed Instance
On Azure SQL Managed Instances, im seeing new database getting 16MB filesize growth on database and logfiles (i changed log to 128MB). I haven't been able to find online docs from MS on recommendation ...
0
votes
1answer
106 views
SQL Server Always Encrypted - Create an external table containing an encrypted column
I'm trying to create an external table MyTable on server S2 that references the table MyTable from server S1.
The table MyTable contains a column encrypted using Always Encrypted. I'd like the column ...
0
votes
0answers
109 views
Azure SQL Query Analysis
I'm having a problem with long elapse times for queries in Azure SQL PaaS, running on the Standard Tier. We have some small External tables as a vertical shard to the database, and shared across a ...
0
votes
1answer
447 views
Intellisense Not Working in SSMS 2016 [duplicate]
I am working with an Azure SQL Server database in SSMS 2016. I have Intellisense enabled in Tools -> Options -> Text Editor -> Transact-SQL -> Intellisense, however I have never had Intellisense ...
0
votes
1answer
28 views
Optimize query plan when your results are either a few rows or hundreds of rows?
The most frequent query typically uses a variable that has hundreds of rows, but also runs often with a variable that has only a few rows (it's always one or the other, nothing in between). SQL ...
0
votes
1answer
58 views
How to check Auditing in Azure MSSQL MI?
I know that auditing is currently enabled in my azure MSSQL server, but how can I access these log files?
Could it be done through SSMS?
I need to know details about user activity in my databaase.
0
votes
0answers
25 views
Move from SSIS to Azure
I have an ETL solution which we have been doing in conventional SSIS. The job of SSIS is just to create star schema from the application database to dimension and fact tables. There is very little ...
0
votes
1answer
308 views
Performance recommendations stuck on 'Validating'
I have been tasked with migrating a 'database from hell' to Azure SQL. It has some complicated and long-running queries (20 seconds on the S6 tier, >600 seconds on S4 tier) and I'd like to optimise ...
0
votes
1answer
43 views
Advanced threat detection vs IP restriction
If we configured IP restriction to allow only internal network, then why we need threat detection?
IP restriction already blocks connections from other resources. Moreover, advanced threat detection ...
0
votes
0answers
38 views
BigData IoT table without foreign key
We thinking about switching our database structure to a more modern schema. We hope to reduce server performance peaks and gain more performance.
This for I read some concepts about general so called ...
0
votes
1answer
41 views
Best High Availability Solution for SQL Server 2014
Please we are about to implement High availability for for SQL server 2014 on our new infrastructure but i need to know which is best between SQL Failover Clustering and Always On High Availability ...
0
votes
1answer
547 views
Always Encrypted - Lock request time out period exceeded
I'm trying to encrypt a column and am getting the following error: Set-SqlColumnEncryption : Lock request time out period exceeded. Are there parameters to specify the lock timeout? What could be ...
0
votes
0answers
207 views
How can I convert integer value from query_hash_s in Azure Log Analytics to a VARBINARY(64) for sys.dm_exec_sql_text?
SQL Server errors are shown in Azure Log Analytics. Sometimes, the query_hash_s column is populated. But the values provided appear to be BIGINT. How can I use that value to find the actual text of ...
0
votes
0answers
173 views
Partitioning in SQL Server: Best choice and partition keys
In my application, I want to partition two tables, "files" and "value_text", because in the next days I have to insert 300 million rows (files) and 1.200 million rows (value_text) ...
0
votes
2answers
445 views
Import bacpac from SQL Azure into local server fails.
We are trying to import a bacpac into a local SQL 2017 instance but it gives the following error. This suddenly started happening, previously we didn't have any problem with it so I can't think of any ...
0
votes
0answers
35 views
Scheduler Current Tasks - Is 92 too high?
When I run the following query on my Azure SQL database:
SELECT
scheduler_id,
cpu_id,
current_tasks_count,
work_queue_count,
runnable_tasks_count,
...
0
votes
1answer
463 views
Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors
I'm trying to import a .bacpac created from SQL Azure into a SQL Server 2016 server that has no existing databases beforehand. It will run but run into issues such as:
Unhandled Exception: ...
0
votes
2answers
42 views
Maximizing Availability on a Table When Changing Data Type
I'm looking for some advice on the best way to change the data type on a column from an INT to a BIGINT on a table with 220 million rows, as it has reached the upper limit of the INT data type.
The ...
0
votes
1answer
79 views
How do I know an index is used for any queries?
I've found a likely abandoned index in the production database. It's not included into .sqlproj from which this database it usually deployed. Most likely it was created for some experiments and then ...
0
votes
1answer
656 views
Azure SQL Databases hit cpu limits too quickly
Background in a nutshell: -
We have a SAAS solution with the following main components.
1. We have a web-portal back-end where administrators can edit data.
2. We have a web API that is called by ...
0
votes
0answers
15 views
Azure SQL SSRS Hybrid Configuration [duplicate]
I would like to migrate my existing Visual Studio SSRS Reports to the cloud while keeping my database on-premise. Any advice on resources for getting started would be greatly appreciated - tutorials, ...
0
votes
0answers
119 views
Which Azure service for use as data warehouse/analysis store?
We currently have a database running in SQL Server 2012 Standard.
We need to export data periodically (a "data dump") of a particular set of data to "a location to be decided" where the client's ...
0
votes
0answers
179 views
Which of sys.dm_exec_query_stats columns should I pay most attention?
I'm trying to tune my database and currently staring into sys.dm_exec_query_stats (with actual queries):
SELECT SqlText.text, * from sys.dm_exec_query_stats
CROSS APPLY sys.dm_exec_sql_text(...
0
votes
2answers
24 views
Vertical Elastic Query is not identifying Object
I did create an External Datasource, identical to the guide described here https://www.sqlservercentral.com/articles/cross-database-queries-in-azure-sql-database .The process is pretty simple, so just ...
-1
votes
3answers
2k views
How do I compare data and schema of on-prem vs off-prem? [closed]
We're working on migrating our database (~400 tables) from SQL 2008 R2 to SQL Azure. We're currently in the proof-of-concept stage, figuring out the process we'll be following. We have a process that ...
-1
votes
1answer
39 views
is it a good idea to migrate a SQL Server database that uses a lot of linked servers and external conenctions with different databases to Azure?
We have a 1tb database that use information from other 4 or 5 databases. It has hundreds of procedures using external databases to calculate and etc. we have 0 problems inside SQL Server.
I would like ...
-1
votes
1answer
36 views
Creating contained users for Azure SQL Database
What's the difference between these two commands?
CREATE USER abc FROM EXTERNAL PROVIDER
CREATE USER abc FOR EXTERNAL PROVIDER
-1
votes
1answer
23 views
Create store procedure to disable and enable indexes
I have two below queries to, first of all, disable indexes and in another query enable them.
Here are my queries
--Disabling indexes
DECLARE @my_sql2 NVARCHAR(200);
DECLARE cur_rebuild CURSOR FOR
...
-1
votes
3answers
167 views
What are the reasons you would not migrate a SQL Server Instance to SQL Azure?
I have some servers and some databases on SQL Azure and as much as I like this idea, I would like to know some good reasons to migrate a SQL Server instance to the cloud and what reasons would be a ...
-1
votes
3answers
9k views
What is wrong with this INSERT Statement
I am trying to use this statement to insert new data into my orders table like so:
$tsql2 =
"INSERT INTO pedidos (numero_local, emailUser,codigopapel,cantidad, color)
VALUES ('$local', '$emailOn', '...
-1
votes
1answer
27 views
Azure SQL ports - expect on 1433 - but finding more
Our security department has questioned why we have multiple ports open to our Azure SQL instance.
Ports highlighted as LISTENING are 443, 3006, 5002, 5432, 7443 and a few in the 16000 to 16018 area.
...
-1
votes
1answer
2k views
Assigning Permission on Azure SQL Database
I have an azure SQL Database. I already created a new login and user on the database. Question is i want to assign permission on the said user. Permission that will restrict the user to drop table, ...
-1
votes
2answers
533 views
SQL Server 2012 log shipping to Azure SQL
Is there any way to take SQL Server 2012 log shipping files and upload them into Azure SQL Database. We just need the data changes and not to bothered about the recovery side of things.
-1
votes
1answer
691 views
How to copy data from Azure SQL DB into Azure SQL DW
I need to copy some data from an azure SQl DB instance into my azure data warehouse.
The most obvious way to do this is to use Elastic Query, similar to the below:
CREATE EXTERNAL DATA SOURCE SqlDb ...
-1
votes
1answer
4k views
Conditionally INSERTING columns into Table
using SQL Azure and like to insert a data to a table using dynamic Query.
No of columns in select statment is dynamic. It will be based on some conditions.
Ex: Salary, Code.
How can I create a ...
-2
votes
2answers
436 views
Problems with having SQL Server Identity Column in the Cloud
Our company is utilizing Identity(1,1) clustered primary index in SQL Server 2016 Enterprise, and will eventually deploy into the Cloud (Amazon AWS, Google Cloud).
Is there any issues utilizing ...
-2
votes
1answer
264 views
How Do You Set a SQL Backup to URL Blob Retention Period Greater than 30 Days?
How can a retention period be configured to delete SQL backup blobs older than some custom duration, such as 180 days?
The existing command only permits a max of 30 days:
use msdb;
GO
EXEC ...
-2
votes
1answer
135 views
Azure SQL Server - big query choosing bad execution plan [closed]
I'm using Azure SQL Server v12 and I have big, complex query that runs ok but when I add more joins, it doesn't matter which table I'm joining to, it gets super slow. The important thing to point out ...
