Repository navigation
sql-server
Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (t-sql), but it has forked significantly since then.
SQL Server is available in multiple versions (typically identified by release year), each of which are subdivided into editions to distinguish between product functionality. The latest released version is SQL Server 2019 which was released on November 4th, 2019.
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
A type-safe TypeScript SQL query builder
Universal command-line interface for SQL databases
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, DuckDB, Microsoft SQL Server]
Automatically identify anti-patterns in SQL queries
Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting
Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
DBA Dash - SQL Server Monitoring Tool
dbt adapter for SQL Server and Azure SQL
👨⚕️ A Clinic Management System based on three tier architecture made using ASP.NET, C#.
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
Take control of your business with Free CRM, an open-source Customer Relationship Management (CRM) software. Built for businesses of all sizes, Free CRM is your all-in-one solution for driving growth. Experience the power of open-source CRM software without hidden costs. Powered by ASP.NET Core 9.x (Demo username: admin@root.com|pwd:123456)
R2DBC Driver for Microsoft SQL Server using TDS (Tabular Data Stream) Protocol
go-etl is a toolset for data extraction, transformation and loading.
Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite written in C# supporting dynamic query building and nesting using expressions.
A collection of cool and useful tools, procedures and scripts for the discerning DBA
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.