Unable to Add Data Connection on Visual Studio 2013 after SQL Server 2014 Upgrade


You uninstall SQL Server 2012 and install a new SQL Server 2014 for your development machine. However after the installation of SQL Server 2014 you get an error like below

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=

And you can’t add the data connection on Visual Studio 2013



This is because you remove the entire installation of SQL server 2012. Visual Studio 2013 need the installation of some of SQL Server 2012 library


Simply download the latest package of this library to fix the problem

    You done !

OneDrive for Business Consumes a lot of Space on Office Cache


When you sync your OneDrive for Business from Office 365 Pro plus / Office 2013. It consumed a same amount of disk that you are synhronized to the cloud. For example you have 2 GB documents on the cloud, if you sync it into your local files you need 2 GB + Office Cache files (2 GB). The other problem makes your Office run slower than before, because it always sync on the cloud


This because the Office Cache files need to store your state of work on their offices. Plus the behavior of the Office cache handler


Step 1 - Configure your Office Cache Control

Find upload center control






Click the settings. My recommended settings is like this







Step 2 - Move your Cache Files

This step is optional. However, I recommend you move the Office File Cache to the other drive if you are using non SSD drive. To do this please follow this

  • Visit regedit by typing regedit on command prompt
  • Open HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet
  • Create a string key value namely OfficeCacheLocation



  • Restart your PC

Step 3 - Stop the Office Upload Center and OneDrive

Use the task manager to kill the office upload center and exit using the notification icon on OneDrive

Step 4 - Clean up your Cache Files

After you restart the document, you can clean up the cache files. The steps are:

  • Visit C:\Users\Ridi Fe\AppData\Local\Microsoft\Office\15.0
  • Fine OfficeCache or something like that
  • Delete it

Enjoy your new and clean OneDrive without consuming a lot of spaces again. If you don’t know what is OneDrive for Business and want to get up-to 15 GB your free personal storage you can click here using OneDrive or Buy OneDrive for Business here

Visual Studio 14 CTP

Yes, its there.. the Visual Studio 2015 aka Visual Studio 14 is free for download. It still early access CTP so you will find many glitches about it. But according to my experience the Visual Studio 14 provides you better integration on the cloud (Azure), mobile, and also Office 365 Apps

You can dowload the latest version of Visual Studio 14 CTP here

You can see the notes about this release here 

I will post my screencast video about this Visual Studio 14 CTP on this weekend so stay tune Smile

The Fundamental of Usability.

Sometme you love the client, sometime you don’t. Client want you more with their limited investment. And you want to give the client the best with their investmet. This article will discuss how we develop the system with usability in mind. Usability is a set of principles that related how the people learn to use the syste. So let’s get started.

They are five basic of usability attributes namely (Nielsen, 1993)

  • Learnability
  • Efficiency
  • Memorability
  • Error tolerance
  • Satisfication

If your team can achive those attributes, ideally your poduct will be awesome. However, it still depends with the client itself. Therefore, the level of usability attributes will be different from one client to the others. When we talk about system acceptance that is finished by acceptance of the user, Figure 1 shows how the system acceptance happens










The acceptability of the system again depends on the user that use the system. Figure 2 shows the acceptance level based on the user. It is shown that there are three characteristics of the user namely the usage of the system, computer experience and domain knowledge.


The All New Safari Books Online

As a subcriber of Safari Books Online for more than two years, i will share my personal opinion about the new interface of safari books online. We will compare the current safari books online (my.safaribooksonline.com) with the all new interface of safaribooksonline (safaribooksonline.com). Let’s get started.

What’s good on the new safari books online

  • Clean interface, responsive, and compatible on many browser
  • Quick search and seamless searching experience between video and book
  • Recommendation system based on the reader interest
  • The semantic usage of reader. For example, what section that become favourite on certain books, or how long reader will read the section of the book
  • Modern video player

What’s wrong with the new safari books online

  • Limited collection, I search the same query between old and the new interface. Guess what the new interface has differeny content about my query “Sharepoint 2013”






  • NO favorite folders only Queue. So you can’t move your collection into a specific folder. It will become a problem if you have many subject to learn






  • No support for exploring a book by years of publication. For example, you want to get a latest definition about e-learning. In the past, I just click the left side filter fo publication years but with the new interface of safari is somewhat impossible.
  • No economic option for student, unemployee, or lecturer. The subscriptions cost ~200-300$, in the old safari you have 100$ option through a bookshelt model.
  • The lack support of Windows Phone, Android, and Windows 8.1 client.

Verdict – upgrade now or later?

I love how Safari books structure the book on a new model. however, they forget how digital library is structured. is just like one step ahead, but two step back.  If you are a book lover, the new upgrade is a must, but if you have limited budget. Keep your old safari till you need to access full library. trust me, 200$-300$ years is worthed with the Safari

UnobtrusiveValidationMode Issues on Visual Studio 2013


Yesterday, I created empty web template with Web Forms support through Visual Studio 2013. Unlike, the WebForms and the MVC template that works flawlessly. I got unique error as shown on figure








It is said that I need ScriptResourceMapping for jquery. It is strange that I don’t need JQUERY for this project.


After doing a search there are several options to solve the Empty Web issues on Visual Studio which are

Option 1 – If you don’t need JQUERY

If you don’t need jquery you can add this on your web.config

    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None"></add>

Option 2 – If you need JQUERY - Installing JQUERY using nugget

For this purpose you can read this link

Option 3 – You don’t need JQUERY but need ASP.NET WebForms Validation

For this purpose you can read this link

Preparing Your SharePoint Certification

As the user of Visual Studio, you might know about SharePoint platform. SharePoint platform is a portal based web application that build for enterprise. Although, it has the foundation version for SMB which is free. SharePoint can easily scaled to the Enterprise or even the cloud. SharePoint has two main version the first version is On-premise and the cloud version. The on-premise version namely SharePoint 2013. The cloud based version namely SharePoint Online and is part of Office 365.

SharePoint become promising in the era of paperless, and the online version will help you to create the SharePoint solution easily rather than in the on-premise version

SharePoint Certification

There are two certification for the latest SharePoint namely MCSE (MIcrosoft Certified Solution Expert) and MCSD (Microsoft Certified Solution Developer). for SharePoints. MCSE is for IT professional and MCSD is for Developers.

MCSE : SharePoint

In order to become MCSE you should pass the MCSA requirements and then follow it with two exam

  • Managing Office 365 Identities and Requirements (70-346)
  • Enabling Office 365 Services (70-347)

If you pass both certification, you will get MCSA (MC Solution Associate), you can join the course 20346B. Yes the course is look like Microsoft Office Specialist Office 365 but the MCSA more focused with the implmentation rather than usage. After pass the MCSA you can join

Beside the offline course you can join microsoft virtual academy (MVA) for SharePoint

MCSD: SharePoint

In order to become Solution Developer for SharePoint you should pass four exam which are

  • Programming in HTML5 with JavaScript and CSS3 (70-480). You can also join the offline course 20480B
  • Developing ASP.NET MVC Web Applications (70-486), You can also join the offline course 20486B
  • Developing Microsoft SharePoint Server 2013 Core Solutions (70-488), You can also join the course 20488B
  • Developing Microsoft SharePoint Server 2013 Advanced Solutions (70-489). You can also join the course 20489B

Book References

Preparing is a must and you should prepare by online, offline, or books like below

Visual Studio Online or Visual Studio 2013





Today, there are two main SKU of Visual Studio namely Visual Studio Online and Visual Studio 2013 products. This article will discuss which one you should buy or invest if you want to build something using Visual Studio.


we divide the usage of Visual Studio into five tiers which are personal / hobbyist, startup, SMB, and Enterprise. This solution is designed to be simplest as possible to get better understanding of Visual Studio Product.

Personal / Hobbyist

You are student or hobbyist, you can grab the Visual Studio Express is a freebies and have a sufficient features to create a product. This program is royalty free so that you can use and sell your software without hassle. The disadvantage of this product is each platform has different SKU. For example, if we want to build on web and on desktop you should install two products on a same machine. This won’t happen on Visual Studio Professional features.

You can download the Visual Studio Express here

and if you want to store you codes to the cloud you can use Visual Studio Online Basic that has five users free slots.


If you are startup you can also use Visual Studio Express. However, we recommend you buy the Professional Version. Yes, it costs about 300$. But it’s really worth for your startup. The professional features has many fundamental aspects of superb IDE such as

  • One stop coding for any platform
  • Unit Testing framework
  • Code metrics and analysis
  • Agile method
  • Code visualization
  • Professional deployment support

You can buy the Visual Studio with MSDN or without MSDN. MSDN means you have all Microsoft Product for test purpose (not for production to a client). The MSDN will cost $1200 yearly and without MSDN it takes cost 300$. Click the picture below to understand the latest prices.

You can download Visual Studio Professional here

and if you want to store you codes to the cloud you can use Visual Studio Online for professional, it costs 45$ per months and it includes Visual Studio Professional also. So as a startup you can invest on three model Visual Studio Online Professionals (Subscriptions / Month) , Visual Studio Professional, and Visual Studio Professional with MSDN (Subscriptions / Year). 

If you don’t have a fund, don’t worry you can use Visual Studio Express family or Visual Studio Online Basic.


We categorize SMB if you have development team more than 10 people. in this model, you need a streamline software engineering process like a Agile method. In this case you can use Visual Studio Professional, but if you need more engineering approaches such as

  • Test case or testing framework
  • UML diagram
  • Team Room
  • Code Review
  • Architecture Validation
  • Code Cloning
  • Graphics Debugging

You can grab the Visual Studio Premium, Visual Studio Premium with MSDN ($6200 / year). There is no Visual Studio Online version that has Premium inside so you need to buy Visual Studio separately.

You can download the Visual Studio Premium Version Here


Yes, if you are enterprise that has many IDE on your company and want to integrate all of your IDE, you can buy Visual Studio Online Advanced Subscriptions (60$ / months). It includes a plugin support for many major IDE like Eclipse, Visual Studio, and others. Others option is choosing Visual Studio Ultimate with MSDN ($13.299/year). Please notes that even Visual Studio Online Advances doesn’t have Visual Studio included, you should buy Visual Studio separately. Visual Studio Ultimate has several enterprise ready features  such as

  • All Visual Studio Premium features
  • Load testing
  • Adopting FULL Application Lifecycle Management using standard like CMMI, SCRUM, and others
  • Has Intellitrace to understand the debug history
  • Architecture dependency


Education is special SKU, you can grab Visual Studio Ultimate for free if your campus is STEM-D and is enrolled with Dramspark Premium. If your campus is not STEM-D you can get Visual Studio Professional with Dreamspark Standard for free.

Quick Fact

Before I close this article you might notice some facts which are:

  • Visual Studio Professional is only version of visual studio that can be bought without MSDN
  • Visual Studio Express is a free version for Visual Studio
  • The Visual Studio online professional is the one and only visual studio online version SKU that include IDE of Visual Studio Professional
  • The reniew prices of MSDN subscriptions is only 30% of new subscriptions

You can do a quick buy using amazon below

WIFI Connection Problem and Visual Studio 2013

If you have a WIFI connection and has a connection problem after you install the Visual Studio. This short article will help you to fix the issues.


You can’t connect to the internet as well as change the connection from one WIFI to the others.


This happens because Visual Studio creates a network bridge to facilitate the internet connection between emulator and real internet connection. Unfortunately, some of WIFI adapter take longer to connect the internet because the bridge connection






There are several solution when you face this problem

Option A. Delete the Windows Phone Emulator and Network Bridge

If you don’t have a windows phone project that connected to the internet, or you have device to debug your Windows Phone app, you can savely to delete Windows Phone emulator and Network Bridge

Option B. Disable and Enable Network Bridge

If you don’t one to delete it. When you change the WIFI connection and the Network Bridge shows Identifying….you can disable and re-enable again to reset network bridge that improve the connection between router and your wifi.

Introducing Excel like Grid using Spread Studio .NET

have you ever got a problem with grid control from the ASP.NET. For example, you can’t create well formatted excel report oon the grid or even to export your griod into Excel. In the past, we can use CSV format to export to the Excel compliant. However, editing is tought using Griid. Grid is great for display a row of data but lack feature of editing. If you need a component that help you display like a grid, and manipulate like an Microsoft Excel you might need Spread. Spread is a component product from ComponentOne. On this article, we will guide you step by step to use Visual Studio and Spread Studio.NET.

Usage Scenario

Spread can be used for several scenario such as:

  • Manipulating native excel files outside Microsoft Excel
  • Creating a dashboard that has chart and data visualization
  • Creating complex and unstructured report such as invoice, or purchase order that can be exported into excel format
  • Creating a flexible grid that use mathematic or statistic formula


The installation is quite simple, you just download the component here. The installer will download the component based on your need.


The installation will add you the Windows RT component, WPF, Windows Form, and ASP.NET components.





Development Preparation

First of first, Spread is simple to activate. It has set of assemby that doesn’t need the Microsoft excel to be installed on client. On this article, we will try the component on Windows RT based. When you start you Visual Studio you will get a toolbox category called GrapeCity XAML the Spredsheet component name is GcSpreadSheet.




Visual Studio will help you add additional reference to the Visual Studio. step-by-step preparation can be seen here. On your designer surface it will be sown like below


Design or Develop

After you put the component, the next step is design the spread report. it just like creating a Excel format like on the designer surface. If you want to create a new spreadsheet template you can select a menu new spred template






The screen will display, Excel application like Senyum dengan mulut terbuka , you can set property and others








We will discuss the Excel manipulation further in the next series tutorial


Spread deployment follows one library deployment and it’s embedded on yout application. Furthermore, the deployment is royalty free make you distribute the application as long as you need.

Translate It

About @ridife

This blog will be dedicated to integrate a knowledge between academic and industry need in Application Lifecycle Management (ALM), ICT tips, and Software Engineering Research. Enjoy this blog and let's get in touch in any social media.

My status


Month List