We have a curious issue with our Azure SQL database with AAD authentication. We have created a role (dbt_user) with all permissions, and excluded some schemas: Then, we add an AAD group (myAADGroup) as user, and add this to the role above: There are 2 members of the AAD group: user1@domain.com and user2@domain.com. The first user can log in, and
Tag: azure-sql-database
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
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
Where Azure SQL Database logs for failed Data Manipulation SQL queries?
I can find tools in Azure to monitor and get logs on the performance of the Azure SQL database. However, what tools are available in the Azure portal to see logs of failed SQL data manipulation …
How to implement OPENJSON Having JSON code as a text inside a column. How do i use OPENJSON on the column of a table in AZURE SQL Dataware House?
Eg: RAW DATA Want to apply OPENJSON on Discounts and have below OUTPUT: Answer I’ve updated my answer, please add ; after the insert statement. Create table and insert two rows: Then we can use following sql to query the data. 3.The result is as follows:
Is is possible to create a view based on a table in a different server?
My client have an azure service app MyServiceApp, its database called MyCloudServer (its data is taken from a legacy MyPremiseServer). The MyPremiseServer is a server located on my client’s site, because the cloud’s service app MyServiceApp can’t access it, They created the MyCloudServer with the exact same scheme of MyPremiseServer. In order to make the MyCloudServer to hold the same
Fastest way to get the max date in SQL database (Azure)
I have a table that has Many rows up to 1000000. and 300 columns Question : I would like to know the fastest way to get the max date of the column ‘LastModifiedDate in table. In My table I have the columns : Id, LastModifiedDate and others columns… Thanks in advance for your help Answer If the inserted records are
Failed to execute query. Error: String or binary data would be truncated in table xdbo.user_info’, column ‘uid’
I have problem inserting values in my SQL server database on Azure, I am getting the following error: I don’t understand where I am wrong, I just created the server, and I am trying to experiment but cant fix this. Creating the table works fine, the only thing that doesn’t work is the second command INSERT Answer I suspect that
Reference to database and/or server name is not supported in this version of SQL Server
Objective I’m trying to put data from a couple different Azure databases into a new Azure database with a script similar to the following: Essentially I am creating the tables in the new database with the exact same schemas that are in the source databases and then trying to insert all of data from those source tables into the target
SQL Server: Drop all Not Null constraints in all DB tables
How do I drop all Not Null Constraints in All Columns in every table using SQL Server ? Would like to loop run this query in all tables and columns, How to remove not null constraint in sql server using query Note: requirement is for all non-primary key columns. Similar Question: How to drop all Foreign Key constraints in all