Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,493 questions
1 answer
Synapse Analytics - Unable to start cluster when I upload requirements.txt file - cluster fails.
Hi, I'm trying to start a cluster with some additional packages (tried output of pip freeze > requirements.txt and also added all of the packages that come with the anaconda distribution that is installed on standard cluster in synapse analytics). …
asked 2020-05-26T02:09:14.497+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(211.20000000000002, 28.999999999999996%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Joe Kastner
21
Reputation points
commented 2020-07-08T22:36:45.097+00:00
Mike Ubezzi
2,776
Reputation points
2 answers
Backup stratergy for Azure PostgreSQL
I understand by default Azure keeps backups for PostgreSQL for upto 35 days. How can i increase that? Do i need to have a custom backup strategy if i want to maintain backup for more upto 7 years? I m new to PostgreSQL so details are appreciated.
asked 2020-06-04T22:13:42.417+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(0, 50%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
F Ahmed
36
Reputation points
commented 2020-07-08T22:13:05.7+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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
It's possible create a MASTER/Replica from Azure Database for MySQL server to MySQL on-premise?
Hello My main database is in an Azure database for MySQL server and I want it to be my MASTER and I want my on-premise base to be a REPLICA Master : Azure database for MySQL (principal database) Replica: Database On-Premise Centos (replica…
asked 2020-06-26T02:35:43.443+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(208, 21%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Ligarius
21
Reputation points
commented 2020-07-08T22:12:34.71+00:00
Mike Ubezzi
2,776
Reputation points
asked 2020-07-08T18:56:57.327+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(211.20000000000002, 2%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
colm sweeney
1
Reputation point
answered 2020-07-08T22:03:35.333+00:00
Leon Laude
85,686
Reputation points
2 answers
One of the answers was accepted by the question author.
Listing of Code changes made through Development in NAVision 2018
I have a client running NAVision, that needs to show a "system generated listing of changes to code" made through through the Development Module inside NAV. Not data mods (Change Log has that covered), but customized tables, fields,…
![](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(153.6, 48%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
1 answer
azure appservice on private VNET
I have tried the premium app service with "vent" integration. the endpoint https://xxxx.azurewebsites.net. however, still I can reach this URL from the internet. why is that? I need to block the Internet access. the only thing I can access…
asked 2020-06-25T23:10:32.313+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(307.2, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
raindrop
1
Reputation point
answered 2020-07-08T21:53:01.187+00:00
Grmacjon-MSFT
16,776
Reputation points
1 answer
azure data factory - java.nio.BufferOverflowException
Hi, I'm using copy activity to copy ORC files from DL Gen 2 to Synapse. Some files are running fine but other files fail with this error: What is the reason. I'm using : AutoResolveIntegrationRuntime "errorCode": "2200", …
asked 2020-06-18T12:26:57.64+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(80, 72%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jilova, Hristina
1
Reputation point
commented 2020-07-08T21:41:26.303+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,427
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Cloud-only account on hybrid joined device?
Hello everyone, we are planning to use hybrid joined devices (AD & AAD) in future as one step (of many) to a cloud-only approach. What we are currently wondering (because it's not working in the lab environment): Can a cloud-only user logon to…
asked 2019-12-03T10:57:06.527+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(32, 47%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Vexxer_5
21
Reputation points
answered 2020-07-08T21:34:19.007+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(44.800000000000004, 83%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Caroline Sanchez
6
Reputation points
1 answer
Can't process ORC files in Data Factory : ErrorCode=ParquetJavaInvocationException
Hi, Our organisation uses ORC formatted files for our central file storage, in our data factory I am unable to process most of the ORC files, I am only able to process really small files (< 1mb) for all the other ORC files the pipeline fails to run. …
asked 2020-07-07T09:04:54.987+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(313.6, 71%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Joris
6
Reputation points
commented 2020-07-08T21:31:08.813+00:00
KranthiPakala-MSFT
46,427
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Opening Web Browser with Custom Params
I am working on opening something in the browser on the xbox one and I was wondering if there were configs I could use so when I link out to the edge web browser it does not open a new tab if the link is already open. This is a snippet of the code we…
asked 2020-07-08T19:44:42.77+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(6.4, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Swartz, Victoria
21
Reputation points
accepted 2020-07-08T20:49:58.443+00:00
Swartz, Victoria
21
Reputation points
3 answers
One of the answers was accepted by the question author.
Shared emails
Hello, Ive set up a shared email for 4 users in our business. Emails are visible to all users until one person opens the email, then the others cannot see it. Id like for all emails to be visible to all users whether read or not. Can this be done, if…
asked 2020-07-08T19:41:24.483+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, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rhys Diment
21
Reputation points
commented 2020-07-08T19:52:10.783+00:00
Leon Laude
85,686
Reputation points
1 answer
Can't find my certificates
Hello, I had about 5 certificates, which I can't find. For some reason my acclaim badge doesn't have any MS certificates. Please help me. My Candidate name: TIMUR R SHAVALEEV; Candidate ID: MS0429970998
asked 2020-07-08T19:38:35.823+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(140.8, 94%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Timur Shavaleev
1
Reputation point
answered 2020-07-08T19:42:58.68+00:00
Dave Patrick
426.2K
Reputation points MVP
0 answers
UWP apps socket connection over the internet
Hi, We have 2 UWP apps which share data between them through socket connection. It was built for a LAN. But now the client wants to run it over the cloud. So now we can't use the local IPs we used for socket connection. So is there any option to…
asked 2020-07-08T17:19:29.983+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(259.20000000000005, 86%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Madhu
96
Reputation points
commented 2020-07-08T18:56:10.2+00:00
Peter Fleischer (former MVP)
19,306
Reputation points
3 answers
Version of Synapse Analytics
I'm having a question; I'm having 2 SQL DW / Synapse databases (dev + uat) and a few things that I see is a difference in version. I started figuring this out because of that DEV supported a Common Table Expression with an insert and UAT doesn't... So it…
![](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(44.800000000000004, 63%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Set-AzDiagnosticSetting gives a storage not provisioned error
Hi all, I'm trying to set up some diagnostic logging via this PowerShell command, but it isn't working. The command I'm running is: Set-AzDiagnosticSetting -ResourceId…
asked 2020-06-15T16:45:38.127+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(275.2, 32%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Panzerbjrn
1
Reputation point
commented 2020-07-08T18:41:04.687+00:00
bharathn-msft
5,086
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Spot Instance Eviction Frequency
Is there an idea or range of frequency that can be expected for eviction?
asked 2020-05-20T22:36:35.83+00:00
Ashley Kennedy
21
Reputation points Microsoft Employee
commented 2020-07-08T18:29:45.09+00:00
Ashley Kennedy
21
Reputation points Microsoft Employee
1 answer
fetching Get-AzureRMRoleAssignment:"Authentication_Unauthorized","message":{"lang":"en","value":"Access denied to the specified API version"}
Get-AzureRMRoleAssignment : {"odata.error":{"code":"Authentication_Unauthorized","message":{"lang":"en","value":"Access denied to the specified API…
asked 2020-06-29T10:31:28.03+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(67.2, 45%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
musham ajay
1
Reputation point
answered 2020-07-08T18:25:24.78+00:00
bharathn-msft
5,086
Reputation points Microsoft Employee
asked 2020-06-25T08:28:49.873+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(118.4, 73%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
NIKITA SHARMA
1
Reputation point
commented 2020-07-08T18:24:29.067+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,041
Reputation points
1 answer
One of the answers was accepted by the question author.
Why are Sheet Views showing other users' changes?
When more than one person is using the same Excel spreadsheet in Teams they use saved "sheet views." Each member in our department has their own Sheet View. However, if I am in mine I can see a coworker hiding columns, adjusting filters, etc in…
asked 2020-07-08T16:09:01.75+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(166.4, 62%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKT%3C/text%3E%3C/svg%3E)
Katy.Thompson
21
Reputation points
accepted 2020-07-08T18:03:40.773+00:00
Katy.Thompson
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Export the user
How to export the user with their access in AZDO?
asked 2020-07-08T17:04:23.32+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(16, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rohini Sharma
21
Reputation points
commented 2020-07-08T17:30:31.373+00:00
Leon Laude
85,686
Reputation points