chrishuffman5/analytics-ssrs-2019
skills/analytics/ssrs/2019/SKILL.md
Version-specific expert for SSRS 2019 (SQL Server 2019). Covers Azure AD Application Proxy integration, accessibility improvements, and support lifecycle. WHEN: "SSRS 2019", "SQL Server 2019 Reporting Services", "SSRS Azure AD".
$ install --global
skillsauthnpx skillsauth add chrishuffman5/domain-expert analytics-ssrs-2019Install this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 26, 2026, 4:31 AM28.1s1 file scanned
SKILL.md
- name:
- analytics-ssrs-2019
- description:
- Version-specific expert for SSRS 2019 (SQL Server 2019). Covers Azure AD Application Proxy integration, accessibility improvements, and support lifecycle. WHEN: \"SSRS 2019\", \"SQL Server 2019 Reporting Services\", \"SSRS Azure AD\".
- license:
- MIT
- version:
- 1.0.0
- author:
- christopher huffman
SSRS 2019 Version Expert
You are a specialist in SQL Server Reporting Services 2019. This was a maintenance-focused release with incremental improvements over SSRS 2017.
For foundational SSRS knowledge (RDL, architecture, data sources, rendering, subscriptions), refer to the parent technology agent. This agent focuses on what is new or changed in 2019.
Key Features
Azure AD Application Proxy Integration
SSRS does not natively authenticate against Azure AD / Entra ID. However, Azure AD Application Proxy can be configured to provide Azure AD-based access to SSRS 2016+:
- Publishes the SSRS web portal through Azure AD Application Proxy
- Enables single sign-on (SSO) via Azure AD without direct SSRS integration
- Supports Conditional Access policies and multi-factor authentication
- Kerberos Constrained Delegation (KCD) required between the proxy connector and SSRS
This is a workaround, not a native integration. SSRS itself still uses Windows Authentication internally.
Accessibility Improvements
- Enhanced screen reader support across the web portal
- Tooltips on report elements recognized by assistive technology
- Improved keyboard navigation in the portal interface
SQL Server 2019 Engine Compatibility
- Full compatibility with SQL Server 2019 database engine as a data source
- ReportServer catalog database can be hosted on SQL Server 2019
- Leverages SQL Server 2019 query processing improvements when used as a data source
Limitations
- No major architectural changes from SSRS 2017
- No native Azure AD / Entra ID authentication
- Mobile reports still present but deprecated (removed in 2022)
- SharePoint integrated mode already deprecated (since SQL Server 2016)
Migration Notes
Upgrading from SSRS 2017
- In-place upgrade supported
- No breaking changes from 2017 to 2019
- Back up encryption key and ReportServer database before upgrade
- Verify custom extensions compile against 2019 assemblies
Upgrading to SSRS 2022
- Mobile reports must be migrated before upgrade (removed in 2022)
- Comments on reports will be disabled by default after upgrade
- Pin to Power BI feature will be removed
- See
../2022/SKILL.mdfor full 2022 delta
Support Lifecycle
- Mainstream support ended: October 2024
- Extended support ends: January 2030
Related Skills
chrishuffman5/kubectl
tools
VerifiedTrustedCommunity
kubectl command-line usage and scripting: kubeconfig and context management, output formats (jsonpath, custom-columns, go-template), all major verbs (get, describe, apply, delete, exec, logs, port-forward, rollout, scale, drain), workload resources, config/storage, networking, RBAC, node management, debugging (CrashLoopBackOff, ImagePullBackOff, OOMKilled), and scripting patterns (dry-run, diff, wait, jq, kustomize). WHEN: "kubectl", "k8s CLI", "kubeconfig", "namespace", "pod", "deployment", "service", "ingress", "configmap", "secret", "rollout", "scale", "drain", "taint", "kustomize". Do NOT use for cluster architecture, sizing, upgrades, or workload design decisions — that's the `kubernetes` skill in the `containers` plugin. This skill is command syntax and scripting kubectl against an existing cluster, not cluster ops.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/bash
tools
VerifiedTrustedCommunity
Bash 5.x shell scripting, Unix text processing, and command-line automation: variables, parameter expansion, quoting, control flow, functions, I/O redirection, error handling (set -euo pipefail, trap), and the Unix tool ecosystem (grep, sed, awk, jq, find, sort, uniq, cut, xargs). Covers process management, networking (curl, ssh, rsync, nc), file locking (flock), parallel execution, and production script patterns. WHEN: "Bash", "bash", "shell", "sh", ".sh", "shell script", "sed", "awk", "grep", "jq", "find", "xargs", "curl", "ssh", "rsync", "cron", "pipe", "redirect", "here-doc", "shebang", "POSIX", "set -euo pipefail", "trap".
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/azure-cli
tools
VerifiedTrustedCommunity
Azure CLI (az) command syntax and scripting: authentication (interactive, service principal, managed identity, SSO), output formats and JMESPath queries, resource groups, VMs, storage accounts/blobs, networking (VNets, NSGs, load balancers, DNS), Entra ID, AKS, App Service, Functions, databases (SQL, Cosmos DB, MySQL, PostgreSQL), Key Vault, Monitor/alerting, and infrastructure scripting patterns. WHEN: "az ", "Azure CLI", "az login", "az vm", "az aks", "az storage", "az keyvault", "az monitor", "az ad", "az group", "az network", "az webapp", "az functionapp", "az sql", "az cosmosdb", "JMESPath", "az account". Do NOT use for Azure architecture, landing zones, or multi-subscription strategy — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/aws-cli
tools
VerifiedTrustedCommunity
AWS CLI v2 command syntax and scripting: authentication (profiles, SSO, assume-role, instance profiles), output formats and JMESPath queries, pagination and waiters, IAM, S3, Lambda, RDS, CloudFormation, ECS, EKS, CloudWatch, SSM, Route 53, STS, and VPC networking. WHEN: "aws ", "AWS CLI", "aws ec2", "aws s3", "aws lambda", "aws iam", "aws cloudformation", "aws ssm", "aws ecs", "aws eks", "aws rds", "aws cloudwatch", "aws route53", "aws sts". Do NOT use for AWS architecture, service selection, multi-account strategy, or FinOps — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026