Softminer.net

here I want to introduce some virtual machines:

virtual box (Oracle): the extension of images are .vdi than can be download from http://virtualboximages.com

I have tested android and chrome OS, the problem is that it can not be full screen :D

---

VMware: its really powerfull software to have virtual machine for desktop and for servers. there are many website to get "vmware appliance".


Virtual pc : its free from microsoft and you can even download the images from microsoft. I use it to test my layout design in IE7


Hyper-V: its a feature in windows server 2008 and even there is a windows server hyper-v which already has Hyper-v installed.

this video shows how to install hyper-v on windows server:

There are many source control software that can be used depend on the purpose for example :

Tortoise SVN
Source Gear (Vault)

fo visual studio

Microsoft Source Safe
Team Foundation Server

Source Safe can be used for small project because in source safe one user can just check out the source and the file is locked, but in TFS in can be edited by many users and then users can solve the conflict when they check-in.

Top features of TFS are :

• Project Management (connecting to Agile)
• Reporting (Based on .NET Framework)
• Automated Builds
• Process Templates
• Code Branching
• Web-Based Portal (Sharepoint)
• Source Control

Here are some Tutorial about installing TFS on Windows Server :

Part 1
Part 2
Part 3
Part 4

if you put this in .aspx code it will return back 0.0.0.0


you have to fill in either in controller or in Helper class:

here is how to fill it in helper class:

http://www.craftyfella.com/2010/01/adding-assemblyversion-to-aspnet-mvc.html

This is the list of Dateformat in SQL 2008 with examples

Data type	Output
Time	12:35:29. 1234567
Date	2007-05-08
Smalldatetime	2007-05-08 12:35:00
Datetime	2007-05-08 12:35:29.123
datetime2	2007-05-08 12:35:29. 1234567
Datetimeoffset	2007-05-08 12:35:29.1234567 +12:15

as you see the new Datetimeoffset is useful for timezone in different countries.

Timestap is changed to rowversion (both are valid)

timestap Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table rows.

if you read a row and wants to edit it check the timestamp in update, if the timestamp is changed means during the update this row is changed by someone else.

furthermore, if you want to have a datetime column which automatically fills in insert and update by sql you should make a default value to GETDATE() function.

this default value will fullfill the insert and for update you need to add a trigger like this

CREATE TRIGGER KeepUpdated on Profiles
FOR UPDATE, INSERT AS
UPDATE dbo.Profiles
SET LastUpdate = GetDate()
WHERE Username IN (SELECT Username FROM inserted)

after creating webapplication you should enable the http,net.tcp port.


windows communication foundation service should be enables in Windows component
WAS ( windows activation service) : when we add this then .svc will add to the handlers


then call this on IE
And then we have to call with
http://localhost/services/myservice.svc

when you call this the the MEX file will be created and then the net.tcp will work
then you can call service by WCF test client

WCF test client is in this address:
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE

run it and add this service to it
net.tco://localhost/services/myservice.svc

PS: if it doesnt work please check if net.tcp protocol is in sitebinding
right click on (default website and click on edit banding)
if net.tcp is not in the list add it as follow:

usually its better to install vault (source gear) after SSMS otherewise installing vault will cause an error in running SSMS.

The server returned the following error:Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed
because the QueryInterface call on the COM component for the interface with IID
'{6D5140C1-7436-11CE-8034-00AA006009FA}' failed due to the following error: No such
interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).


to fix this error you need to register this dll's again

Urlmon.dll
Mshtml.dll
Actxprxy.dll
Oleaut32.dll
Shell32.dll
Shdocvw.dll

For example, click on Start, and then choose Run, and in the Run dialog type:
dont forget to run cmd as administratore:

regsvr32 Urlmon.dll

try it first in %WinDir%\SysWOW64 and if it doesnt work try %windir%\system32 folder.

after this maybe you have this sideeffect that cause you explorer to open the folders alway in new page.

to solve this :

regsvr32 "%programfiles%\Internet Explorer\ieproxy.dll"
regsvr32 "C:\Program Files (x86)\Internet Explorer\ieproxy.dll"

to solve the SSMS and vault in Windows x32 do following step:

copy this text in .reg file and run it

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Interface\{6D5140C1-7436-11CE-8034-00AA006009FA}\ProxyStubClsid32]
@="{A4A1A128-768F-41E0-BF75-E4FDDD701CBA}"

in c# by default when the UI culture is changed then for every UI language there is a format

for example for

en-US is MM/dd/yyyy
de-DE is dd.MM.yyyy

so if you UIculture is changed to de-DE then the datatime format will also change to dd.MM.yyyy

if you want to change datetime format for de-DE to MM/dd/yyyy then try to set it

culture.DateTimeFormat.ShortDatePattern = "MM/dd/yyyy";