sp_whoisactive

Contains all the 117 Leetcode questions with their solutions ranging from Easy to Hard in MySQL.

Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.

Kangaroo is a AI-powered SQL client and admin tool for popular databases(MariaDB / MySQL / Oracle / PostgreSQL / Redis / SQLite / SQLServer / ...) on Windows / MacOS / Linux, support table design, query, model, sync, export/import etc, focus on comfortable, fun and developer friendly.

The most comprehensive SQL guide from a real-world expert! Learn everything from basics to advanced queries, optimizations, and real-world SQL

A comprehensive guide to building a modern data warehouse with SQL Server, including ETL processes, data modeling, and analytics.

Инструменты обслуживания и разработки для Microsoft SQL Server, а также другие интересности

Logo Tiger Enterprise Özel Raporlar, Tablo ve View Açıklamaları, Logo Bordro

Database Project with generic procedures to consume API through GET/POST methods.

A zero ceremony ORM for Java

collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence

Repository for lab exercises and instructions for Microsoft DP-300 learning content

a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files.

DATABASE dei COMUNI ITALIANI 2018 PROVINCE, REGIONI, COMUNI CON CAP e COORDINATE GEOGRAFICHE

🐸 Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

I chose 'AdventureWorksLT2019.bak' and 'AdventureWorksLT2017.bak' data for analysis & visualization. The query editing was done in 'Microsoft SQL Server Management Studio' and the visualization part was using 'Microsoft Power BI'. Also for analysis, I used MS Excel and PowerBI's query tool.

✍️ Udacity SQL for Data Analysis Course Solutions and Notes along with Parch and Posey DB

Idiomatic data access for F#