Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
1answer
47 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
197 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
27 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
125 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
35 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
49 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
155 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
237 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
57 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
26 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 ...
1
vote
1answer
636 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
42 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
59 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
39 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 ...
9
votes
2answers
574 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
36 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
102 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
387 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
136 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
69 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
354 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
328 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
76 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
64 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
23 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
75 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
38 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
236 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
72 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
52 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
162 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
51 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
42 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 ...
2
votes
1answer
377 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 ...
0
votes
1answer
47 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 ...
2
votes
1answer
88 views

Excessive log throttling on Azure SQL on business critical tier

We moved from the Biz Critical vCore Gen4_8 tier to Gen5_8 over the holidays. We had to move because our log growth is constantly pushing us into the 1 TB limit of Gen4. Not only are our queries ...
-2
votes
1answer
63 views

Database Backup to URL fails with Device I/O Error [closed]

I'm using Ola's Maintenance Solution to backup my databases to a URL. Most of my databases backup just fine but I have one 2 TB database that continues to fail with a device I/O error. Has anyone ...
0
votes
1answer
38 views

FK relationships between schemas in azure SQL don't work

I'm having an issue with migrating my SQL 2014 database to an azure database. I'm able to get everything migrated except for any FK relationships between tables that aren't the in same schema. for ...
0
votes
3answers
79 views

Slow performance matching columns to lists of values

I've made a stored procedure to get all results which match specific students and objectives. CREATE PROCEDURE [dbo].[GetResults] @students [IdList] READONLY, @objectives [IdList] READONLY AS SELECT ...
0
votes
1answer
32 views

deploy data from sql 2016 backup to azure database

I've got backup data from a SQL 2016 server that i want to move/restore onto an azure database. I'm not seeing an in-house option to do this anywhere, so it looked like the best option was to restore ...
2
votes
1answer
611 views

How to troubleshoot “BCP copy in failed”

I have a table that looks something like this in a SQL server database in Azure: CREATE TABLE [dbo].[TableName]( [col01] [int] IDENTITY(1,1) NOT NULL, [col02] [varchar](255) NOT NULL, [col03] [...
3
votes
2answers
281 views

Azure SQL cross-database queries returns too many rows with joins

I have a problem with Azure SQL cross-database queries, it looks like if we join data across databases the join is not distributed as input to the external database. Currently I tried to implement a ...
0
votes
2answers
1k views

Azure sql database grant select on certain tables

I have created a user in a Azure sql database in SSMS. Now trying to give select permission to certain tables in a db to this user. The security control options seems quite different than on premise ...
3
votes
2answers
222 views

How often should you update your stats?

How often should you update your stats? What is "too seldom"? How often is "too often"? The answer is "it depends" on your database, users, data, etc. So I've tried to log what our stats look like ...
1
vote
1answer
766 views

“Keyword not supported: Server” error when using ADO.NET connection string to connect to Azure DB

I have an ASP.Net project that I am running. I have added a database to Azure, and Azure generated a connection string for the database. When running the application I however get an error stating ...
2
votes
1answer
830 views

Managed Instance Restart

Does anyone know how to restart a SQL Server Managed Instance? The stop / start / reset are all grayed out, so that’s really. It an option. Any thoughts? Thanks...
0
votes
1answer
95 views

How to analyze compression options for Azure SQL Database?

What is the most efficient way to determine whether row or page or columnstore compression (or none) would be most effective for each index in an Azure SQL Database (standard or premium tier) used for ...
0
votes
1answer
56 views

What type of data ingestion does Azure Data Factory use?

This article data-ingestion says that there are two types of data ingestion Data can be streamed in real time or ingested in batches. What type of data ingestion does Azure Data Factory's ...
4
votes
2answers
122 views

Can't stop execution of “ADD PERIOD”

I'm trying to conditionally execute an ALTER TABLE command (this one, to be precise). However, I can't get the ADD PERIOD to be conditional and I suspect this might be a bug. Here's what I've tried ...