SQL Server 2008 RTM IS Ready

http://msdn.microsoft.com/en-us/subscriptions/downloads/default.aspx Has Ent, Dev, Std, Web and Workgroup for subscriber downloads, can’t see Express or Ent Trial yet on the non subscriber pages.

Study EXAM 70-235

I am going to spend some time in the next couple of weeks to try the BizTalk Server 2006 Exam (70-235), I found a good guide from

http://www.biztalk247.com/v1/articles/exam70235.aspx

VS 2008 Themes

Here is the link to some great visual stuido 2008 themes

http://www.winterdom.com/weblog/2007/11/22/VS2008ColorSchemes.aspx

SQL 2008 Training Kit

Now you can download SQL 2008 training kit from
http://sqlserver2008jumpstart.microsofttraining.com/content/info.asp?CcpSubsiteID=69&infoid=27

which includes powerpoints, HOLs and demos. They are now allowing anyone who likes to download these (sadly they are built on an old CTP but should be broadly useful).

How to change the editor background to black

Here is the link to change the IDE color

http://blogs.msdn.com/saraford/archive/2007/09/06/did-you-know-how-to-change-the-editor-background-to-black.aspx

The published message could not be routed because no subscribers were found

Error Message: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

Resolution: You would try to change the Receive pipeline to “XMLReceive”, instead of “PassThruReceive”, this way is worthy to try as one of the possibilities.

BizTalk Utilities Adapter for Databases

I just found

The BizTalk Utilities Adapter for Databases allows BizTalk Server 2004/2006 to interact with any .NET Compliant Data Provider.

Support for the following .NET Data Providers are provided by default:

* Microsoft .NET SQL Server Data Provider
* Microsoft .NET Oracle Data Provider
* Microsoft .NET OLEDB Data Provider
* Microsoft .NET ODBC Data Provider
* IBM DB2 .NET Data Provider
* IBM DB2 UDB for iSeries .NET Provider
* Sybase ASE .NET Data Provider
* PgSqlClient .NET Data Provider (PostgreSql)
* MySql .NET Data Provider
* FireBird ADO.NET Data Provider
* Oracle Data Provider for .NET (ODP)
* Microsoft Host Integration Server OLEDB Interface

Data providers can be extended by simply adding a new provider definition.

Will have a try tongiht, but wonder if anyone used it before? How good is it?

http://www.topxml.com/biztalkutilities/biztalk2006DB.asp