Friday, November 10, 2006 - Posts

SQL Server 2005 Compact Edition RC1

Microsoft announces the release of SQL Server 2005 Compact Edition RC1 - formerly named SQL Server Everywhere Edition. You can download it here.

One nice feature is ClickOnce support. There several steps you must take to enable ClickOnce in this edition (perhaps another blog entry...). But the work will be worth it if ClickOnce works as advertised (I haven't tested it).

:{> Andy

Technorati Tags: SQL Server Compact Edition Everywhere Edition ClickOnce

Page Vest and SQL Server 2005 Service Broker

Page Vest did an outstanding job last night at the Richmond SQL Server User Group! His presentation on SQL Server 2005 Service Broker was well-received by all in attendance.

He did a good job digging into the inner workings of queues. I learned something: there's a system queue (sys.transmission_queue) where all messages land before moving to the destination queue. The reason? The destination queue may be disabled.

Page covered that and much more - good stuff!

:{> Andy

Technorati Tags: Developer Community SQL Server Service Broker Richmond, VA Page Vest