Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting

query performance sql-server microsoft-sql-server index performance-analysis performance-monitoring t-sql ms-sqlserver extended-events perfomance-monitor t-sql-scripts performance-analysis-scripts

• Updated Nov 11, 2026
• TSQL

A simple database that people can install and use to practice writing queries with.

sql sql-server database databases t-sql ssms t-sql-exercises t-sql-scripts

• Updated Oct 17, 2024
• TSQL

y2021 - Felsineo - SQL Server Reporting Services (SSRS) reports in Felsineo Company environment

sql sql-server database integration reporting tsql t-sql ssrs reporting-services database-development system-integration ssrs-reports t-sql-scripts

• Updated Jul 17, 2025

Useful SQL scripts

sqlserver t-sql-scripts

• Updated Aug 9, 2024
• PLpgSQL

Free T-SQL scripts to migrate Microsoft Master Data Services (MDS) to SQL Server tables: tables and data, lookups and subscription views.

sql sql-server migrations migration sql-server-database sql-query sqlserver mds t-sql migration-tool master-data-services t-sql-scripts master-data-service master-data-service-sync sql-server-2025 mds-devs sql-spreads

• Updated Nov 12, 2026
• TSQL

SQL Server DBA Flight Recorder: a lightweight, pure T-SQL, open-source diagnostic script to collect safe snapshots and produce concise incident timelines, findings, and recommendations for “SQL Server was slow earlier—what happened?”

sql sql-server monitoring incident-response sql-server-database performance-tuning database-administration diagnostics dba sqlserver troubleshooting stored-procedures observability tsql t-sql stored-procedure azure-sql t-sql-scripts

• Updated Sep 8, 2026
• TSQL

Operating room scheduling analysis: 48.1k cases across 418 procedures show $15.8M to $27.1M in yearly cost exposure, with 133 procedures driving 53.6%. Microsoft Fabric, PySpark, Power BI.

power-bi pyspark sparksql dax data-modeling data-quality delta-lake data-reconciliation dataprofiling healthcare-analytics medallion-architecture microsoft-fabric t-sql-scripts

• Updated Sep 27, 2026
• HTML

Collection of SQL query solutions for LeetCode challenges.

schema sql database etl data-analysis cte conditional-statements query-optimization pivot subquery windowfunction tsql-stored-procedures unpivot t-sql-scripts joins-aggregation setoperators

• Updated May 16, 2026
• TSQL

Gestión de facturas de un supermercado que busca migrar sus ventas físicas a una base de datos

t-sql-scripts proyecto-universitario

• Updated Nov 26, 2024
• TSQL

Моя Курсовая работа по разработке модулей

xaml csharp wpf entity-framework mssql t-sql mssql-database wpf-application t-sql-scripts

• Updated Jun 8, 2025
• C#

Scripts de estudo de SQL Server (T-SQL) — da criação básica de banco de dados até modelagem relacional com notas fiscais e itens vendidos. Material do curso técnico no SENAC-SP.

sql sql-server sql-server-database sql-query sqlserver banco-de-dados t-sql sql-server-management-studio estudos banco-de-dados-relacional relacionamentos senac-sp relacionamento banco-de-dados-relacionais t-sql-exercises t-sql-scripts modelagem-relacional relacionamiento

• Updated Oct 29, 2026

User Identification and Authentication with Transact-SQL

sql-server authentication t-sql-scripts

• Updated Oct 24, 2024
• TSQL

Heap forwarded record mitigation for SQL Server. Finds heaps with forwarded records, ranks by CPU impact via Query Store, rebuilds online where possible.

performance sql-server ms-sql-server microsoft-sql-server performance-analysis t-sql stored-procedure database-maintenance t-sql-scripts dba-tools index-maintenance heap-table forwarded-records

• Updated Aug 2, 2026
• TSQL

From Tables and SELECT queries to advanced SQL.

views sql sql-server mssql t-sql indexes-in-db t-sql-exercises t-sql-scripts

• Updated Dec 20, 2024
• TSQL

repositorio del trabajo práctico integrador "gestión de viajes" de la cursada de base de datos de utn frba

data sql database big-data dataset business-intelligence data-analytics t-sql business-analytics t-sql-scripts

• Updated Oct 20, 2026
• TSQL

python-script pandas data-analysis azure-sql-database t-sql-scripts

• Updated Jul 30, 2025
• Python

Sistema de gerenciamento de biblioteca em Java Swing com persistência em SQL Server. Cadastro de clientes e livros, controle de empréstimos e devoluções via stored procedures, com validações e triggers no banco.

java crud sql-server netbeans swing jdbc sql-server-database desktop-application jdbc-driver java-swing netbeans-ide t-sql swing-gui t-sql-scripts

• Updated Oct 29, 2026
• Java

End-to-end SQL Server (T-SQL) project on the Olist e-commerce dataset: raw staging layer, typed core schema, validation, data cleaning, foreign key constraints, and analytical business queries.

portfolio sql sql-server database databases database-migrations business-intelligence database-management sqlserver database-schema t-sql database-design portfolio-project business-analytics business-analysis t-sql-exercises t-sql-scripts

• Updated Nov 11, 2026
• TSQL

📚 The Ultimate SQL Server Book — 51 pages of deep database education in Persian & English. Dark/light themes, keyboard navigation, single-file, zero dependencies.

education sql sql-server database sql-server-database microsoft-sql-server t-sql ssms sql-server-management-studio online-booking query-tuning t-sql-scripts microsoft-sql-server-management-studio

• Updated Sep 13, 2026
• HTML

SQL Server database project for a School Management System, including table design, test data, queries, and class-teacher-subject reports.

sql sql-server database databases database-management relational-databases relational-database t-sql ssms database-design school-management-system relational-database-design t-sql-scripts

• Updated Oct 9, 2026
• TSQL