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.Better way to check database for dups
I have vba in Excel that incorporates SQL to iterate through all the records in a sheet and checks the databsase for that record using a combination of two fields to make a unique id. If it's in the database then it's deleted from the sheet. Otherwise it goes to the next one. Easy enough. I've had this code for years and it's always been fine but now there are too many records to do it this way. It takes too long. What would be a better way to query the SQL database to return those records that are dups and then delete them from the sheet. Here's an idea of the snippet of code I currently use: 'i is the record number from bottom to top For i = DataSheet.Range("A" & Rows.Count).End(xlUp).Row To 2 Step -1 CountyName = DataSheet.Cells(i, 1).Value CaseNumber = DataSheet.Cells(i, 3).Value strSQL = "SELECT County, Case_Number FROM tblAdLetter " & _ "WHERE County = '" & CountyName & "' AND Case_Number = '" & CaseNumber & "'" rs.Open strSQL, cn If Not rs.EOF Then DataSheet.Rows(i).Delete End If rs.Close Next i Is there a better way or faster way? todAzure SQL DB Index Recommendations
For the SQL Azure Databases in multiple regions and multiple subscriptions, we keep getting recommendations/warning regarding the addition of indexes is required, but those recommendations are implemented already and those indexes exist. We understand that manually applied recommendations will remain active and shown in the list of recommendations for 24-48 hrs. before the system automatically withdraws them but it's a recurring issue for them and is causing lot of churn. Basically we want to understand if the recommendation has already been applied why is the base issue not resolved? Will they be there forever or is there a way to force the recommendation to be evaluated again. Thanks.
Query from Excel in Synapse Serverless
I'm trying to use the following code to read from an Excel file using Synapse Serverless. Is this even possible? SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 Xml;HDR=YES;Database=https://container.blob.core.windows.net/datalake/Bronze/Manual/Testing 20230106.xlsx', 'SELECT * FROM [ProductList$]') AS ROWS; I'm getting an error near Openrowset which is less than helpful from the Synapse Serverless SQL engine
Azure SQL Database
Hi, i currently have a Microsoft Access application that uses data, queries, forms, report and custom vb coding. I'm looking for a modern cloud solution that i can use to recreate my application and then be able to offer to my clients via web link. Is Azure SQL database a reasonable tool for this high level requirement?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 ?
