Monthly Archives: August 2011

Walkthrough: Comparing the Schemas of a Database and Database Project – sample download

Posted on August 31, 2011 by

Comparing the Schemas of a Database and Database Project is a pretty good article to read and try but it does not provide any sample to play with. Download the sample project from http://skydrive.live.com.The sample file name is CompareProjectDB.rar. My … Continue reading →

Posted in .Net | Tagged , , | Leave a comment

How to duplicate MS SQL Database

Posted on August 29, 2011 by

Watch the video below.   How to duplicate MS SQL Database   Resources: http://msdn.microsoft.com/en-us/library/ms188664.aspx

Posted in .Net | Tagged , | Leave a comment

An unhandled exception (‘Unhandled Error in Silverlight Application Code:4004

Posted on August 26, 2011 by

The above error could be caused by one of the follow reasons.   The database does not support user instance. For example, you are using Domain Service Class.   An unhandled exception (‘Unhandled Error in Silverlight Application Code:4004 The video … Continue reading →

Posted in .Net | Tagged | 1 Comment

Microsoft is the leader in Magic Quadrant for Business Intelligence Platforms

Posted on August 23, 2011 by

We can learn 3 things from this Gartner report. 1. Microsoft is one of the key players in Business Intelligence. 2. Jaspersoft is one of those that do well in a specific segment of the BI platform market such as … Continue reading →

Posted in Computers and Internet | Tagged , , | Leave a comment

This function has none of the DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enable (you *might* want to use the less safe log_bin_trust_function_creators variable)

Posted on August 23, 2011 by

If your MySQL database has a binary field in it and you hit the above error while restoring from the dump like the one below.   Issue the follow command in MySQL console. SET GLOBAL log_bin_trust_function_creators  = 1;  

Posted in Community | Tagged , | 1 Comment

Microsoft is in the leaders of Forrester Wave Enterprise Data Warehousing Platforms

Posted on August 21, 2011 by

There is 2 key points I realized here. 1. Microsoft still in leaders wave of Forrester Wave. 2. MySQL is not mentioned in Forrester Wave.     Resources: The Forrester Wave™: Enterprise Data Warehousing Platforms, Q1 2011 Magic Quadrant for … Continue reading →

Posted in Community | Tagged , | 1 Comment

Magic Quadrant for Data Warehouse Database Management Systems

Posted on August 21, 2011 by

There are 2 key points I noticed. 1. Will Microsoft catch up with Parallel Data Warehouse (PDW) and get back in leader area? 2. MySQL has dropped from the magic quadrant. MySQL fate is pretty much in the hand of … Continue reading →

Posted in Community | Tagged , | 2 Comments

Connecting to SQL Server Express User Instances

Posted on August 20, 2011 by

If you have a connection like <addname=“ApplicationServices“connectionString=“data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true“providerName=“System.Data.SqlClient“ /> You might hit the error —————————————————————————— Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection … Continue reading →

Posted in .Net | Tagged , , | 2 Comments

Migrate from MySQL to MSSQL using Microsoft SQL Server Migration Assistant for MySQL v1.0

Posted on August 17, 2011 by

Watch the video below. Migrate from MySQL to MSSQL using Microsoft SQL Server Migration Assistant for MySQL v1.0   Resources: Microsoft SQL Server Migration Assistant for MySQL v1.0

Posted in .Net | Tagged , , | Leave a comment

What is Microsoft Most Valuable Professional (MVP)?

Posted on August 17, 2011 by

What is MVP? How to become MVP? What is Microsoft Most Valuable Professional (MVP)? Recourses: https://mvp.support.microsoft.com/

Posted in Community | Tagged , | Leave a comment