Advertisements

Archive

Archive for the ‘Business Intelligence’ Category

PowerShell for Creating a Database Login

July 14, 2013 2 comments

This is PowerShell tutorial script to walk you through how to create database login with the help of PowerShell and SMO. Read more…

Advertisements
Categories: Business Intelligence

MongoDB Vs Neo4j GraphDB. It’s your Case Study..!!

April 30, 2013 2 comments

I was working on one Social Media Streaming proof of concept where problem statement was which NoSQL Database is best fit for social media network. I’m big fan of MongoDB and I was planning to use MongoDB in this case but I wanted give another shot for other NoSQL databases where I chose Neo4j Graph Database. Read more…

Social Media and Sentiment Analysis

January 23, 2013 1 comment

Recently sentiment analysis has gained much attention and interest to huge proportions which is also being fuelled by the many social media platforms mushrooming each day. And sometimes we actually do not understand how this is going to help? But before this we need to understand what sentiment analysis is and how it really works? Read more…

Finding and removing hidden characters in your data using dynamic T-SQL

October 5, 2012 1 comment

Today I was struggling with one issue which keeps my SSIS package failing in one of the data imports.And came across one of the blog. The problem was a conversion problem from varchar type to float and I kept getting the following error:

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.

However, my data was numeric I checked it many times… or was it really 100% numeric?

Apparently there are some crazy hidden characters that you cannot see when you just glimpse at data. One of the best ways to find out if your data has some non-numeric characters in it is by running a simple query.

Read more...

Power Pivot and Power View now available in Excel 2013.

August 1, 2012 1 comment

In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and Power View add-ins are installed by default. But they are not automatically enabled.  You have to do some menu/dialog box acrobatics to turn them on, but it’s a one-time set-and-forget requirement.

If you’d like to try it yourself, click through File|Options|Add-Ins|Manage COM Add-Ins|Go… and then enable the add-ins by checking them off and clicking OK.

Read more…

SQL Azure Reporting.

SQL Azure Reporting
SQL Azure Reporting enables developers to enhance their applications by embedding cloud based reports on information stored in a SQL Azure database.  Developers can author reports using familiar SQL Server Reporting Services tools and then use these reports in their applications which may be on-premises or in the cloud.

Get a comma separated list in SQL & MDX.

To get a comma separated list in SQL as well as in MDX use below queries.
%d bloggers like this: