Monthly Archives: August 2011

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

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

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

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

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)

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 , | 2 Comments

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

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

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