Scripts those can be used by SQL Server DBAs and SQL Server Developers on daily basis.
Data Analysis / Data Validation / Data Cleansing Scripts
How to Search in all Columns for all tables in a database for Date Value in SQL Server
How to Find Percentage of Null Values in every Column of all the Tables in … Read More →
If you are looking for the real time scenarios/ Examples or type of work developer perform on Job as ETL developer. You are looking at the right place. The videos explain different scenarios those can answer your so many questions and also helpful if you are going for SSIS/ETL developer interview.
Starting with SSIS
How to Create … Read More →
In the following example we will looking for the LOCAL FAST_FORWARD parameter in to the declaration of cursor code.
Specifies that the scope of the cursor is local to the batch, stored procedure, or trigger in which the cursor was created. The cursor name is only valid within this scope. The cursor can be referenced by … Read More →
Free SQL Server video tutorial
Connecting to SQL Server
Working with databases
Creating and working with tables
Cascading referential integrity
Retrieving identity column value
Unique key constraint
All about select statement
Different ways to replace NULL
Union and Union All
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 →
OpenFace is a Python and Torch implementation of face recognition with deep neural networks and is based on the CVPR 2015 paper FaceNet: A Unified Embedding for Face Recognition and Clustering by Florian Schroff, Dmitry Kalenichenko, and James Philbin at Google. Torch allows the network to be executed on a CPU or with CUDA.
Crafted by … 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 →
SQL Server Execution Plans, 3rd Edition
by SQL Server MVP Grant Fritchey
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how … Read More →
Dowload last release : https://github.com/aelassas/Wexflow/releases/tag/v2.4
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:
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.
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.
Big Data (Hadoop Stack)
ETL Tools (GUI)
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 →
So you need to perform simple Extract Transform Load (ETL) from different databases to a data warehouse to perform some data aggregation for business intelligence. There are alot of ETL products out there which you felt is overkilled for your simple use case.
Here I am going to walk you through on how to Extract data … Read More →
Q. What is SSIS?
SSIS was first introduced with SQL Server 2005, which was the next generation of SQL Server software after SQL Server 2000. SSIS is an ETL tool that handles data Extraction, Transformation and load. In addition, it can handle more tasks besides the ETL tasks such as data profiling, file system manipulation etc…. … Read More →
Minimum No. of tables
1:1 cardinality with partial participation of both entities
1:1 cardinality with total participation of atleast 1 entity
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?
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.
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 →
We can use Python urllib to get website content in python program.
We can also use it to call REST web services.
We can make GET and POST http requests.
This module allows us to make HTTP as well as HTTPS requests.
We can send request headers and also get information about response headers.
Response read() method returns the … Read More →