skills.rest
donellmccoy
donellmccoyCOMMUNITY
Explore all skills by this author →
𝕏@donellmccoyGitHub

sql-server-dba-dev-expert

Optimize SQL Server queries and stored procedures in the AF.ECT.Database schema.

Updated Aug 23, 2026
Search Tags:#indexing#performance-tuning#data-integrity#sql-server#database-design#backup-recovery#stored-procedures
One-click install
npx skills add https://github.com/donellmccoy/ECTSystem --skill sql-server-dba-dev-expert
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-server-dba-dev-expert
Source: https://github.com/donellmccoy/ECTSystem/tree/main/.github/skills/sql-server-dba-dev-expert
Command: npx skills add https://github.com/donellmccoy/ECTSystem --skill sql-server-dba-dev-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides the combined expertise required to design, implement, optimize, and troubleshoot the AF.ECT.Database schemas, queries, and stored procedures, ensuring performance, data integrity, security, and reliable operations.

Core Features & Use Cases

  • Performance tuning: Optimize high-volume queries and stored procedures used by the AF.ECT.Database, such as form348_sp_* and related search routines.
  • Schema and security design: Apply best practices for schema organization (dbo, usp, DBSign), access control, and auditing.
  • Backup, recovery, and compliance: Establish robust backup strategies, disaster recovery plans, and data protection measures for military-grade operations.
  • Use Case: When a case search is slow or a workflow transition fails, this skill guides diagnosis, remediation, and validation.

Quick Start

Start by auditing the performance of key search SPs (e.g., form348_sp_FullSearch) and reviewing core_user_sp and core_workflow_sp implementations against recommended patterns.

Frequently Asked Questions about sql-server-dba-dev-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL Server stored procedures during a case search?▼

Optimizing slow SQL Server stored procedures involves auditing search routines like form348_sp_FullSearch against recommended patterns and applying indexing strategies to improve high-volume query performance.

What's the best way to structure SQL Server schemas for data integrity and security?▼

The best way to structure SQL Server schemas for data integrity is to apply best practices for schema organization across dbo, usp, and DBSign, ensuring proper access control and auditing for user and permission domains.

How do you troubleshoot a failed workflow transition in a SQL Server database?▼

Troubleshooting a failed workflow transition in a SQL Server database requires reviewing core_workflow_sp implementations, diagnosing execution failures, and validating remediation against Microsoft SQL Server best practices.

Can I use this approach for military-grade SQL Server backup and recovery planning?▼

Yes, this approach supports military-grade SQL Server backup and recovery planning by establishing robust disaster recovery strategies, data protection measures, and compliance governance for the AF.ECT.Database.

Why does my high-volume SQL Server query performance degrade over time?▼

High-volume SQL Server query performance degrades when indexing strategies and stored procedure designs are not tuned to handle increasing data loads, requiring performance auditing against established database design patterns.

Related Skills

Explore More Software Engineering Skills→
Srujan0798Srujan0798

performance

Benchmark system performance by measuring core metrics against established baselines.

Community
Advanced
Hack23Hack23
235

postgresql-operations

Orchestrate PostgreSQL migrations, tuning, backups, and monitoring with Liquibase.

Official
Advanced
manuelbrandner85manuelbrandner85

supabase

Manage Supabase project lifecycle, schema migrations, and security policies.

Community
Advanced
fuziix266fuziix266

sql-pro

Optimize SQL queries and design database schemas across PostgreSQL, MySQL, and SQL Server.

Community
Advanced