A collection of premium SSIS components to enable greater developer productivity and increase the power of SSIS.
The HTTP/Web Services components is a grouping of SSIS add-on components from the SSIS Productivity Pack which facilitate working with HTTP and SOAP or REST based web services within SSIS.
There are currently 6 SSIS components within this category:
HTTP Connection Read More →

Free SQL Server video tutorial

Connecting to SQL Server
Working with databases
Creating and working with tables
Default Constraint
Cascading referential integrity
Check Constraint
Identity Column
Retrieving identity column value
Unique key constraint
All about select statement
Group By
Basic Joins
Advanced Joins
Self join
Different ways to replace NULL
Coalesce function
Union and Union All
Stored Procedures
Stored Procedures with output parameters
Difference between output Read More →

SQL Server APPLY operator has two variants; CROSS APPLY and OUTER APPLY

The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table expression. In other words, the right table expression returns rows for the left table expression match only.
The OUTER APPLY operator Read More →

Code Source : https://github.com/BrandonJoffe/home_surveillance
Smart security is the future, and with the help of the open source community and technology available today, an affordable intelligent video analytics system is within our reach. This application is a low-cost, adaptive and extensible surveillance system focused on identifying and alerting for potential home intruders. It can integrate into an Read More →

What is Streaming?
Streaming is a technique in which the server provides the response to a request in chunks. I can think of a couple of reasons why this might be useful:

Very large responses. Having to assemble a response in memory only to return it to the client can be inefficient for very large responses. An Read More →

Dowload last release : https://github.com/aelassas/Wexflow/releases/tag/v2.4
Features
Wexflow is an open source extensible workflow engine with a cross-platform manager and designer. The goal of Wexflow is to automate recurring tasks without user intervention. Wexflow aims to make automations, workflow processes, long-running processes and interactions between systems, applications and folks easy, straightforward and clean.
Wexflow provides the following features:

Sequential workflows.
Flowchart workflows.
Workflow events.
A cross-platform application Read More →

Neural Networks and Deep Learning is a free online book. The book will teach you about:

Neural networks, a beautiful biologically-inspired programming paradigm which enables a computer to learn from observational data
Deep learning, a powerful set of techniques for learning in neural networks

Neural networks and deep learning currently provide the best solutions to many problems in Read More →

What is a Neural Network ?
To get started, I'll explain a type of artificial neuron called a perceptron.
Perceptrons
were developed in the 1950s and 1960s by the scientist Frank Rosenblatt, inspired by earlier work by Warren McCulloch and Walter Pitts. Today, it's more common to use other models of artificial neurons - in this book, and Read More →

A curated list of notable ETL (extract, transform, load) frameworks, libraries and software.

Awesome ETL

Workflow Management/Engines
Job Scheduling
Python
Ruby
Go
Java
Talks/Articles
Cloud Services
Big Data (Hadoop Stack)
ETL Tools (GUI)

Related Lists

awesome-pipeline

Workflow Management/Engines

Airflow - "Use airflow to author workflows as directed acyclic graphs (DAGs) of tasks. The airflow scheduler executes your tasks on an array of workers while following the specified dependencies. Rich command Read More →

Cardinality
Minimum No. of tables

1:1 cardinality with partial participation of both entities
2

1:1 cardinality with total participation of atleast 1 entity
1

1:n cardinality
2

m:n cardinality
3

 
Note: This is a general observation. Special cases need to be taken care. We may need extra table if attribute of a relationship can’t be moved to any entity side.
 
Keys of a relation: There are Read More →

What are advantages of DBMS over traditional file based systems?
Ans: Database management systems were developed to handle the following dif?culties of typical ?le-processing systems supported by conventional operating systems.
1. Data redundancy and inconsistency
2. Dif?culty in accessing data
3. Data isolation – multiple ?les and formats
4. Integrity problems
5. Atomicity of updates
6. Concurrent access by multiple users
7. Security Read More →