DataResearchLabs / sql_scriptsLinks
Useful sql scripts and snippets for MSSQL, Oracle, PostgreSQL, Greenplum, and MySQL
☆98Updated 3 years ago
Alternatives and similar repositories for sql_scripts
Users that are interested in sql_scripts are comparing it to the libraries listed below
Sorting:
- Generic interface exchange format for Data Warehouse Automation and ETL generation.☆42Updated last year
- Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup …☆101Updated 2 years ago
- Data reporting and visualization for your app☆350Updated last year
- Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style…☆150Updated last month
- Set up the AdventureWorks sample database for use with Postgres☆459Updated last year
- The Virtual Data Warehouse is a code generation and template management tool. It is part of the data solution automation ecosystem - the …☆46Updated 5 months ago
- A framework for moving data into a data warehouse.☆57Updated 4 years ago
- a set of scripts to pull meta data and data profiling metrics from relational database systems☆77Updated last year
- Database Project with generic procedures to consume API through GET/POST methods.☆144Updated 4 years ago
- Various stored procedures that are used to import and export JSON Data☆46Updated 5 years ago
- The Taxonomy for ETL Automation Metadata (TEAM) is a tool for design metadata management geared towards data warehouse automation. It is …☆37Updated 10 months ago
- Asynchronous T-SQL procedure execution☆24Updated 12 years ago
- HTML5 SQL Server Integration Services Dashboard☆262Updated 6 years ago
- DIRECT, the Data Integration Run-time Execution Control Tool, is a data logistics control framework that can be used to monitor, log, aud…☆28Updated last month
- SQL Server docker image with all sample databases☆41Updated 2 years ago
- A library for data warehouse and data integration pattern and architecture documentation.☆51Updated 5 months ago
- A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and gener…☆287Updated last year
- ETL process for creating a Data Warehouse using SQL Server (SSIS and SSMS). Project based on the AdventureWorks dataset.☆24Updated 8 years ago
- All of the SQL scripts used on my website.☆316Updated last month
- Library of Oracle EBS SQLs for operational Excel and ECC reporting, Discoverer replacement, Oracle EBS performance tuning and rapid repor…☆68Updated last week
- Source code for 'Building a Data Warehouse' by Vincent Rainardi☆32Updated 8 years ago
- The Microsoft AdventureWorks database as a fact-based model in CQL and ORM☆25Updated 9 years ago
- ReplicaDB is open source tool for database replication, designed for efficiently transferring bulk data between relational and non-relati…☆472Updated 2 months ago
- SQL Query Design Best Practices, published by Packt☆58Updated 2 years ago
- SQL Server Metadata Toolkit☆86Updated last year
- Microsoft Integration Services (SSIS) Source component☆48Updated 4 years ago
- Adventureworks OLTP for training, tutorials☆67Updated last year
- Docker Learning Examples☆57Updated 5 months ago
- Azure Data Factory Cookbook, published by Packt☆37Updated 2 years ago
- Data Modeling with Snowflake, published by Packt☆71Updated 8 months ago