madeiradata Goto Github PK

.github

clrhttprequest

SQL Server CLR function for running REST methods over HTTP

clrwmirequest

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

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.

generic-api-platform

Generic SQL Server platform for configuring and running API requests via HTTP

madeiradata.github.io

madeiratoolbox

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

microsoft-data-analysts-club

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

microsoft-data-engineers-club

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

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

multi_tenancy_ssdt_sample

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

powershell-remote-execution

Data-Driven Solution for remotely controlling machines using Powershell

replicationmanagementmechanism

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

sp_generate_merge

Generate SQL MERGE statements with Table data

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

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.