Questions tagged [azure-sql]
51 questions
0
votes
2 answers
Azure ElasticPool "BadRequest" during creation deployment when using ARM template
I have a task where I need to use ARM template to "setup SQL server with elastic pool and 2 databases (imported from bacpac files) use Microsoft Adventureworks samples."
Most of the template I made using "101-sql-elastic-pool-create" template that…
KarlisAG
- 21
- 4
-1
votes
1 answer
Identifying distinct sets of rows in SQL
I'd like to uniquely identify groups of rows that use the same grouping.
For example, if we imagine some epos data, I'd like to identify the customers that bought the exact same combination of items, relating them all to a definition of the set (see…
Neil P
- 2,920
- 5
- 33
- 64
-1
votes
1 answer
Replacing all 0s with Nulls in a table
Is there a way to replace all 0s with a null for all the columns of a table ? I know how to do it for single column, I am searching for something like dynamic query for all the columns.
Shadow
- 21
- 5
-1
votes
1 answer
C# MVC Core 5 Site throws encoding error when trying to open a connection to Azure SQL DB
As stated above. Under IIS Express on VS2019 I have no issues. When opening the site after deployment to Azure I get:
"The character encoding of the plain text document was not declared. The document will render with garbled text in some browser…
Destroigo
- 101
- 4
-1
votes
1 answer
Is it even possible to migrate huge SQL Server relational database to Azure replicating across multi-regions with master-master replication?
I have my DB users who frequently performs write operations from both China and US, Currently we have data on premise in the US region and are facing huge challenges as write and read operations are very slow for all users across the world having…
sai-sreenath
- 1
- 2
-1
votes
1 answer
Azure Data Factory - Inner join a table with a SQL query inside stored procedure activity
Situation:
I have two databases DB1 and DB2. DB1 has 9 tables (out of these 9, any of the tables could get updated with only column to track that change i.e TIME_STAMP column).
Now I am trying to bring only the Updated/New records from these 9…
Prashant Babber
- 431
- 4
- 6