• Stars
    star
    186
  • Rank 207,316 (Top 5 %)
  • Language TSQL
  • License
    MIT License
  • Created over 4 years ago
  • Updated 6 months ago

Reviews

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

Repository Details

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

Welcome - We are Madeira Data Solutions

Madeira Toolbox

This is the official Toolbox repository for Madeira's consultant team, for "as-is" solutions and tools/scripts that the team publishes.

Please visit our official website at:

www.madeiradata.com

License

All Madeira Toolbox materials in this repository are released under the MIT license.

More Repositories

1

ClrHttpRequest

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

DynamicFilters

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

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
4

sql-clr-ics

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

SqlClrJsonParser

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

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
7

microsoft-dbas-club

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

DatabaseFileSizeMaintenance

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

CosmosDb-to-MSSQL-Migration

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

MadeiraData.github.io

4
star
11

powershell-remote-execution

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

ClrWmiRequest

SQL Server CLR function that uses System.Management to run WMI queries and return results as XML
C#
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
2
star
14

microsoft-data-engineers-club

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

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
16

SqlServerReview

TSQL
2
star
17

microsoft-data-analysts-club

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

multi_tenancy_ssdt_sample

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