DataResearchLabs / sql_scriptsLinks
Useful sql scripts and snippets for MSSQL, Oracle, PostgreSQL, Greenplum, and MySQL
☆91Updated 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 box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and gener…☆274Updated 6 months ago
- Various scripts I use for SQL Server databases. These include Reporting Services, Primavera P6, and general administration T-SQL backup …☆94Updated 2 years ago
- DataTalks Workshop Materials☆18Updated last year
- ☆51Updated 3 years ago
- Repository for lab exercises and instructions for Microsoft DP-300 learning content☆98Updated last month
- Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse☆18Updated 2 years ago
- Various stored procedures that are used to import and export JSON Data☆45Updated 4 years ago
- Source Code Collection and Supplemental Material for the O'Reilly Snowflake Definitive Guide 1st Edition book☆96Updated 2 years ago
- Data Engineering, SQL, Exploratory Data Analysis (EDA), Machine Learning (Python), Business Intelligence (BI)☆13Updated 11 months ago
- A framework for moving data into a data warehouse.☆58Updated 3 years ago
- The Microsoft AdventureWorks database as a fact-based model in CQL and ORM☆25Updated 9 years ago
- Microsoft Integration Services (SSIS) Source component☆49Updated 3 years ago
- Snippets and samples for Azure SQL Data Warehouse☆143Updated last year
- SQL Server docker image with all sample databases☆38Updated last year
- Generic interface exchange format for Data Warehouse Automation and ETL generation.☆41Updated 10 months ago
- Tsql stored procedures and scripts to help the DBAs and Developers to make their job easier☆44Updated 10 months ago
- Various example reports I use for Microsoft Report Server (SSRS & PBIRS) as well as documents for unit testing, requirements and a style…☆136Updated last week
- End to end data engineering project☆56Updated 2 years ago
- Template for Data Engineering and Data Pipeline projects☆112Updated 2 years ago
- SSASQueryAnalyzer is a tool to analyze and troubleshoot MDX queries on Analysis Services Multidimensional☆22Updated 7 years ago
- ☆43Updated 2 months ago
- A portable Datamart and Business Intelligence suite built with Docker, Airflow, dbt, PostgreSQL and Superset☆42Updated 6 months ago
- A T-SQL script for improving database configuration and design in Azure SQL DB.☆148Updated 2 years ago
- Analyzing Manufacturing and Inventory Operations of the AdventureWorks Database using Power BI☆27Updated 3 years ago
- A data pipeline moving data from a Relational database system (RDBMS) to a Hadoop file system (HDFS).☆15Updated 4 years ago
- High-Speed Bulk Copy tool to move data from one Azure SQL / SQL Server database to another. Smartly uses logical or physical partitions t…☆63Updated last year
- Source code of the Apache Airflow Tutorial for Beginners on YouTube Channel Coder2j (https://www.youtube.com/c/coder2j)☆304Updated last year
- Azure Data Factory Cookbook, published by Packt☆36Updated 2 years ago
- The Virtual Data Warehouse is a code generation and template management tool. It is part of the data solution automation ecosystem - the …☆45Updated 2 months ago
- This repository is deprecated and no longer updated. Please visit the new repository:☆195Updated last month