skills.rest
rudi-bruchez
rudi-bruchezCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqlserver-security

Audit and harden SQL Server security configurations for SQL Server 2016 and later.

Updated Feb 19, 2026
Search Tags:#security#audit#permissions#encryption#sql server#hardening
One-click install
npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-security
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlserver-security
Source: https://github.com/rudi-bruchez/dba-skills/tree/main/skills/sqlserver-security
Command: npx skills add https://github.com/rudi-bruchez/dba-skills --skill sqlserver-security

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill helps you identify and remediate critical security vulnerabilities in your SQL Server instances, protecting sensitive data and ensuring compliance.

Core Features & Use Cases

  • Security Auditing: Detects weak authentication, excessive permissions, unencrypted data, and other common security flaws.
  • Hardening Guidance: Provides specific SQL queries and remediation steps to secure your instance.
  • Use Case: Before deploying a new SQL Server to production, run this Skill to perform a comprehensive security audit and apply necessary hardening measures.

Quick Start

Run the sqlserver-security skill to audit the current SQL Server instance for security vulnerabilities.

Frequently Asked Questions about sqlserver-security

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

FAQPage Schema
How do I audit SQL Server security configurations for weak authentication and excessive permissions?▼

To audit SQL Server security, the Skill detects weak authentication, excessive permissions, unencrypted data, and common flaws, providing specific SQL queries and remediation steps to secure your instance.

How do I set up TDE encryption and SQL Server Audit for compliance requirements?▼

Setting up TDE encryption and SQL Server Audit involves configuring transparent data encryption and audit specifications; this Skill guides you through these configurations to ensure compliance for SQL Server 2016 and later.

What is the best way to harden a new SQL Server instance before production deployment?▼

The best way to harden a SQL Server instance is performing a comprehensive security audit and applying surface area reduction, login management, and permission reviews before deploying to production.

Does this SQL Server security audit support instances older than SQL Server 2016?▼

This SQL Server security audit does not support instances older than SQL Server 2016, as the configurations and hardening measures are specifically designed for SQL Server 2016 and later versions.

Can I use this Skill for incident response and investigating security vulnerabilities in SQL Server?▼

You can use this Skill for incident response in SQL Server by identifying critical security vulnerabilities, auditing login management, and reviewing permission configurations to remediate potential breaches.

What SQL Server surface area reduction steps are needed to secure my database instance?▼

SQL Server surface area reduction steps include disabling unnecessary features, reviewing login management, and applying specific remediation queries provided by the Skill to minimize your instance's attack surface.

Related Skills

Explore More Legal & Compliance Skills→
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-view-config

Retrieve Cloud SQL for PostgreSQL instance state, extensions, and configuration parameters.

Official
Intermediate
skwuwuskwuwu

gvm_audit

Verify GVM audit log integrity and export compliance reports.

Community
Intermediate
Muath2000Muath2000

network-scanner-engineer

Build and manage network scanning engines for asset discovery and vulnerability detection.

Community
Advanced
lapc506lapc506
4

Security & Compliance Automation

Automate security policy enforcement with OPA, Trivy, and CIS benchmarks.

Community
Advanced