Friday, July 27, 2007

Visual Studio 2008 beta 2 released

Visual Studio 2008 beta 2 has been released.

Click on the link to download:
http://msdn2.microsoft.com/en-us/vstudio/default.aspx

Thursday, July 26, 2007

Using the SQL Server's Timestamp datatype

The Timestamp datatype is supported by SQL Server 2000 and SQL Server 2005.

It is a good way to indicate the row version because it represents a unique value.

A field defined as 'timestamp' is automatically updated by SQL Server when rows are inserted or updated. You cannot read the content of a timestamp field in the Management Studio. It is encapsulated as 'binary'. ('Timestamp' is stored in 8 bytes as binary(8)).

Why is the timestamp datatype useful?

The timestamp datatype guarantees to be unique across the DB. It is generally used as a DB generated ID in tables.

Other methods?
You can also use a DateTime datatype to indicate a row's version. A datetime field is not automatically updated and is not unique across the database.

Click here to read more about SQL Server 2000/2005 datatypes

Wednesday, July 25, 2007

Workflow Persistency: adding Oracle and MySQL support

Workflow Foundation (WF) provide assistance to use SQL Server as datasource for workflow persistency and tracking.Companies which want to work with Oracle, cannot use the same scripts and default logic.
Workflow Foundation uses services to accomplish this task. Normally you want add a SqlWorkflowPersistenceService to the Workflow Runtime Manager to enable workflow persistency.
In case of Oracle you can download the Oracle Persistency Service for Oracle databases written by Mick.



For Oracle & MySQL support, you can download the Workflow Foundation Tools (release 0.2.2 -alpha at this moment)Release date: 15th July 2007



To read more about 'Workflow Persistence' you can read the sample chapter of Bruce Bukovic's book by clicking on this link.

Tuesday, July 24, 2007

Bruce's fantastic: 'PRO WF, Windows Workflow in .NET 3.0'

I would like to suggest the wonderful book of Bruce Bukovics.
Last month I read his book "Pro WF: Windows Workflow in .NET 3.0." which I can only suggest to everyone!

The book explains you every aspect of Workflow Foundation in a very practical way!
So, just buy and read the book.

To read his blog, just click here.