skills.rest
cuongtl1992
cuongtl1992COMMUNITY
Explore all skills by this author →
GitHub

sqlserver-expert

Provide T-SQL optimization, indexing, and CDC guidance for SQL Server.

10|7|Updated Jan 5, 2026
Search Tags:#performance#indexing#cdc#ef-core#sqlserver#t-sql
One-click install
npx skills add https://github.com/cuongtl1992/vibe-skills --skill sqlserver-expert
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-expert
Source: https://github.com/cuongtl1992/vibe-skills/tree/main/skills/database/sqlserver-expert
Command: npx skills add https://github.com/cuongtl1992/vibe-skills --skill sqlserver-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Tackle SQL Server performance bottlenecks and design questions by delivering expert guidance on T-SQL optimization, indexing, CDC implementation, and .NET integration patterns with EF Core or Dapper.

Core Features & Use Cases

  • Comprehensive T-SQL optimization recommendations for slow queries and deadlocks.
  • Index design, including when to add, modify, or remove indexes and how to measure impact.
  • CDC setup, data capture querying, and integration patterns with .NET apps.
  • Guidance for schema design, EF Core mappings, and Dapper data access optimizations.

Quick Start

Review a slow SQL query and return an optimized rewritten version with suggested indexes.

Frequently Asked Questions about sqlserver-expert

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

FAQPage Schema
How do I optimize slow T-SQL queries and resolve deadlocks in SQL Server?▼

To optimize slow T-SQL queries and resolve deadlocks, analyze the execution plan to identify bottlenecks. This Skill provides rewritten T-SQL statements, targeted index recommendations, and error handling patterns to improve throughput in enterprise SQL Server environments.

When should I add, modify, or remove indexes in SQL Server?▼

You should add, modify, or remove indexes based on query usage patterns and performance impact measurements. This Skill delivers expert index design strategies, helping you determine optimal indexing structures and measure their effect on SQL Server query performance.

What is the best way to set up CDC and query captured data in SQL Server?▼

Setting up CDC in SQL Server involves enabling capture on target tables and querying the change tracking functions. This Skill provides step-by-step CDC implementation recommendations and integration patterns to consume captured data effectively.

Can I use EF Core or Dapper with SQL Server for optimized data access?▼

Yes, you can use EF Core or Dapper with SQL Server for optimized data access. This Skill offers specific guidance on EF Core mappings and Dapper optimizations to ensure efficient integration and query execution within your .NET applications.

Does this SQL Server guidance apply to enterprise application schema design?▼

Yes, this SQL Server guidance applies to enterprise schema design by addressing structural bottlenecks and data integrity. It delivers validated, actionable recommendations for schema design, indexing, and query optimization tailored for enterprise-scale environments.

Related Skills

Explore More Software Engineering Skills→
Tnemo65Tnemo65

sql-pro

Analyze SQL execution plans and optimize slow queries across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
FerranGuardiaFerranGuardia

entity-framework-6

Apply EF6 Code-First patterns to manage DB schemas and data access.

Community
Advanced
bbsbotbbsbot
1

database-performance

Optimize database access patterns with CQRS, AsNoTracking, row limits, and SQL joins for EF Core and Dapper.

Community
Advanced
claudcherejiclaudchereji

sql-pro

Optimize SQL queries and database performance across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced