query-tuning

Free, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review.

Java 17, Spring Boot 3, Oracle DB

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.

PostgreSQL query optimization playground: schema, slow queries, EXPLAIN ANALYZE and fixes. Demo project.

Information Security Analyst

PostgreSQL schema-design and query-tuning lab on an auto-repair-shop schema: every optimization measured before and after with EXPLAIN (ANALYZE, BUFFERS) on ~2M rows.

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

Code that I used to test my Final Year Project

Advanced SQL analytics lab: CTEs, window functions, and measured query tuning on real PostgreSQL and SQL Server. 7 query patterns + 8 T-SQL queries, with EXPLAIN before/after and data-quality checks.

10 T-SQL query-tuning cases measured on real SQL Server data (Morrisons products + Udacity A/B). Slow/tuned pairs with SHOWPLAN before/after.

This 2-day course builds on the SQL Server 2025 query analysis skills taught in 65317A and focuses on real-world troubleshooting techniques.

Optimization of weekly SQL queries for department-level reporting. Reduced execution time and eliminated dependency on multiple servers by centralizing query logic. Implemented parameterized T-SQL scripts and temporary tables to enhance performance and simplify maintenance.

AI pair-DBA for SSMS 22 — keyless (your own Claude / ChatGPT / Codex). Proves a change's blast radius, cites live incidents, proves AI rewrites. A Copilot-in-SSMS alternative.