Azure SQL Database
An Azure relational database service.
5,343 questions
1 answer
Azure Datawarehouse Performance Tuning
Hi..Am currently working on Azure Sql DB to Azure Datawarehouse migration.. After migration when I tired to run fact load sp am facing severe performance issue.. That sp which has while loop in it and it has to iterate for 7000+ plus times. For each and…
asked 2020-10-13T06:52:25.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 62%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bharathiraja
1
Reputation point
commented 2020-10-16T03:50:37.437+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
One of the answers was accepted by the question author.
Getting SSL certificate error while connecting to Synapse SQL pool from Databricks in Azure using JDBC
--------------------------------------------------------------------------- Py4JJavaError Traceback (most recent call last) <command-3031308706598466> in <module> 6 .option("tempDir",…
asked 2020-10-06T17:17:39.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 91%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Ajay Verma
21
Reputation points
commented 2020-10-15T05:11:29.787+00:00
PRADEEPCHEEKATLA-MSFT
84,381
Reputation points Microsoft Employee
2 answers
There are no adventureworks tables in datawarehouse
Trying to create an azure datawarehouse using powershell and want to import sample adventureworks data in it using powershell. Passing samplename parameter as "AdventureworksLT". But when the Dataware house is created,there are no…
asked 2020-10-06T10:12:26.62+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 44%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Suneetha Devibusi
1
Reputation point
commented 2020-10-09T16:57:11.477+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
0 answers
ADW : Any changes to HEAP in Gen3
Hi All, We are using HEAP for transient data and want to check with experts if there are any upcoming changes to HEAP in Gen3.
asked 2020-10-02T18:11:11.703+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 84%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
commented 2020-10-06T08:39:59.183+00:00
PRADEEPCHEEKATLA-MSFT
84,381
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Synapse Analytics - Resource Class assignment to Active Directory Group
I've assigned resource_class to a specific Active Directory group, but the user within that group gets the default resource_class assigned when executing queries. User X is assigned to AD group Y. Y is assigned to 'mediumrc' but the execution…
asked 2020-09-30T12:41:26.59+00:00
XchangeVisions
301
Reputation points
commented 2020-10-05T19:36:44.087+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
0 answers
Synapse not supporting pagination JPA
When trying pagination with spring data jpa; getting duplicate records from other page and some records are being skipped.
asked 2020-09-29T09:37:00.053+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
pankaj tiwari
1
Reputation point
commented 2020-10-05T19:05:05.223+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
How to read a CSV file with Line break and Quotes through PolyBase in Synapse
Hi All, I have an automated source that generates Excel file with data that can contain line breaks or double quotes or some delimiter values. I am converting this Excel file to CSV using ADF Copy activity and to handle column delimiter in data i have…
asked 2020-09-11T06:51:43.757+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 27%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
Priya Jha
871
Reputation points
commented 2020-09-29T21:17:44.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT
26,051
Reputation points
2 answers
SYNAPSE STUDIO- SQL POOL -(NEW)OPTIONS DISABLED
Hello Community, I have been facing error related to creation of new sql pool via synapse stuido. The (New) options is disabled over synapse studio. Please could anyone let me know why is the reason behind it. THanks, Deepak
asked 2020-09-10T12:54:54.187+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 89%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
demo case
1
Reputation point
commented 2020-09-28T07:28:27.253+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
2 answers
ADF Copy activity using PolyBase fails to load "Date" type to Synapse
When loading Date type from a parquet file to Synapse with "Date" type via ADF Copy with PolyBase, the ADF throws the following error: { "errorCode": "2200", "message":…
asked 2020-09-24T14:46:46.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 15%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Robert Kostecki
6
Reputation points
answered 2020-09-25T17:15:07.9+00:00
Robert Kostecki
6
Reputation points
2 answers
One of the answers was accepted by the question author.
Spark pool does not reflect the contents of requirements.txt
I have checked the Microsoft Learn description below and am trying to add the Python libraries to the Spark pool. https://video2.skills-academy.com/en-us/azure/synapse-analytics/spark/apache-spark-azure-portal-add-libraries I created…
asked 2020-09-23T19:51:02.64+00:00
Yuji Masaoka
56
Reputation points
answered 2020-09-25T11:45:56.717+00:00
Yang Jiayi
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Performance, Pros and Cons of using Logic Apps or Azure Data Factory for Orchestration of huge ADW and Performance, Pros and Cons of using ADFV2 Mapping Data Flows
Please share Performance, Pros and Cons of using Logic Apps or Azure Data Factory for Orchestration for huge ADW and Performance, Pros and Cons of using ADFV2 Mapping Data Flows
asked 2020-09-11T07:30:47.203+00:00
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
accepted 2020-09-25T08:21:21.553+00:00
Faiaz Pasha Shaik
21
Reputation points Microsoft Employee
0 answers
Data Disposal/Retirement in Azure Synapse
Can someone please let me know how to achieve data disposal/retirement in Azure Synapse Analytics (SQL DW) and how to ensure it is happening safely in Azure.
asked 2020-09-22T20:50:56.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Akash Verma
21
Reputation points
commented 2020-09-25T00:31:03.757+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
2 answers
Setting password for contained users mapped to Azure AD identities
Hi, I'm implementing Azure Active Directory Authentication for users to get in and use Synapse Analytics (SQL DW). I have 2 questions they are as follows: The Azure AD method that I used was Azure Active Directory Password. Through…
asked 2020-09-17T19:52:11.627+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 21%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Neil Pereira
81
Reputation points
commented 2020-09-24T06:42:34.207+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
0 answers
Pause/Resume SQL Synapse using SSIS
Hello, We are working on creating an automation script where our SQL Synapse can be paused/resumed during a time window for cost savings. Basically we wanted to do it in SSIS using powershell becase we wanted to check if there are any queries running…
asked 2020-09-11T11:19:59.437+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 99%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DeeMu
1
Reputation point
commented 2020-09-23T23:33:12.523+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
EdX Certified but not MCSA
I completed a couple of certifications on EdX a while ago. Received the Microsoft Applied Data Analytics and Microsoft Data Science Fundamentals certificates from them. MCSA: BI Reporting wasnt available at the time I completed the EdX certifications.…
asked 2020-09-22T16:09:01.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 14.000000000000002%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rob Bebout
1
Reputation point
answered 2020-09-22T16:11:51.637+00:00
Leon Laude
85,716
Reputation points
1 answer
One of the answers was accepted by the question author.
time query in PowerBIP
Hello We have an SQL Server 2016 database with historical tables We would like to display this data in PowerBi Like this in SQL Server "select * from XXXXXXXXXX for system_time all" thank you for your reply. Olivier Diago …
asked 2020-09-22T10:03:59.837+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
DIAGO Olivier
21
Reputation points
accepted 2020-09-22T10:50:19.29+00:00
DIAGO Olivier
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Synapse Analytics: Trigger activation error. I can't activate any scheduled Trigger.
I'm working on Azure Synapse Analytics. It was working fine till yesterday when I decided to create a new Scheduled Trigger. I can create a new trigger and associate it with an existing pipeline. When I try to activate it by hitting the publish…
asked 2020-09-17T08:02:57.337+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 68%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Danilo Tascone
21
Reputation points
commented 2020-09-18T16:37:50.487+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Password for Contained User in Synapse Analytics
Team, I'm unable to create password for a contained user in Azure Synapse Analytics (SQL DW), seems like this feature isn't available. Please confirm on this! The available option is to create a contained user without password. But after…
asked 2020-09-11T17:46:16.797+00:00
Neil Pereira
81
Reputation points
commented 2020-09-17T21:15:55.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Browne - msft
3,771
Reputation points
3 answers
One of the answers was accepted by the question author.
Column level security not working in Synapse Analytics
Hi Team, I tried to implement column level security on a table in synapse analytics by skipping one column that shouldn't be viewed by a specific user, but still this user is able to view this column from the table. The query I used to implement…
asked 2020-09-11T17:32:43.54+00:00
Neil Pereira
81
Reputation points
accepted 2020-09-17T19:38:37.503+00:00
Neil Pereira
81
Reputation points
1 answer
Alternative to using Azure SQL Managed Instance for Complex calculations
I have inherited an Architecture which carries out complex calculation in Azure SQL Managed Instance via Databricks. The Databricks is connected via Apache Spark connector. The Databricks does the calculations in SQL and the end results are in Tables…
asked 2020-09-02T16:31:09.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 90%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kman
41
Reputation points
commented 2020-09-16T19:45:52.69+00:00
MartinJaffer-MSFT
26,051
Reputation points