yorek/ssis-dashboard

Stars
246
Rank 164,726 (Top 4 %)
Language
JavaScript
License
Apache License 2.0
Created over 10 years ago
Updated over 5 years ago

yorek/ssis-dashboard

yorek

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

HTML5 SQL Server Integration Services Dashboard

SQL Server Integration Services Dashboard v 0.6.8 Beta

The purpose of this project is to provide a web-based, user-friendly, useful and nice looking SQL Server Integration Services Dashboard and a set of REST API to monitor execution of SQL Server Integration Services Packages.

Supported Environments

SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SSIS on Azure Data Factory V2 (https://docs.microsoft.com/en-us/azure/data-factory/)

Documentation

Used Platforms & Tools

SSIS Dashboard has been built using:

Python 3.6: https://www.python.org/
Flask 0.12.2: http://flask.pocoo.org/
PyODBC 4.0.17: https://github.com/mkleehammer/pyodbc
SB Admin 2 Template: http://startbootstrap.com/template-overviews/sb-admin-2/

The IDE used to build the project is Visual Studio 2017 (that's why you can see the runserver.py file), though now I'm also using Visual Studio Code

dapper-samples

Tutorial samples that shows how to use Dapper .NET

awesome-azure-sql

An awesome list of Azure SQL samples for Developers of any Language and Platform

ssis-queries

A set of queries useful to easily extract monitoring and package performance data from SSISDB database

azure-sql-db-samples

Samples and Best pratices to use Azure SQL DB to build modern, mission critical application, with ease and confidence

AzureFunctionUploadToSQL

Azure function to upload a CSV file to Azure SQL automatically via Azure Blob Store

practical-azure-sql-db-for-modern-developers

Code samples for the book "Practical Azure SQL Database for Modern Developers"

locust-on-azure

Running distributed Locust.io on Azure Container Instances

bcnet-2020

Demo code used at the BC .NET User Group Meeting 2020

apache-drill-azure-blob

A simple way to run Apache Drill against Azure Blob store

RealTime-PowerBI

Real-Time Dashboard with Power BI

non-scalar-uda-transitive-closure

Transitive Closure Clustering with T-SQL, SQLCLR and JSON

TSQLQueryBenchmark

SQL Server Query Benchmark

docker-anaconda

Several ways to have Anaconda running on Docker containers

docker-python-nanoserver

Run python in a nanoserver container

zeppelin-sqlserver-docker

Dockerized Apache Zeppelin with SQL Server and SQL Azure support

devweek2016

Demos of my talks at DevWeek 2016

Jupyter Notebook

SSISAdapterForPowerBI

SSIS adapter for Power BI REST api

ms-pm

Being a PM in Microsoft

PNWSQL-201610

SQL Server 2016 Temporal Table Demos

aoc-2022

Advent of Code 2022

appdev2017

Demos used during my "When indexes are not enough" webinar for PASS Application Development Virtual Group

azure-data-conference-2022

Demos used at the Azure Data Conference 2022

cloud-day-2020

"Serverless Scalable Back-End API with Hybrid Data Models" Samples

sql-bits-2023

SQL Bits 2023 Demos

sqlsat613

Demos of my sessions at SQL Saturday 613 (http://www.sqlsaturday.com/613)

ollama-playground

Playground with Ollama and Azure SQL

cloud-db-perf-test

Test cloud database performances

happy-birthday-ugidotnet-2016

Demo used at the "Happy Birthday UGIDotNet" 2016 event

dab-azure-friday

azure-script

Azure Script: a script language to make deployment and management of Azure resources as simple and intelligent as possibile.

dab-microsoft365-demo

Sample demo for using Data API builder with Microsoft 365