Lab Sql

Is there a way to bind an event to Sql Server (specially Azure) so that, when there's new data … Read more Is There A Way To Be Notified In .net When Data Changes In The Sql Server? Like An Event?

I am using SQL Azure SQL Server for my App. The DB tier, which my app was in was working perfectly … Read more Find Out Which Query Increasing Dtu In Sql Azure

I have been trying to connect SQL database (in Azure) to shinyapp deployed in shinyapps.io, but I c… Read more Connecting Azure Sql Databse To Shinyapps.io

I'm trying to move my databases to a newer Azure subscription. I used to simply click 'Depl… Read more Unable To Import/deploy Database To Sql Azure: "the Service Objective (business/web) Specified Is Invalid."

I have a fact table where I have ClosePrice for Company Tickers and TradingDates. I also have a di… Read more Sql For Dates With No Closeprice For All Companies

I just created a new SQL Server Database in Azure and then opened it in Visual Studio 2015 using th… Read more Why Is Sql Server Object Explorer In Visual Studio So Slow?

In Azure, how can you configure an alert or notification when a SQL Server failover happened if you… Read more In Azure, How Can You Configure An Alert Or Notification When A Sql Server Failover Happened?

This has been cracking me up for a few days now and I just can't solve it. I followed an online… Read more Azure Sql Database Working When Ran Locally But Not When Published To Azure

Background in a nutshell: - We have a SAAS solution with the following main components. 1. We have … Read more Azure Hits Database Cpu Limits Too Easily

I want to move my azure sql db to another host. However my new host allows to import sql db backup-… Read more How To Create Bak File From Azure Sql Db

I'm using Azure SQL DB automated export feature. Everything worked like a charm, but recently i… Read more Automated Azure Sql Db Export Fails - Indexing For Document Type .xml Is Not Supported On Ms Azure Sql Db V12

I am attempting to use an Azure Automation Runbook to run a query against an Azure SQL database usi… Read more Azure Automation Runbook Adal Sql Support

I want to use an inner join query with Java and Azure mobile apps, but it looks like api does not l… Read more Azure Mobile App Query Inner Join With Java

I have updated SQL Server Management Studio to the latest version at time of writing - 12.0.4432.0 … Read more Sql Server Management Studio 2014: Unable To View Stored Procedures On Azure Sql Database V12

I am in the planning phase of the typical social network type of a web application. It will have pr… Read more Azure, Mvc Web App Architecture - How To Split Data Between Sql Azure And Azure Table Storage?

I need to connect from an Azure SQL Database to an Azure VM that has a SQL Server instance installe… Read more Azure Sql Database - Elastic Query To Azure Vm Sql Instance - Ssl Error

I know it may sounds crazy, but i want to connect a symfony project with microsoft azure database c… Read more Symfony Connect With Windows Azure

I am trying to do a basic query that calculates average, min, max, and count. SELECT MIN(column) a… Read more Arithmetic Overflow Error Converting Expression To Data Type Int For Basic Statistics

I am using android studio to develop an application and using Azure Sql Server to host my database.… Read more Android Studio Can't Connect To Database In Azure Sql Server

We are having issues to scale out our ASP.NET Web API on Azure because of our SQL Azure DB. The iss… Read more Ado.net Connection Pool Concurency Issue With Sql Azure Or How We Cannot Scale Out Our Web App