Extracting Data from Multiple Excel sheet using Multiple Tags

Follow the steps given here to know exactly how to extract data from various Excel sheets using multiple tags.

Step 1 Create few samples with Excel with DimCustomer or DimEmployee from Adventures Works Database. Continue reading »

Tags: Microsoft BI

Installing Master Data Services

Find the step by step procedures on installing the master data services given here.

Step 1: Click on the Master Data Services folder present in All Program — > Microsoft SQL Server 2012

Continue reading »

Tags: Microsoft BI

Using MonoGame for 2d Game Development

In this blog We’re going to cover MonoGame development for Windows8 apps (Metro apps).

What is Monogame

Monogame is a component used by game developers to make their games. Monogame is an open source implementation of Microsoft XNA 4 Framework. It can target more platforms, including Android, iOS, Linux, Mac, and Windows 8. On the other hand, its development is a bit more fragmented and there are some bugs & features not available. Overall, it’s a pretty good project and alternative to XNA.

(Microsoft XNA is a set of tools with a managed runtime environment provided by Microsoft that facilitates game development and management. XNA is based on the .NET Framework. It can target several platforms like “Windows”,” Windows Phone “and the” Xbox”) Continue reading »

Tags: Technology

Maps for Application

I still remember my school days when I used to struggle to draw the train route between the cities on a map of my country. Now things are entirely different, I can draw air routes between the cities within my country as well as those which are located on the other side of the globe, within a few seconds, using web mapping tools. With today’s mapping applications, one can navigate to any part of the world desired.

The potential of web mapping APIs goes beyond the above mentioned functionality, it could also be used for the safety and security of your loved ones. We had one such scenario where parents were enabled to track their child’s / children’s whereabouts all the time with the help of a system & web mapping API. Implementing such functionalities are made easier by a web mapping service application and technology providers like Google (Google Maps) & Microsoft (Bing Maps). Continue reading »

Tags: Technology

Problem with SSIS – OLEDB Destination – When there is a Composite Key in Table

Few Months back, we were working on a task with respect to OLEDB Source and Destination. We extracted data from Heterogeneous Source and dumped the data into SQL Server Database tables. Everything was going fine. Few days later, we added a Composite Key for the table columns, which was then deployed in the production environment.

After a while, we noticed that few rows [Almost 20 Million Rows 🙂 ] were missing from the box and so we decided to analyze the reasons behind it. We were too curious as to what was happening in the database after applying the Composite Keys. So we took a sample data as shown below and went on doing an RND as follows. Continue reading »

Tags: Microsoft BI