Skip to content

Instantly share code, notes, and snippets.

@dzsquared
dzsquared / CodeAnalysisOutput.ps1
Created April 23, 2025 14:52
PowerShell script to convert SQL code analysis findings into markdown
# output markdown summary of sql code analysis errors and warnings
# parsed out of StaticCodeAnalysis xml output
param(
[Parameter(Mandatory = $true)]
[string]$inputFile
)
$markdownOutput = "# SQL Code Analysis Output`n"
@dzsquared
dzsquared / sql-dev-feedback.yml
Created April 23, 2025 14:55
Example CI pipeline that integrates database quality and pre-deployment checks
# this workflow will create the DB in a container
# and perform code analysis checks on the T-SQL code
# before getting a script for the anticipated deployment
name: SQL dev feedback
on:
workflow_dispatch:
push:
branches: [ "main" ]
pull_request: