搜索技能.../

Database Sqlserver | Skills Pool

技能档案

Database Sqlserver

Configure and optimize SQL Server for .NET applications. Covers connection management, indexing strategies, query optimization, security hardening, and monitoring. Use when: setting up SQL Server or Azure SQL, designing schemas, optimizing query performance, configuring Always Encrypted, or troubleshooting SQL Server issues.

congiuluc0 星标2026年3月28日

职业
分类: SQL 数据库

技能内容

SQL Server Database Skill

When to Use

Setting up SQL Server or Azure SQL Database for production
Configuring connection strings, pooling, and resilience
Designing schemas with proper data types, constraints, and indexes
Optimizing query performance with execution plans
Implementing security features (TDE, Always Encrypted, row-level security)
Running EF Core or Dapper against SQL Server
Monitoring and diagnosing performance issues

Official Documentation

SQL Server Documentation
Azure SQL Database

相关技能

快速安装

Database Sqlserver

npx skills add congiuluc/my-awesome-copilot

下载 Skill 打开源码仓库

作者: congiuluc
星标: 0
更新时间: 2026年3月28日
职业

本页内容

01SQL Server Database Skill

EF Core SQL Server Provider

SQL Server Indexing

Query Performance Tuning

SQL Server Security

Procedure

Configure connection and resilience — see connection setup
Design schema with proper types — see schema design
Add indexes and optimize queries — see performance tuning
Apply security hardening — see security
Review complete sample

Key Principles

Use NVARCHAR for Unicode text, VARCHAR for ASCII-only
Use DATETIMEOFFSET for timestamps — stores timezone offset
Always use parameterized queries — SQL injection is the #1 vulnerability
Design indexes around your query patterns, not your table structure
Use INCLUDE columns in indexes to create covering indexes
Configure connection resilience with EnableRetryOnFailure() for Azure SQL
Monitor with Query Store (enabled by default in Azure SQL)
Use READ COMMITTED SNAPSHOT isolation to reduce blocking

02

When to Use

03Official Documentation

05Key Principles

数据库架构师

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

数据库架构师