Lab Sql

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 created a pipeline and two linked services to move data from an on-prem instance of SQL Server to… Read more Azure Data Factory Copy Identity Column With Gaps

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."

EDIT: Added in sample data that I am trying to disallow. This question is similiar to this: Cannot … Read more How Do I Reference A Table Twice When Creating An Indexed View? Can I Enforce Uniqueness Based On 2 Tables And Multiple Rows Without It?

I'm trying to execute a (very) simple query on Azure MSSql Server using PHP, but it does not wo… Read more How To Query In A Specific Database On Azure?

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?

Say I have two JSON strings as follows: [{'RowId':102787,'UserId':1,'Activity&#… Read more Generate A Json String Containing The Differences In Two Other Json Strings Using T-sql

I have a SQL Azure database with one table on Azure and I want to trigger my notification hub when … Read more Sql Azure Database Trigger Notification Hub

Inside the readme file of the ASP.NET Universal providers NuGet package is this quote The SqlMembe… Read more What Do The Asp.net Universal Providers Enable That The Default Sql Providers Don't?

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'm very familiar with the process of exporting from Azure SQL V12 down to my dev box and then … Read more Cannot Import Sql Azure Bacpac To 2016 Ctp

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

Assuming I have a table in Azure SQL DB with a million rows. What are the ways I can optimize the t… Read more Creating Optimized Azure Sql Table For Querying

Hey all, just quick question about sql azure. My App is running on windows azure and the database i… Read more Sending Email From Sql Azure

How do you set up a foreign key in SQL Azure? I have a database now on the Azure system. The tables… Read more How Do You Set Up A Foreign Key In Sql Azure?

I'm trying to create a service based on an Azure SQL Database backend. The service will be mult… Read more Encrypting Data In Sql Server Azure Database With Separate Key For Each User's Data

I have a Microsoft Action Pack subscription with Office 365. I would like to connect to an SQL SERV… Read more Connect To A Azure Sql Database/sql Server From Office 365

I am running an Azure based site that for historic reasons uses two databases on two servers. I hav… Read more How Do I Stop And Start A Sql Azure Database?