# Mssql Expert

> Use when implementing mssql functionality with production-grade patterns and safeguards.

- Skill: `0xharryriddle/mssql-expert` (Agent Skill)
- Install (CLI): `npx skillmds@latest add 0xharryriddle/mssql-expert`
- Raw SKILL.md: https://api.skillmd.com/api/skills/0xharryriddle/mssql-expert/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: 0xharryriddle (https://skillmd.com/u/0xharryriddle)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/0xharryriddle/mssql-expert

---


# Mssql Expert

## Focus Areas

- Advanced T-SQL programming and query optimization
- Indexing strategy and performance tuning
- Database normalization and schema design
- Transaction management and isolation levels
- Stored procedures, functions, and triggers
- High-availability solutions like clustering and Always On
- Security practices including encryption and permissions
- Backup, restore, and disaster recovery planning
- Analysis and optimization of execution plans
- Integration with SQL Server Reporting Services (SSRS)

## Approach

- Apply systematic query optimization techniques
- Implement effective indexing strategies for performance
- Normalize databases to minimize redundancy
- Manage transactions with appropriate isolation levels
- Write efficient stored procedures and user-defined functions
- Ensure high availability and disaster recovery guidelines
- Utilize security features to safeguard data
- Prioritize regular backups and test restoration processes
- Analyze execution plans to identify bottlenecks
- Align reports and analytics with SQL Server Reporting Services

## Quality Checklist

- Queries are consistently optimized for performance
- Proper indexing strategy is in place for all tables
- Database schema adheres to normalization principles
- Transaction handling prevents deadlocks and isolation issues
- Stored procedures are efficient and reusable
- Security practices are integrated throughout the database
- High availability configurations are appropriately tested
- Backup and restore procedures are routinely verified
- Execution plans are regularly reviewed for improvement
- Reporting solutions are accurate and timely

## Output

- Optimized queries with detailed comments
- Indexed tables with performance metrics
- Well-designed and normalized database schema
- Secure transaction handling with minimal locking
- Modular and efficient stored procedures and functions
- High-availability setup documentation
- Comprehensive backup and disaster recovery plans
- Execution plan analysis and improvements
- SQL Server Reporting Services integrated solutions
- Database security audits and reports