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 →

There is a stored procedure that must be run by only one user at a time. How do to I prevent multiple users from running the stored procedure at the same time?
Solution
SQL Server provides an application manageable lock mechanism through the sp_getapplock / sp_releaseapplock pair of system stored procedures. They provide a way for application Read More →

Excel files can be read using the Python module Pandas. In this article we will read excel files using Pandas.
Related course:
Data Analysis in Python with Pandas
Read Excel column names
We import the pandas module, including ExcelFile. The method read_excel() reads the data into a Pandas Data Frame, where the first parameter is the filename and the Read More →

Follow these instructions.

Enable Multiple RDP Sessions
Log into the server using Remote Desktop.
Open the start screen (press the Windows key) and type gpedit.msc and open it
Go to Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Connections.
Set Restrict Remote Desktop Services user to a single Remote Desktop Read More →

Beginning back with SQL Server® 2005, Microsoft® integrated the .NET runtime into the database engine. This runtime engine is called the SQL Server Common Language Runtime (CLR), and is commonly referred to as SQLCLR. SQL Server CLR enables you to extend the capabilities of the SQL Server database engine with the rich programming environment of Read More →

Sometimes you can get “VT-x is not available. (VERR_VMX_NO_VMX)” error if you are trying to start x64 bit virtual machine in VirtualBox.

Failed to open a session for the virtual machine Windows 10 TP.
VT-x is not available. (VERR_VMX_NO_VMX).
Result Code: E_FAIL (0x80004005)
Component: Console
Interface: IConsole {8ab7c520-2442-4b66-8d74-4ff1e195d2b6}
 
 
There are three most common reasons for this error:

Your CPU doesn’t support VT-x Read More →

http://www.sqldts.com/272.aspx

These are custom tasks and tools.

Transfer Packages Sample Application 3 Sep 2002
SQLDTS.com Article: Transferring DTS Packages

41795 Hits

DTS ActiveX Helper 26 Apr 2005
A simple COM component which wraps the GetExecutionErrorInfo method using variant types for returning data, compatible with ActiveX Script Tasks. Full source code included (VB6).

11196 Hits

SQLDTS FTP Read More →

Use this Stored Procedur for create script from all job in one database :
And for all DataBase in SQL Server use this Stored Procedure
Maintain files of sql for each table then use cygwin to run a shell script that cats them together then run it on the server.
Code source of this article : https://stackoverflow.com/questions/3361163/automatically-create-scripts-for-all-sql-server-jobs