Chatbot for future conversation – Installation

June 23, 2018 Leave a comment

We all must have come across this word recently. It is part of AI application where most of giant internet companies using to chat with customer or providing this platform as a service (reference).


1.  –  Microsoft
2.  – Facebook
3.  – Google
4. Watson Assistant- IBM

Now adding my perspective towards data privacy. I don’t like companies saving my information and analyze and used against me in terms of marketing. But, good news is that Europe has introduced General Data Protection Regulation (GDPR) in 2018 to protect consumer’s data. They started this new path in internet world to protect customer data before data breach occured. I would recommend this types of law to implemented in other countries.

So, keeping that in my mind. I look for alternative solution in golden world Open Source tools.

The purpose of this blog is to setup the RASA NLU and bug fix system after installation.

Tools – installation

  1. Python 3.x –
  2. pip install rasa_nlu
  3. Check or install “Common Tools for Visual C++ 2015 or 2017”
  4. pip install rasa_nlu[spacy] —
  5. python -m spacy download en_core_web_md
  6. python -m spacy link en_core_web_md en
  7. When install dependency package all at once or when needed.
    1. pip install colorlog —
    2. pip install pypiwin32 —

Now, the system is ready to train data and setup chatbot.

Getting started

We can create chatbot for any domain of our choice. But, we need initial data to train our system with NPL and ML using Python modules or other tools or services.

Sample Data

Data is important for chatbot. It is like teaching baby. You can download sample demo data from this link

In the next blog post I will talk about data training, client and Server interface to do simple chatbot.



Categories: SQL Server

Evolution of Database in short picture

March 7, 2018 Leave a comment


Growth of data is in exponential rate and storage become cheaper. So the data management evolves with it.

Categories: SQL Server

Why do we need SQL Server 2017

September 18, 2017 Leave a comment

SQL Server 2017 (Linux)

DIM (Data is Money) is the latest or at-least a new business model. Microsoft did a fantastic job in implementing SQL Server in Linux as a cross platform. This strategy has surprised Microsoft community and overturned the way we think about Microsoft database management products. In this story, I am going to talk about the SQL Server 2017 on Linux.


SQL Server 2017 runs on Windows, Linux, Docker containers. It has key features that attract many industry leaders for these features.

  • Cost
  • Security
  • Performance
  • Simplicity
  • Flexibility
  • Everything built in


First of all, I would think about product cost. Because, there are many technologies available as an open source. Linux is open source and free for commercial use. So, we can remove Operating system license cost from the investment. Linux can run on any hardware and we can have affordable hardware to setup a business. It reduces the infrastructure cost. Well, With these two cost reduction options, it would possible to achieve ROI in short period of time.

  • With SQL Server 2017 on Linux, it’s possible to realize a lower total cost of ownership (TCO) and quicker return on investment (ROI)
  • Expand your hardware options and achieve ROI more quickly with Linux.
  • Mobile BI anywhere at a fraction of cost.


Next, with the current digital environment, we are worried about data protection. Past several yearly we have been hearing about data breaches in different sectors. Some events are unavoidable but we need to take maximum effort to protect it. In this way, we need to give preferences to security. So, what kind of security does SQL Server have?

SQL Server 2017 – Data Sheet

  1. Fewest NIST vulnerabilities over last 7 years
  2. Encrypt data at rest and in motion with Always Encrypted
  3. Dynamic Data Masking conceals sensitive data
  4. Control access to database rows with Row-Level Security


We do not have much time to wait for a task to complete. It is due to heavy competition and vast amount of data to process to get serious decision quickly. Such as, Weather forecast, Medical diagnosis and real-time sale performance during holidays, etc. So, what does SQL Server 2017 have?

From Data Sheet:

  • Speed query performance without tuning using Adaptive Query Processing
  • Faster transactions with In-Memory OLTP and up to 100x faster analytics with in-memory Columnstore
  • Real-time operational analytics when you combine inmemory technologies


Who do like to spend lot of man hours for just migrating database from one platform to others. With SQL Server 2017, we can transfer database from Windows to Linux easily by taking backup and restore. For security, we can use encrypted backup with master key.



This word “Flexibility” is more complicated then it looks. Because, it has to satisfy every audience from every perspective. SQL Server 2017 is also a flexible platform to connect with any application. Also, it gives various flexibility for language of your choice, on the platform of your choice, on premises or in the cloud.

Language of your choice:

  • C#, Java, Ruby, or another coding language

Platform of your choice:

  • Support for Windows and Linux operating systems and Docker containers


  • Any cloud, any platform including OpenShift, Red Hat OpenStack, Kubernetes, Docker Swarm and Pivotal

Everything built-in:

SQL Server 2017 is a complete package that can be used for data management with 99.99% availability, simplicity, security, efficiency, affordability and reliability. Also, features like data compression, columnstore, partitioning, high availability, and disaster recovery.

Categories: SQL Server

Gartner – Operational Database Management Systems

September 13, 2017 Leave a comment

I recent got to see the gartner’s magic quadrant for Operational Database Management Systems (ODMS). It is an interesting chart to visualize different companies and its market position in ODMS. There are 4 categories given in the chart with company’s position.

  • Niche Players –
    1. Couchbase
    2. MapR
    3. Clustrix
  • Visionaries
    • None
  • Challengers
    1. MarkLogic
    2. MongoDB
    3. EnterpriceDB
  • Leaders
    1. Microsoft
    2. Oracle
    3. SAP

Image credit:


For more details download the document from this link

Categories: SQL Server

Gartner Magic Quadrant BI and Analytics

February 18, 2017 Leave a comment

It is very interesting to see a consistent growth of Microsoft in BI and Analytics environment. Lets see Gartner’s Magic Quadrant BI and Analytics graph so several years.











We will revisit next year to see what-else has changed. By the way, what is your favorite tool.

Categories: Application, SQL Server, Tools

Can you identify file type without extension

November 17, 2016 Leave a comment

We may come across this situation when we get a file with out extension or given incorrectly. But, we have options in some operating system that will search and match the program associated with the unknown file type.

I had situation recently, a file with incorrect extension. I was trying to open the file in text edition (binary mode) to identify the file type manually. But, I could not do it simple reading the file content.

Finally found a tool that does what i was trying to do manually. This is light weight tool with easy to update external data dictionary for file finger print matching data.

Utility software details:


is free for personal / non commercial use.


Direct download:

TrID is free for personal / non commercial use.

 Win32  TrID v2.24, 47KB ZIP(PGP sig)
 Linux/x86  TrID v2.24, 357KB ZIP(PGP sig)
 Linux/x86-64  TrID v2.24, 421KB ZIP(PGP sig)
 TrIDUpdate v1.00, 1KB ZIP (Python 2.7.x required)
 TrIDDefs.TRD package, 982KB ZIP (7647 file types, 15/11/16)

SQL Server 2016 – Arrived

June 3, 2016 Leave a comment

This is a good news for the SQL Server community for this year. Microsoft has released SQL Server 2016 on June 1st  2016.

You need to sign-up to download the evaluation edition from this web page.

There are many exciting features in this version. Now, SQL Server has moved to the top of the database management servers ladder.



Categories: SQL Server
%d bloggers like this: