Netwoven Tech-talk

Category Archives: Big Data and Analytics

SQL Server 2016 In-Memory OLTP

Posted by
Date : April 8, 2016

With the release of SQL Server 2016 RC0, last month, I thought it would be pertinent to review the New Features and Enhancements being made to our favourite Database Server. This is the first in a series of blogs where I would discuss the changes that are being released as part of SQL Server 2016. In this post – we will review the new features and enhancements that are being made to In-Memory OLTP. Continue Reading…

Install PostgreSQL for Windows and restore database using GUI

Posted by
Date : November 17, 2015

PostgreSQL is of the most popular open source database around the market for quite some time. Though designed for UNIX/Linux platform, setting up a PostgreSQL for Windows server platform might be a challenge at time.

Here is a simple tutorial to help you get started with creating a Database Server free. Continue Reading…

Notes from Microsoft Convergence 2015

Posted by
Date : March 23, 2015

I just returned from Convergence and while it was fresh in my mind, I decided to write a blog post on the event.  For some of you, who may not know Convergence, it is the Microsoft annual event for its business products – Dynamics CRM, GP, AX, NAV and SL.  My focus in the event was primarily on Dynamics CRM, Dynamics Service and parature, Dynamics Marketing, and Power BI.

Continue Reading…

Enabling Power BI in O365 (SharePoint Online)

Posted by
Date : October 22, 2014

Is your organization currently using SharePoint Online? Are you planning to leverage the power of Microsoft’s BI to power your organization’s analytical needs or have just purchased licenses for Power BI? If the answer is “Yes” to either of the above two questions, then it is very important to understand how these two solutions from Microsoft talk to each other to provide a robust collaborative environment.

Continue Reading…

Microsoft and Salesforce – Part 3

Posted by
Date : October 20, 2014

Dreamforce 2014 Announcement – Analytics Cloud from Salesforce.com

I continue my series on Microsoft and Salesforce Collaboration. In this article, I will be discussing about a latest analytical offering from Salesforce. If you would like to read my previous posts on the Microsoft and Salesforce collaboration, you can go to the following links:

What is Analytics Cloud and Wave?

Analytics cloud is the latest offering from Salesforce announced last week as their analytical platform. It is based on a company that Salesforce bought about 2 years ago. Salesforce also hired a former co-founder of Business Objects to lead the development of this platform.

Wave is the platform on which the analytics cloud is built. Continue Reading…

How to install .Net Framework 3.0/3.5(NetFx3) on Windows Server 2012

Posted by
Date : September 10, 2014

Introduction

Installing windows server and .NET Framework has always been a kids stuff till we realized that Server 2012 R2 release onwards, it is not available by default to be added from ‘Add Remove Windows Server Role Features’. Hence like all, I was stumped at installation of SQL server 2012 which requires Netfx3 and so will the problem appear for any application that depends on .Net Framework 3.5 Continue Reading…

Using SSIS ‘Data Profiling Task’ Control for data validation

Date : April 30, 2014

Overview

When you are involved in an SSIS project, you have to collect data from various data sources like from databases, flat files, excel files etc. Generally when you find that the data is not well formed, it’s of very poor quality for analyzing, lots of data are missing etc. etc. So before starting the project and designing a database structure if we can analyze the data properly it will be helpful for us to design our data ware house properly.

SSIS provides a wonderful control ‘Data Profiling Task’ to accomplish this task that helps us to provide the Meta information of how the data is organized.

Continue Reading…

HBase – Overview of Architecture and Data Model

Posted by
Date : October 10, 2013

In this article, we will briefly look at the capabilities of HBase, compare it against technologies that we are already familiar with and look at the underlying architecture. In the upcoming parts, we will explore the core data model and features that enable it to store and manage semi-structured data.

Introduction

HBase is a column-oriented database that’s an open-source implementation of Google’s Big Table storage architecture. It can manage structured and semi-structured data and has some built-in features such as scalability, versioning, compression and garbage collection. Since its uses write-ahead logging and distributed configuration, it can provide fault-tolerance and quick recovery from individual server failures. HBase built on top of Hadoop / HDFS and the data stored in HBase can be manipulated using Hadoop’s MapReduce capabilities. Continue Reading…