Useful links, scripts, tools and best practice for Microsoft SQL Server Database
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.
Инструменты обслуживания и разработки для Microsoft SQL Server, а также другие интересности
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
Data Analyst portfolio project that deals with business KPIs, cleaning and transforming data and visualizing it to create a dashboard. The tools used are: SQL Server, T-SQL, Excel and Power BI.
🐸 Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup and restore, etc.
Transact-SQL scripts and gists
Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier
This repo is the home of various SQL-Server-Tools
sp_Develop can be used by database developers, software developers and for performing database code (smell) reviews.
PowerShell Module to interact with Lansweeper Database
Demos for Azure SQL DevOps presentation
Azure Data Studio Dark Theme
Basic to Complex SQL Server queries with Adventure Works database including window functions, triggers, string manipulation, user-defined functions, CTE, recursive CTE, DML and DDL
This automation has been designed to eliminate manual efforts on Space Capacity ESC tickets where DBA has to add new data or log files on new volume, and restrict data or log files on old volume. Apart from this, this procedure can be used for variety of tasks related to capacity management.
🌎World countries, states/regions, cities served inn various formats. All Countries, Cities, States with ISO2, ISO3
A repo revolving around attempting to solve the Advent of Code puzzles with single-statement t-sql
This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring
Add a description, image, and links to the tsql topic page so that developers can more easily learn about it.
To associate your repository with the tsql topic, visit your repo's landing page and select "manage topics."