Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

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

1
vote
1answer
16 views

Azure SQL Server - Cannot get rid of the sort operator

I'm using Azure SQL Server (Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 3 2019 13:27:00 Copyright (C) 2019 Microsoft Corporation), Premium tier 4 (500 DTUs). Query: offer progress has a history ...
-2
votes
1answer
21 views

Azure SQL Server - big query choosing bad execution plan [on hold]

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 ...
0
votes
0answers
18 views

Database Administrator

If I want to be the only person/department in my organization that can create and administer databases in Azure. What privileges do I need have and make sure no one else has? I will need to give ...
0
votes
1answer
21 views

sp_Blitz Error on Azure SQL Database [on hold]

Getting the following error when trying to install sp_Blitz on a Azure SQL Database Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 15] Reference to database and/or ...
5
votes
1answer
72 views

Understanding Plan Choice When Query Store Doesn't Respect Forced Plan

I'm trying to figure out a situation that I encountered last week where, in an attempt to temporarily fix a plan regression during an incident, I forced an execution plan using Query Store, but found ...
7
votes
0answers
34 views

Storing CREATE EXTERNAL DATA SOURCE in a SSDT project without exposing the DATABASE SCOPED CREDENTIAL or MASTER KEY secret;

I have a SSDT project that deploys to Azure SQL DB. Recently I added an external table. This required an external data source as follows: CREATE EXTERNAL DATA SOURCE [data_warehouse] WITH ( ...
0
votes
2answers
30 views

Unable to connect SQL Managed instance in the vnet

One of our team member wanted to create a Managed instance for his testing and was asked to use existing vnet which was already configured to connect remotely and had other Managed instances for POC. ...
1
vote
0answers
22 views

SQL Azure write-heavy DB doesn't return anything

I have a request to provide a SQL server to query application logs, which we are trying to fulfill but having issues (which isn't surprising). The database is very write-heavy, since a few things are ...
0
votes
1answer
15 views

T-SQL to show Azure SQL Managed Instance vs Azure SQL Database

Restated: How can I use T-SQL to determine whether a instance is an Azure SQL Managed Instance or Azure SQL Database?
2
votes
1answer
49 views

Make database writeable (Azure MS Sql)

I have a bacpac file from a read-only database hosted on Azure. When imported to a new server the database is also read-only. I’ve tried looking for answers with no luck. How can I change it to a ...
0
votes
1answer
28 views

Azure SQL Row Level Security Full Index Scan

We have implemented SQL Row-level security using SESSION_CONTEXT. From an architecture standpoint, this is a beautiful paradigm that allows our application to be clueless to the fact that only 1 ...
0
votes
2answers
17 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
36 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 ...
3
votes
1answer
81 views

How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?

I have created a SQL maintenance job using Azure Elastic Job Agent with the following step: EXEC jobs.sp_add_jobstep @job_name = @jobName, @step_name = 'Optimize indexes and statistics', @command=N' ...
0
votes
1answer
36 views

Migrate azure sql database to Azure SQL Database Managed Instance

We need to migrate one of the database into MI from Azure Sql. Has anyone done it before.Looking for any documenatation/Guidance on this as not much is available. Will be testing the below method soon....
0
votes
1answer
35 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
1answer
11 views

Are user defined types (UDTs) available in an Azure SQL database managed instance?

Is it possible to create user defined types and user defined table types in an Azure SQL database managed instance?
0
votes
1answer
52 views

Ola Hallengren for Managed instance

How can we configure Ola Hallengren's solution on a managed instance? (We want output file for each run, storing it is an issue) If we want backup retention longer than 35 days for the database in ...
0
votes
1answer
20 views

PaaS Server - Random row order while using aggregate function with group by

Result set of a query with an aggregate function and group by (no order by specified) returns different result or at least in different order almost in each execution. I have a database on Azure PaaS ...
2
votes
1answer
96 views

Is it possible to force an adaptive join with a query hint?

Is it possible to force a query to use an adaptive join? The query in question produces an adaptive join when run as a SELECT, but when run as SELECT INTO instead, it doesn't. I have a parameterised ...
1
vote
1answer
20 views

scheduler_count in Azure SQL DB

I'm trying to find a scheduler_count for my Azure SQL DB, so that I can get sp_Blitz to run. On all other platforms, scheduler_count can be read from sys.dm_os_sys_info, but this dmv is not available ...
0
votes
0answers
19 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
27 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 ...
3
votes
0answers
36 views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
2
votes
0answers
53 views

Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?

Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle? What if the publisher database is in PostgreSQL? If ...
0
votes
1answer
54 views

Is it possible to log ship from on-premise SQL server to Azure SQL Managed Instance?

From the docs, it would seem that restoring a full database backup file is possible, but can one also restore transaction logs? (the idea is to minimize downtime in a migration from on-prem to MI). ...
0
votes
1answer
35 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.
2
votes
1answer
33 views

Only 'master' inside the system databases in Azure Managed instance

During our POC we saw the system databases(model,msdb and tempdb) lying outside the system databases group. Any specific reason behind it?
0
votes
0answers
30 views

How to join multiple tables

I'm Stuck at Joining multiple tables. Context: i have order table which is linked to productTable(name: ORDER_DETAILS) and recipeTable(ORDER_RECIPEs).I can order product from product menu and ...
7
votes
2answers
396 views

SQL Server: Covering indexes including all columns?

Our team has inherited an application and associated database. The previous developers appear to have enforced a rule where every index, on every table, has an INCLUDE clause to always add every ...
1
vote
1answer
21 views

FILEPROPERTY not working over linked server to Azure SQL Database

FILEPROPERTY (Transact-SQL) is not working with a linked server pointing from a on-Premise SQL 2017 to a Azure SQL Database. I see the following comment in books online: Returns NULL for files that ...
1
vote
0answers
16 views

SSRS Azure SQL Database Active Directory - Universal with MFA

Does anyone know when support for Active Directory - Universal with MFA will be included in Reporting Services? It's available in SSMS. Visual Studio 2017 Data Source Properties Reporting Server ...
10
votes
3answers
311 views

Filter condition not correctly applied to Clustered Columnstore index

Using the below example, the predicates are the same, however the top statement (correctly) returns 0 rows, the bottom statement returns 1 - even though the predicates do NOT match: declare @barcode ...
1
vote
1answer
41 views

Azure SQL Database and Database Maintenance

If SQL Agent isn't available for Azure SQL Database then is it possible to maintain (indexes, statistics etc) the databases with Ola Hallengren's maintenance scripts, for example?
2
votes
1answer
36 views

Is there an Express version of Azure SQL DB?

With on-premise SQL Server, there are editions such as Express, Web, Standard, and Enterprise. Do those editions (or an analog) exist in Azure SQL DB, especially Express? My Google-Fu is failing ...
2
votes
1answer
50 views

what is the maximum capacity allowed for SQL managed Instance?

I am looking in option to migrate to SQL Managed Instance but found on MSDN that it supports max of 8 TB in General tier and 4 TB Business critical. what are option for databases greater than 8 TB? ...
0
votes
1answer
43 views

“Active Directory - Password” login in SSMS for Azure AD - Password expired

I'm trying to connect to an Azure SQL DB through SSMS (v17.9.1), using an Azure AD user, that is an Active Directory Admin for my SQL Server that hosts my Azure SQL Database. I'm able to login with ...
0
votes
0answers
28 views

Azure MariaDB log_bin_trust_function_creators

I'm testing AzureDB for MariaDB and for my DB to work properly I must change log_bin_trust_function_creators variabl. However, it isn't available in Azure Portal Server Parameters. I've checked and ...
0
votes
1answer
48 views

How to check when a record is replicated in SQL Server

I have configured a database installed On-Premise to replicate certain tables on a Cloud SQL Server database hosted on Azure. The replication task is scheduled to run at specific time everyday and I ...
0
votes
0answers
20 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 ...
2
votes
1answer
66 views

Does Batch Mode only apply to Agg Functions on ColumnStore Index

Azure SQL Database - Standard Edition (S3 Service Tier) Why does Batch Mode only come into effect when using Aggregate Functions? DROP TABLE IF EXISTS dbo.TransCS CREATE TABLE dbo.TransCS ( ...
1
vote
1answer
36 views

Recalculate and replace large table without interrupting table reads

There's a large table in the database containing statistical information. This table must be read frequently (by lookups which return a single row). This table must be completely recalculated every ...
1
vote
1answer
69 views

Sql server deadlock when insert and update in one transaction

I'm using Azure SQL + Java + Spring Boot 2. Currently I'm trying to understand the reason why deadlocks occur. In transaction I'm doing insert and later update on the same table by different rows. ...
0
votes
0answers
37 views

Azure Managed Instance Log file Larger than Data File

Good Afternoon, I am working with the Brent Ozar tools on an Azure SQL Server Managed Instance. Once of the things that came up when I ran the sp_Blitz procedure was that I had several databases that ...
1
vote
1answer
33 views

How to get EstimatedRows values from SQL Server execution plan nodes

When I execute the following code in an Azure SQL Database (v12) or SQL Server 2016 instance, I get values in the EstimatedRowsRead column, but not in the EstimatedRows column, and I'm not seeing why. ...
1
vote
1answer
34 views

Can I on purpose lock the admin out of an Azure SQLDB (as admin)

Can I on purpose lock the admin out of an Azure SQLDB (as admin) As this may sound as a strange question on first sight. The goal is to only have sql users with data reader & writer rights on the ...
0
votes
1answer
18 views

Contained User within a Non-Contained Azure SQL Database

While granting access to Azure SQL databases I have been creating Contained Users directly in the SQL database like so:- CREATE USER [email@domain.com] FROM EXTERNAL PROVIDER; As this has been ...
2
votes
1answer
43 views

Why does elimination of an if-statement cause notable speed up in my function?

I have the following table: CREATE TABLE [dbo].[StateChanges] ( [RecordId] uniqueidentifier NOT NULL, [LinkedObjectId] uniqueidentifier NOT NULL, [ChangeType] TINYINT not null, [...
0
votes
1answer
27 views

Concern on Active Directory Users on Azure SQL Server

I was able to add Azure Active Directory Users to Azure Sql server. My question is not related in including or removing an Azure AD user, but its existence after the user ceases himself/herself. My ...
1
vote
1answer
99 views

install FirstResponderKit in Azure SQL DB?

I've just downloaded the newest version (20190128) of FirstResponderKit from BrentOzar.com, and tried to install it on Azure SQL DB. I'm getting these errors: Msg 40515, Level 15, State 1, Procedure ...