Madeira Data Solutions (@MadeiraData)

Top repositories

1

MadeiraToolbox

Open-source Repository of Useful Scripts and Solutions for the Microsoft Data Platform
TSQL
178
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

SqlClrJsonParser

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

sql-clr-ics

Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure
TSQL
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

CosmosDb-to-MSSQL-Migration

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

DatabaseFileSizeMaintenance

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

MadeiraData.github.io

4
star
11

ClrWmiRequest

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

powershell-remote-execution

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

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
1
star
14

multi_tenancy_ssdt_sample

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

microsoft-data-engineers-club

Microsoft Data Engineers Club
Jupyter Notebook
1
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
1
star