Pinned Repositories
ClrHttpRequest
SQL Server CLR function for running REST methods over HTTP
CosmosDb-to-MSSQL-Migration
Simple app to migrate data from CosmosDB to SQL Server
DatabaseFileSizeMaintenance
Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.
DynamicFilters
Example front-end website and back-end for fully-dynamic filtering capabilities (column, operator, value). Fully protected from SQL Injection.
MadeiraToolbox
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
microsoft-dbas-club
Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
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.
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
Madeira Data Solutions's Repositories
MadeiraData/MadeiraToolbox
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
MadeiraData/microsoft-dbas-club
Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
MadeiraData/ClrHttpRequest
SQL Server CLR function for running REST methods over HTTP
MadeiraData/DynamicFilters
Example front-end website and back-end for fully-dynamic filtering capabilities (column, operator, value). Fully protected from SQL Injection.
MadeiraData/mssql-jobs-hadr
This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring
MadeiraData/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.
MadeiraData/sql-clr-ics
Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure
MadeiraData/SqlClrJsonParser
A SQL CLR wrapper for parsing Json in SQL Server versions pre-2016
MadeiraData/CosmosDb-to-MSSQL-Migration
Simple app to migrate data from CosmosDB to SQL Server
MadeiraData/DatabaseFileSizeMaintenance
Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.
MadeiraData/microsoft-data-engineers-club
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Engineers
MadeiraData/MadeiraData.github.io
MadeiraData/powershell-remote-execution
Data-Driven Solution for remotely controlling machines using Powershell
MadeiraData/ClrWmiRequest
SQL Server CLR function that uses System.Management to run WMI queries and return results as XML
MadeiraData/ReplicationManagementMechanism
Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures
MadeiraData/SqlServerReview
MadeiraData/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.
MadeiraData/microsoft-data-analysts-club
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Analysts
MadeiraData/multi_tenancy_ssdt_sample
Sample SSDT solution for handling SQL Server in a multi-tenancy environment (includes cross-database access)
MadeiraData/sp_generate_merge
Generate SQL MERGE statements with Table data
MadeiraData/.github
MadeiraData/FileOperationsCLR
SQL-CLR project for running file operations from within a SQL Server instance without needing xp_cmdshell
MadeiraData/generic-api-platform
Generic SQL Server platform for configuring and running API requests via HTTP