Madeira Data Solutions

All

23 repositories

microsoft-dbas-club
Public
Open-source Repository of Useful Scripts and Solutions for Microsoft Database Administrators
sql-server database microsoft-sql-server mssql azure-sql-database mssqlserver azure-sql
TSQL
•
MIT License
•5•16•3•1•Updated Nov 16, 2024Nov 16, 2024
microsoft-data-engineers-club
Public
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Engineers
python azure data-engineering databricks azure-data-factory cosmosdb microsoft-data-warehouse
Jupyter Notebook
•
MIT License
•1•5•0•0•Updated Nov 12, 2024Nov 12, 2024
SqlServerReview
Public
sql-server microsoft-sql-server mssql tsql t-sql mssqlserver
TSQL
•
MIT License
•2•2•0•0•Updated Nov 10, 2024Nov 10, 2024
MadeiraToolbox
Public
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Platform Administrators
sql-server azure scripts ms-sql-server microsoft-sql-server mssql sqlserver tsql t-sql
TSQL
•
MIT License
•96•187•1•0•Updated Oct 3, 2024Oct 3, 2024
mssql-jobs-hadr
Public
This repository contains solutions to properly control and maintain scheduled jobs on SQL Servers with either Availability Groups or Database Mirroring
sql-server jobs mssql high-availability sqlserver mirroring tsql t-sql hadr
TSQL
•
MIT License
•8•10•0•2•Updated Sep 24, 2024Sep 24, 2024
FileOperationsCLR
Public
SQL-CLR project for running file operations from within a SQL Server instance without needing xp_cmdshell
microsoft-sql-server mssql bcp sqlserver mssqlserver sqlclr sql-clr
C#
•
MIT License
•0•0•0•0•Updated Sep 3, 2024Sep 3, 2024
sql-clr-ics
Public
Send Calendar Event / Appointment Invitations (iCal formatted file) from within SQL Server using a CLR stored procedure
events mail database calendar email clr mssql ics sqlserver calendar-events
TSQL
•
MIT License
•1•8•5•1•Updated Aug 15, 2024Aug 15, 2024
.github
Public
0•0•0•0•Updated Apr 25, 2024Apr 25, 2024
microsoft-data-analysts-club
Public
Open-source Repository of Useful Scripts and Solutions for Microsoft Data Analysts
data-visualization data-analysis powerbi powerbi-report microsoft-data-analysis
MIT License
•1•1•0•0•Updated Apr 15, 2024Apr 15, 2024
ReplicationManagementMechanism
Public
Use SQL Server database tables to manage and configure Transactional Replication, and set it up easily between publishers and subscribers using stored procedures
sql-server replication microsoft-sql-server mssql sqlserver mssqlserver mssql-replication
TSQL
•
MIT License
•0•2•2•0•Updated Feb 5, 2024Feb 5, 2024
CosmosDb-to-MSSQL-Migration
Public
Simple app to migrate data from CosmosDB to SQL Server
azure migration microsoft-sql-server mssql sqlserver mssqlserver cosmosdb azure-cosmos-db migration-tool azure-cosmosdb
C#
•
MIT License
•4•6•2•1•Updated Jan 16, 2024Jan 16, 2024
ClrHttpRequest
Public
SQL Server CLR function for running REST methods over HTTP
slack http zendesk rest-api adwords clr http-requests sqlserver restful-api adwords-api
C#
•
MIT License
•16•15•2•0•Updated Jan 2, 2024Jan 2, 2024
multi_tenancy_ssdt_sample
Public
Sample SSDT solution for handling SQL Server in a multi-tenancy environment (includes cross-database access)
sql-server microsoft-sql-server mssql multi-tenancy
TSQL
•
MIT License
•0•1•0•0•Updated Nov 4, 2023Nov 4, 2023
sp_generate_merge
Public
Generate SQL MERGE statements with Table data
TSQL
•151•1•0•0•Updated Jul 25, 2023Jul 25, 2023
DatabaseFileSizeMaintenance
Public
Add-on to Ola Hallengren's maintenance solution, focusing on managing database file size growth and shrink.
sql-server ms-sql-server maintenance microsoft-sql-server mssql sqlserver shrink t-sql autogrow size-growth
TSQL
•
MIT License
•4•6•4•0•Updated Mar 31, 2022Mar 31, 2022
powershell-remote-execution
Public
Data-Driven Solution for remotely controlling machines using Powershell
PowerShell
•
MIT License
•0•3•6•0•Updated Mar 26, 2022Mar 26, 2022
mssql-data-allocation-report
Public
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.
sql-server ms-sql-server microsoft-sql-server mssql sqlserver powerbi t-sql sqlserver-2016 powerbi-report database
TSQL
•
MIT License
•3•8•1•0•Updated Sep 24, 2021Sep 24, 2021
wwi-ssdt
Public
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•2•0•0•Updated Jul 18, 2021Jul 18, 2021
DynamicFilters
Public
Example front-end website and back-end for fully-dynamic filtering capabilities (column, operator, value). Fully protected from SQL Injection.
angularjs angular sql-server angular4 mssql asp-net-core sqlserver dynamic-filters asp-net-mvc mssqlserver
TSQL
•
MIT License
•4•14•3•0•Updated May 27, 2021May 27, 2021
MadeiraData.github.io
Public
MIT License
•0•4•0•0•Updated Jul 9, 2020Jul 9, 2020
SqlClrJsonParser
Public
A SQL CLR wrapper for parsing Json in SQL Server versions pre-2016
wrapper json sql-server clr json-parser mssql mssqlserver sqlclr sqlserver2008 sqlserver2008r2
C#
•
MIT License
•4•8•4•0•Updated May 31, 2019May 31, 2019
ClrWmiRequest
Public
SQL Server CLR function that uses System.Management to run WMI queries and return results as XML
xml wmi sqlserver sqlclr
C#
•
MIT License
•2•2•0•0•Updated Apr 21, 2019Apr 21, 2019
generic-api-platform
Public
Generic SQL Server platform for configuring and running API requests via HTTP
sql-server api-wrapper api-rest sqlserver httpwebrequest sql-clr
JavaScript
•
MIT License
•0•0•0•0•Updated Feb 5, 2019Feb 5, 2019