TSQL sql-server

Open-source TSQL projects categorized as sql-server
Edit details
Topics: Sqlserver Tsql Docker SQL t-sql
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured

Top 12 TSQL sql-server Projects

  • SQL-Server-First-Responder-Kit

    sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

    • Project mention: Resource Usage Historical Log | /r/SQLServer | 2023-05-08

    I would also check that the server is configured according to best practices - DBA Dash can also help with that. I would also recommend running sp_Blitz. In terms of memory configuration, you should set the max server memory to an appropriate value.

  • sqlserver-kit

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

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • AdvancedSQLPuzzles

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

    • Project mention: Not using window functions? | /r/dataengineering | 2023-07-04

    Try advancedsqlpuzzles.com

  • 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.

  • vscode-remote-try-sqlserver

    SQL Server and Azure SQL sample project for trying out the Dev Containers extension

  • MachineIntelligence-TextAnalytics-TPLDataFlows

    Machine Intelligence using OpenAI, Semantic Kernel, Vector Search, SQL Server

    • Project mention: An Innovative OpenAI Approach to Crafting a Vector Database in SQL Server using Semantic Kernel | dev.to | 2023-07-31

    Main GitHub location: source code, developer instructions to get started and more details on the application: https://github.com/bartczernicki/MachineIntelligence-TextAnalytics-TPLDataFlows

  • CEDS-Data-Warehouse

    Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo

  • sql-clr-ics

    Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure

  • azure-sql-db-ci-cd

    Azure SQL DB CI/CD Sample Solution

  • DataAccessGeneration

    Better SQL Server stored procedure calls from C#

  • Advent_of_Code

    A repo revolving around attempting to solve the Advent of Code puzzles with single-statement t-sql (by adimcohen)

  • utility

    Making the world a better place, one utility tool at a time (by dadepretto)

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

TSQL sql-server related posts

  • Not using window functions?

    1 project | /r/dataengineering | 4 Jul 2023

  • I don't see the point in these problems.

    1 project | /r/SQL | 10 May 2023

  • Resource Usage Historical Log

    1 project | /r/SQLServer | 8 May 2023

  • Unknown High SQL Server CPU usage

    2 projects | /r/SQL | 21 Apr 2023

  • Interview at Square for Data Engineering

    1 project | /r/dataengineering | 23 Mar 2023

  • How can I improve my SQL skills if I don't use it in work?

    1 project | /r/datascience | 17 Mar 2023

  • What is a good method to run an SP across all databases?

    1 project | /r/SQL | 13 Mar 2023
  • A note from our sponsor - InfluxDB
    www.influxdata.com | 8 May 2024
    Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →

Index

What are some of the best open-source sql-server projects in TSQL? This list will help you:

Project Stars
1 SQL-Server-First-Responder-Kit 3,222
2 sqlserver-kit 1,980
3 AdvancedSQLPuzzles 499
4 Sql-Server-DBA-Toolbox 91
5 vscode-remote-try-sqlserver 33
6 MachineIntelligence-TextAnalytics-TPLDataFlows 19
7 CEDS-Data-Warehouse 18
8 sql-clr-ics 8
9 azure-sql-db-ci-cd 7
10 DataAccessGeneration 7
11 Advent_of_Code 6
12 utility 1

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com