Forum Widgets
Latest Discussions
AzureSQL DB looks empty when it's not
Hi, Quite often it happens that DB does not show any items (tables, views, scripts etc. - any item) in it. At the same time one user can see everything when other not. It happens randomly to different users. For now the only way to fix that we found for now is to scale up and down the DB compute power. It's like it "resets" something and suddenly all items are visible again. We're connecting to DB cluster via MSSMS as per screenshot. Anyone know how to fix that for good?
Unable to enable RCSI
We created our Azure SQL database few years ago and at that time RCSI was not a default setting. I am trying to enable RCSI now but unsuccessful. Database details: We have Azure SQL database (single database) in East US. A read replica (Geo-replication) was created against it. Steps identified from documentation to enable RCSI: ALTER DATABASE [DatabaseName] REMOVE SECONDARY ON SERVER [SecondaryServerName]; ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE [DatabaseName] SET READ_COMMITTED_SNAPSHOT ON; ALTER DATABASE [DatabaseName] SET MULTI_USER; ALTER DATABASE [DatabaseName] ADD SECONDARY ON SERVER [SecondaryServerName]; Second script to set single user returns below error. I am unable to proceed after this. Any help to resolve the problem and enable RCSI is appreciated. Msg 1468, Level 16, State 1, Line 1 The operation cannot be performed on database "[DatabaseName]" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group. Msg 5069, Level 16, State 1, Line 1 ALTER DATABASE statement failed.Azure Data Studio - SQL DB Project build error MSB4020
Hi folks. I'm just getting started with ADS as we need to move an existing on-prem DB to Azure. I 'm trying to use ADS to set up the target DB. I installed the SQL Database Projects extension and created a project from our on-prem DB, but every time I try to build it I get Error MSB4020: stdout: C:\Program Files\dotnet\sdk\7.0.403\Sdks\Microsoft.NET.Sdk\targets\Microsoft.NET.Sdk.targets(1199,3): error MSB4020: The value "" of the "Project" attribute in element <Import> is invalid. [c:\testing\WT pre-migration\WT pre-migration.sqlproj] Here's the proj file: <?xml version="1.0" encoding="utf-8"?> <Project DefaultTargets="Build"> <Sdk Name="Microsoft.Build.Sql" Version="0.2.0-preview" /> <PropertyGroup> <Name>WT pre-migration</Name> <ProjectGuid>{AE8E25C1-F1D6-4447-A008-2C24C82B51FA}</ProjectGuid> <DSP>Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider</DSP> <ModelCollation>1033, CI</ModelCollation> </PropertyGroup> <Target Name="BeforeBuild"> <Delete Files="$(BaseIntermediateOutputPath)\project.assets.json" /> </Target> </Project>AZURE SQL DB Deadlock
I see more than 2000 deadlock everyday for my Azure SQL DB in deadlock metrics but at the end it is not causing any missing data or any transaction drop. My application not using any retry logic then how it is possible that deadlock is getting automatically resolved has no impact at all ?
Azure SQL programmatic access
I work with a team of statisticians who would like to programmatically access an Azure SQL database via R/R Studio without human interaction. Access is setup currently with Microsoft Entra with MFA. The team ideally want to run their R script and connect to the database, without having to be there to enter their login credentials and MFA, can this be done via a key or SAS token? What is the best or recommended method to do this? Thank you. Z
Importing bacpac to Azure database fails
I am trying to import a database from a bacpac file to our azure sql server. I am following these steps: Creating a bacpac file from our production database running on an MS SQL Server 2022. Importing it into azure using sqlpackage But, it keeps failing with *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK_ForexQuote'. Cannot insert duplicate key in object 'dbo.ForexQuote'. The duplicate key value is (1). The statement has been terminated.))). The ForexQuote table DOES NOT have any duplicate primary keys. If I omit this table in my bacpac export I get a similar error on another table. I dont understand. What is going on here?
error when trying to execute sp_invoke_external_rest_endpoint
hi team i am using the following sql server version Microsoft Azure SQL Data Warehouse - 10.0.33054.0 Jul 9 2024 00:12:38 Copyright (c) Microsoft Corporation my college told me this is Azure Dedicated pool , but when i try this statement SERVERPROPERTY('EngineEdition') it gave me the value of 6 now the issue is :- this is my code , which is the REST API is working fine from postman tool ------------------------------------------------------ DECLARE @URL NVARCHAR(255) = 'https://date.nager.at/api/v3/PublicHolidays/2024/ZA' -- HTTP Request Parameters DECLARE @Object AS INT; DECLARE Hr INT; DECLARE @JSONResponse as NVARCHAR(max); -------------------------------------------------------------------------------- -- Perform HTTP GET Request to endpoint EXEC Hr = sp_invoke_external_rest_endpoint @url = @URL, @method = 'GET', @response = @JSONResponse output; SELECT Hr AS ReturnCode, @JSONResponse AS Response --------------------------------------------------------------------- it gave me the following error :- Msg 103010, Level 16, State 1, Line 1 Parse error at line: 10, column: 1: Incorrect syntax near 'EXEC'. any suggestions ????how to export all tables from database
I'm recently started working in Microsoft Synapse and exploring the templates from the gallery available in Synapse "Database templates" and want to export all tables e.g. Automotive. I’ve tried using the DESCRIBE command, but it only gives information about a single table.How can I write a SQL query to exportall tables from the database template and export it to CSV? Is there a specific system view or query I should use in Synapse to achieve this? Any help would be appreciated. Thanks in advance!
