Questions tagged [azure-sql-database]

1

votes
1

answer
240

Views

Azure SQL: Update Compatibility Level of [master] database

We have a single production database [ProdDatabase] on an Azure SQL Server instance that was created back in 2013. At the time of creation the compatibility level of [ProdDatabase] and [master] was hence set to 100 (SQL Server 2008). Over the past few weeks we've successfully updated the compatibili...
sammy34
1

votes
1

answer
2.2k

Views

How to set any column as primary key in Azure SQL data warehouse

I am trying to set one column in DB as primary key but I always get this error: Enforced unique constraints are not supported in Azure SQL Data Warehouse. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement. While doing R & D,I found that ther...
shweta_kaushish
1

votes
2

answer
249

Views

Azure SQL Database DTU metrics

I'm using Azure's metrics chart to see if it's feasible to merge two databases into one Pool. The two databases are currently in tier S3. The first chart is the result with 'DTU Used' metric using MAX() aggregation function in the last 30 days. It can be observed that during several intervals the 'D...
DuroForce
0

votes
1

answer
26

Views

Change “Allow access to Azure services” settings of Azure SQL Server using powershell

I want to modify (enable/disable) 'Allow access to Azure services' settings of Azure SQL Server using powershell, based on a value from my JSON configuration I do have referred couple of StackOverflow, all the answers are to create a firewall rule '0.0.0.0' to enable and '255.255.255.255' to disable...
Manjunath Rao
1

votes
1

answer
45

Views

Fuzzy search in Azure SQL Server

In the project I work we have the necessity to use some kind of fuzzy search to fill an autocomplete field. This autocomplete field must show some information as the user type inside. I'm using Azure SQL database, and I found out that it's not possible to use Master Data Services. (https://docs.micr...
Henrique
1

votes
1

answer
56

Views

.Net/SQL Insert and Select on datetime2 not matching

I have a piece of code that inserts a data sample ([id + datetime2] +...) in sqlAzure database. Later for each call I do a select to know if the primaryKey is already in DB [id + datetime2] so I update it, otherwise I do an insert. The problem is, the select doesnt return anything but the insert wil...
Carlos Barroso
1

votes
0

answer
14

Views

SSIS Package in SSMS - ADO NET Source has failed to acquire the connection - Could not create a managed connection manager

I have some problems with getting my SSIS Packages to work from my Azure SQL SSIS DB in Azure. I built the SSIS packages in VS and they run without any problem. What i am doing is getting data from a remote MariaDB (Source) with a '.NET MySQL Data Provider (mysql-connector-net-8.0.15)' and inserting...
John
1

votes
1

answer
1.1k

Views

What is the difference between Azure SQL Database Elastic Pools and Azure SQL Database Managed Instance?

Azure SQL Database has two similar flavors - Managed Instance and Elastic pools. Both flavors enables placing multiple databases that share the same resources and in both cases can be changed cpu/storage for entire group of database within the instance/pool. What is the difference between them?
Jovan MSFT
1

votes
1

answer
71

Views

Azure SQL Data Warehouse - Max concurrent queries

I have to decide to use an Azure SQL Data Warehouse or a SQL Data warehouse based on Microsoft SQL Server virtualized on a VM. The problem what i do not understand is the MAX CONCURRENT QUERIES LIMITATION TO 32. The same for the Azure SQL Database is 6400. To be honest when i want to use the Azure D...
STORM B.
-1

votes
0

answer
18

Views

I have an Azure SQL Server back end and would like to use Excel as a front end to edit, add and delete data [on hold]

I realize that new software and features come up all the time so could anyone help summarize some different ways that I could use to report, add, edit and delete data in my Azure SQL database using Excel. Is this something I could code up with macros or what Excel technology should I concentrate o...
Alan2
0

votes
0

answer
14

Views

I have an Azure SQL Server backend database with 50,000 rows. Can I use Access to edit this? [on hold]

My database is currently using a web front end for access but maintaining this is hard work and I would like to move to a Microsoft solution. My problem is that I don't know what I can use. Would appreciate some suggestions here. For example, can I use an Access front-end to connect to my SQL Serve...
Alan2
1

votes
1

answer
304

Views

Best way to Move/Merge Tables between 2 Azure SQL databases

I have 2 Azure SQL databases, each with identical schemas. Each database has about 200 tables. I need to MOVE the data from 70 of the tables in db1 to db2 I need to MERGE the data from 5 of the tables in db1 to db2 One of the tables involved in the MOVE has 120 million rows and is 100GB in size. Of...
Terrence
1

votes
0

answer
67

Views

Deleting one row super slow on Azure SQL, but cascade delete is normal

When I delete an entity, it executes instantly on local but it takes almost 20~30 seconds on Azure SQL. High CPU and IO usage is observed from Azure SQL. But if I delete the parent of the entity, (and the entity is cascade deleted) there is no problem. both local and Azure SQL executes the parent de...
min.jun.krm
1

votes
0

answer
44

Views

Application doesn't update its connection when SQL Azure Failover occurs until it's restarted

Changed our connection in the web.config to point to the failover group, and then trigger a failover in Azure. What I expected was that the application would have some errors for a while during the transition, but then it would continue to work and hit the new database. Instead however it continues...
NibblyPig
1

votes
0

answer
117

Views

Should I go tightly coupled, with singleton, or loosely coupled, without a singleton? Azure Services, Xamarin Forms

I am making a Xamarin Forms Cross platform app. I have been trying to figure out how to go about getting my app to integrate with the Azure Backend the best way. I have ran into a problem. It has been drilled into my head to try to build programs as loosely coupled as possible. But then I have been...
John Butler
1

votes
1

answer
200

Views

How to backup an Azure SQL database which contains encrypted stored procedures

I have an Azure Powershell script that I have used to create a .bacpac file from an Azure SQL database. It works fine on a basic test database (AdventureWorks), but now that I am trying to use it on a database which contains encrypted stored procedures I am getting the following error: Error SQL715...
user3626232
1

votes
1

answer
1.6k

Views

How to get rid of warning “Operator used tempdb to spill data”

I have a number of stored procedures using mostly the same tables and views that have started to run slow. I looked at the query plan for one of them and it is giving me two warnings. One is 'Columns with no statistics' on a view with a clustered index that is queried with a 'no expand' hint. The s...
Colin
1

votes
1

answer
1.6k

Views

How to connect Symfony 4 with MSSQL

Is there any way to configure and connect to MSSQL database using Symfony 4? I tried to configure Doctrine, but I get the error that I cannot debug. I'd be grateful for any clues. I've put the line below in .env file: DATABASE_URL=sqlsrv://myname:[email protected]/AzureDB?p...
Publius
1

votes
0

answer
118

Views

Search text in file stored as SQL varbinary column in Azure Database

We have a Database in Azure where we're storing files of different types(.docx, .doc, .pdf, .txt, .ppt, .pptx) in a varbinary column. I tried to configure the fulltext search like that: CREATE FULLTEXT CATALOG DbaAttachments; CREATE FULLTEXT INDEX ON dbo.Attachments( Attachment TYPE COLUMN FileExten...
Detelina
1

votes
2

answer
853

Views

What is Log Bytes Flushed/sec

What exactly does Log Bytes Flushed/sec tell me on SQL Server? I understand it's a metric used in performance tuning/troubleshooting as well as DTU calculations for Azure SQL Databases. I just want to understand what exactly it indicates.
Sam
1

votes
0

answer
50

Views

Filter two users for Row Level Security

I'm going to use Row Level Security in Sql server Management Studio I need help with how I can assign 2 users where one user can see their own rows which has 'purple' in rows, and the other user which will be the Manager, is going to have access to see rows that contains 'Purple' and 'Black' data....
test
1

votes
0

answer
77

Views

Why is a simple SQL script so much slower in Azure SQL

I run a simple insert/update/delete 1m rows script to crudely check the health of our SQL server installations. It's 10 times slower in Azure SQL(S6) than on our in-house test server. Anyone experienced similar problems? Is there a fundamental difference in the way that Azure SQL behaves which inval...
NickC
1

votes
0

answer
54

Views

large amount of data in Azure SQL > U-SQL

I am trying to find the best way to process in U-SQL a query that produces 450 millions rows. I use DataFactory V2 (pipeline) - USQL for transformation The problem : it takes an eternity to extract it into a csv file and to inject it back to the Azure SQL DB I wanted to know if it is possible to que...
EZL
1

votes
1

answer
135

Views

How to export (bacpac) azure database

I have one database in azure and accessing in my SQL Server Management studio and try to export the database but gives me the errors. Here are the steps I have done: 1) Export data-tier Application 2) No of errors I got 3) Got this error in all the processes: I am using SSMS (2014 and 2016)
Mahavirsinh Padhiyar
1

votes
1

answer
292

Views

Azure SQL blob storage select

I am attempting to create a temp table to store the values of an xlsx file on my azure blob storage, I have followed numerous Microsoft articles now and I am under the impression that I should be using SELECT * FROM OPENROWSET(), this seems to be working or at least selecting something. Here is my c...
Mike
1

votes
1

answer
854

Views

Spring Hibernate failed to connect to SQL Server with hyphen in its name

I am trying to build an application with Rest APIs using spring boot-hibernate with Azure SQL Server as backend. While trying to connect to database I get the following error: Stacktrace 11:43:59.735 [main] INFO org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean - Building JPA conta...
Dhruva N
1

votes
0

answer
394

Views

Long elapsed_time with Azure SQL

We have been using Azure SQL successfully with low data amounts for some time. Now when we have seen moderate increase in data storage volumes we are experiencing very long query times. What is weird is that querying dm_exec_query_stats shows that the worker/cpu time for queries is very low (roughly...
Otto T.
1

votes
0

answer
103

Views

Azure VM SQL Server Agent EXE/BAT file on shared drive

I have an Azure VM (Windows Server 2016 Datacenter) that is running MS SQL Server 2017. I've created several SSIS packages that use Execute Process Tasks to run EXEs and batch files that are stored on my Azure file storage account (i.e. \[storage name].file.core.windows.net[storage name]). I have d...
Justin Birmingham
1

votes
1

answer
730

Views

Not having the option of of “Release” in the configuration when publishing a website

I have already build a web application using visual studio. Now I am trying to host it using azure. I have hosted the database successfully. But I am unable to host the website. I have gone through several tutorials. In the publishing procedure there is no option of “Release” for configuration....
Lasith Jayalath
1

votes
0

answer
80

Views

Throttling Event Notification in Azure

This is mostly a design question. I have a web application that takes in data from multiple users on multiple tenants. We also have a desktop application that we want to keep up to date with these data changes from the web app. Currently the desktop application polls every X seconds retreiving the...
Sen
1

votes
2

answer
93

Views

Ridding this query of Hash Match Join?

I have the following query that takes around 26 rows to return 8700 rows of data. SELECT R.ClientReferralID, R.ClientID, C.FirstName, C.LastName, C.FullName, dbo.fnGetLocalDate(R.ReferralDate) as ReferralDate, RT.ReferralTypeName, R.ReferralTypeOther, RT2.ReferredToName, R.ReferredToOther, R.Referre...
Philip
1

votes
1

answer
202

Views

Azure Sql and Azure Web App loosing connection

I run a web application on Azure and it connects with Azure Sql. This has worked without any problems for a few years now. But today I have started to get the following message: The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured...
Dennis C
1

votes
0

answer
98

Views

Microsoft.SqlServer.Management.Smo.Transfer using Active Directory based user credentials

I am looking to transfer data and schema between Azure SQL database using the Microsoft.SqlServer.Management.Smo.Transfer and would like to use an Active Directory username and password. I am able to load the objects from both the source and destination databases using a connection string using Aut...
tnwheeler
1

votes
2

answer
92

Views

Want to select data from other azure database and insert into our server database [duplicate]

This question already has an answer here: How do I copy SQL Azure database to my local development server? 22 answers I've two different SQL database servers: one on my Local server and the other is on Microsoft Azure. I want to Copy data from SQL Server on Azure into my local database. My conside...
DhavalR
1

votes
1

answer
295

Views

How to put a User Id that's an email address in a connection string

I'm trying to connection to a SQL Azure db using a sys.sysusers with name equal to '[email protected]'. The issue is that when try with the connection string Data Source=tcp:coolsqldb.database.windows.net,1433;Initial Catalog=Cool;Persist Security Info=False;User [email protected];... I get the exc...
Questionaire
1

votes
2

answer
174

Views

Duplicate SQL Schema in SQL Server

I have a requirement that a user can have multiple environments to make experiments and test how good their modifications are; after the users are satisfied with the modifications they've done to the data in the working environment, these modifications can be (partially or completely) copied to anot...
streetwizard
1

votes
0

answer
144

Views

Increase 2 min timeout on ASP.NET Core 2.0 web app hosted in Azure

I get the following error message with this code after exactly 2 minutes: 'The specified CGI application encountered an error and the server terminated the process'. public async Task AddRange(IList items) where TEntity : class { _db.AddRange(items); return await _db.SaveChangesAsync() >= 0;; } I'm...
MatSer
1

votes
1

answer
216

Views

How to generate ENCRYPTED_VALUE for CEK in SQL Server Always Encrypted

It is possible to generate ENCRYPTED_VALUE in different way than by SSMS? I like to enable 'Always encrypted' feature for chosen columns but I am wondering about encrypting data by unknown key. In my oppinion there always should be way to decrypt data without connecting to azure key vault(like i un...
sglogowski
1

votes
1

answer
160

Views

Azure SQL Server configuration SQL Server Connectivity Level locked/grayed out

We have an Azure VM where SQL Server 2017 is installed. When the VM was set up, the level 'local' was selected. Now we determined it should be private and not 'local'. We clicked the Edit pencil icon on the portal but the drop down box with supposedly 3 possible option values (public, private, local...
Daisy
1

votes
1

answer
176

Views

Microsoft Azure Service Bus / Hybrid Connection

I am looking for a solution to solve the below... I have a SQL db in an on premise server that runs on a LAN locked down to our site only. I also have a server up on the cloud with a SQL database. I need to create a process that grabs data from the cloud and inserts it into the on premise server. So...
Matthew Stott

View additional questions