# Coverage demoted 2026-10-07 (roadmap#942, PLAN.md Stage A): this file was written by an API Evangelist
# sweep and names no billing unit, meters or pricing category read from the provider — it restates the
# FinOps framework. It is `x-coverage: unmeasured`, and the FOCUS alignment it claimed has been removed.
x-coverage: unmeasured
specification: FinOps Framework
specificationVersion: '1.0'
provider: Microsoft SQL Server
providerId: microsoft-sql-server
publisherName: Microsoft SQL Server
serviceCategory: API
created: '2026-05-04'
# Provenance stamped 2026-08-11: this artifact was written by the API Evangelist
# bulk sweep dated 2026-05-04, not harvested from the provider. See roadmap#35.
method: generated
modified: '2026-05-04'
tags:
  - Cloud
  - Data Management
  - Database
  - Enterprise
  - Relational Database
  - SQL
  - FinOps
  - Cost Management
  - FOCUS
description: FinOps framework definition for the Microsoft SQL Server API surface. Provides a FOCUS-aligned
  mapping for cost allocation, usage measurement, and unit-economics reporting across the provider's APIs.
principles:
  - name: Visibility
    description: Make API consumption costs visible to engineering, product, and finance teams in near
      real-time.
  - name: Allocation
    description: Tag every chargeable API call with the consuming team, environment, application, and
      feature so cost can be allocated.
  - name: Optimization
    description: Continuously evaluate request patterns, caching, batching, and tier selection to reduce
      cost per useful unit of work.
  - name: Accountability
    description: Establish budget owners and chargeback or showback flows for each consuming team.
domains:
  - name: Understand Usage and Cost
    capabilities:
      - Data Ingestion
      - Allocation
      - Reporting and Analytics
      - Anomaly Management
  - name: Quantify Business Value
    capabilities:
      - Planning and Estimating
      - Forecasting
      - Budgeting
      - Benchmarking
      - Unit Economics
  - name: Optimize Usage and Cost
    capabilities:
      - Architecting for Cloud
      - Rate Optimization
      - Workload Optimization
      - Cloud Sustainability
      - Licensing and SaaS
  - name: Manage the FinOps Practice
    capabilities:
      - FinOps Practice Operations
      - FinOps Education and Enablement
      - Invoicing and Chargeback
      - Onboarding Workloads
      - Intersecting Disciplines
billingModel:
  pricingCategory: Usage-Based
  billingFrequency: Monthly
  billingCurrency: USD
  chargeCategories:
    - Usage
    - Purchase
    - Tax
    - Credit
    - Adjustment
  chargeFrequency: Recurring
focusColumns:
  ServiceName: Microsoft SQL Server
  ServiceCategory: Developer Tools / API
  ProviderName: Microsoft SQL Server
  PublisherName: Microsoft SQL Server
  InvoiceIssuerName: Microsoft SQL Server
  PricingCategory: Usage-Based
  PricingUnit: request
  BillingCurrency: USD
  ChargeCategory: Usage
meters:
  - name: api_requests
    description: Count of billable API requests
    unit: request
    aggregation: sum
    dimensions:
      - api
      - endpoint
      - tier
      - region
      - consumer
  - name: data_egress
    description: Bytes returned over the network in API responses
    unit: GB
    aggregation: sum
    dimensions:
      - api
      - region
      - consumer
  - name: compute_seconds
    description: Server-side compute consumed by the request, where applicable
    unit: second
    aggregation: sum
    dimensions:
      - api
      - endpoint
      - tier
apis:
  - name: SQL Server Database Engine API
    baseURL: https://your-server.database.windows.net
    tags:
      - Database
      - Query
      - Transact-SQL
    serviceName: SQL Server Database Engine API
    serviceCategory: API
  - name: SQL Server Management Objects (SMO) API
    baseURL: https://api.example.com/smo
    tags:
      - .NET
      - Administration
      - Management
    serviceName: SQL Server Management Objects (SMO) API
    serviceCategory: API
  - name: Azure SQL Database REST API
    baseURL: https://management.azure.com
    tags:
      - Azure
      - Cloud
      - Database Management
      - REST API
    serviceName: Azure SQL Database REST API
    serviceCategory: API
  - name: SQL Server Reporting Services (SSRS) API
    baseURL: https://your-server/reports/api/v2.0
    tags:
      - Business Intelligence
      - Reporting
      - REST API
    serviceName: SQL Server Reporting Services (SSRS) API
    serviceCategory: API
  - name: SQL Server Integration Services (SSIS) Catalog API
    baseURL: https://your-server/SSISDB
    tags:
      - Data Pipeline
      - ETL
      - Integration
    serviceName: SQL Server Integration Services (SSIS) Catalog API
    serviceCategory: API
  - name: Azure SQL Managed Instance REST API
    baseURL: https://management.azure.com
    tags:
      - Azure
      - Cloud
      - Database Management
      - Managed Instance
      - REST API
    serviceName: Azure SQL Managed Instance REST API
    serviceCategory: API
  - name: Data API Builder
    baseURL: https://localhost:5000/api
    tags:
      - CRUD
      - Data Access
      - GraphQL
      - Open Source
      - REST API
    serviceName: Data API Builder
    serviceCategory: API
  - name: Azure Analysis Services REST API
    baseURL: https://management.azure.com
    tags:
      - Analysis Services
      - Azure
      - Business Intelligence
      - REST API
      - Tabular Models
    serviceName: Azure Analysis Services REST API
    serviceCategory: API
  - name: Microsoft SqlClient Data Provider (ADO.NET)
    baseURL: ''
    tags:
      - .NET
      - ADO.NET
      - Data Provider
      - SqlClient
    serviceName: Microsoft SqlClient Data Provider (ADO.NET)
    serviceCategory: API
  - name: Microsoft JDBC Driver for SQL Server
    baseURL: ''
    tags:
      - Cross-Platform
      - Driver
      - Java
      - JDBC
    serviceName: Microsoft JDBC Driver for SQL Server
    serviceCategory: API
  - name: Microsoft ODBC Driver for SQL Server
    baseURL: ''
    tags:
      - Cross-Platform
      - Driver
      - Native Code
      - ODBC
    serviceName: Microsoft ODBC Driver for SQL Server
    serviceCategory: API
  - name: Microsoft OLE DB Driver for SQL Server
    baseURL: ''
    tags:
      - COM
      - Driver
      - OLE DB
      - Windows
    serviceName: Microsoft OLE DB Driver for SQL Server
    serviceCategory: API
  - name: Microsoft Python Driver for SQL Server (mssql-python)
    baseURL: ''
    tags:
      - Cross-Platform
      - DB-API
      - Driver
      - Python
    serviceName: Microsoft Python Driver for SQL Server (mssql-python)
    serviceCategory: API
  - name: Node.js Driver for SQL Server (tedious)
    baseURL: ''
    tags:
      - Cross-Platform
      - Driver
      - JavaScript
      - Node.js
      - TDS
    serviceName: Node.js Driver for SQL Server (tedious)
    serviceCategory: API
unitEconomics:
  - name: Cost per 1K Requests
    metric: billed_cost / (api_requests / 1000)
  - name: Cost per Active Consumer
    metric: billed_cost / active_consumers
maintainers:
  - FN: Kin Lane
    email: kin@apievangelist.com
    url: https://apievangelist.com