Questions tagged [sql-azure]
12 questions
6
votes
1 answer
Continuous Deployment Database Project VSTS
Looking for continuous deployment strategies regarding SQL server database projects targeting Azure SQL using VSTS. My scenario...
Using VSTS for CI/CD
Using a SQL Server Database Project to define my database schema
Using Dapper for my ORM (so no…
Tim_Cardwell
- 69
- 2
4
votes
1 answer
Is there another name for Sql Azure's programming language?
According to this page on MSDN the sql language used on Sql Azure is called transact-sql (the same as on sql server). But is this the only way to refer to programming on Sql Azure?
The Sql Azure variant of transact-sql doesn't support a bunch of…
amelvin
- 1,525
- 1
- 11
- 19
3
votes
1 answer
Questions about developing for azure
We currently have a .Net MVC web app with a SQL server back-end database and two web services that perform periodically some computing tasks in the database.
I am thinking of packaging this app for the cloud, where a client would "instantiate" it as…
boggy
- 141
- 4
1
vote
2 answers
Azure website that talks to third party services
I have website that crawls data from many third party services when user browse to webpage. This can be really slow because I hit third party server and process returned data before showing it to user. I am hosting website on Azure (shared mode). I…
Andy Frank
- 11
- 1
0
votes
1 answer
Caching or in-memory table in Azure for performance
I am building an Angular web application that retrieves part of its data from a Azure SQL Database table via APIs developed in Azure Functions (with Azure API Management at the API Gateway). The data in the table (80k records) do not change for at…
Tanmoy Sengupta
- 153
- 1
- 1
- 4
0
votes
0 answers
Manipulating a large dataset before inserting in Azure Search
I have an Azure SQL database with 20 million + records that i need to manipulate (including joining other tables, etc) before inserting into Azure Search.
The procedure needs to be reproducible in case i need to rebuild the Azure search index.
Some…
Rhodes73
- 43
- 1
- 4
0
votes
0 answers
how to work with variable data structures and templates
I need users to be able to create an organization which will have some preset fields such as Name, Address, and Type. But depending on the type, the organization can have type-specific fields such as as President, Manager, or something that I can…
Riz
- 196
- 7
0
votes
1 answer
Should we do data migration from Oracle via the microservices, or should we do direct data migration from Oracle to Azure SQL DBs?
We are replacing a legacy application that runs on a single Oracle DB, and the decision has been made to replace it with a microservices-based application running on Azure SQL.
Do we do data migration from Oracle via the microservices, or do we do…
Roger Mouton
- 1
- 1
0
votes
2 answers
Should I move to In-Memory tables and stored proc or NoSql (CosmosDB)
I have a lot of data. Objects with other objects nested like this (JSON):
{
id: 12,
Code: "a code",
country: "at",
prices:
[{
{ price: 100, from "2017-05-05", to "2017-06-05" },
{ price: 150, from "2017-05-06", to "2017-06-06"…
JP Hellemons
- 123
- 10
0
votes
1 answer
Synchronize Azure SQL (cloud) with Azure SQL Emulator (local)?
We have an Azure service (web role) that heavily depends on the database. For offline development/testing, we'd like to have the app+db run offline within the emulators. Running the webrole itself within the emulator is straightforward but doing so…
DeepSpace101
- 1,394
- 5
- 14
- 26
0
votes
1 answer
How to setup users for desktop app with SQL Azure as backend?
I'm considering SQL Azure as DB for a new application I'm developing. The reason I want to go with Azure is because I don't want to have to maintain yet another database(s) and I want my users to be able to access the data from anywhere. The problem…
Manuel
- 123
- 5
-3
votes
1 answer
Serving large file (dozens of GB) to client from a server-side query to the Azure SQL database?
I have an SQL database in Azure that is ~4.5 TB / 150 million rows worth of data. Users will need to query this database for large sets of data. Right now, I am having users submit their requests through a web application hosted on an Azure VM.
How…
Alex Gao
- 1