microsoft / microsoft/finops-toolkit
[Power BI] Create a SQL Azure Hybrid Benefit page in the Cost summary report
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 603
- Forks
- 248
- Avg merge
- 7d 11h
- Merged PRs (30d)
- 11
Description
📝 Scenario
As a SQL admin, I need to review my AHB usage in order to determine if I'm maximizing my existing licenses
💎 Solution
Create a new Azure Hybrid Benefit report for SQL Server licenses.
ℹ️ Additional context
The main issue here is that SQL and Windows usage data is inconsistent. Consider creating a proposal for the SQL and/or VM teams to emit usage in a consistent manner. Another possible workaround is to manipulate data in Data factory, but this is less ideal.
Contributor guide
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.
Research direction
Start with the Cost summary report and review how SQL and Windows usage data is currently represented. Clarify the SQL Server license and Azure Hybrid Benefit data with the SQL and VM teams before choosing between consistent usage emission and a Data Factory workaround. Done means a defined, validated SQL Server AHB report proposal.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- analytics, cloud, data-visualization, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100