Madeira Data Solutions (@MadeiraData)

Top repositories

1

MadeiraToolbox

Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
TSQL
186
star
2

ClrHttpRequest

SQL Server CLR function for running REST methods over HTTP
C#
15
star
3

DynamicFilters

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

mssql-jobs-hadr

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

sql-clr-ics

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

SqlClrJsonParser

A SQL CLR wrapper for parsing Json in SQL Server versions pre-2016
C#
8
star
7

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.
TSQL
8
star
8

microsoft-dbas-club

Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
TSQL
7
star
9

DatabaseFileSizeMaintenance

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

CosmosDb-to-MSSQL-Migration

Simple app to migrate data from CosmosDB to SQL Server
C#
6
star
11

MadeiraData.github.io

4
star
12

powershell-remote-execution

Data-Driven Solution for remotely controlling machines using Powershell
PowerShell
3
star
13

ClrWmiRequest

SQL Server CLR function that uses System.Management to run WMI queries and return results as XML
C#
2
star
14

ReplicationManagementMechanism

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

microsoft-data-engineers-club

Open-source Repository of Useful Scripts and Solutions for Microsoft Data Engineers
Jupyter Notebook
2
star
16

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.
TSQL
2
star
17

SqlServerReview

TSQL
2
star
18

microsoft-data-analysts-club

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

multi_tenancy_ssdt_sample

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