Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
50 questions
1 answer
DB import error
Hi, I created a MariaDB server and I am able to connect it using commandline. I created a database and few empty tables from mysql cli without any issues. I am unable to import a database dump in the server. I get below error, root@Anonymous [~]# mysql…
asked 2020-08-21T12:26:41.07+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(115.19999999999999, 26%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ajin Prasad
6
Reputation points
answered 2020-10-28T19:55:25.18+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(102.4, 25%, 19%)' 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)
Miroslav Adamec
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Sinking to a Power BI created Data Flow using Data Factory CDM sink
Hi, I've created a Power BI Data Flow with a single entity and I would like to use Data Factory to push data to it. I am unsure what options I should be using in the Data Factory inline CDM sink. I can see I have a model.json file in the Power BI…
asked 2020-10-27T19:29:34.12+00:00
Serverless SQL
216
Reputation points MVP
commented 2020-10-28T19:43:21.393+00:00
Serverless SQL
216
Reputation points MVP
1 answer
Objects and arrays defined in outer scopes are currently not supported inside sortBy predicate
This problem was raised in 2018 and it's still not fixed:…
asked 2020-10-16T19:02:12.467+00:00
Noel Abrahams
1
Reputation point
commented 2020-10-28T19:37:38.397+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
Identity function on column
Hi. I have an Identity column set for one of my columns in the Azure SQL database. However the column values are not shown as expected. I want to have a sequential numbering to be set for this column, however the values are getting set randomly. …
asked 2020-10-21T04:27:26.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(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
venkatesh padmanabhan
181
Reputation points
commented 2020-10-28T19:35:38.467+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
ADF "Index out of range" when reading XLSX with hidden columns
@Anonymous @Anonymous @Anonymous Hello everyone, I have a XLSX file generated by a system, and this file has 3 hidden columns on the start (columns A, B, and C). These columns aren't important and can be ignored if necessary. So, I've…
asked 2020-10-20T14:35:23.897+00:00
Alexandre Von Mühlen
1
Reputation point
answered 2020-10-28T18:47:47.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(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,386
Reputation points Microsoft Employee
1 answer
How to get the latest Json file from any Cloud source to the ADLS whenever the ADF Pipeline runs
Hi Team Whenever we run a pipeline in ADF, how we are getting the latest file from a list of files from a source and copying it into the ADLS Regards Kks
asked 2020-10-06T10:30:30.973+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(147.20000000000002, 10%, 24%)' 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)
kks8589
96
Reputation points
commented 2020-10-28T18:07:12.86+00:00
HimanshuSinha-msft
19,386
Reputation points Microsoft Employee
1 answer
Where can I see and download the code examples mentioned on docs.Microsoft?
Good morning, I'm following a tutorial on learn.microsoft 1 and the article mentions some code examples but I can't figure out where I can find them. I'm looking for an example of the repository pattern using a current site context, according to…
![](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, 68%, 23%)' 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)
1 answer
One of the answers was accepted by the question author.
HD Insights - Script Action stored in ADLSGen2
When trying to run Bash scripts as Script Actions on Cluster creation is there a way to use a ADLSGen2 location? From the current documentation it shows ADLGen1, and public HTTPS requests but does not discuss this possibility with Gen2. In scripts…
asked 2020-10-26T20:12:52.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(67.2, 46%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brendan Cassidy
26
Reputation points Microsoft Employee
accepted 2020-10-28T16:49:12.527+00:00
Brendan Cassidy
26
Reputation points Microsoft Employee
1 answer
VMWare Config Server Second Nic Azure Site Recovery
When configuring the Azure Site Recovery Vmware onsite config server it states to add a second nic card. Is there any networking configuration or settings in general? I added it to the VMware VM but it doesnt have an IP and the first NIC does. The doc's…
asked 2020-10-23T04:58:14.51+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, 15%, 38%)' 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)
Johnny
41
Reputation points
commented 2020-10-28T16:12:45.72+00:00
SadiqhAhmed-MSFT
39,941
Reputation points Microsoft Employee
1 answer
Text Independent Speaker Identification REST API
Hello! I'm following this tutorial, in the Speaker Identification portion of the REST API tab. …
asked 2020-10-27T15:45:14.397+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, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWA%3C/text%3E%3C/svg%3E)
Wilf, Alex
6
Reputation points
commented 2020-10-28T15:30:51.73+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(22.400000000000002, 11%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ramr-msft
17,651
Reputation points
1 answer
Check Version of Azure Gateway services and upate with latest version
Hi All, Where can i find my Azure gateway service information on the Azure Portal. How can i check what version it is running on and how can i find the latest version and update it? Thanks
![](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, 7.000000000000001%, 10%)' 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)
0 answers
Database not available (error 40613) since this morning
Since this morning, my database is unavailable. This is really annoying because our customer is completely blocked!! What can I do to resolve this? When I try to connect with SSMS, I receive this error : =================================== …
asked 2020-10-21T07:56:00.023+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, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Gianni Tagliarino
6
Reputation points
commented 2020-10-28T15:30:11.14+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
To get all CosmosDB Mongo API collection using foreach and copy Activity
I have 10 collection in CosmosDB with Mongo API and load in BLOB storage , I can able to do for 1 collection using copy activity but cant do for all collection as I have used for each activity but not able to get all collection name in for each…
asked 2020-10-20T06:58:40.28+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(60.8, 97%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Girish13
1
Reputation point
commented 2020-10-28T15:29:17.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(108.80000000000001, 9%, 20%)' 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)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
Out of Memory (Analysis Service Database Processing)
I am often running into "Out of Memory Error", while database full process. Could you please recommend the solution ? What are the tip for Analysis Service maintenance ? Thanks
asked 2020-10-22T19:06:11.953+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, 88%, 23%)' 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)
Boiler
1
Reputation point
commented 2020-10-28T15:27:26.83+00:00
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Error - Create your first Azure IoT Central app
I am trying to implement "RefrigeratorTruck" example on Azure IoT Central. I have created the Device Template and added the interfaces as per the document and published it and added the devices. When I am running the Visual Studio + C#…
asked 2020-10-21T17:45:23.093+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(233.6, 1%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abhishek Anand
36
Reputation points
accepted 2020-10-28T15:12:22.977+00:00
Abhishek Anand
36
Reputation points
2 answers
Is there any specific date fromat for 2011-03-09T01:42:34.9360000Z, the datetime value of a blob snapshot?
Hello, I am trying to do a date transformation from 2020-10-28 12:48 to 2020-10-28T12:48:33.6528850Z. Is there any date format that would do that for me? YYYY-MM-DDTHH:mm:ss.SSSSSSS[Z] doesn't seem to resolve into the correct date of the snaphot.
asked 2020-10-28T13:25:45.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(83.2, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sandboxtray
41
Reputation points
answered 2020-10-28T14:58:36.32+00:00
sandboxtray
41
Reputation points
0 answers
How to prev()
Hello! How do I use prev() to return only results of the same UserDisplayName of the current log? Running the search below gives unexpected output (negative time_between_logins) and the previous log seems to be tied to a different user. Any…
asked 2020-10-15T14:49:24.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(163.2, 38%, 25%)' 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)
Ashley Van
1
Reputation point
commented 2020-10-28T14:41:38.353+00:00
Clive Watson - MSFT
106
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Server 2016 On Prem connection to Azure SQL Server
We are thinking of moving our on prem NAV SQL Server into Azure but if this does happen our BI SQL Server 2016 will not move at the same time. The SSIS jobs on the BI Server will still need to select data out every hour. (BI into Azure or SSIS setup in…
![](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, 31%, 14%)' 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)
2 answers
WVD smartcard redirection is not working
Has anyone been able to get smartcard redirection to work with WVD? I just want to use them to access DoD websites, not login. All the other RDP properties on the host pool work as expected (printer, clipboard, drives), but not smart cards. When…
asked 2020-10-27T19:29:28.803+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Al Fontaine
1
Reputation point
answered 2020-10-28T14:21:51.057+00:00
Al Fontaine
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Ingesting json events with various schemas from Blob Storage to Azure Data Explorer
Hi, We're a game company using PlayFab for our backend. Play sessions events are created by PlayFab and are automatically sent to a blob storage in Azure. I created an Azure Data Explorer Database which ingests these events whenever the blob storage…
![](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, 33%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)