MadeiraData/microsoft-dbas-club

Stars
7
Rank 2,294,772 (Top 46 %)
Language TSQL
License
MIT License
Created 8 months ago
Updated 3 months ago

MadeiraData/microsoft-dbas-club

MadeiraData

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators

MadeiraToolbox

Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators

ClrHttpRequest

SQL Server CLR function for running REST methods over HTTP

DynamicFilters

Example front-end website and back-end for fully-dynamic filtering capabilities (column, operator, value). Fully protected from SQL Injection.

mssql-jobs-hadr

This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring

sql-clr-ics

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

SqlClrJsonParser

A SQL CLR wrapper for parsing Json in SQL Server versions pre-2016

mssql-data-allocation-report

Queries and reports to visualize your SQL data and transaction log page allocations. See which pages are reserved for which objects, and which pages are not used.

DatabaseFileSizeMaintenance

Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.

CosmosDb-to-MSSQL-Migration

Simple app to migrate data from CosmosDB to SQL Server

MadeiraData.github.io

powershell-remote-execution

Data-Driven Solution for remotely controlling machines using Powershell

ClrWmiRequest

SQL Server CLR function that uses System.Management to run WMI queries and return results as XML

ReplicationManagementMechanism

Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures

microsoft-data-engineers-club

Open-source Repository of Useful Scripts and Solutions for Microsoft Data Engineers

Jupyter Notebook

wwi-ssdt

This Visual Studio SQL Server Data Tools project is used to construct the WideWorldImporters database from scratch on SQL Server or Azure SQL Database.

SqlServerReview

microsoft-data-analysts-club

Open-source Repository of Useful Scripts and Solutions for Microsoft Data Analysts

multi_tenancy_ssdt_sample

Sample SSDT solution for handling SQL Server in a multi-tenancy environment (includes cross-database access)