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:
- A framework for moving data into a data warehouse.☆57Updated 4 years ago
- Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style…☆151Updated 3 months ago
- Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup …☆103Updated 3 years ago
- a set of scripts to pull meta data and data profiling metrics from relational database systems☆77Updated last year
- A library for data warehouse and data integration pattern and architecture documentation.☆51Updated last week
- Generic interface exchange format for Data Warehouse Automation and ETL generation.☆42Updated last month
- ETL process for creating a Data Warehouse using SQL Server (SSIS and SSMS). Project based on the AdventureWorks dataset.☆24Updated 8 years ago
- Set up the AdventureWorks sample database for use with Postgres☆461Updated 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 6 months ago
- SQL Server Metadata Toolkit☆86Updated last year
- Database Project with generic procedures to consume API through GET/POST methods.☆144Updated 4 years ago
- Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse☆20Updated 3 years ago
- The Taxonomy for ETL Automation Metadata (TEAM) is a tool for design metadata management geared towards data warehouse automation. It is …☆37Updated last year
- Docker Learning Examples☆58Updated 7 months ago
- Transact-SQL scripts and gists☆58Updated last week
- SSASQueryAnalyzer is a tool to analyze and troubleshoot MDX queries on Analysis Services Multidimensional☆23Updated 7 years ago
- SQL Server docker image with all sample databases☆41Updated 2 years ago
- HTML5 SQL Server Integration Services Dashboard☆260Updated 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…☆29Updated 3 weeks ago
- Custom Contoso database generator and ready-to-use Contoso sample databases for SQL Server☆150Updated last year
- Useful T-SQL container☆22Updated 4 years ago
- Scripts for SQL Server☆49Updated last year
- OLAP PivotTable Extensions is an Excel add-in which extends the functionality of PivotTables on Analysis Services cubes, the Excel Data M…☆57Updated last year
- An Azure Function which allows Azure Data Factory (ADF) to connect to Snowflake in a flexible way.☆26Updated 2 years ago
- Bravo for Power BI☆413Updated this week
- Snowflake scripts and useful snippets☆14Updated last year
- BETL. Meta data driven ETL generation using T-SQL☆18Updated 3 years ago
- Microsoft Integration Services (SSIS) Source component☆48Updated 4 years ago
- SCD Merge Wizard is an application which will help you generate T-SQL statement for merging data from two tables into one table in minute…☆44Updated last year
- A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data …☆88Updated 2 years ago