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
2
votes
1answer
70 views

Azure SQL Database vs. error 8152 enhancement

How can I take advantage of the enhancement for error 8152 (https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/) in Azure SQL ...
2
votes
1answer
1k views

Cannot set READ_COMMITTED_SNAPSHOT to OFF on Azure SQL

Me and my team are trying to use Azure SQL for our development environment and ran into some critical and unwanted differences in locking behaviour to our production environment. The main problem is ...
2
votes
1answer
91 views

Recommendation on changing Azure SQL Database tier weekly [closed]

We have an Azure SQL Database of size 50GB in the S6 tier. On weekends, the usage is very minimal. Is it okay to change the tier to S0 every weekend for cost savings, and change back to S6 on Monday? ...
2
votes
1answer
745 views

How do you retrieve the identity value of a row inserted from the OUTPUT of an UPDATE statement?

How do you retrieve the identity value for an inserted row when that row is inserted from the OUTPUT of an UPDATE statement? Neither @@IDENTITY nor SCOPE_IDENTITY() appears to be set properly. ...
2
votes
1answer
98 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?
2
votes
1answer
71 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, [...
2
votes
1answer
949 views

how azure sql geo replication works internally?

My company moved to azure and started to use azure Sql database and geo replication. For our on-premise servers, we heavily rely on Microsoft transactional replication to move data. Now we setup ...
2
votes
1answer
1k views

Azure SQL Databases: High number of SA connections with “BRKR TASK” and “TASK MANAGER” commands

Found out that all our Azure SQL Databases (pricing tiers S1-S2) have high number of connections/sessions from SA SA - BRKR TASK - around 60 sessions SA - TASK MANAGER - around 20 sessions Here are ...
2
votes
1answer
278 views

What is the SQL Azure equivalent of the server “public” role?

In our on-premise database, we create database users mapped to a login, and then assign the user to specific roles within the database. Access to the database is strictly governed by which stored ...
2
votes
1answer
5k views

Connection issues with Azure DB from SSMS

I am currently making a connection to Azure DB from SSMS using public wifi. For the past few days, I was able to connect SSMS to Azure DB without any issues by adding the current ip address into the ...
2
votes
1answer
84 views

Azure - How can I check if my first full backup is available

As per Microsoft documentation Learn about automatic SQL Database backups How often do backups happen? Full database backups happen weekly, differential database backups generally happen every ...
2
votes
1answer
211 views

Duplicate rows with a few changes in a table with a composite primary key, but only if target does not exist

Consider the following table: CREATE TABLE [xxx].[MyTable]( [period] [date] NOT NULL, [genusId] [int] NOT NULL, [subjectId] [int] NOT NULL, [waitingStageId] [tinyint] NOT NULL, [...
2
votes
1answer
554 views

Optimize query with join and null predicate [SQL Server]

I have the following query which I am having problems optimizing: SELECT TOP (100) this_.Id AS Id80_1_, this_.UserAgent AS UserAgent80_1_, this_.IP AS IP80_1_, this_.Guid AS Guid80_1_, ...
2
votes
1answer
868 views

Remove index fillfactor for Azure migration

I'm deploying a SQL Server database to Azure. I've tried to export to a .bacpac, but receive an error: fill factor set and is not supported when as part of a data package Using the script in this ...
2
votes
2answers
5k views

SQL Server 2012 import/export wizard not showing at all

So I have access of two databases that are stored in Azure, and using SQL Server 2012 to access them. All I need to do is copy a table from one db and duplicate and create it in another. I keep ...
2
votes
1answer
141 views

Why would CREATE INDEX with “online” mode suddenly slow my database down?

Earlier I used CREATE INDEX ... WITH(ONLINE=ON) without any problems - the statement would run in parallel with user queries and not slow them down at any time. Then suddenly I see that once I start ...
2
votes
1answer
5k views

Continuous replication between Oracle Database and Azure SQL Database

Background info: Our core ERP has its data on Oracle. Our own applications are Microsoft SQL Server based. Almost every application reads data from this Oracle database and usually there is some sort ...
2
votes
1answer
64 views

How can I model and enforce constraints on a categorical item contained in a collection?

Scenario: There is a collection of items where each item belongs to 1 category. There is a collection of buckets which may contain at most 1 item from each category. Oh, and an item may belong to at ...
2
votes
1answer
5k views

Connecting to sql azure from ssms throw exception 'sys.configurations'

Connecting to Sql Server Azure from MSSQL Server MGMT Studio, following exception occures : Cannot connect to xxxxxxxxx.database.windows.net An exception occured while executing a Transact-SQL ...
2
votes
1answer
794 views

Best patterns for encrypting database columns/tables in SQL Azure

Azure SQL doesn't support many of the encryption features found in SQL Server (Table and Column encryption). What is the best practice for doing application level encryption into a database that doesn'...
2
votes
1answer
428 views

How to create a unique column in SQL Azure Federation

I need to create two columns in a federated table where ID is a primary key and EMAIL_ADDRESS can never contain duplicate values. Think of it like a user being able to register only one email address ...
2
votes
2answers
82 views

How can I query on-premise SQL Server database from Azure SQL database using stored procedure?

I have a Azure SQL database and it has a stored procedure from where I am trying to join a table which resides in on-premise SQL server database. Essentially, I am trying to query a table which sits ...
2
votes
1answer
23 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 ...
2
votes
1answer
167 views

Importing a single large table in Azure

I have an existing DB called MyDb in Azure SQL Server. I have a bacpac of another DB with several tables in it. I'm interested in importing one single table (that table has no FK, it makes things ...
2
votes
1answer
101 views

Azure SQL: Azure SQL Database traffic migration to newer Gateways

I have been assigned a task to look at this: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-gateway-migration. I got an email about it: I have a pretty standard setup, with a Azure ...
2
votes
1answer
390 views

Azure Managed Instance - Is it possible to send Sql Logs To Log Analytics?

Is it possible to stream a Managed Instances SQL logs into log analytics? I need a single location for all Azure based monitoring so that multiple teams have visibility/access to log information for ...
2
votes
1answer
157 views

SQL Replication - Specify Schema on destination Table

wondering if it's possible to replicat into a different schema using Transactional Replication? My situation is that I have 3 DB servers, each hosting it's own instance of our software, in three ...
2
votes
1answer
666 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? ...
2
votes
1answer
182 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
494 views

Snapshot Azure database for fast revertion to snapshot

I have spent a considerable amount of effort creating a set of Azure SQL databases and importing data. Importing the data with the DMA tool took the best part of two days. This is on an 'SQL Server (...
2
votes
1answer
328 views

SQL Server - How to improve/optimize remote scan on a linked server

I'm trying to figure it out how to optimize/improve the following thing, on a VM hosted in MS Azure and a database, also hosted in MS Azure. Besides the instance hosted in MS Azure, there is another ...
2
votes
1answer
587 views

Out of Memory Exception When Creating BACPAC File

We're having a frustrating time migrating our on-premises SQL application to Azure. The database is large but not crazy, about 265 GB. SQL Server Management Studio > "Deploy Database to Windows Azure ...
2
votes
1answer
7k views

Grant View Server State - is it possible for a none SA user to have in Azure SQL?

I'm trying to set up some scheduled jobs which will collect some server stats, using system DMV's in SQL Server Azure. If a none SA users uses 'sys.dm_os_schedulers', they get an error (below), query ...
2
votes
1answer
148 views

How does clustering on a field other than autoincrement id affect inserts?

I have a table with an id column which is auto-incremented, and various other informational columns. Rows are inserted into this table very frequently. When the data is read back, the majority of ...
2
votes
2answers
83 views

Any existing programs that track the origin of data in your database?

I am doing some integrity work at the moment, investigating cases when something goes wrong with incoming data. The system I am working with involves multiple servers, including Sybase and SQL Sever ...
2
votes
1answer
1k views

Multi-tenant database

We are building a database for a SaaS web application. We have been told to use a multi-tenant approach and to expect over 100,000 tenants to be using the system over the next 5 years, so we're ...
2
votes
1answer
806 views

Fastest method for inserting large number of records from query between tables

I have a query that returns 14 million results that I need to store in a table, the SELECT query itself returns in a little over 2 minutes but INSERT statement takes well over 30 minutes (which is ...
2
votes
1answer
261 views

Automatic migration failed on Azure Database

I am using Entity Framework 6.1.1. The database has three million records; migration has to change the precision of a column of type decimal. The migration timeout window is set to the maximum value, ...
2
votes
1answer
469 views

my azure sql database is not connecting with SSMS 2014

The firewall contain my IP in valid list but I am still getting error in connection. I tried the command C:\Users\MianAsbat>SQLCMD -U username -P password -S and got the following response. I am ...
2
votes
1answer
86 views

How to cope with SQL Server 2012 vs SQL (Azure) Database sql files

I'm trying to port my system to SQL Database (Azure instance) from SQL Server 2012. I'm using Visual Studio 2013 and I have my .sqlproj with all the definition of my database inside. Given that a ...
2
votes
1answer
933 views

Can I limit the time a table lock is being held server side?

I have a SQL Azure server with some stored procedures with TABLOCKX hints that I call from C# code on a Windows Azure web role VM. I'm kinda paranoid about those hints - what if there's some network ...
2
votes
1answer
90 views

Logging and Replaying database updates/inserts SQL Server 2008

I am in the process of migrating our client's database to the Azure Cloud SQL Server and setting up data sync etc. All of this is ok, but I need to reduce the amount of time the client's system needs ...
2
votes
1answer
36 views

Hide schemas from users in MSSQL

I'm creating a database with a few different schemas. 99% of users connect using Excel, and when they do they see all the system stuff: This just confuses the users and I would like to configure SQL ...
2
votes
0answers
102 views

Partitioning Help Needed for Azure SQL

Myself and some peers had some discussion about the approach for an issue regarding the care and feeding of a very large table in a Azure SQL database. I understand that the main issue they are trying ...
2
votes
0answers
144 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
42 views

Difference between SQL Server Azure and SQL Server 200x

I'm a SQL Server DBA and I can understand the logic behind logins users roles and etc ( login for server access, user for databases and etc ). I've asked some questions here but I think I need to ...
2
votes
0answers
1k views

RequestError: Connection lost - read ECONNRESET

I am new to Microsoft SQL Server, please advise. I am receiving the following error message when I deploy code into my development environment (which is hosted on Azure using Node.js (version 10) and ...
2
votes
0answers
41 views

How to implement updates from mySQL operational DB to Azure SQL DB for reporting

We have an operational mySQL DB running on AWS for a transactional system and an Azure SQL DB for reporting with PowerBI. Now I'd like to regularly (e.g. every night) do an update of certain tables ...
2
votes
0answers
60 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 ...
2
votes
0answers
240 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...

1
4 5
6
7 8
15