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).

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