skills.rest
congiuluc
congiulucCOMMUNITY
Explore all skills by this author →
𝕏@congiulucGitHub

database-sqlserver

Configure SQL Server and Azure SQL for .NET applications with EF Core and Dapper.

Updated Mar 28, 2026
Search Tags:#performance#indexing#health-check#dapper#sql-server#ef-core#sql-server-security
One-click install
npx skills add https://github.com/congiuluc/my-awesome-copilot --skill database-sqlserver
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-sqlserver
Source: https://github.com/congiuluc/my-awesome-copilot/tree/main/skills/database-sqlserver
Command: npx skills add https://github.com/congiuluc/my-awesome-copilot --skill database-sqlserver

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

SQL Server configuration and optimization for .NET applications, covering connection management, indexing strategies, query optimization, security hardening, and monitoring to reduce latency and improve reliability.

Core Features & Use Cases

  • Configure resilient EF Core / Dapper integration with SQL Server and Azure SQL.
  • Design schemas with recommended data types and indexing practices; implement security features like TDE, Always Encrypted, and row-level security.
  • Use health checks and monitoring to guarantee readiness in production environments.

Quick Start

Install the SQL Server EF Core provider, configure a resilient connection string, and enable a health check to verify readiness.

Frequently Asked Questions about database-sqlserver

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

FAQPage Schema
How do I configure resilient EF Core connections to SQL Server for .NET apps?▼

Configure resilient EF Core connections by installing the SQL Server provider, setting a resilient connection string, and applying connection retry logic. This reduces latency and improves reliability for .NET applications connecting to SQL Server or Azure SQL.

What's the best way to design SQL Server schemas and indexing for .NET applications?▼

Design SQL Server schemas by selecting recommended data types and applying indexing patterns to optimize query performance. Proper indexing strategies reduce latency and improve overall database reliability for .NET services.

Can I use Dapper alongside EF Core with SQL Server in the same .NET service?▼

Yes, Dapper works alongside EF Core with SQL Server in .NET services. The Skill provides guidance on integrating both ORMs to optimize connection management and query performance for your application.

How do I implement health checks and monitoring for SQL Server in production .NET apps?▼

Implement SQL Server health checks by enabling readiness verification within your production .NET services. This monitoring guarantees database availability and improves overall system reliability.

Does this SQL Server optimization approach work with both on-premises SQL Server and Azure SQL?▼

Yes, the optimization approach applies to both on-premises SQL Server and Azure SQL. It covers connection management, security hardening, and monitoring for .NET applications across both deployment environments.

Related Skills

Explore More Software Engineering Skills→
kevintsengtwkevintsengtw
28

dotnet-testing-advanced-testcontainers-database

Provision and tear down containerized SQL Server and PostgreSQL instances for .NET integration tests.

Community
Advanced
sfc-gh-dflipposfc-gh-dflippo
34

dbt Projects on Snowflake

Deploy and manage dbt projects on Snowflake with monitoring.

Community
Intermediate
AGIBuildAGIBuild
10

dotnet-observability

Integrate OpenTelemetry tracing, metrics, and structured logging into .NET applications.

Community
Advanced
shalevaminshalevamin

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Community
Advanced