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
786 views

Does Azure SQL Data Sync support MySQL or SQLExpress?

I did see that it supports SQL Server (2005 and later) but does it support syncing between a SQLExpress server or MySQL server and an Azure Server? I'm trying to use it with a SQLExpress server but ...
2
votes
0answers
215 views

Is there a way to programmatically get the version of a .bacpac file without unzipping and inspecting the xml?

The situation is that we get a copy of the latest production bacpac, then restore it locally when setting up our dev environment. During the setup, we do an explicit check for the DacFX dll but target ...
2
votes
0answers
212 views

Help in understanding how to avoid a page-level deadlock

I have the following deadlock xml <deadlock> <victim-list> <victimProcess id="process9b7ade24e8" /> </victim-list> <process-list> <process id="...
2
votes
0answers
112 views

Backup or export Azure SQL Database with Row-Level Security

I'm having difficulties exporting a Sql Azure database using Row-Level Security. When using the Export method the following error occurs: Error encountered during the service operation. Could not ...
2
votes
0answers
2k views

Something similar to GENERATED ALWAYS for a DEFAULT? (SQL Server / Azure SQL)

Question: Is there any way to force a column to always use the default value definition? I would like to always have the user_id populated on an insert/update (I know delete might be a bit different) ...
2
votes
0answers
207 views

Stage database in SQL Azure

I am designing a data warehouse using Azure Databases (not Azure Data Warehouse though), I have 2 databases: the main data warehouse and a staging database. As in a traditional ETL process, the raw ...
2
votes
1answer
220 views

Developing an Azure Sql Database backup strategy [closed]

I know Azure databases are backed up and kept for a retention period, which I believe the default is 30 days. I'd like to come up with a plan to mimic our current strategy with a physical SQL Server ...
2
votes
0answers
756 views

Connection to Azure SQL from Java

I try to connect to Azure SQL with MS JDBC driver: import java.sql.*; public class ExampleSQLJDBC { public static void main(String[] args) { // Setting. String connectionUrl = "...
2
votes
0answers
547 views

Unable to use select top N shortcut on Azure SQL Database via SSMS

Yesterday morning I was able to query my Azure databases via SSMS and the Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the ...
2
votes
0answers
82 views

Create multiple databases dynamically in Microsoft Azure

I am a newbie in Microsoft Azure platform. I want to create multiple databases dynamically (We are developing multi-tenant model. So, Each organization should have their own database. Whenever an ...
2
votes
0answers
72 views

Azure SQL: Unexplainable Database size

Last month we upgraded our Azure database from Business to S1 plan. S1 plan was chosen based on an article on MSDN giving guidance on how to choose the best plan for us. Also, Azure by itself ...
2
votes
0answers
141 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
1
vote
2answers
467 views

Stored Procedure return unwanted cursor result

Context I have created a stored procedure that simulates a merge command for an OLTP in-memory table. It used the simulated merge for upsert moving massive data form a normal table to an OLTP one. ...
1
vote
2answers
3k views

BULK INSERT not supported

I have a text file, which I want to insert into a table in my database. My query looks like this: BULK INSERT myDepartment FROM 'C:\myDepartment-c-t.txt' WITH ( DATAFILETYPE = 'char', ...
1
vote
4answers
53 views

Azure sql database how to track table schema change

So someone dropped a column in a Azure sql db. How to show the table schema before the change? Restore to a previous version is not a option as that would override everything.
1
vote
3answers
695 views

single select vs multiple selects using limit and offset

Working on a fairly high volume site. There are some tables example - the customers table which gets hit a lot. The problem We are writing a piece of code that selects a bunch of customers and ...
1
vote
2answers
4k 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 ...
1
vote
4answers
781 views

Rebuilding fragmented indexes on SQL Server

We've got a SQL Server database powering our SAAS web app. It's a SQL Azure database, hosted on S3 Standard plan (100 DTU units - pretty suficient for what we need). Our DB indexes fragment really ...
1
vote
2answers
750 views

Azure SQL Database in different locations

I'm deploying a Sitecore website using Azure and Azure SQL, and one of the requirements is to have some of the databases in different Azure Regions but sharing the same data among the other databases. ...
1
vote
2answers
5k views

visual studio database project - publish did not include drops but schema compare did

I just observed a difference in the result of publish vs schema compare. I made changes to visual studio database project - some of which involved deleting tables. Pushed changes to VSTS, build ...
1
vote
2answers
1k views

Сopy rows from one table to another and replace duplicates in the process

I have a SSIS job that loads daily data from CSV files into a raw staging table in a SQL Server database (technically is an Azure SQL database). Then after that, a stored procedure is executed to copy ...
1
vote
3answers
1k views

Do management operations such as database copy affect our current db performance?

Example: I have a database named "myDb" I execute on the master: create database mydb_copy as copy of myDb Will the performance of "myDb" be affected? Specifically the avg_read_io (data reads)?
1
vote
1answer
136 views

Why can members of db_datareader SELECT sys views

In SQL Azure my understanding of db_datareader is that it is allowed to SELECT all user tables. I couldn't find a definition of exactly what a user table is, but I assumed it was all of the non-...
1
vote
1answer
358 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?
1
vote
2answers
2k views

Statistics update on Azure SQL DB

New to Azure SQL DB. I was wondering what is the best practices for scheduling jobs like update statistics in Azure SQL DB. Googling got a couple of blogs that uses Azure automation. https://blogs....
1
vote
1answer
1k views

Replication from Azure SQL Database table to On-premise SQL Server possible?

I have a table on Azure SQL Database that I would like to have replicated/mirrored to our on-premise SQL Server So the on-prem SQL Server would have a copy of table from Azure that is always up-to-...
1
vote
1answer
235 views

Stored Procedure With an Optional Parameter Limiting Rows Returned if Specified

How would one go about having a sproc that allows a consumer to optionally specify the number of rows returned? If no row count is specified, then all rows returned.
1
vote
2answers
2k views

Capture live stored procedure calls (as per Query Profiler) in SQL Azure

TL;DR - Is it possible to capture live procedure calls (with parameter names/values) in SQL Azure, to replicate the output of SQL Profiler illustrated below - or - is there a better way to achieve ...
1
vote
2answers
185 views

Granting Permissions for a limited period of time

Is it possible to grant permissions to a user for just a certain period of time? For example, I ran into a situation the other day where I wanted to grant a user the ability to modify data in a table ...
1
vote
1answer
483 views

SQL GUID or Identity in the Cloud

Follow up from my previous question SQL Server Identity Column in the Cloud: Are there any general guidelines? Should a person use Clustered Index Identity or GUID in the cloud for SQL Server 2016? ...
1
vote
2answers
3k views

Syncing data between onprem and Azure SQL

I have the following Scenario: an on-premise SQL Server 2008 R2 and an app using it as db. I want to create an Azure SQL database that will be synced (asynchronous replication) with the on-premise ...
1
vote
2answers
120 views

Best practices for providing PHI/PII data to users in organization

I am looking for best practices for how to share data from a SQL Server database that contains PHI/PII to individuals that cannot view PHI/PII. In short, we maintain a SQL server database that ...
1
vote
1answer
110 views

High WRITELOG wait on Azure SQL Database

My WaitStats analysis of our Azure SQL Database is showing WRITELOG and HADR_SYNC_COMMIT as counter the highest wait. This is a Premium 250 eDTU resource. Script SELECT TOP (10) wait_type, ...
1
vote
2answers
33 views

Temporarily Turn Off Table Type Reference Checking On A Development Database

During my database design process I have begun to add Table Types to the database and have run into the need to alter a table type. It is painfully clear that one cannot remove or drop the table type ...
1
vote
4answers
563 views

How to quantify or locate command timeouts in Azure SQL

I am trying to if confirm query timeout in Azure. Our frontdoor is reporting a 503 response at 30 Seconds response, as its the SQL server default value, I am trying to confirm if these are indeed ...
1
vote
2answers
549 views

Copy SQL database with encryption from one Azure subscription to another

I need to copy an entire Azure SQL Database from one subscription to another. The challenge I have is that it has a certificate with symmetrical key and if I try to export it to a .bacpac file I get ...
1
vote
2answers
864 views

Incorrect “Sensitive data columns should be classified” report

Every week I'm getting a failed "Vulnerability Assessment" email report from my Microsoft Azure SQL Database that is incorrect. It complains about columns that have is_computed column in sys.columns ...
1
vote
1answer
66 views

Is it faster to truncate destination and copy all source data or lookup and keep only non-matching data with SSIS transfer packages?

I am building an Azure SQL DB database and to do this I will have to regularly (weekly-monthly) pull data from various other servers. I am designing SSIS packages to do this and whilst most of the ...
1
vote
1answer
700 views

sp_Blitz Error on Azure SQL Database [closed]

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 ...
1
vote
1answer
91 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
2answers
65 views

How do you know when it's time to upgrade a RDBMS/SQL database infrastructure? What metrics to follow? [closed]

In my specific case, I have just deployed my side project to AWS and using AWS MySQL Tier 2 Micro instance, which is within AWS' Free Tier; https://aws.amazon.com/ec2/instance-types/t2/ It has: 20 ...
1
vote
3answers
478 views

azure sql - create index, does DB have to be offline?

New to Azure SQL. Simple example to ask question. Table Cars. Want to add an non clustered index to Cars table. Takes a long time, say 30 min during staging test deploy. When upgrading production ...
1
vote
2answers
2k views

Delete query uses 100% CPU with in Azure SQL Database

I have a relatively small database, maybe a few hundred thousand rows, and we have a stored procedure that is meant to clear out a 'Dealer' (the application aggregate root) and all of it's related ...
1
vote
1answer
1k views

openrowset to connect to SQL server with a password containing single quotes

Can someone help me if there is ever a way to query an Azure SQL database using openrowset with an SQL authenticated account having "single quotes" in it's password string. My statement looks like the ...
1
vote
2answers
4k views

How to copy Azure SQL database to on-premises SQL Server daily for reporting?

I have a database as a service SQL instance in Azure, I want to copy this database to a reporting server located in a virtual machine, and this is not SQL as a service, so my COPY statement won't work,...
1
vote
1answer
33 views

How do I facilitate access to an Azure based SQL View for non-SQL users on Prem? [closed]

Afternoon I'm hoping this one is simple and my general lack of Azure knowledge is the problem, but I need to present data from within a view to some non-SQL end users via some form of application / ...
1
vote
1answer
279 views

Azure SQL Audit Log Analysis

Afternoon all I am attempting to analyse some Server Audit logs for one of my Azure DB databases that reported unusual activity. I have full access to the logs and have downloaded then as well as ...
1
vote
1answer
40 views

Losing customization capability with managed servers (AWS or Azure)?

We're currently hosting our SQL Server instances on AWS VMs. I was recently hired as a data architect and DBA. I'd like to move our instances to either managed services using AWS RDS or Azure SQL. I ...
1
vote
1answer
253 views

Replace all rows in a table based on date

I need to copy the values from a staging table into a production table in SQL Azure V12, considering the following rule: I need to replace all rows for a given day (see datefield column) in the ...
1
vote
2answers
3k views

Azure SQL Database “Login failed for user” contained users.

I'm having a similar issue to this question (https://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: https://azure.microsoft.com/en-gb/documentation/articles/sql-...

1
5 6
7
8 9
15