Playing with Vertial and Horizontal Tables

Pivot Transformation SQL Server 2005 Integration Services – Part 38 – Pivot Transformation Horizontal vs. Vertical Database Design Using PIVOT and UNPIVOT


How to write a CMS like Sharepoint?

How to use virtual path providers to dynamically load and compile content from virtual paths in ASP.NET 2.0

Virtual Path Povider Class

The ASP.NET Virtual Path Provider – An Example Implementation Creating Custom Virtual Path Provider in ASP.Net 2.0 MSDN ScreenCast – ARCast – ASP.NET Virtual Path Provider


About SqlCacheDependancy, Personalization, and Sql’s Xml DataType

Dependant Cache to Sql Server Using SqlDependency in a Windows Application ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) Enabling Query Notifications Using Query Notifications MSDN forum thread about sqlCacheDependancy Personalization Info [How Do I:] Utilize Web Parts and Personalization? WebPart.AuthorizationFilter Property How To get Web Parts to work with SQL Server 2005 (not Express) Sql Server […]

Recommendation Engines

“People who bought this item also bought the following” kind of cross sell functionality. A Simple Recommender System – The Collaborative Network Library, By edeferia Wiki page of “Recommender System” Duine Prediction Framework

Analytics Software


Cognitive Analytics

Tradeoff Analytics

Watson Tradeoff Analytics Service

sample app on property choices

20+ Emotion Recognition APIs That Will Leave You Impressed, and Concerned

Tone Analyzer

Getting Started with Watson Developer Cloud Services —


web analytics software


One of the most […]

Accessing Microsoft Commerce Server 2007/2009 ConnectionStrings


If you are using Microsoft Commerce Server 2007/2009 (MSCS) and if you have one commerce starter site then you will have 7 databases in your Sql Server. The databases are listed as following:

1. SiteName_ProductCatalog 2. SiteName_Profiles 3. SiteName_Marketing 4. SiteName_MarketingLists 5. SiteName_Transactions 6. SiteName_TransactionConfig 7. SiteName_DataWareHouse

If you […]

Why shouldn’t you use folder synchronizers instead of source control providers

I was coding a project with my best friend who lives far away from my home. We have created the solution however the need for a source controlling system emerged. First we tried to use MS Visual SourceSafe 2005 over VPN, that was working but it was so slow that you cannot get latest version […]

use wss 3.0 with sp2

WSS 3.0 with SP2Differences between WSS 3.0 and MOSS 2007How To Install Windows SharePoint Services 3.0 On SBS 2003How to install Windows SharePoint Services 3.0 SP1 on Vista x64/x86

Connecting to WSS 3.0 SP2 database instence Microsoft Sql Server Embedded Edition Microsoft##SSEEWSS 3.0 and SQL Server Embedded Edition

More on customizationHow to Customize SharePoint Forms […]