Any updated script that can be used for azure sql db connection?
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 35/100
Research direction
Read the linked Azure SQL guidance and locate the diagnostic script containing CollectionDBDiagnosticScripts\IndexingUnitData.sql. Review the many Invoke-Sqlcmd calls and determine how Azure managed identity can be supported while retaining on-premises use. Done means the script can connect to both Azure SQL Database and on-premises SQL Server.
Written by the indexing model from the issue text.
Description
https://learn.microsoft.com/en-us/azure/devops/server/install/install-azure-sql?view=azure-devops-2022
It's possible to use ADO server with azure SQL db. but elastic search scipt provided here only works for onprem environment.
e.g.
$SqlFullPath = Join-Path $PWD -ChildPath 'CollectionDBDiagnosticScripts\IndexingUnitData.sql'
$queryResults = Invoke-Sqlcmd -InputFile $SqlFullPath -serverInstance $SQLServerInstance -database $CollectionDatabaseName
Invoke-Sqlcmd here uses windows logon, not azure managed identity. And there are many places in the script using Invoke-Sqlcmd. Hence it cannot connect to azure sql db.
Could you modify the script and share an updated version which can be used for azure sql db connection as well?
- Dominant language
- PowerShell
- Stars
- 57
- Forks
- 68
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/Code-Search
-
Difficulty 4/5 3-5 days Newbie friendliness 48/100
microsoft/Code-Search#122 ·
-
Difficulty 5/5 Over a week Newbie friendliness 25/100
microsoft/Code-Search#98 · 2 comments · 2 reactions ·
-
Difficulty 1/5 Under an hour Newbie friendliness 15/100
microsoft/Code-Search#97 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
microsoft/Code-Search#96 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 30/100
microsoft/Code-Search#95 · 1 comment ·
All issues in microsoft/Code-Search
Similar issues
-
documentation improve or update documentation priority/low triage
Difficulty 2/5 Half a day Newbie friendliness 86/100
warpdotdev/docs#782 · 1 comment ·
-
EKS 1.35 Support Openenhancement
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
gruntwork-io/kubergrunt#281 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
ehmpathy/declastruct-aws#104 ·
-
enhancement service/sns
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
hashicorp/terraform-provider-aws#50109 · 1 comment · 1 reaction ·
-
Product: Azure Policy :shield: Topic: Diagnostic Settings :test_tube: Topic: Policy :pencil:
Difficulty 1/5 1-3 hours Newbie friendliness 92/100
Azure/Azure-Landing-Zones#4283 · 1 comment ·