Monthly Archives: August 2011

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

Posted on August 31, 2011 by chanmingman

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 →

How to duplicate MS SQL Database

Posted on August 29, 2011 by chanmingman

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

Posted in .Net | Tagged How to copy MS SQL Database, How to duplicate MS SQL Database | Leave a comment

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

Posted on August 26, 2011 by chanmingman

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 An unhandled exception (‘Unhandled Error in Silverlight Application Code:4004 | 1 Comment

Microsoft is the leader in Magic Quadrant for Business Intelligence Platforms

Posted on August 23, 2011 by chanmingman

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 Jaspersoft in Magic Quadrant for Business Intelligence Platforms, Microsoft is the leader in Magic Quadrant for Business Intelligence Platforms, Pentaho in Magic Quadrant for Business Intelligence Platforms | 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 chanmingman

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 log_bin_trust_function_creators, This function has none of the DETERMINISTIC | 2 Comments

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

Posted on August 21, 2011 by chanmingman

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 Forrester Wave Enterprise Data Warehousing Platforms, MySQL not in Forrester Wave Enterprise Data Warehousing Platforms | 1 Comment

Magic Quadrant for Data Warehouse Database Management Systems

Posted on August 21, 2011 by chanmingman

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 Magic Quadrant for Data Warehouse Database Management Systems, MySQL has dropped from the magic quadrant for Data Warehouse Database Management Systems | 2 Comments

Connecting to SQL Server Express User Instances

Posted on August 20, 2011 by chanmingman

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 Connecting to SQL Server Express User Instances, Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance, user instance true | 2 Comments

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

Posted on August 17, 2011 by chanmingman

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 Microsoft SQL Server Migration Assistant for MySQL v1.0, Migrate from MySQL to MSSQL, Migrate from MySQL to MSSQL using Microsoft SQL Server Migration Assistant for MySQL v1.0 | Leave a comment

What is Microsoft Most Valuable Professional (MVP)?

Posted on August 17, 2011 by chanmingman

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

Posted in Community | Tagged How to become a Microsoft Most Valuable Professional (MVP)?, What is Microsoft Most Valuable Professional (MVP)? | Leave a comment