t-sql
There are 627 repositories under t-sql topic.
ktaranov/sqlserver-kit
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
erikdarlingdata/DarlingData
Open source SQL Server troubleshooting: sp_PressureDetector, sp_QuickieStore, sp_HumanEvents, and other SQL Server scripts for performance troubleshooting
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.
dbt-msft/dbt-sqlserver
dbt adapter for SQL Server and Azure SQL
fsprojects/FSharp.Data.SqlClient
A set of F# Type Providers for statically typed access to MS SQL database
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.
Excel-projects/Script-Help
: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#.
lowlydba/dba-multitool
:hammer_and_wrench: T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.
jxareas/PL-300-Guide
Questions, Solutions & Labs of Microsoft's Official Power BI Certification.
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.
fabioms-br/estudados
Banco de Dados para Estudo
MasayukiOzawa/SQLServer-Util
SQL Server の各種情報を取得するためのユーティリティ
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+
arvindshmicrosoft/SQLScriptDomSamples
Samples showing how to use Microsoft.SqlServer.TransactSql.ScriptDom classes
rudi-bruchez/tsql-scripts
Transact-SQL scripts and gists
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.
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.
Thomas-S-B/SQLServerTools
This repo is the home of various SQL-Server-Tools
EmergentSoftware/SQL-Server-Development-Assessment
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
ericcobb/SQL-Server-Metrics-Pack
A collection of scripts for gathering metrics from SQL Server's underlying DMO's.
MadeiraData/microsoft-dbas-club
Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
tomaztk/MSSQLSERVER_Pandas
Using Python Pandas dataframe to read and insert data to Microsoft SQL Server
ericcobb/SQL-Server-Index-Insight-Scripts
A collection of scripts to use with indexes in SQL Server
koshovyi/SqlBuilder
Simple SQL query builder for .NET
ericcobb/SQL-Server-Permissions-Manager
A set of scripts for managing logins and permissions on SQL Server databases.
sqids/sqids-t-sql
Official T-SQL port of Sqids. Generate short unique IDs from numbers.
datnguye/SQL-Server
Useful T-SQL container
yemrekeskin/sql-lessons
💾 📚 📂 Sample Querying , Data and Training Materials with Transact-SQL
tomaztk/SQLServer-Data-Lineage
Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse
basvdberg/BETL-old
BETL. Meta data driven ETL generation using T-SQL
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.
arvindshmicrosoft/YelpDatasetSQL
Working with the Yelp Dataset in Azure SQL and SQL Server
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.
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/
pelsql/YourSqlDba
Sources for YourSqlDba : Database maintenance solution that installs as a single SQL script
mehmetozdeemiir/DbFirst-CodeFirst
In this project, I examined the terms database first and code first and developed an application.