SQL Azure - Development

• Topics

  Started by

  Posts

  Last post

• Azure DW default schema in a query / proc equal to "Search_Path" in AWS

  I know you can't do this in MSSQL, but hoping DW has progressed more. Search_path in AWS / Postegre…

  digdave7

  1 replies

  10 months, 2 weeks ago

  By: digdave7

• Azure availability groups requirements question

  Does anyone know if Azure absolutely requires windows clustered services to support availability gr…

  Brandie Tarvin

  1 replies

  10 months, 2 weeks ago

  By: Grant Fritchey

• Copy DB from Prod to Test !!

  Good morning. I would like your advice. I work on Azure Sql. We have 3 environments (Dev, Test and …

  Lidou123

  17 replies

  1 year ago

  By: Lidou123

• ChatGPT implementation "reluctance"

  Fragmentation is my main area of interest and its my overriding concern.  Of course, when I speak …

  Steve Collins

  3 replies

  1 year ago

  By: Jonathan AC Roberts

• Retrieve records from a database table where the value of a certain column is th

  I have a simplified version of a table for organizing documents here. What is the most efficient w…

  Aarush32

  2 replies

  1 year, 1 month ago

  By: Emperor100

• Can I connect Azure Synpase to an on-prem data source via Power BI Gateway

  Hello, I heard you can connect from Azure Synapse to on-prem data sources by connecting through a P…

  Luke L

  1 replies

  1 year, 1 month ago

  By: Luke L

• Advanced grouping for gaps and islands

  Hi, I'm trying to figure out how to group a set of data based on how many days a person is sick. Th…

  Alfred

  3 replies

  1 year, 2 months ago

  By: Alfred

• Reducing varchar(max) cols that are in auto generated indexes

  Hi all, I inherited an app schema that is shared across 140+ different DBs [one for each client; th…

  scarr030

  2 replies

  1 year, 2 months ago

  By: EdVassie

• JSON formatting output nested array

  Hi Guys, Apologies if this is posted in the wrong forum, but I have a query that moves data from a …

  lawson85

  6 replies

  1 year, 3 months ago

  By: lawson85

• Azure Pricing, SQL Server seems pretty high?

  Hi, I'm really new to this and I think I've got this wrong, wondering if you can help me.   I'…

  dosel99

  3 replies

  1 year, 3 months ago

  By: Eirikur Eiriksson

• bacpac has less records on local sql server

  Hello Everyone, As a server, I use Azure SQL (Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 8 2022 12…

  gaurav

  5 replies

  1 year, 3 months ago

  By: gaurav

• Reducing I/O reads and tempdb in Azure Severless SQL pool

  I've been using Azure Serverless SQL Pool for a couple of months now. I don't have much knowledge o…

  Dominic546

  2 replies

  1 year, 3 months ago

  By: Eirikur Eiriksson

• How to list sum of values in the specific period

  Sorry for very newbie questions. I have a table, shown below with values about duration of events. …

  demokedes

  3 replies

  1 year, 3 months ago

  By: demokedes

• Azure DevOps and branches

  Hi all   Firstly, full disclosure, we're only getting started with this so late to the party (…

  richardmgreen1

  13 replies

  1 year, 4 months ago

  By: richardmgreen1

• Substitute of trigger in a merge statement.

  Hello Everyone I hope you all are rocking. My question is regarding the merge statement. I am using…

  gaurav

  5 replies

  1 year, 4 months ago

  By: Eirikur Eiriksson