What is Node.js?

• Event-driven, non-blocking I/O model that makes it lightweight and efficient
• Uses google's  Chrome's V8 JavaScript engine 
• JavaScript which runs on your computer
• Node.js' package ecosystem, npm, is the largest ecosystem of open source libraries in the world

Declarative vs imperative programming

Declarative :

• Write code what you want but not  necessarily how to get it (Declare the desired results but not the step-by-step)
• A style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.
• Minimize or eliminate the side effects by describing what program should accomplish 
• How is left to the problem implementation
• Only thing a function can do is calculate something and return it as a result.

   Declarative languages include, SQL, React, Functional programming like haskell

Functional Prgramming

•  In purely functional programming you don't tell the computer what to do as such but rather you tell it what stuff is
• if a function is called twice with the same parameters, it's guaranteed to return the same result. That's called referential transparency and not only does it allow the compiler to reason about the program's behavior, but it also allows you to easily deduce (and even prove) that a function is correct and then build more complex functions by gluing simple functions together

var results = collection.Where( num => num % 2 != 0);

Imperative :

• Tell the compiler what you want to happen step by step
• Java, C, C#  is imperative
• Main method of computation is assignment variable
• Implements algorithms in explicit steps.

Machine learning

-Is a science of getting computers to learn, without being explicitly programmed

-Grew out of work in AI

-New capability of the computers

Supervised Learning ML

Supervised learning is a type of machine learning algorithm that uses a known dataset (called the training dataset) to make predictions. 

The training dataset includes input data and response values. From it, the supervised learning algorithm seeks to build a model that can make predictions of the response values for a new dataset. A test dataset is often used to validate the model. Using larger training datasets often yield models with higher predictive power that can generalize well for new datasets.

Supervised learning includes two categories of algorithms:

Intents, Entities, and Model Training LUIS

One of the key problems in human-computer interactions is the ability of the computer to understand what a person wants, and to find the pieces of information that are relevant to their intent. 

Ex : " Get the stock price for msft". In this case the intent is to get the stock price of the company and entity is msft.

Intent -> What we want to do.
StockPrice
IstheMarketUpOrDown
RepeatLastStock

Entity -> an object that exists and is distinguishable from other objects

Overview of LUIS ( Language Understanding Integration Services )

Is a service provided by Microsoft cognitive services, Formally known as project Oxford.They are a set of intelligent services with the vision of democratizing machine learning. 

MessageController in Bot Framework

  The Message Controller is the meat of  Bot application

• It resides in an asp.net application
• It can accept a message and return a message

The message controller monitors the different activities of the User

The default type of activity is is Activity.message. 

Azure app services

 Azure App Service, a cloud service that bundles together several existing ones: Azure Websites,  Azure Mobile Services, and Azure BizTalk Services 

• Provides services that can be used to build many applications
• Offers these services as capabilities that can be used without having to worry about plumbing servers
• Enables us to focus on adding business values

Advantages of Microsoft Azure

• Ease of use 
• We do not need physical hardware
• Certain cloud services do not need servers
• Scalability. We can easily scale up or down based on the need
• Pay for what we use

Getting started with Microsoft bot connector

The Microsoft Bot Connector is a communication service that  helps you connect your Bot with many different communication channels (Skype, SMS, email, and others)


If you write a conversational Bot or agent and expose a Microsoft Bot Framework-compatible API on the Internet, the Bot Framework Connector service will forward messages from your Bot to a user, and will send user messages back to your Bot.

Microsoft BOT Framework

• Microsoft Bot Framework is a comprehensive offering to build and deploy high quality bots for your users to enjoy in their favorite conversation experiences.
• Bot Framework provides just what you need to build, connect, manage and publish intelligent bots that interact naturally wherever your users are talking – from text/sms to Skype, Slack, Facebook Messenger, Kik, Office 365 mail and other popular services.
• Microsoft bot framework has the ability to detect the language that the user is typing and it can translate the text to other languages 

Bots , Agents of Bots, explained

  Bot

• A bot is a software that is designed to automate tasks that would be performed by a human like booking a flight , scheduling an appointment or ordering a pizza.
• A bot can receive a text string and perform some task and then send response as a text string
• They are service specific. example we can have a bot for a coffee chop or a bot for yelp.

Simple component angular 2

• Components are simply directives that are always associated with a direct template
• Component is nothing but a type script class
• An Angular application is a tree of Angular components

Setup angular 2 environment

• Prerequisite: Install Node.js
• Step 1: Create the app’s project folder and define package dependencies and special project setup
• Step 2: Create the app’s Angular root component
• Step 3: Create an Angular Module
• Step 4: Add main.ts, identifying the root component to Angular
• Step 5: Add index.html, the web page that hosts the application
• Step 6: Build and run the app
• Make some changes to the app

 

Advantages of typescript

1.  Like babel typescript uses a compiler to write ES5 to the compiler
2. Typescript is a super set of ES6. 
3. Typescript adapts emerging standards like Decorators  
4. Class and Module Support
5. Static Type-checking
6. Build-in Support for JavaScript Packaging
7. Syntax Similarity to Our Backend Languages (Java)

Language support for Angular 2

Advantages of languages with type support

• Interfaces and Types
• Helps detect error when we type
• Helps to gives us hints

Pipe character angular 2

A pipe takes in data as input and transforms it to a desired output.

Pipe character "|" helps to display the content

Examples of pipe

import { Component } from 'angular2/core';

@Component({
  selector: 'my-story',
  template: `
    <h3>{{story.name}}</h3>
    <h3 [innerText]="story.name"></h3>
    <div [style.color]="color">{{story.name}}</div>
    {{story| json}}
  `
})
export class StoryComponent {
  story = { id: 100, name: 'The Force Awakens' };
  color = 'blue';
}

Custom pipes

This custom pipe is used to perform sorting

Note:For the PipeTransform there is only one interface

Using the custom pipe in a template

Cognitive technologies

Cognitive technologies are products of the field of artificial intelligence. They are able to perform tasks that only humans used to be able to do.

Important Cognitive technologies 

Practical UX tips

Advantages of  UX

• Great user experience
• Meets the customer needs
• Easy to use
• Enjoyable to use
• Simple

UX!=UI (not the same as the user interface or UI)UX!=Usability
UI is part of UX

Practical tips and tricks for UX

• Alignment

• The placement of elements such that edges line up along common rows or columns, or bodies along a common center (Usually involvment in left, right alignment if the elements)

        

Frame Box - Lightweight online tool for creating mockups

Show what you need in 3 easy steps:

1. Sketch frame using UI units
2. Save it and get a link to created frame
3. Send a link to your companion

URL :  http://framebox.org/

  Create basic mockup diagram

Installing and updating all programs at once using Ninite

Advantages

• Install and Update all your programs at once
• Always Up-to-date (Do not have to watch for updates) Their bots do that
• No Tool Bars
• No clicking Next
• Multiple selection for picking apps

URL : https://ninite.com/

Save requests and organize your APIs into Collections using Postman

Add app to your chome browser by clicking this link

https://www.getpostman.com/

Advantages of using Postman

• Create and send any HTTP request using the awesome Postman request builder.
• Write your own test cases to validate response data, response times, and more!
• Easily enter parameters 

Simple steps for using animate.css

you need reference to animate.css . You can download the file from
Animate css repository

CSS class
In this example below I am using bounceIn and flipInx feature

.ng-hide-remove {
    -webkit-animation: bounceIn 2.5s;
    animation: bounceIn 2.5s;
}
 
.ng-hide-add {
    -webkit-animation: flipInX 2.5s;
    animation: flipInX 2.5s;
    display: block !important;

Default file extension in file explorer

We can default the file types in file explorer as shown below

1) Select the files and then hit alt
2) Once you select alt -> Tools--> Folder Options

Simple steps to use ng-route in angular 1

•  Include a reference to ng-route file (angular-route.min.js)
•  Add ng-route as module dependency (In app.js file)
•  Add a ng-view directive

Aurelia: Simple App Development on Every Platform (Slides from Boston Code camp)

https://drive.google.com/file/d/0B-WwOnvCTkDuTzhYSTY1djlKWkU/view

Simple steps for scaling performance

Tools for Aurelia

Top 5 Features of Aurelia

Create script task in SSIS

One of the efficient way to extend SSIS control flow is to create  script task. 

Need : We can perform custom task that cannot be performed using default task

Steps involved

1) Select the script task from the toolbox

 

Running angular applications in IE 8 and other browsers

We recently published a angular application to production. There was couple of tickets created with "Application failing in Enterprise mode in IE" . 

Fetch all files from FTP or DFTP Site

There could be business need where we need to get all the files from the secured or non secured servers. which includes folders and sub folders. This can be done easily by using Task factory secured FTP site.

The steps involved in this task

1) Fetch the Task factory task from the toolbox

Add Expressions in SSIS

We can easily add expressions for our connection manager. This can be achieved as shown below

Steps involved

1) Select the connection manger which needs to have an expression

Batarang chrome extensions for debugging angular applications

As we are using angular to develop SPA applications, this chrome extension would be helpful for debugging.

You can add this to your chrome extension from here.

https://chrome.google.com/webstore/detail/angularjs-batarang-stable/niopocochgahfkiccpjmmpchncjoapek?hl=en-US

Advantages.

1   1) We would be able to visually select the scope

PGP Tutorial For Windows (Kleopatra – Gpg4Win)

The security of your data is the most important thing. The focus of Gpg4win is on secure file and email encryption as well as good usability.

Part 1.  Installing Kleopatra 

1. Head on over to https://gpg4win.org/download.html. We want the full version, so click ‘Gpg4win 2.2.3’

Custom Csv import for angular UI-Grid

We can have a customized csv import for angular UI-Grid.

Integrate task factory in BIDS

Task Factory offers essential, high-performance components and tasks for SSIS that eliminate the need for programming. With over 50 components, Task Factory can increase productivity, improve performance and increase your ROI.

Responsive Image generator

Have you ever wondered how to create one image and then generate images for different devices?

We can use responsivebreakpoints.com is pretty awesome. Generates all the images required and spits out the picture code

Encryption in SQL Server

Encryption

Encryption hierarchy is marked by three-level security. These three levels provide different mechanisms for securing data across networks and local servers. 

Data conversion in SSIS package

When we create a SSIS package and run the package after mapping the columns we might receive error saying "Cannot Convert between Unicode and Non Unicode String Data Type" 




This can be resolved using Data conversion

Solution for SSIS Error code 0xC0209303

When we try to load data from MS-Access to SQL server using SSIS we can get an error with code "0xC0209303"

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered

 

Add active class to HTML in ASP.Net MVC

When we use bootstrap nav-bar in asp.net MVC,  we need to dynamically update the selected item class as active. By default this feature is not available in ASP.Net Mvc. 

       <ul class="nav navbar-nav">
             <li class="active">@Html.ActionLink("Home", "Index", "Home")</li>
             <li>@Html.ActionLink("About", "About", "Home")</li>
             <li>@Html.ActionLink("Contact", "Contact", "Home")</li>
       </ul>

SQL-RD Data driven schedule

Automation Schedule

•  Business process automation arm of SQL-RD
•  Enable to run multitude of different task
•  These task can be scheduled before and after a report schedule

 Ex we can print a document before sending Reports

SQL-RD Dynamic schedule

Need: 

To run SSRS reports against multiple recipients or each individual needs to get a unique flavor of the same report

Note: We do not have to use subscription for each individuals

Resolve issue with ASP.net session timeout with report viewer

Issue: asp.net session error in Iframes within report viewer as shown below.

SQL-RD Single and Package schedule

Single Schedule

 Scheduling SSRS reports for singe schedule delivery