How to work with SQL server
If I downloaded and installed MySQL server into my personal computer, how do I access or use it from a different computer and is it possible or not.
How is managed identity of web app working without assigning IAM role in SQL?
Hi, I am moving towards managed identities, in doing so I followed https://techcommunity.microsoft.com/t5/apps-on-azure-blog/connect-app-service-with-azure-sql-database-with-managed/ba-p/3288300 to connect web app with SQL DB. I followed every step but I…
Azure SQL Database large tables performance Issue
In my Azure SQL Database, there exists a considerably large table, let's call it 'tableA'. In my application, I have several distinct queries (approximately 10) that involve different sets of columns from this table. For example, 'query1' utilizes…
Indexing on replica
Can we create an index on read-only replica of azure sql db? if not, then how can we create index on replica directly. I don't want to create index on primary db.
Read_Write access to replica of azure sql
How to provide read_write access to azure sql replica. By default it is read only
Ocean Credit cusTomer care service Tollfree Number)+91)8293804210(call)8293804210/ call.
Duck Dynasty warriors and your family and friends
55 ACE GAME customer care toll free service Number 91-6363218511xNn
Ka hi dena chahiye tha na to get it done by hi I should not be able to get a chance for
Ocean Credit cusTomer care service Tollfree Number)+91)9861431692(call)9861431692/ call
H is a good day and I
55 ACE GAME customer care toll free service Number 91-6363218511xJ
Yes sir withing for the time to get it done by the time to get it done by the time to get it done
Is Azure SQL trigger for Functions is generally available for SQL Server hosted on Azure VM
I see that the Azure SQL trigger is now generally available on Azure SQL Database. Here is the link: https://azure.microsoft.com/en-us/updates/general-availability-azure-sql-updates-for-latejanuary-2024 Is it also generally available for SQL Server…
Indexing on Subscriber
I want to create index directly on subscriber in azure sql replication. Is it possible to do it without affecting the Publisher?
Purview Lineage for Stored Procedure Not Working (Few weeks ago same was working)
Hello Everyone, have anyone noticed Purview Lineage for Azure SQL Database stored procedure stopped working now, Purview lineage for stored proc depends on running the SP after Lineage Scan is configured. and we successfully implemented the use case it…
SQL Data max Size
Hello, I have one SQL server with elastic pool enabled. On the elastic pool the Data Max Size set to 200GB and this SQL contains of 22 database. Current elastic pool datas storage is 78% used space and this mean I still have around 44 GB. Also today i…
How is it possible to set the minimum amount of CPU for a database inside a pool in Azure?
Good afternoon, For some time now, we have been experiencing issues regarding resources in a database pool. as a first solution we decided to increase the amount of vCore to improve processing, for a few days everything went well, but today a strange…
unresolved reference to SqlSchema Azure Data Studio
I am trying to build the database project on Azure Data Studio and receiving errors saying has an unresolved reference to SqlSchema. I have several databases under one project. How can I fix this error. The table create script has…
In the SQL Server, we observed that the process System Interrupts is regularly spiking between 1 to 24 of CPU time, this is happening very frequently nowadays why its happening ? how can we resolve this issue?
In the SQL Server, we observed that the process System Interrupts is regularly spiking between 1 to 24 of CPU time, this is happening very frequently nowadays why ? how can we resolve this issue?
Security with azure
I want to sign up for azure. I need to know how secure I can make the database. I will be having maybe 10-20 clients logging into the database via a SQL driven website so need the data to be really secure. Would azure be a good option for this? Thanks
Azure - Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user ''. at Microsoft.Data.ProviderBase.DbConnectionPool.CheckPoolBlockingPeriod(Exception e)
Hi guys Dont know where to start, we have a SQL server and we recently added a new database which connects to the same SQL as the Production server but will function as our DEV environment. When trying to run Swagger API calls we get error…
Unable to access azure sql datbase rest api page
I'm unable to access the following link https://review.docs.microsoft.com/en-us/rest/api/sql/retirement?branch=sqlretirement#latest-stable-version-of-azure-sql-database-rest-api I had access to it for a day or so, but now everytime I go to it I get the…
Assembly creation in SQL Server for azure managed instance with MFA authentication
Hi Team, During the creation of an assembly, we require some field information from sys.[sql_logins] view. These fields are such as SID, name, principal_id, type, type_desc, create_date, modify_date, default_database_name, and default_language_name, etc.…