Monthly Archives: December 2008

Errors in the metadata manager (Analysis Services 2005)

Posted on December 27, 2008 by chanmingman

You might encounter a problem when working with Analysis Services. The Analysis Services Database cannot be deleted and cannot even go to properties. When you search through msdn.microsoft.com you will get many results and you may get a bit frustrating … Continue reading →

Posted in Uncategorized | Leave a comment

Parallel Computing (Xmas special)

Posted on December 25, 2008 by chanmingman

Personal Computer hardware has been invented to do parallel processing since Intel Hyper-Threading® in year 2002 till today’s quad-core process. Software developers have been relying on the Operating System to handle the parallel task for the code that they have … Continue reading →

Posted in .Net | Tagged | Leave a comment

How to Create Dynamic Data Entities Web Site

Posted on December 20, 2008 by chanmingman

How to Create Dynamic Data Entities Web Site 1. Start Visual Studio 2008. File -> New -> Web Site… 2. Choose Dynamic Data Entities Web site from New Web site dialog 3. Right click the Web Project then select Add … Continue reading →

Posted in .Net | 1 Comment

Dataset vs. LINQ to SQL Classes

Posted on December 13, 2008 by chanmingman

This short article is to compare between how to use Dataset to populate DataGridView with parameter and how to use LINQ to SQL Class to populate DataGridView with parameter. Create a Winform with 1 Textbox named txtSearch, 1 Button named … Continue reading →

Posted in .Net | Tagged | 2 Comments

List all tables in database and output to text file (using PowerShell)

Posted on December 5, 2008 by chanmingman

The SQL statement to list all the tables in the database as below: SELECT * FROM sys.tables How do you output the results to a text file? It is easy in MS SQL 2008. Right click the Tables from the … Continue reading →

Posted in Uncategorized | Leave a comment