skills.rest
MassimilianoPili
MassimilianoPiliCOMMUNITY
Explore all skills by this author →
GitHub

dba-mssql

Design and administer SQL Server 2022+ databases with T-SQL and performance tuning.

Updated Mar 7, 2026
Search Tags:#schema design#performance tuning#dba#sql server#database administration#t-sql#columnstore
One-click install
npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-mssql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-mssql
Source: https://github.com/MassimilianoPili/agent-framework/tree/main/.claude/agents/dba-mssql
Command: npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-mssql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the design, development, and administration of SQL Server 2022+ databases, ensuring efficient, secure, and performant data management.

Core Features & Use Cases

  • T-SQL Development: Write stored procedures, functions, and optimize queries.
  • Schema Design: Implement best practices for indexing, partitioning, and temporal tables.
  • Performance Tuning: Analyze execution plans and leverage DMVs for optimization.
  • Administration: Configure Always On availability groups and security features like TDE.
  • Use Case: Develop a new temporal audit table for tracking changes to sensitive customer data, ensuring compliance and enabling point-in-time analysis.

Quick Start

Use the dba-mssql skill to create a new temporal audit table named 'audit_log' with a clustered columnstore index.

Frequently Asked Questions about dba-mssql

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

FAQPage Schema
How do I design a temporal table in SQL Server 2022 to track sensitive data changes?▼

To design a temporal table in SQL Server 2022, you configure system-versioning with a history table to track sensitive data changes. This ensures compliance by maintaining historical records and enabling point-in-time data analysis.

What is the best way to optimize T-SQL query performance using columnstore indexes?▼

The best way to optimize T-SQL query performance using columnstore indexes is by leveraging clustered columnstore indexes for large data warehousing workloads. This method compresses data and enables fast analytical querying.

How do I configure Always On availability groups for SQL Server database administration?▼

To configure Always On availability groups for SQL Server database administration, you set up failover clustering and define availability replicas. This ensures high availability and disaster recovery for your critical databases.

Does SQL Server 2022 support transparent data encryption for database security?▼

Yes, SQL Server 2022 supports transparent data encryption (TDE) for database security. TDE encrypts the data files at rest, protecting sensitive information without requiring changes to the application layer.

When should I use partitioning and columnstore indexes for schema optimization?▼

You should use partitioning and columnstore indexes for schema optimization when managing large analytical workloads. Partitioning improves manageability, while columnstore indexes deliver high compression and query performance for big data sets.

Related Skills

Explore More Software Engineering Skills→
flatrickflatrick
1

sqlserver-patterns

Provides T-SQL and SQL Server best practices for queries, indexing, and stored procedures.

Community
Intermediate
chrishuffman5chrishuffman5

sqlserver-engineering

Analyze SQL Server execution plans and optimize indexes for query performance.

Community
Advanced
DevelopersGlobalDevelopersGlobal
65

ci-cd-pipelines

Automate CI/CD pipelines with quality gates and deployment processes.

Official
Advanced
RightNow-AIRightNow-AI
18.1k

postgres-expert

Analyze PostgreSQL query plans and recommend indexing strategies.

Official
Advanced