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