Ferramentas e Scripts úteis para DBAs e Dev SQL

Tools for management of SQL Server's Query Store data

Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier

SqlDeep is a collection of Microsoft SQL Server database administration scripts originally developed by SqlDeep team.

Compilation of Scripts (mostly SQL ones) used to administer SQL Server

SQL Scripts and Command for DBA and Developer

SQL I commonly reference

SQL Server management scripts for DBA's / DBRE's !

Battle-tested SQL Server performance diagnostic toolkit for developers and DBAs. Quickly detect blocking, missing indexes and slow queries.

I share my favorite database scripts here

Das Projekt realisiert in T-SQL-Code (und nicht nur) das Verfahrensframework "MSSQL*Maintenance" für Unterstützung von "Database Administration Lifecycle".

This repository provides access to various SQL commands for querying databases and database administration. The scripts are available in SQL file format and can be easily copied for use anywhere.

Read-only T-SQL script that captures a performance and schema snapshot of a SQL Server database and exports an LLM-friendly Markdown tuning report.

DB에 대한 운영, 관리, 모니터링, 백업 정책 수립, 쿼리 튜닝, 성능 개선

Collection of SQL Server automation scripts for backup, monitoring, and maintenance tasks

SQL Server script to display the current status of database files, including auto growth configuration, growth type (percent or KB), maximum size, and physical file location.

Projeto de modelagem e otimização de consultas no SQL Server, utilizando brModelo e técnicas de tuning com índices clusterizados e não clusterizados. Inclui análise de planos de execução e comparação de desempenho entre consultas otimizadas e não otimizadas.

Simulating virtualization best practices for managing on-prem Dev, Staging, and Prod database environments.

This SQL script provides a complete overview of collation settings for all text-based columns (char, varchar, nchar, nvarchar, etc.) across user tables in a database.