MongoDB Vs Neo4j GraphDB. It’s your Case Study..!!
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
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
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.
Power Pivot and Power View now available in Excel 2013.
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.
SQL Azure Reporting.
Get a comma separated list in SQL & MDX.
Sequence Vs Identity – SQL Server 2012
What is sequence?
Sequence is a newly introduced database object in Sql Server 2012, Sequence is used to generate a sequence of numeric values in either ascending or descending order, along with an option to have the minimum and maximum values and also allows to cycle and cache for better performance.
Change the Look & Feel of the Report Manager.
Why we need to change the Look & Feel of the Report Manager?
Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once open the Report Manager. Read more…
Introduction and Installation of Data Quality Services for Denali
Data Quality Services (DQS) enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling
DQS is not installed automatically with Microsoft SQL Server Denali CTP3. You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…