I am having few data which gets returned from my Store procedure or table from Azure SQL Server, Client is having some formatted excel and I need to export data from SP to that formatted excel. The excel has pre defined columns with different name than DB Column names . Is it possible by using any Azure resources like Azure
Tag: azure
Microsoft Azure database admin user creation
I deployed azure MySQL 5.7 database in azure. I can’t create another admin user with admin permission with the serveradmin login. When I tried below command GRANT ALL PRIVILEGES ON . TO ‘sammy’@’localhost’ WITH GRANT OPTION; I am getting error serveradmin@ip don’t have enough permissions even though I am user server admin login. Is this because of Microsoft Azure database
Azure SQL: Modify table data via UI instead of writing SQL query
Is there a way I can modify the table data in an Azure SQL database via some sort of UI (like Excel) instead of having to write SQL queries? Preferably I can modify it online in the Azure Portal instead of having to install some third-party software. Often times, I just want to edit a specific cell in the table
call an forEachActivty from a body Json of an webActivtity
I want to use a pipline ADF to call an API REST which used an sql table and extracts one or more files. API should return 3 files if the table contains 3 different regions, for this reason I used the following activities: A lokupctivity : it’s a query ( distinct on the column Regions) to get all the regions
unpivot columns into two new columns in Stream Analytics
I have a stream from IoT Hub like: I want to pass this stream in a SQL DB like this: is there any way to use cross apply or other way to create two new columns form multi json element Answer If it’s a static pivot (you know in advance the list of fields and you can hardcode their value),
Set a databricks python variable with a %sql statement
The code in cell 1 works just fine. The problem I just don’t know the correct keywords to search to see how I can make the code in cells 2 & 3 work. Basically, in a %sql cell, can I select into a variable that can be later used in a python cell? I realize this may not even be
Why Synapse is not working with my query?
I’m trying to use a query in Synapse Analytics from Azure, and when I use it I got the next error: at Source ‘AgenciesInventoryQueryFromSynapsestg’: shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 1, column: 47: Incorrect syntax near ‘WITH’. That’s weird for me cause I tested the query in Microsoft SQL Server Management before to add it to Synapse, and it works perfectly
Azure data upload and SQL database update failure for filename tracking
I have a scenario, in which I upload the file to Azure and will get the uploaded filename. Now I would need to store the filename (received for Azure upload) to SQL database. In case, if database down means it will fail to capture the filename (received for Azure upload) to SQL database but the File upload to Azure was
Excel into Azure Data Factory into SQL
I read a few threads on this but noticed most are outdated, with excel becoming an integration in 2020. I have a few excel files stored in Drobox, I would like to automate the extraction of that data into azure data factory, perform some ETL functions with data coming from other sources, and finally push the final, complete table to
Unable to Run Update Query in SQL Azure *Invalid object name ‘DataSync.provision_marker_dss’.*
I was syncing my Azure SQL Database with On-Premises SQL Database which created a lot of tables in the Online database (As Usual). Anyway, It was working fine. Now, I had to re-create the Azure SQL Database. So, I deleted the Sync Group & Sync Agent as well. Everything’s working absolutely fine unless I run an Update Query on that