t-sql-scripts

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

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

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

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?”

Useful SQL scripts

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.

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

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.

Collection of SQL query solutions for LeetCode challenges.

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

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

Personal collection of SQL queries, relational database models, and data analysis projects.

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.

User Identification and Authentication with Transact-SQL

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

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

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.

Modelagem e script SQL (T-SQL) de banco de dados para gestão de pizzaria — clientes, pedidos, estoque, fidelidade e RH.

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