GitHub topics: t-sql

erikdarlingdata/DarlingData

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

Language: TSQL - Size: 7.33 MB - Last synced at: about 17 hours ago - Pushed at: about 17 hours ago - Stars: 540 - Forks: 155

5ldv/Clinic-Management-System

🏪 Clinic Management System – A desktop app for efficiently managing patients, doctors, appointments, and more. Built with C#, .NET 9, and WinForms.

Language: C# - Size: 26.6 MB - Last synced at: 2 days ago - Pushed at: 2 days ago - Stars: 1 - Forks: 0

abdelwahab-ahmed-shandy/My-Study-Archive

This repository serves as a personal archive of my study materials, notes, and resources across various topics. It includes content from courses, books, research, and personal learning experiences.

Language: C# - Size: 295 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

kkyungseo/SQL_Practice_2025

SQL Study for DBMS (APR, 2025)

Size: 0 Bytes - Last synced at: 1 day ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

Archive-of-practical-work-for-the-MPT/Homework-ASP 📦

Репозиторий с практическими работами по разработке программных модулей на ASP.NET.

Language: C# - Size: 12.2 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

CrisCorreaS/apuntes-sql

Apuntes y ejercicios resueltos de SQL en PostgreSQL, SQL Server y phpMyAdmin

Size: 56.5 MB - Last synced at: 4 days ago - Pushed at: 5 days ago - Stars: 5 - Forks: 0

Thallerich/SQL

Collection of SQL Scripts

Language: TSQL - Size: 19.9 MB - Last synced at: 4 days ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

microsoft/openCypherTranspiler 📦

This tool transpiles openCypher graph query language to a relational database query language. This project publishes a T-SQL for Microsoft SQL Server as the target query language.

Language: C# - Size: 385 KB - Last synced at: 2 days ago - Pushed at: over 2 years ago - Stars: 85 - Forks: 19

MiKL5/TSQL

Language: TSQL - Size: 84 KB - Last synced at: 7 days ago - Pushed at: 8 days ago - Stars: 0 - Forks: 0

kisinamso/SQLServerMaintenanceBoxGuideline

SQL Server Maintenance Box Repository Guideline

Size: 68.4 KB - Last synced at: 9 days ago - Pushed at: 9 days ago - Stars: 1 - Forks: 0

18520339/database-lab

Thực hành Cơ sở dữ liệu UIT

Language: TSQL - Size: 3.38 MB - Last synced at: 1 day ago - Pushed at: over 4 years ago - Stars: 10 - Forks: 2

koshovyi/SqlBuilder

Simple SQL query builder for .NET

Language: C# - Size: 141 KB - Last synced at: 6 days ago - Pushed at: almost 5 years ago - Stars: 27 - Forks: 6

MadeiraData/microsoft-dbas-club

Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators

Language: TSQL - Size: 34.6 MB - Last synced at: 12 days ago - Pushed at: 12 days ago - Stars: 23 - Forks: 11

jd0x0021/Paraject

A project management desktop application that keeps track of a project's tasks and organizes them.

Language: C# - Size: 653 MB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 3 - Forks: 1

ktaranov/sqlserver-kit

Useful links, scripts, tools and best practice for Microsoft SQL Server Database

Language: TSQL - Size: 181 MB - Last synced at: 11 days ago - Pushed at: 22 days ago - Stars: 2,244 - Forks: 698

AshkanMoradi/Ashkan-Moradi-Portfolio

Ashkan Moradi's Portfolio

Language: Jupyter Notebook - Size: 538 KB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

jxareas/PL-300-Guide

Questions, Solutions & Labs of Microsoft's Official Power BI Certification.

Language: PowerShell - Size: 77.1 MB - Last synced at: 13 days ago - Pushed at: 2 months ago - Stars: 63 - Forks: 31

dbt-msft/dbt-sqlserver

dbt adapter for SQL Server and Azure SQL

Language: Python - Size: 1.11 MB - Last synced at: 10 days ago - Pushed at: 22 days ago - Stars: 227 - Forks: 106

MaxGripe/sql-server-dba-scripts

SQL Server administration scripts

Language: TSQL - Size: 135 KB - Last synced at: 3 days ago - Pushed at: 15 days ago - Stars: 0 - Forks: 0

thanu36/SQL-Books-Analysis

This project involves designing and analyzing a bookstore database using Ms-SQL Sever. created relational tables for books, customers, and orders.

Size: 24.4 KB - Last synced at: 17 days ago - Pushed at: 17 days ago - Stars: 0 - Forks: 0

khaled-alselwady/karate-club-management-system

🥋 The Karate Club Project is a feature-rich application designed to meet the specific database requirements for effective management of a Karate Club. 📊

Language: C# - Size: 27.3 MB - Last synced at: 9 days ago - Pushed at: 12 months ago - Stars: 5 - Forks: 0

Mindful-AI-Assistants/No-SQL

🛢️ NoSQL: Building Databases in Practice (Not Only SQL)

Language: SQL - Size: 74.3 MB - Last synced at: 2 days ago - Pushed at: 18 days ago - Stars: 3 - Forks: 0

ctd12/Resources

Resources for languages and technologies I have used.

Size: 154 KB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 0 - Forks: 0

DevExpress-Examples/how-to-implement-t-sql-language-syntax-highlighting-by-creating-syntax-highlight-tokens

Register the ISyntaxHighlightService to implement simplified syntax highlighting for the T-SQL language

Language: C# - Size: 95.7 KB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 1 - Forks: 1

n3rada/MSSQLand

Interract with Microsoft SQL Server (MS SQL | MSSQL) servers and their linked instances in restricted environments, without the need for complex T-SQL queries.

Language: C# - Size: 1.55 MB - Last synced at: 19 days ago - Pushed at: about 1 month ago - Stars: 16 - Forks: 2

rudi-bruchez/tsql-scripts

Transact-SQL scripts and gists

Language: TSQL - Size: 373 KB - Last synced at: 13 days ago - Pushed at: about 1 month ago - Stars: 55 - Forks: 13

arvindshmicrosoft/SQLScriptDomSamples

Samples showing how to use Microsoft.SqlServer.TransactSql.ScriptDom classes

Language: C# - Size: 72.3 KB - Last synced at: 7 days ago - Pushed at: almost 2 years ago - Stars: 62 - Forks: 17

:memo: This VSTO Add-In is used for cleaning & creating a script for batch loading records into SQL Server, Oracle, Documentum, Markup or Markdown Languages. The functionality within the ribbon allows a quick way of preparing a bulk data load. Otherwise, the requests can be both time-consuming and error prone. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In. The most complete version is C#.

Language: C# - Size: 29.8 MB - Last synced at: 17 days ago - Pushed at: about 2 months ago - Stars: 99 - Forks: 24

MatDabS/SQL---DataWarehouse

Modern data warehouse with SQL Server. Includes initialization, ETL processes, data modeling and later analysis.

Language: TSQL - Size: 1.09 MB - Last synced at: 29 days ago - Pushed at: 29 days ago - Stars: 0 - Forks: 0

SQL-Server-projects/Reporting-Services-examples

:closed_book: Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style guide template.

Language: Mathematica - Size: 11.8 MB - Last synced at: 18 days ago - Pushed at: about 2 months ago - Stars: 134 - Forks: 75

DevExpress-Examples/winforms-rich-edit-implement-t-sql-language-syntax-highlighting

Create a custom ISyntaxHighlightService implementation to highlight the T-SQL syntax.

Language: Visual Basic .NET - Size: 104 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 4 - Forks: 0

vaxdata22/Foresight-Institution

This is a Data Analysis case study done on the Foresight Institution dataset.

Size: 822 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

vaxdata22/Foresight-Pharmaceutical

This is a Data Analysis case study done on the Foresight Pharmaceutical Company dataset.

Size: 301 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

vaxdata22/Cyclistic-Ride-Sharing-Company

This is my Google Data Analytics Certificate case study for the Cyclistic ride-sharing company

Size: 98.6 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

vaxdata22/Water-Quality-DW-on-SQL-Server

This is an MSSQL Data Warehouse and manual ETL demo on a specially formatted Water Quality dataset from DEFRA, UK. It is a personal academic-grade exercise to explore the basic concepts of data warehousing and manual ETL process from an academic perspective.

Language: Jupyter Notebook - Size: 394 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 1

Merrill007/Retail-Database-Management-System-T-SQL-SQL-Server-

This project is a comprehensive Retail Database Management System designed for Splendor Analytics Retail, a growing e-commerce and physical store business. The system is built using Microsoft SQL Server and T-SQL to streamline customer management, inventory tracking, order processing, supplier coordination, and reporting.

Size: 5.86 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

245839/Social-Media-Database

A relational Microsoft SQL Server database containing descriptions of users, their posts, and other activities characteristic of a social network. The implementation includes the appropriate triggers, procedures, and functions to properly handle the social portal features.

Language: TSQL - Size: 157 KB - Last synced at: 27 days ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

DavidSchanzer/Sql-Server-DBA-Toolbox

A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.

Language: TSQL - Size: 537 KB - Last synced at: 10 days ago - Pushed at: 5 months ago - Stars: 269 - Forks: 95

yorek/non-scalar-uda-transitive-closure

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

Language: C# - Size: 25.4 KB - Last synced at: 23 days ago - Pushed at: about 1 month ago - Stars: 6 - Forks: 1

tomaztk/MSSQLSERVER_Pandas

Using Python Pandas dataframe to read and insert data to Microsoft SQL Server

Language: Python - Size: 23.4 KB - Last synced at: 13 days ago - Pushed at: almost 4 years ago - Stars: 32 - Forks: 14

MasayukiOzawa/SQLServer-Util

SQL Server の各種情報を取得するためのユーティリティ

Language: TSQL - Size: 7.25 MB - Last synced at: 16 days ago - Pushed at: about 1 month ago - Stars: 79 - Forks: 24

Manuel7806/sql-server-hospital-database

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

Language: TSQL - Size: 75.2 KB - Last synced at: 22 days ago - Pushed at: 6 months ago - Stars: 4 - Forks: 1

MadeiraData/SqlServerReview

Language: TSQL - Size: 86.9 KB - Last synced at: 13 days ago - Pushed at: about 2 months ago - Stars: 2 - Forks: 2

Devinterview-io/t-sql-interview-questions

🟣 T-SQL interview questions and answers to help you prepare for your next technical interview in 2024.

Size: 18.6 KB - Last synced at: 23 days ago - Pushed at: over 1 year ago - Stars: 6 - Forks: 4

DrBarnabus/DacTools

A Helpful tool that can be used to deploy dacpac files to SQL Server. This tool has the ability to deploy a dacpac to multiple databases simultaniously.

Language: C# - Size: 304 KB - Last synced at: 13 days ago - Pushed at: 7 months ago - Stars: 9 - Forks: 1

segovoni/sql-server-demos

Some experiments and demos of my sessions at live/online events like Data Saturday and Microsoft Conference

Language: TSQL - Size: 21 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 7 - Forks: 3

AlessandroCorradini/Microsoft-Data-Science-Professional-Program

Repository for the Microsoft Data Science Professional Program

Language: Jupyter Notebook - Size: 578 MB - Last synced at: 15 days ago - Pushed at: over 5 years ago - Stars: 10 - Forks: 14

MiKL5/PostgreSQL

SGBDR

Size: 396 KB - Last synced at: about 2 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

zBalachandar/Sales-Data-Analytics-Azure-Data-Engineering-End-to-End-Project-13

This project builds an End-to-End Azure Data Engineering Pipeline, performing ETL and Analytics Reporting on the AdventureWorks2017LT Database.

Language: Jupyter Notebook - Size: 23.3 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 9 - Forks: 4

VolodimirDD/Analytics_and_store_administration

The app was built with C# in Visual Studio, .NET Framework, and WinForms UI. It utilizes SQL Server LocalDB for DBMS functionality, with Entity Framework for DB operations and ADO.NET for data access. SSDT used to design and manage the database schema. Dependencies are managed via NuGet packages.

Language: C# - Size: 113 MB - Last synced at: 25 days ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

johnt84/AnnualLeaveRequestTool

A simple Annual Leave Request web app to manage annual leave requests. Web app developed 5 ways - WebForms, MVC, RazorPages and Blazor (WASM/Server).

Language: JavaScript - Size: 2.16 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 3 - Forks: 0

MadeiraData/mssql-jobs-hadr

This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring

Language: TSQL - Size: 197 KB - Last synced at: 13 days ago - Pushed at: 7 months ago - Stars: 12 - Forks: 9

netojoao85/SQL

🔎 Database querying

Language: HTML - Size: 8.51 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 1 - Forks: 0

RubyNixx/coding_resources

Range of cheat sheets, coding resources, videos, etc that I want to keep track of & others may find helpful.

Size: 61.5 KB - Last synced at: about 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Rhoxolan/Structured_Cabling_Studio_Database 📦

The prototype database for the Structured Cabling Studio / Structured Cabling Studio Education project

Language: TSQL - Size: 45.9 KB - Last synced at: 13 days ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

imwrdo/data-warehouses

Data warehouses labs at Gdansk University of Technology

Language: Python - Size: 28.9 MB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

lowlydba/tsqllint-action

✅ Github Action to run TSQLLint.

Language: PowerShell - Size: 96.7 KB - Last synced at: 18 days ago - Pushed at: 3 months ago - Stars: 4 - Forks: 0

Zeekersky/AdventureWorks-SplitPackage

This repository contains an SSIS package that splits employee data from the AdventureWorksDW2017 database into country-specific tables (United States, United Kingdom, Germany, and others). It demonstrates ETL processes using tools like Merge Join, Conditional Split, and OLE DB Destination for efficient data integration.

Size: 862 KB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

ChristianRCanlas/ChristianRCanlas.github.io

e-Portfolio showcasing my personal projects.

Language: Python - Size: 279 MB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 1 - Forks: 0

tomaztk/SQLServer-Data-Lineage

Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse

Language: TSQL - Size: 86.9 KB - Last synced at: 13 days ago - Pushed at: over 2 years ago - Stars: 18 - Forks: 8

fsprojects/FSharp.Data.SqlClient

A set of F# Type Providers for statically typed access to MS SQL database

Language: F# - Size: 47.3 MB - Last synced at: 10 days ago - Pushed at: over 1 year ago - Stars: 204 - Forks: 69

ayush-singhh/Cohort-Retention-Analysis

Cohort Retention Analysis of an Online Retail platform

Language: TSQL - Size: 11.7 KB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

AbualiYousef/Library-Management-System-Database

This GitHub repository hosts the Library Management System project, designed to transition a local library from traditional book-keeping to a comprehensive digital database system using MS SQL, enhancing the management of books, borrowers, and loans

Size: 129 KB - Last synced at: 2 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

PieRatCat/SQL-stuff

Language: Jupyter Notebook - Size: 5.67 MB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

ftaskoski/ReadEase

Read Ease is your ultimate book companion, meticulously crafted to cater to the needs and desires of avid readers like you. Our mission is to transform your reading experience with features like New York Times' best books updates, a customizable "Read List" collection, and personalized settings, all within a sleek and user-friendly interface.

Language: Vue - Size: 11.7 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

EmergentSoftware/SQL-Server-Development-Assessment

sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.

Language: TSQL - Size: 4.33 MB - Last synced at: 13 days ago - Pushed at: almost 2 years ago - Stars: 33 - Forks: 7

Adarsh-Hota/CDC_SCD-1_Pipeline

Real-time data ingestion and transformation pipeline for AirBnB using Azure Data Factory, Synapse, CosmosDB, and ADLS for automated CDC and analytical reporting.

Language: Python - Size: 360 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

mtmjansen/sql-sudo-solver

Use T-SQL to solve Sudoku puzzles

Language: TSQL - Size: 47.9 KB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

males23/SQL_BDD_Chytin

Les bases de donnée dans toute leur diversité.

Size: 7.81 KB - Last synced at: about 2 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

drisskhattabi6/SQL-Server-and-T-SQL-Lab

this repo contains Lab about SQL-Server and T-SQL in French

Size: 1.79 MB - Last synced at: about 1 month ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

staivanov/From-Zero-To-Advance-In-SQL

From Tables and SELECT queries to advanced SQL.

Language: TSQL - Size: 414 KB - Last synced at: about 1 month ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Ereh11/ITI-Examination-System-Project

ITI Examination Database System

Language: TSQL - Size: 18.3 MB - Last synced at: 24 days ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

itsmeyogesh22/Solved-8-Weeks-SQL-Challenge-Correct-Solutions

Included in Serious SQL Virtual apprenticeship program, this repository contains solutions for all eight different case studies crafted by Danny Ma. For more information please visit: https://8weeksqlchallenge.com/

Language: SQL - Size: 3.09 MB - Last synced at: 16 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

NikoirDevelopment/YP1-2024

Creation of a software product for the workshop of household appliances (Educational practice) | Создание программного продукта для мастерской бытовой техники (Учебная практика)

Language: C# - Size: 13.8 MB - Last synced at: about 1 month ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

AmmarSahyoun/Azure-Synapse-Analytics

Serverless SQL pool implementation for a modern BI solution.

Size: 65.2 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

GziXnine/Hospital_Management_System

This repository contains a comprehensive database schema designed for a Hospital Management System to manage various aspects of healthcare operations efficiently. The project is built with a focus on scalability, data integrity, and ease of use for medical staff and administrators.

Language: TSQL - Size: 81.1 KB - Last synced at: 2 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0