2009-03-25

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Microsoft Commerce Server 2007 Catalog Manager Web Version Project Created

MS CS 2007 Catalog Manager Web Version project has been created by Ziver Alen, now you may download the working but not fully tested Alpha release of this web based catalog manager tool. http://catmanweb.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=25221#ReleaseFiles

2009-03-22

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Fixing Windows using a Live Linux CD

Fixing Windows using a Live Linux CD
http://www.askreamaor.com/microsoft-and-windows/fixing-windows-using-a-live-linux-cd-part-one/
Trinity Rescue Kit
http://trinityhome.org/Home/index.php?wpid=1&front_id=12

2009-03-19

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

MyArticle: Combining Commerce Server 2007 Catalog Tables in a View

This article of mine, describes how to union multiple catalog tables in a single view. This approach may be used for reporting purposes, thus developer will not require to find out which table contains the product, but will execute a select stmt for a view and will get the information required.
Combining Commerce Server Tables as a View

2009-03-17

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

ASP.NET MVC Book Published!

http://www.cemsisman.com/FreeAspnetMVCEBookTutorial.aspx

2009-03-16

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Installing Commerce Server 2009

Step by step instructions on Installing Commerce Server 2009,
a gate to Software-Smith's Blog
http://www.software-smith.com/blog20081118.htm

How to Install Commerce Server 2007/2009 on the Web Servers
http://msdn.microsoft.com/en-us/library/dd451137.aspx

How to Install Commerce Server 2007/2009 on the Web Servers
http://msdn.microsoft.com/en-us/library/dd451137.aspx

2009-03-11

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Does your ASP.NET Application performs slow, or uses high memory / cpu?

Then check the maxWorkerThreads & minFreeThreads settings for your .NET Framework config.

Improving ASP.NET Performance
http://msdn.microsoft.com/en-us/library/ms998549.aspx

Why 'maxWorkerThreads' = 100 and 'minFreeThreads' = 88 is suggested?
http://forums.asp.net/t/1299590.aspx

Planning, testing and tuning for ASP.NET and IIS 6.0
http://www.codeproject.com/KB/aspnet/ASPNET_and_IIS_60.aspx?display=PrintAll&fid=127812&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=1069214

Tune the thread pool by using the formula to reduce contention
http://channel9.msdn.com/wiki/guidancelibrary/tunethreadpool/

Reduce Server Too Busy errors with the httpRuntime tag
http://www.devx.com/vb2themax/Tip/18804

Set maxWorkerThreads to 100. This setting controls the maximum number of worker threads in the thread pool. This number is then automatically multiplied by the number of available CPUs. Set maxWorkerThreads to 100.

Set minFreeThreads to 88 * # of CPUs. This setting is used by the worker process to queue all the incoming requests if the number of available threads in the thread pool falls below the value for this setting. This setting effectively limits the number of requests that can run concurrently to maxWorkerThreads – minFreeThreads. Set minFreeThreads to 88 * # of CPUs. This limits the number of concurrent requests to 12 (assuming maxWorkerThreads is 100).
reference: http://msdn.microsoft.com/en-us/library/ms998549.aspx

2009-03-09

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

LINQ to Oracle support

> bLinq is the "linq to SQL" for other databases. It currently supports MySQL, PostgreSQL, Oracle and SQLite
http://linq.to/db
> Linq to Oracle support is available by a third party product: Mindscape's LightSpeed
http://www.mindscape.co.nz/products/lightspeed/screencasts/gettingstarted.aspx

references:
http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thread/bce9266a-0d90-4ea4-85d0-6166f4bf61db/
http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/thread/2335f6ae-47cf-4497-b007-14be21c5b8df/

Links about ADO.NET Data Services

ADO.NET Entity Framework
http://msdn.microsoft.com/en-us/data/aa937723.aspx#
http://msdn.microsoft.com/en-us/library/bb399572.aspx

ADO.NET Data Services Framework (formerly "Project Astoria")
http://astoria.mslivelabs.com/

ADO.NET Data Services Team Blog
http://blogs.msdn.com/astoriateam/

ADO.NET team blog
http://blogs.msdn.com/adonet/

2009-03-06

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

What would you prefer, TestDD or BugDD ?

The Cost of Test Driven Development
http://blog.typemock.com/2009/03/cost-of-test-driven-development.html

Bug Driven Development
http://haacked.com/archive/2007/09/24/bug-driven-development.aspx

2009-03-04

Alen Ziver Malhasoglu's New Microsoft Commerce Server Blog

Sql Server 2005 Installation Issues...

If installation of Sql Server 2005 fails on XP because of MSXML6
Then check the following thread
http://www.windows-tech.info/15/62c4c7d22384e2f6.php

Windows Installer CleanUp Utility
http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml


When you try to install SQL Server 2005 you may get the following error message during setup: "Shared Memory Provider: No process is on the other end of the pipe"
http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/968cd292-5a3f-4c48-9347-4604a6fa9872/
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

...finaly found the problem to be the certificate used.
I noticed that a certificate was added to the machinekeys just recently.
(in C:\Documents and Settings\All Users\Application
Data\Microsoft\Crypto\RSA\MachineKeys)

I renamed it to another name and re-installed sql server.
I noticed that sql server ERRORLOG complained about certificate that it
couldn't load and the generation of a self-generaed certificate (see below)

"2005-12-10 21:01:02.30 Server The server could not load the
certificate it needs to initiate an SSL connection. It returned the following
error: 0x8009030d. Check certificates to make sure they are valid.
2005-12-10 21:01:02.49 Server A self-generated certificate was
successfully loaded for encryption."

Now the installation succeeded

http://groups.google.com/group/microsoft.public.sqlserver.connect/browse_thread/thread/dbec4a9a271f69a6/7cd22694da3a6062?lnk=st&q=%22Shared+Memory+Provider%3A+No+process+is+on+the+other+end+of+the+pipe%22&rnum=2&hl=en#7cd22694da3a6062