Useful links, scripts, tools and best practice for Microsoft SQL Server Database
-
Updated
Oct 30, 2024 - TSQL
Useful links, scripts, tools and best practice for Microsoft SQL Server Database
dbt adapter for SQL Server and Azure SQL
A set of F# Type Providers for statically typed access to MS SQL database
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
📕 Various example reports I use for SQL Server Reporting Services (SSRS) as well as documents for unit testing, requirements and a style guide template.
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.
📝 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…
🛠️ T-SQL scripts for the long haul: optimizing storage, on-the-fly documentation, and general administrative needs.
SQL Server の各種情報を取得するためのユーティリティ
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.
Banco de Dados para Estudo
TOP 200 #Dev 🏆 LeetCode, Solutions in Swift, Shell, Database (T-SQL, PL/SQL, MySQL), Concurrency (Python3). @ S. Leschev. Google Engineering Level: L6+
Samples showing how to use Microsoft.SqlServer.TransactSql.ScriptDom classes
The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.
Transact-SQL scripts and gists
Questions, Solutions & Labs of Microsoft's Official Power BI Certification.
This repo is the home of various SQL-Server-Tools
A collection of scripts for gathering metrics from SQL Server's underlying DMO's.
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
Using Python Pandas dataframe to read and insert data to Microsoft SQL Server
Add a description, image, and links to the t-sql topic page so that developers can more easily learn about it.
To associate your repository with the t-sql topic, visit your repo's landing page and select "manage topics."