SQL Azure - Development

• Topics

  Started by

  Posts

  Last post

• Temporal tables -- reasons not to use them?

  In the project I'm working on we're about to implement 4 temporal tables in Azure SQL.  In the pas…

  scdecade

  7 replies

  1 day, 21 hours ago

  By: Fleurpink

• Import JSON file through ADF (from blob to SQL DW)

    My task is to import JSON file into SQL table using ADF. What am I doing wrong while importi…

  SQL_Surfer

  2 replies

  1 week, 3 days ago

  By: SQL_Surfer

• Dmvs to show missing indexes

  Any dmvs(sripts) to show missing indexes in azure sql db?

  SQL_Surfer

  4 replies

  2 weeks ago

  By: Jeff Moden

• DMV to monitor query performance/show plan

  Is there list of DMVs that i can use to see query performance in azure SQL DB? Particularly i'm int…

  SQL_Surfer

  1 replies

  2 weeks, 1 day ago

  By: SQL_Surfer

• How can we get updated and old values from sys.fn_get_audit_file table

  Dear Team, This is Naveen, i want to get the list of update new value and old values from audit tab…

  maroju1

  3 replies

  2 weeks, 4 days ago

  By: John Mitchell-245523

• CTAS data load incremental

  I'm using CTAS concept to do full load and works perfectly. Now, they want to load the data increme…

  SQL_Surfer

  2 replies

  3 weeks, 6 days ago

  By: Mildofly

• Azure file copy creating a directory to hold the renamed file

  Hi All, I'm pretty new to azure and am hitting the following problem. I've got a notebook that crea…

  Irish-Toon

  1 replies

  2 months ago

  By: Irish-Toon

• Azure SQL MI Question (tempdb issue)

  We are getting following error while dumping data from Databricks into SQL MI. "Error : Could not a…

  imani_technology

  2 replies

  2 months, 1 week ago

  By: Andrey

• SQL Azure Latest v12 update error Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violate a uniqueness constraint imposed by the target table

  My SQL Azure database has a stored procedure that has the merge statement. When my database on Azur…

  gurvinderg

  6 replies

  2 months, 2 weeks ago

  By: sangeetha.microsoft

• Cancelling pipeline condition based

  I have created a pipeline to move the data from  on-premise to Azure VM. There are instances that …

  ammit.it2006

  2 replies

  3 months, 1 week ago

  By: ammit.it2006

• How to replace placeholders in a string from an ordered list of column names

  We have a CI/CD project underway to use the options pattern in C#/.NET Core to remove settings and …

  scdecade

  2 replies

  4 months, 2 weeks ago

  By: scdecade

• Why would an indexed column could take 5 seconds to apply a where clause?

  I am testing a design and to implement my test, I've created a table with 1 milion rows in it.  Wh…

  ashkan sirous

  3 replies

  5 months, 1 week ago

  By: Jeff Moden

• differentiating between ADLS and ADF and use applications

  I recently completed Mike McQuillan's ADLS and USQL course on Pluralsight in addition to PragmaticW…

  vega805

  1 replies

  5 months, 1 week ago

  By: vega805

• RLS and Multi tenancy

  Hi All, I am looking at implementing RLS in my multi tenant databases and was trying to think of a …

  Leighton21

  1 replies

  5 months, 2 weeks ago

  By: Leighton21

• Load azure data warehouse

  Hi I have on-premises sql server database. I need to load data from this DB to azure DW. What is th…

  a2zwd

  1 replies

  5 months, 2 weeks ago

  By: RobertMPotter