Forum Widgets
Latest Discussions
Azure SQL Firewall / Locks
Hi there, I have 2 environments. I'm more of admin on Azure environment (recently made as subscription admin) after which Dev issue - Azure SQL I'm having difficulty to remove IP from Azure SQL Firewall. (Earlier i was able to) today my manager granted me subscription admin and as SQL Security Manager and it still not able to remove grayed out IPs.
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?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 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. Zerror 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 ????
SQL MI firewall
During SQL MI deployment, a built-in firewall is deployed along with a dedicated virtual network (VNET). We can choose to access SQL MI using either a public URL or a private endpoint. Does this built-in firewall provide sufficient protection for SQL MI, or do we need to implement an additional firewall?Managed Instance - Start/Stop Schedule and Planned Maintenance (Updates)
Hello Tech-Community, we recently startet to Shut-Down our Managed Instance over night when all Developers are a sleep. My question now is - when a [Planned Maintenance] is announced for Updating the Managed Instance Infrastructure, what will happen if the Instance is down with a [Stop Schedule] ? Will the Patches be applied anyway - or will the Updates fail ? If anybody knows - please inform us. Thanks. Regards from Zürich _ SwitzerlandManaged Instance intermittently logs me in as DBO
Intermittently Azure Managed Instance logs me in as dbo when I log in using Entra. I will wake up the next day to find the problem gone. This is an issue because when i try to create a new transactional replication publication I get Msg 15007, Level 16, State 1, Procedure sys.sp_grant_publication_access, Line 112 [Batch Start Line 17] 'dbo' is not a valid login or you do not have permission. Can anyone help me understand why Managed Instance sometimes logs me in as 'dbo' or should I raise a ticket..? FYI - I am in the Entra Admin group on the server
