t-sql | Topic | Ecosyste.ms: Repos

Topic: "t-sql"

ktaranov/sqlserver-kit

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

Language: TSQL - Size: 181 MB - Last synced at: 6 days ago - Pushed at: 9 days ago - Stars: 2,268 - Forks: 703

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.81 MB - Last synced at: 8 days ago - Pushed at: 12 days ago - Stars: 590 - Forks: 166

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: 25 days ago - Pushed at: 7 months ago - Stars: 272 - Forks: 97

dbt-msft/dbt-sqlserver

dbt adapter for SQL Server and Azure SQL

Language: Python - Size: 1.12 MB - Last synced at: 4 days ago - Pushed at: 15 days ago - Stars: 230 - Forks: 105

fsprojects/FSharp.Data.SqlClient

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

Language: F# - Size: 47.4 MB - Last synced at: 26 days ago - Pushed at: about 2 months ago - Stars: 204 - Forks: 69

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: 25 days ago - Pushed at: about 1 month ago - Stars: 135 - Forks: 76

lowlydba/dba-multitool

:hammer_and_wrench: T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.

Language: PLpgSQL - Size: 3.62 MB - Last synced at: 26 days ago - Pushed at: 26 days ago - Stars: 99 - Forks: 26

: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: 24 days ago - Pushed at: 3 months ago - Stars: 99 - Forks: 24

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: 5 days ago - Pushed at: over 2 years ago - Stars: 86 - Forks: 19

MasayukiOzawa/SQLServer-Util

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

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

fabioms-br/estudados

Banco de Dados para Estudo

Size: 161 MB - Last synced at: 6 months ago - Pushed at: over 1 year ago - Stars: 69 - Forks: 10

jxareas/PL-300-Guide

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

Language: PowerShell - Size: 77.1 MB - Last synced at: 29 days ago - Pushed at: 4 months ago - Stars: 67 - Forks: 33

arvindshmicrosoft/SQLScriptDomSamples

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

Language: C# - Size: 72.3 KB - Last synced at: 11 days ago - Pushed at: about 2 years ago - Stars: 63 - Forks: 17

rudi-bruchez/tsql-scripts

Transact-SQL scripts and gists

Language: TSQL - Size: 386 KB - Last synced at: about 15 hours ago - Pushed at: about 1 month ago - Stars: 56 - Forks: 14

sergeyleschev/leetcode-swift

TOP 200 #Dev 🏆 LeetCode, Solutions in  Swift, Shell, Database (T-SQL, PL/SQL, MySQL), Concurrency (Python3). @ S. Leschev. Google Engineering Level: L6+

Language: Swift - Size: 3.55 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 56 - Forks: 12

ronascentes/sp_who3

The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.

Language: TSQL - Size: 121 KB - Last synced at: 11 months ago - Pushed at: almost 2 years ago - Stars: 52 - Forks: 12

Thomas-S-B/SQLServerTools

This repo is the home of various SQL-Server-Tools

Language: TSQL - Size: 122 KB - Last synced at: 2 months ago - Pushed at: over 2 years ago - Stars: 36 - Forks: 12

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: about 2 years ago - Stars: 33 - Forks: 7

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: 2 months ago - Pushed at: about 4 years ago - Stars: 32 - Forks: 14

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.58 MB - Last synced at: 29 days ago - Pushed at: 29 days ago - Stars: 31 - Forks: 5

koshovyi/SqlBuilder

Simple SQL query builder for .NET

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

ericcobb/SQL-Server-Metrics-Pack

A collection of scripts for gathering metrics from SQL Server's underlying DMO's.

Language: TSQL - Size: 42 KB - Last synced at: over 1 year ago - Pushed at: about 4 years ago - Stars: 26 - Forks: 12

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: 23 days ago - Pushed at: 23 days ago - Stars: 25 - Forks: 11

ericcobb/SQL-Server-Index-Insight-Scripts

A collection of scripts to use with indexes in SQL Server

Language: TSQL - Size: 18.6 KB - Last synced at: over 1 year ago - Pushed at: over 5 years ago - Stars: 23 - Forks: 7

datnguye/SQL-Server

Useful T-SQL container

Language: TSQL - Size: 159 KB - Last synced at: 11 days ago - Pushed at: over 3 years ago - Stars: 22 - Forks: 11

ericcobb/SQL-Server-Permissions-Manager

A set of scripts for managing logins and permissions on SQL Server databases.

Language: TSQL - Size: 35.2 KB - Last synced at: about 1 year ago - Pushed at: about 4 years ago - Stars: 22 - Forks: 11

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: 2 months ago - Pushed at: almost 3 years ago - Stars: 18 - Forks: 8

Burakkylmz/Programming_SQL_Server_Database

In this repository, you can find some stored procedures, triggers, views and t-sql examples with both their explanations and implementations.

Language: TSQL - Size: 38.1 KB - Last synced at: about 1 month ago - Pushed at: about 4 years ago - Stars: 18 - Forks: 4

basvdberg/BETL-old

BETL. Meta data driven ETL generation using T-SQL

Size: 2.49 MB - Last synced at: over 2 years ago - Pushed at: almost 3 years ago - Stars: 17 - Forks: 2

arvindshmicrosoft/YelpDatasetSQL

Working with the Yelp Dataset in Azure SQL and SQL Server

Language: TSQL - Size: 43 KB - Last synced at: 2 months ago - Pushed at: over 4 years ago - Stars: 17 - Forks: 9

Darko-Martinovic/TransposingMatrix

The detailed explanation could be found on Red Gate SimpleTalk's link 'An Easier Way of Transposing Query Result in SQL Server' https://www.red-gate.com/simple-talk/sql/t-sql-programming/easier-way-transposing-query-result-sql-server/

Language: SQLPL - Size: 137 KB - Last synced at: over 2 years ago - Pushed at: about 7 years ago - Stars: 16 - Forks: 4

pelsql/YourSqlDba

Sources for YourSqlDba : Database maintenance solution that installs as a single SQL script

Language: TSQL - Size: 4.82 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 15 - Forks: 10

mehmetozdeemiir/DbFirst-CodeFirst

In this project, I examined the terms database first and code first and developed an application.

Language: C# - Size: 61.5 KB - Last synced at: almost 2 years ago - Pushed at: over 4 years ago - Stars: 14 - Forks: 0

yemrekeskin/sql-lessons

💾 📚 📂 Sample Querying , Data and Training Materials with Transact-SQL

Language: TSQL - Size: 10.3 MB - Last synced at: about 2 years ago - Pushed at: about 5 years ago - Stars: 14 - Forks: 4

Darko-Martinovic/SQLCLR

The detailed explanation could be found on Red Gate SimpleTalk's link 'SQLCLR in Practice: Creating a Better Way of Sending Email from SQL Server' https://www.red-gate.com/simple-talk/sql/sql-development/sqlclr-practice-creating-better-way-sending-email-sql-server/

Language: SQLPL - Size: 130 KB - Last synced at: over 2 years ago - Pushed at: over 6 years ago - Stars: 13 - Forks: 10

somdipdey/SystemPerformance

Track System Performance (CPU / RAM / Memory / SQL Server) using this NuGet Package. Requires .Net framework 3.5+. It is an Open Source project under MIT License.

Language: C# - Size: 47.9 KB - Last synced at: 21 days ago - Pushed at: over 7 years ago - Stars: 13 - Forks: 2

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: 2 months ago - Pushed at: 9 months ago - Stars: 12 - Forks: 9

usharik/MsSqlDependencyBrowser

Simple tool to browse between dependent objects on MS SQL Server

Language: C# - Size: 94.7 KB - Last synced at: 2 months ago - Pushed at: over 2 years ago - Stars: 11 - Forks: 3

JSuder-xx/TSqlStrong

T-Sql type checker that detects improper joins, invalid null value operations, enumeration check constraint violations, incorrect use of temporary table at call site, more. On-line demo available.

Language: C# - Size: 363 KB - Last synced at: about 1 year ago - Pushed at: about 7 years ago - Stars: 11 - Forks: 6

18520339/database-lab

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

Language: TSQL - Size: 3.38 MB - Last synced at: 3 days ago - Pushed at: almost 5 years ago - Stars: 10 - Forks: 2

AlessandroCorradini/Microsoft-Data-Science-Professional-Program

Repository for the Microsoft Data Science Professional Program

Language: Jupyter Notebook - Size: 578 MB - Last synced at: 2 months ago - Pushed at: almost 6 years ago - Stars: 10 - Forks: 14

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: 4 months ago - Pushed at: 4 months ago - Stars: 9 - 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: 22 days ago - Pushed at: 9 months ago - Stars: 9 - Forks: 1

khaled-alselwady/study-center-management-system

🏫 The Study Center is a comprehensive software solution for managing educational operations in schools and educational institutions. 📚

Language: C# - Size: 12.2 MB - Last synced at: 2 months ago - Pushed at: about 1 year ago - Stars: 9 - Forks: 0

chrisoldwood/SS-Unit

A 100% T-SQL based unit testing framework for SQL Server

Language: TSQL - Size: 211 KB - Last synced at: 6 months ago - Pushed at: over 5 years ago - Stars: 9 - Forks: 0

MadeiraData/mssql-data-allocation-report

Queries and reports to visualize your SQL data and transaction log page allocations. See which pages are reserved for which objects, and which pages are not used.

Language: TSQL - Size: 791 KB - Last synced at: 2 months ago - Pushed at: over 3 years ago - Stars: 8 - Forks: 3

learn-by-doing-organization/my-simple-site-statistics-mssql

A simple sql script for create a site statistics in SQL Server

Language: TSQL - Size: 34.2 KB - Last synced at: almost 2 years ago - Pushed at: about 4 years ago - Stars: 8 - 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: 22.4 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 7 - Forks: 3

highlightjs/highlightjs-tsql

JavaScript syntax highlighter for with zero dependencies for MS SQL Transact-SQL language

Language: JavaScript - Size: 213 KB - Last synced at: 6 days ago - Pushed at: 10 months ago - Stars: 7 - Forks: 6

jeffshumphreys/MySQLCLRFunctions

Free SQLCLR functions tested on SQL Server 2019. That are used.

Language: C# - Size: 218 KB - Last synced at: 2 months ago - Pushed at: over 2 years ago - Stars: 7 - Forks: 1

tomaztk/2048_sql_game

Popular 2048 game with T-SQL

Language: TSQL - Size: 27.3 KB - Last synced at: about 1 month ago - Pushed at: about 3 years ago - Stars: 7 - Forks: 3

I-SER-I/ITMO-DataBase-2-sem 📦

Labs. works on database 2 sem.

Size: 209 KB - Last synced at: over 2 years ago - Pushed at: about 3 years ago - Stars: 7 - Forks: 1

semcha/useful-tsql

Language: TSQL - Size: 171 KB - Last synced at: 2 months ago - Pushed at: about 4 years ago - Stars: 7 - Forks: 3

Devinterview-io/t-sql-interview-questions

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

Size: 30.3 KB - Last synced at: 14 days ago - Pushed at: 29 days ago - Stars: 6 - Forks: 4

CrisCorreaS/apuntes-sql

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

Size: 56.5 MB - Last synced at: 1 day ago - Pushed at: 2 months ago - Stars: 6 - Forks: 0

yorek/non-scalar-uda-transitive-closure

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

Language: C# - Size: 25.4 KB - Last synced at: about 2 months ago - Pushed at: 3 months ago - Stars: 6 - Forks: 1

stonebr00k/aoc

My Advent of Code solutions

Language: TSQL - Size: 59.6 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 6 - Forks: 0

khaled-alselwady/hotel-management-system

🏨 The Hotel Management System is a comprehensive application designed to efficiently manage various aspects of hotel operations. 📊

Language: C# - Size: 3.67 MB - Last synced at: 2 months ago - Pushed at: about 1 year ago - Stars: 6 - Forks: 0

ststeiger/SqlParser

Ways to remove sql-comments, including ANTLR4

Language: ANTLR - Size: 53.7 KB - Last synced at: 2 months ago - Pushed at: over 2 years ago - Stars: 6 - Forks: 0

MadeiraData/DatabaseFileSizeMaintenance

Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.

Language: TSQL - Size: 221 KB - Last synced at: 2 months ago - Pushed at: about 3 years ago - Stars: 6 - Forks: 4

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: 16 days ago - Pushed at: about 1 year ago - Stars: 5 - Forks: 0

philomela/PlanningPoker

This repo is site project PlanningPoker. PlanningPoker - game for evaluating scrum team tasks. Go(Gorilla) + MSSQL + HTML + CSS using WebSockets

Language: Go - Size: 20.8 MB - Last synced at: about 2 years ago - Pushed at: over 2 years ago - Stars: 5 - Forks: 1

xmikedanielsx/cSharp-Import-Delimited-Files

This repo contains a Windows Form application wrote in C# (.NET 5.0) with 4 NuGet Packages to allow users to read flat files (delimited) and write in bulk multiple files. It also allows users to change the datatypes upon import for each individual file (like SQL Import Util). However, unlike SQL Server import util, this utility also allows for multiple files as well as using VARCHAR(MAX) as SQL import util only allows varchar(8000) and TEXT.

Language: C# - Size: 3.4 MB - Last synced at: 2 days ago - Pushed at: about 3 years ago - Stars: 5 - Forks: 1

chrisoldwood/SS-Cop

A 100% T-SQL tool for static code analysis of SQL Server databases

Language: TSQL - Size: 32.2 KB - Last synced at: 6 months ago - Pushed at: over 5 years ago - Stars: 5 - Forks: 0

chrisoldwood/sql2doxygen

A PowerShell script to convert T-SQL scripts to C code to allow Doxygen to parse them

Language: PowerShell - Size: 50.8 KB - Last synced at: 6 months ago - Pushed at: over 5 years ago - Stars: 5 - Forks: 1

MichaelSScott/GraphDoc

Draw graphs of stored procedure calls and object usage

Language: TSQL - Size: 730 KB - Last synced at: 5 months ago - Pushed at: over 5 years ago - Stars: 5 - Forks: 3

MindFlavor/SQLBeam 📦

A massively concurrent ETL tool for SQL Server administration using T-SQL.

Language: C# - Size: 62.5 KB - Last synced at: over 2 years ago - Pushed at: about 7 years ago - Stars: 5 - Forks: 0

lanceengland/SqlHelpers

Basic T-SQL code generation for some frequently used commands.

Language: PowerShell - Size: 10.7 KB - Last synced at: almost 2 years ago - Pushed at: over 7 years ago - Stars: 5 - Forks: 0

DevExpress-Examples/winforms-richedit-implement-t-sql-language-syntax-highlighting

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

Language: Visual Basic .NET - Size: 108 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 4 - Forks: 0

lowlydba/tsqllint-action

✅ Github Action to run TSQLLint.

Language: PowerShell - Size: 99.6 KB - Last synced at: 13 days ago - Pushed at: 2 months ago - Stars: 4 - Forks: 0

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: about 1 month ago - Pushed at: 8 months ago - Stars: 4 - Forks: 1

davinci70/Vehicle-Rental-Management-System

The Vehicle Rental Management System is a robust software application designed to streamline the entire process of renting vehicles. Whether for short-term or long-term use, this system efficiently manages various aspects related to vehicle rentals.

Language: C# - Size: 10.6 MB - Last synced at: 2 months ago - Pushed at: 11 months ago - Stars: 4 - Forks: 0

timbrownls20/Demo

Demo code

Language: JavaScript - Size: 9.23 MB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 4 - Forks: 4

tomaztk/Business-rules-for-T-SQL

Manage your business rules in T-SQL

Language: TSQL - Size: 53.7 KB - Last synced at: 2 months ago - Pushed at: almost 3 years ago - Stars: 4 - Forks: 0

another-one-employee/Northwind 📦

Northwind is a simple MVC application with CRUD operations for working with Products and Categories designed on a Clean Architecture.

Language: C# - Size: 6.65 MB - Last synced at: 7 months ago - Pushed at: over 3 years ago - Stars: 4 - Forks: 2

quantumudit/Querying-with-TSQL

This repository contains notebooks that can help in learning T-SQL queries from the very basics to the advanced level.

Language: Jupyter Notebook - Size: 109 KB - Last synced at: about 1 month ago - Pushed at: over 3 years ago - Stars: 4 - Forks: 0

MeKerimKilic/T-SQL-Egitim-Dokumantasyon

Başakşehir Living Lab'de verdiğim T-Sql Eğitim Dökümanları

Size: 6.59 MB - Last synced at: 6 months ago - Pushed at: almost 4 years ago - Stars: 4 - Forks: 0

BorislavNikolov/SQL

Simple SQL

Language: TSQL - Size: 4.88 KB - Last synced at: almost 2 years ago - Pushed at: over 5 years ago - Stars: 4 - Forks: 0

91ahmed/E-commerce-DB

PostgreSQL, SQL Server, MySQL (database design for e-commerce website)

Language: TSQL - Size: 181 KB - Last synced at: about 1 month ago - Pushed at: almost 6 years ago - Stars: 4 - Forks: 0

francesco1119/OSM_to_MSSQL

Import OSM to MSSQL on SSMS through a SQL query with an HTTP request. BOOM!!!

Size: 77.1 KB - Last synced at: almost 2 years ago - Pushed at: over 6 years ago - Stars: 4 - Forks: 0

DustinLedbetter/T-SQL-Fundamentals-Third-Edition-Book-Work

This is a collection of the chapter code and exercises I tested as I progressed through the book

Language: PLSQL - Size: 42 KB - Last synced at: about 2 years ago - Pushed at: almost 7 years ago - Stars: 4 - Forks: 2

tkreque/DB_Scripts 📦

Scripts for Database Administration

Language: Shell - Size: 82 KB - Last synced at: over 2 years ago - Pushed at: about 7 years ago - Stars: 4 - Forks: 0