Monday, November 26, 2007

Web Service software Factory Hands on lab

Service Factory Hands on Labs are now available you can download it here

http://www.codeplex.com/servicefactory/Wiki/View.aspx?title=HandsOnLab&referringTitle=Home

What Is the Service Factory?
software factories represent a collection of guidance that helps architects and developers build a specific kind of application. Therefore, the Service Factory helps developers and architects build Web service applications. Web service applications are more than just the technologies that send and receive SOAP messages and expose WSDL contracts—they also include the functionality that is needed to fulfill the service's behavior. Figure below illustrates the parts of the application, and their relationship with one another, the Service Factory will help you build.

Structure of a service built with the Service Factory


Sunday, November 11, 2007

Shrink the transaction log file in SQL Server 2005

I face a problem where i use database to store application session the problem is that the ASP state database log file size is 50 GB so i need to shrink the log file after googling I found the solution

first you need to backup the log file using this command
BACKUP LOG TestDB TO DISK='C:\TestDB1.bak'
Second you run the following command to shrink the log file
DBCC SHRINKFILE (, ) WITH NO_INFOMSGS

For more information check this link on
Microsfot support http://support.microsoft.com/kb/907511

RSS Feeds