Monthly Archives: August 2014

How to search null value in Microsoft SQL Server column

Posted on August 29, 2014 by chanmingman

A lot of users think they do not have a null value in their column because the do the following. DON’T SELECT TOP 1000 [ProductID]       ,[ProductName]       ,[SupplierID]       ,[CategoryID]       ,[QuantityPerUnit]       ,[UnitPrice]       ,[UnitsInStock]       ,[UnitsOnOrder]       … Continue reading →

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

Visual Studio “14” CTP 3 Released

Posted on August 27, 2014 by chanmingman

Visual Studio 14 CTP 3 Released this week. More information here http://blogs.msdn.com/b/visualstudio/archive/2014/08/18/visual-studio-14-ctp-3-released.aspx. There is a new .NET Framework vNext. You cannot download the .NET Framework separately at this moment but to install Visual Studio 14 CTP 3. For me, still … Continue reading →

Posted in .Net | Tagged , | Leave a comment

Feature broken after install VS 14 CTP 2 with Visual Studio 2012

Posted on August 25, 2014 by chanmingman

I have Visual Studio 2012, Visual Studio 2013 and Visual Studio 14 CTP 2. Today I realized that I can no longer create Entity Framework in Visual Studio 2012 but I can still do that in Visual Studio 2013. Symptom: … Continue reading →

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

3 Best Programming Practices

Posted on August 24, 2014 by chanmingman

Recently I attended the online course provided by SkillSoft. One of the courses was Object-Oriented Programming Best Practices. I found there are 3 practices worth to be mentioned here. 1. Although you may provide your code in a clear, well … Continue reading →

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

Only one configSections element allowed per config file and if present must be the first child of the root configuration element

Posted on August 19, 2014 by chanmingman

Only one <configSections> element allowed per config file and if present must be the first child of the root <configuration> element When you have custom section in app.config or web.config then you might hit the error “Only one <configSections> element … Continue reading →

Posted in .Net | Tagged , | Leave a comment

The Import Organization Wizard cannot connect to the SQL Server or cannot find an organization database on SomeMachineName. Verify that the server name in the SQL Server box is correct and that the computer is running Microsoft SQL Server where an organization database is stored

Posted on August 17, 2014 by chanmingman

When you start you Microsoft Dynamics CRM Deployment Manager, choose Organizations then click Import Organization… You might hit the error “The Import Organization Wizard cannot connect to the SQL Server or cannot find an organization database on SomeMachineName. Verify that … Continue reading →

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

Visual Studio 2013 Update 3

Posted on August 14, 2014 by chanmingman

I have done installation of Visual Studio 2013 Update 3. So far it is still not break…   Download from msdn or here http://www.visualstudio.com/en-us/downloads/download-visual-studio-vs.

Posted in .Net | Tagged | Leave a comment

How do I create Query in Access 2013

Posted on August 10, 2014 by chanmingman

After I read http://social.msdn.microsoft.com/Forums/en-US/60f55061-37f0-419d-914e-5ccbdf5941a8/4-access-tables-how-to-have-a-select-query-with-left-join-?forum=csharpgeneral in the forum. I think the easy way is to create a query in Access itself to test the query statement. To create Query in Access 2013. 1. Click on the Create tab. 2. Choose either … Continue reading →

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

Save your Hyper-V image instead of pause it to prevent keeping the memory (part 2 hard disk space)

Posted on August 10, 2014 by chanmingman

My previous blog https://chanmingman.wordpress.com/2014/08/10/save-your-hyper-v-image-instead-of-pause-it-to-prevent-keeping-the-memory/ lead to answer question by Senthamil Selvan “Does it takes more HDD space if we save? What about server with 100 GB used size? Any delay in restore?” He found more hard disk space has been … Continue reading →

Posted in .Net, Community, Operating System, Servers | Tagged , | 1 Comment

Save your Hyper-V image instead of pause it to prevent keeping the memory

Posted on August 10, 2014 by chanmingman

When I pause my Hyper-V image, the total memory usage is 3.8 GB.   I saved the Hyper-V image then I gained back 2GB.   Although saving the image will take slight longer time to restore than pause it but … Continue reading →

Posted in .Net, Community, Operating System, Servers | Tagged , | 1 Comment