Thanks for attending my sessions at the DevTeach conference in Toronto/Canada this week. As announced in all my sessions, you can download the whole material (Slides & Demos) for my sessions here:

• Message in a bottle: Service Broker from 1 to 100
• Service Broker Enhancements in SQL Server 2008
• Workflow driven Service Broker solutions
• SQL Server 2008 & the GEOGRAPHY data type

-Klaus

Thanks for attending my sessions at the European PASS conference in Neuss/Germany this week. As announced in both of my sessions, you can download the whole material (Slides & Demos) for both sessions here. Enjoy it! :-)

-Klaus

Lernen Sie konzentriert das, was Sie zur BI Programmierung mit dem SQL Server 2008 benötigen.
Sichern Sie sich Ihren Technologievorsprung zur SQL Server 2008 BI Programmierung bereits diesen Sommer!

Zielpublikum: SQL Server 2000/2005 Programmierer
Termine: Montag 02.06.2008 bis Freitag 06.06.2008
Ort: Palais Strudlhof, Pasteurgasse 1, A-1090 Wien, Anfahrtsinformationen
Kosten: € 1.300,00 (im Betrag ist keine Umsatzsteuer enthalten)
Rabatt: Ab 3 Anmeldungen pro Firma wird Ihnen ein Rabatt von 10% pro Teilnehmer gewährt!

Es ist ein eigenes Notebook mitzubringen!

Tagesablauf:

• 09:00 - 13:00 Workshops
• 13:00 - 14.00 Mittagessen
• 14:00 - 18:00 Workshops
• Abends: Abendprogramm zum Ausklang des Tages

• 5 Tage Power-Workshops zur SQL Server 2008 BI Programmierung
• Begrüßungskaffee/Tee
• Vormittagsjause
• 3-gängiges Mittagessen
• Nachmittagsjause
• Konferenzgetränke

Erfahren Sie alles was Sie zur SQL Server 2008 BI Entwicklung in der tagtäglichen Arbeit benötigen!

Warum teilnehmen?
Mit dem SQL Server 2008 stellt Microsoft eine umfassende Entwicklungsumgebung für Business Intelligence Anwendungen auf der Microsoft Plattform zur Verfügung. Das SQL Server 2008 BI Developers Summit ist daher eine ausgezeichnete Möglichkeit, sich schnell und praxisgerecht auf die BI Programmierung mit dem SQL Server 2008 ausbilden zu lassen. Bei dem Speaker (Willfried Färber, SQL Server MVP) handelt es sich um einen international anerkannten Experten, der sich bereits seit über 10 Jahren mit dem SQL Server und der Business Intelligence Entwicklung beschäftigt, und daher bereits umfangreiches Know-How aufbauen konnte und dieses in ausgezeichneter Qualität an die Teilnehmer weitergibt.

Top-Themen:

• Theoretischer Hintergrund zu Data Marts und dem Data Warehouse
• Planung, Konzept und Entwurf eines Data Warehouse
• Einführung in die Integration Services
• Erstellen von Ladejobs für ein Data Warehouse
• Einführung in die Analysis Services
• Einführung in MDX
• Erstellung und Validierung eines Cubes

Weitere Informationen finden Sie unter der Event-Homepage.

-Klaus

Thanks for attending my SQL Server 2008 introduction session on Thursday 28 in Vienna at the .NET User Group Austria, hosted by Christian Nagel. As announced in my session, you can download the samples from my session here.

-Klaus

Für das .NET 3.5 Developers Summit, dass ich vom 21.04.2008 - 25.04.2008 gemeinsam mit Christian Nagel veranstalte, gibt es noch einige freie Plätze. Wer also daran Interesse hat, meldet sich einfach bei mir.

-Klaus

In May my friends from Solid Quality are delivering the best SQL event in Vienna this year, the Solid Quality Summit Vienna! If you want to get up-to-date with SQL Server 2005/2008, don't miss this event and the following very great speakers:

• Itzik Ben-Gan
• Dejan Sarka
• Gianluca Hotz
• Davide Mauri
• Maciej Pilecki
• Herbert Albert
• Helmut Knappe
• Andreas Schindler
• Karol Papaj
• Klaus Aschenbrenner :-)

As you can see I'm also particating at this event with 2 sessions: SQLCLR development and (of course!) SQL Service Broker :-)

See you there!

-Klaus

If you want to get up-to-date with SQL Server 2008, I recommend you to visit the website SQL Server 2008 {JumpStart}. This site contains 29 Hands-On-labs around all the new features of SQL Server 2008. The SQL Server 2008 {JumpStart} event was an event delivered by SQLskills.com internally for Microsoft employees and several selected MVPs. So get your chance, grab the content from the website, and start playing around with SQL Server 2008!

-Klaus

Lernen Sie konzentriert das, was Sie zur .NET Framework 3.5 Programmierung benötigen.
Sichern Sie sich Ihren Technologievorsprung zum .NET Framework 3.5 bereits diesen Frühling!

Zielpublikum: .NET Framework 3.0 Programmierer/innen
Termin: 21.04.2008 – 25.04.2008
Ort: Palais Strudlhof, Pasteurgasse 1, A-1090 Wien, Anfahrtsinformationen
Kosten: € 1.300,00 (im Betrag ist keine Umsatzsteuer enthalten)
Vortragende: Klaus Aschenbrenner, Christian Nagel

Es ist ein eigenes Notebook mitzubringen!

Tagesablauf:

• 09:00 - 13:00 Workshops
• 13:00 - 14.00 Mittagessen
• 14:00 - 17:00 Workshops
• Abends (optional): gemeinsames Abendessen zum Ausklang des Tages

Das ergibt 5 x 8 Stunden gepowertes .NET Framework 3.5 Know-How zum Preis von nur € 1.300,00. Dieser Preis beinhaltet:

• Konferenztasche
• Begrüßungskaffee/Tee
• Vormittagsjause
• 3-gängiges Mittagessen
• Nachmittagsjause
• Konferenzgetränke

Erfahren Sie alles was Sie .NET Framework 3.5 Entwicklung in der tagtäglichen Arbeit benötigen: angefangen bei LINQ, dem ADO.NET Entity Framework, den WCF & WF Erweiterungen, der Managed AddIn Programmierung, ASP.NET AJAX und der Managed SQL Server 2008 Programmierung.

Warum teilnehmen?
Mit dem .NET Framework 3.5 stellt Microsoft die 4. Generation der .NET Laufzeitumgebung zur Verfügung. Das .NET Framework 3.5 Developers Summit ist daher eine ausgezeichnete Möglichkeit, sich schnell und praxisgerecht auf das .NET Framework 3.5 ausbilden zu lassen. Bei den Speakern handelt es sich um international anerkannte Experten, die sich bereits seit über 2 Jahren mit dem .NET Framework 3.5 und dem SQL Server 2008 beschäftigen, und daher bereits umfangreiches Know-How aufbauen konnten und dieses in ausgezeichneter Qualität an die Teilnehmer weitergeben.

Top-Themen:

• LINQ
  • LINQ to SQL
  • LINQ to XML
• ADO.NET Entity Framework
• Cryptography Next Generation
• WCF & WF Erweiterungen
• Managed AddIn Programmierung
• ASP.NET AJAX
• Managed SQL Server 2008 Programmierung

Weitere Informationen können Sie der Konferenz-Homepage unter http://developers-summit.csharp.at entnehmen.

Anmeldungen werden unter Klaus.Aschenbrenner@csharp.at entgegengenommen.

-Klaus

Within the next months I'm doing some sessions at several conferences around the world:

• DevWeek Conference (March 11 - March 14, London/UK)
• Building asynchronous, distributed Service Broker applications
• Scaleout scenarios with Service Broker
• Team System Conference (April 22 - April 24, Munich/Germany)
• Using Team Build 2008
• European SQLPASS Conference (April 14 - April 16, Neuss/Germany)
• ADO.NET Enhancements for SQL Server 2005
• SQL Server 2008 and the GEOGRAPHY data type
• DevTeach Conference (May 12 - May 16, Toronto/Canada)
• Building asynchronous, distributed Service Broker applications
• Service Broker enhancements in SQL Server 2008
• Workflow driven Service Broker solutions

I'm looking forward to meet you at one of these events :-)

-Klaus

Today Microsoft has released the February CTP of SQL Server 2008. You can download the new CTP version from here.

-Klaus

According to Bob, HTTP endpoints are deprecated in SQL Server 2008. With HTTP endpoints you had the possibility to expose stored procedures and stored functions as SOAP web services to the outside world of SQL Server 2005. But with SQL Server 2008 you have to choose some other ways, if you want to accomplish the same thing.

You could use ADO.NET Data Services  - formerly known as Project Astoria. With ADO.NET Data Services you can implement RESTful services over any type of data. You can also supply directly a stored procedure as input. So it seems that ADO.NET Data Services is the replacement for HTTP endpoints in SQL Server 2008 and any further version. This means also that the .NET runtime is getting more and more power on the Microsoft platform, because everything has to be done with .NET - also exposing stored procedures from SQL Server...

-Klaus

The short answer to the subject of this posting is NO, Visual Studio 2008 Database Edition & SQL Server 2008 November CTP are NOT working together! If I try to create a new database project inside Visual Studio 2008 and have specified the SQL Server instance where I installed the November CTP of SQL Server 2008 (for the Design-time validation database and the "real" database), then I just get a error message that Visual Studio 2008 can't connect to the SQL Server 2008 instance.

If I change the connection string for the design-time validation database to a SQL Server 2005 (SP2) instance, then I can create a new Database Edition project on a SQL Server 2008 November CTP instance...

-Klaus

Office 2007 SP1
http://www.microsoft.com/downloads/details.aspx?FamilyId=9EC51594-992C-4165-A997-25DA01F388F5&displaylang=en

SharePoint Designer SP1
http://www.microsoft.com/downloads/details.aspx?FamilyId=B57C805D-2821-4625-A6F1-80725267F887&displaylang=en

WSS 3.0 SP1
http://www.microsoft.com/downloads/details.aspx?FamilyId=4191A531-A2E9-45E4-B71E-5B0B17108BD2&displaylang=en

MOSS 2007 SP1
http://www.microsoft.com/downloads/details.aspx?FamilyId=AD59175C-AD6A-4027-8C2F-DB25322F791B&displaylang=en

-Klaus

Since today Amazon.com lists my new book Pro SQL Server 2008 Service Broker for preorder. Regarding the expected delivery of SQL Server 2008 in Q1/Q2, I'll try to release the book in June 2008.

I also welcome Remus Rusanu - ex software develop engineer in the SQL Service Broker team - as an guest author. Remus writes the complete 12th chapter, where he talks about administration and troubleshooting of Service Broker applications. Remus will also write about the tool ssbdiagnose.exe that helps you to find errors in a distributed Service Broker configuration.

-Klaus

A few days ago, the SharePoint Product Group announced the WSS 3.0 and MOSS 2007 Service Pack 1. Here are some key features:

• Support for Windows Server 2008, and therefore for IIS 7.0
• AJAX support for building web parts
• New STSAdm commands

Read more here.

-Klaus

Brian has an excellent posting why SQL Server 2008 removes the dependency of IIS and hosts the Reporting Services stuff (like Report Manager & Report Web Services) directly inside the SQL Server 2008 process through HTTP.SYS.

-Klaus

Am 28.02.2008 veranstalte ich den SQL Server 2008 Developer Day in Wien.

Der SQL Server 2008 Developer Day ist eine ausgezeichnete Möglichkeit, sich schnell und praxisgerecht auf den SQL Server 2008 ausbilden zu lassen. Bei dem Speaker handelt es sich um einen international anerkannten Experten, der sich bereits 1 - 2 Jahre professionell mit dem SQL Server 2008 beschäftigt, und daher bereits umfangreiches Know-How in diesem Bereich aufbauen konnte, und dieses in ausgezeichneter Qualität an die Teilnehmer weitergibt.

Themen

• Die neuen SQL Server 2008 Datentypen
• DATE, TIME
• FILESTREAM
• Spatial
• HierarchyID
• Table Valued Constructors
• Table Valued Parameters
• Data Compression
• MERGE T-SQL Statement
• Grouping Sets
• SQL Server Extended Events
• Change Data Capture
• Declarative Management Framework

Die Anmeldung zum SQL Server 2008 Developer Day erfolgt hier.

-Klaus

In the next 2 days I'm presenting 3 SQL Service Broker sessions at the DevTeach conference in Vancouver:

• Message in a bottle: Service Broker from 1 to 100
• Workflow driven Service Broker Solutions
• Smart Client solutions with Service Broker

You can download here my slides and the samples.

-Klaus

Microsoft drops several well-known features from SQL Server 2005 in SQL Server 2008. They are also not anymore included in the November CTP, released yesterday:

1. SQL Server Notification Services
   Key notification scenarios are covered by Reporting Services, everything else (like additional notification scenarios not available with Reporting Services) might be expected in future releases of SQL Server... :-(
2. SQL-DMO removed from SQL Server 2008 Express Edition
   SQL-DMO is replaced by the SQL Server Management Objects (SMO). So please be careful when you write new database applications based on SQL Server 2008 Express Edition.
3. Surface Area Configuration Tool
   Yes, the nicy tool first introduced with SQL Server 2005 is gone a few years after its birth. I remeber the first time, where I presented the Surface Area Configuration Tool to several customers during a SQL Server 2005 workshop, and they were very impressed of it. Starting with SQL Server 2008 you have to configure everything you have done through Surface Area Configuration as follows:

1. Protocols, and connection and startup options:
   Use SQL Server Configuration Manager
2. Database Engine features
   Use the Declarative Management Framework
3. SSAS features
   Use the property settings in SQL Server Management Studio
4. SSRS features
   Edit the RSReportServer.config configuration file directly.... :-(

-Klaus

Since today SQL Server 2008 November CTP is available. You can download it from here. It seems that Microsoft released a bunch of new products, since the .NET Framework 3.5 and Visual Studio 2008 is also available in their release versions. :-)

-Klaus

Today I've started the work on the update of my book "Pro SQL Server 2005 Service Broker" to SQL Server 2008. Therefore the new release is called "Pro SQL Server 2008 Service Broker" and is also published by Apress. In the new book I'll cover all new Service Broker features of SQL Server 2008 and also integrate new general topics around Service Broker.

The planned changes are currently as follows:

• Chapter 3 - Service Broker in Action
  - New: Management Studio Enhancements for Service Broker in SQL Server 2008.
• Chapter 4 - Service Broker Activation
  - New: Official support for external activation in Service Broker
• Chapter 9 - Service Oriented Database Architecture
  - Update: More stuff about Query Notification
• Chapter 10 - Real World Application Scenarios
  - Update: Asynchronous Triggers: I'll show how you can reuse and recycle existing conversations for better performance.
  - New: Asynchronous data warehouse loading with Service Broker
  - New: Conversation Priority
  - New: Implementing Service Broker solutions with Windows Workflow Foundation
• Chapter 11 - High Availability and Scalability
  - New: A complete scaleout sample with all available scaleout technologies
  - New: Data Dependent Routing
• Chapter 12 - Administration & Troubleshooting
  - New: Troubleshooting Service Broker applications
  - New: Diagnostic Tools

If you want that I cover additional topics about Service Broker in my upcoming book or you want give me feedback about the planned changes, please leave me a comment.

-Klaus

Today I've seen that the article "Service Broker – the asynchronous messaging framework in SQL Server 2005" that I have written several months ago for VSJ in UK was published by the end of August, ups that was a long time ago...

Read it here.

-Klaus

Heute und morgen halte ich 2 Vorträge zum SQL Service Broker bei den SQLdays in München:

• Verteilte, zuverlässige Anwendungs-Architekturen mit dem SQL Service Broker
• Zuverlässige Smart Clients mit dem SQL Service Broker

Unter http://www.csharp.at/downloads/sqldays2007.zip finden Sie meine Präsentationen und Beispiele zum Download. Ich würde mich über Ihr Feedback zu den Vorträgen sehr freuen.

-Klaus

Microsoft has released several whitepapers targeting SQL Server 2008: http://www.microsoft.com/sql/2008/learning/whitepapers.mspx

-Klaus

Today I've started with the demo preparations for my upcoming spotlight session "Scaleout scenarios with Service Broker" for the SQLPASS Community Summit in Denver (September 18 - 21). In this session I'll show you how you can scale out an existing Service Broker application to any required size. In detail you'll see:

• Load balancing : I'll take a SSB TargetService and implement load-balancing between different SQL Server machines
• Message Forwarding : After the first step (load balancing), the Initiator Service will communicate with a Message Forwarding Service, which forwards the request to the real TargetService. Because of this your internal network topology is completely isolated from your business partners.
• Configuration Notice Service : In the last and final step I'll implement a Configuration Notice Service for the Message Forwarder, so that the routes to the internal hosted services are created on demand. Therefore you have the chance to dynamically move your SSB services inside your environment.

What do you think? What kind of scale out scenarios would you will see in my session?

Thanks

-Klaus

In the next months I have several speaking engagements around the whole world. I'm looking forward to meet you at some of these events! :-)

PASS Essentials: Workshop zum SQL Server 2005 „Service Broker“

27.08.2007 – Microsoft Bad Homburg, Germany

http://www.sqlpass.de/Default.aspx?tabid=159

Gesamtziel des Workshops:

Das Ziel des Workshops ist das Verständnis und der praktische Umgang mit dem SQL Server 2005 Service Broker. Der Service Broker ist ein asynchrones Messaging Framework, das direkt in den SQL Server 2005 integriert wurde. Dadurch lassen sich skalierbare, sichere, verteilte und asynchrone Datenbankanwendungen sehr einfach und leicht mit dem SQL Server 2005 erstellen.

Teilnehmer Voraussetzungen:

· Kenntnisse von SQL Server 2005

· T-SQL

· Managed Development

· Grundlegende Programmierkenntnisse

Weitere Kursinhalte:

· Grundlagen der nachrichtenbasierten, asynchronen Entwicklung

· Warum Service Broker?

· Vergleich Service Broker mit anderen Messaging Systemen (WCF, MSMQ)

· Grundlagen der Service Broker Entwicklung

· Service Broker Objekte

· T-SQL Erweiterungen im Bereich Service Broker

· Senden und Empfangen von Service Broker Nachrichten

· Service Broker Aktivierung

· Interne Aktivierung

· Externe Aktivierung

· Service Broker & Managed Code

SQLPASS 2007 Community Summit

18.09.2007 – 21.09.2007 – Denver, USA

https://www.sqlpass.org/summit/Pages/default.aspx

Session “Scaleout Scenarios with Service Broker”:

SQL Server 2005 provides a lot of scaleout technologies. In combination with Service Broker you can build message-based applications that can be scaled out to any required workload and size. In this session you will learn the basics of achieving scaleout scenarios with Service Broker. We’ll cover in detail:

• Scaling out with Service Broker
• Database Mirroring
• Load Balancing o Routing
• Service Broker message forwarders
• Data-Dependent Routing

Klaus Aschenbrenner ist einer der wenigen europäischen Sprecher denen es gelungen ist, von der SQLPASS USA eine Einladung für eine Spotlight-Session zu erhalten. Solche Einladungen werden nur ausgesprochen, wenn die vorjährige Session extrem guten Zuspruch erhalten hat.

.NET 3.0 Developers Summit

24.09.2007 – 28.09.2007 – Wien

http://developers-summit.csharp.at

Mit dem .NET Framework 3.0 stellt Microsoft die 3. Generation der .NET Laufzeitumgebung zur Verfügung. Das .NET Framework 3.0 Developers Summit ist daher eine ausgezeichnete Möglichkeit, sich schnell und praxisgerecht auf das .NET Framework 3.0 ausbilden zu lassen. Bei den Speakern handelt es sich um international anerkannte Experten, die sich bereits seit über 2 Jahren mit dem .NET Framework 3.0 beschäftigen, und daher bereits umfangreiches Know-How aufbauen konnten und dieses in ausgezeichneter Qualität an die Teilnehmer weitergeben.

Klaus Aschenbrenner ist Organisator des .NET 3.0 Developers Summit und hält einen 1,5 tägigen Workshop zur Windows Workflow Foundation.

SQLdays 2007

05.11.2007 – 06.11.2007 – Munich, Germany

http://www.sqldays.net

Drei parallele Workshop-Reihen (Administration, Entwicklung, Business Intelligence) bieten fundierte Informationen rund um .NET, SQL Server und Analysis Services und geben nützliche Praxisbeispiele, die Ihre tägliche Arbeit erleichtern und unterstützen sollen.

Spezialisten von Microsoft und unabhängige Experten zeigen Ihnen „echten“ Live-Code und stehen dazu Rede und Antwort.

Die SQLdays genießen in der Branche einen hervorragenden Ruf und bieten Weiterbildung auf hohem Niveau in kompakter Form, die im deutschsprachigen Raum einmalig ist.

Die Jahreskonferenz für die SQL Server Community ist interessant für alle, die mit dem SQL Server arbeiten, die Leistungsfähigkeit und Funktionsvielfalt der Datenbank optimal nutzen möchten und aktuelle Informationen und Statements vom Hersteller suchen.

DevTeach 2007

26.11.2007 – 30.11.2007 – Vancouver, Canada

http://www.devteach.com

Session “Smart Client Solutions with Service Broker”

One requirement of Smart Clients is the support of offline scenarios. Fortunately, Service Broker provides you a reliable messaging framework that also supports offline scenarios for your Smart Client applications. In this session you’ll learn how to integrate Service Broker into your Smart Client applications to provide reliable messaging and offline scenarios out of the box for your users. Finally, you’ll see how easy it is to extensibility configure security between your front-end Smart Client applications and back-end database servers.

Session „Workflow driven Service Broker solutions“

Service Broker is an asynchronous messaging framework directly built into SQL Server 2005. Windows Workflow Foundation (WF) on the other hand is the new workflow framework that is part of the .NET framework 3.0. This “No slides – just code” session shows you, how you can create Service Broker solutions that are driven by a workflow implemented with WF.

Session “Message in a bottle: Service Broker from 1 to 100

Service Broker provides several new key features for building SOA applications directly with SQL Server 2005. This "No slides – just code" session shows you, in just 75 minutes, how to build an SOA-based, secure, reliable, and distributed messaging application with SQL Server 2005 Service Broker from scratch. We’ll cover: The core architectural concepts behind Service Broker How you can do SOA with Service Broker – a practical approach Advanced Topics – from the field Routing between several SQL Server instances Securing a Service Broker conversation between you and your trading partners Using managed code in Service Broker applications.

-Klaus

Today Microsoft released the July CTP of SQL Server 2008. You can find the download here and more information about the new July CTP features here.

-Klaus

These days Microsoft released the Windows Server 2008 Developer Training Kit with tons of information ranging from IIS 7 to the .NET Framework 3.0, HPC and virtualization.

-Klaus

Today I prepared a Service Broker Hands On Lab and restored the AdventureWorks database from another SQL Server. As soon as I wanted to send a message from one Service Broker service to another, sys.transmission_queue contained my sent message with the following error message:

Cannot execute as the database principal because the principal "dbo" does not exist.

After some research on Google, I get the solution from the following MSDN Forum Thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=348709&SiteID=1

You must change the owner of the database to a valid login, when you moved it between different servers.

ALTER DATABASE ON DATABASE::[AdventureWorks] TO [SA];

Thanks Remus!

-Klaus

This week I received the authors copy of my book "Pro SQL Server 2005 Service Broker", published by Apress. :-)

From the original ideas and plannings of the book it tooks about 11 months, until I hold my book in my own hands :-)

-Klaus

Yesterday Rick Negrin - the program manager of Service Broker - announced at the MSDN forum the new features of Service Broker in SQL Server 2008:

Conversation Priority -  This feature allows the messages of a one conversation to be prioritized higher than the priority of another conversation.  The priority affects both the sending and the receiving side.  On the sending side it affects the order messages from different conversations are put on the wire as they are pulled out of the transmission queue. On the receiving side it affects the order in which the next conversation group is chosen via a RECEIVE call.  A priority only applies to one side of the conversation (i.e. priority does not travel across the wire).  Priority information is stored in a system table and DDL is used to create/alter the priority.  You can configure priority via local service name, remote service name, and contract.  The system uses these rules to set the priority of a conversation at the time it is created.  The priority level will not change for the lifetime of the conversation.

Diagnostic Tool - This is a command line tool that allows you to easily diagnose both configuration and runtime problems in your Service Broker application.  It reports the errors as it finds them along with recommendations on how to fix them.  Below are examples of the kinds of problems it can find:

- Service Broker is not enabled

- A route is missing

External Activation - Activation is the mechanism that launches business logic to process messages whenever there is an event on the queue (such as message arrival, queue enabled, timer, etc...).  In Yukon the business logic had to be a stored procedure.  This is what we call "internal activation" because the business logic runs inside the database.  In Katmai we are supporting "external activation" where the business logic can run outside the database.  This works by having an NT service,  that runs on the same machine as the database or a different machine, watch a queue for events. When a queue event happens it starts the associated process.  The executable file is bound to the queue via an XML configuration file deployed with the NT service.  The Service Broker team supported external activation as a sample for Yukon but it is being productized for Katmai.  The Katmai tool will support both Katmai and Yukon instances.

Management Studio Enhancements - Of course one of our top asks has been for better Management Studio enhancements for the Broker objects.  We will be adding additional actions, such as a Create and Alter on all the Service Broker objects in the Object Explorer.  We will also add custom actions like "Enable Activation".  There will also be a grid view of the contents of a queue and a property page.

These features are currently not available in the June CTP of SQL Server 2008. So we have to wait for a later CTP... :-(

-Klaus

In the last days I've played around with the SQL Server 2008 June CTP features. Especially those were:

• The new dynamic management views (DMVs)
• The new MERGE T-SQL statement
• CDC - Change Data Capture
• UDTT - User Defined Table Type
• Declarative Management Framework Policies

In the next days I give you some information about these new features with some postings about it.

Stay tuned :-)

-Klaus

eScrum is a Web-based, end-to-end project management tool for Scrum built on the Microsoft Visual Studio Team Foundation Server platform. It provides multiple ways to interact with your Scrum project: eScrum Web-based UI, Team Explorer, and Excel or Project, via Team Foundation Office Integration. In addition, it provides a single place for all Scrum artifacts such as product backlog, sprint backlog, task management, retrospective, and reports with built-in context sensitive help.

Download

-Klaus

Microsoft has posted a very interesting article about the TFS Cube. If you're using TFS for project management, this is a must read! :-)

-Klaus

Since yesterday the first public CTP of SQL Server 2008 is out. The big question is now where you can find resources about SQL Server 2008.

First of all Microsoft also released an updated version of BOL for SQL Server 2008. The drawback on this is, that there is too less information about the new features in SQL Server 2008. After surfing through the internet I've found the following two interesting resources about SQL Server 2008:

• SQL Server 2008 Product Overview
• SQL Server 2008 Overview Web Cast

-Klaus

Today Microsoft released the first CTP version of SQL Server 2008 - formerly known under SQL Server Katmai. You can download the CTP from here.

-Klaus

Today Microsoft released the first CTP version of Acropolis which is the successor of CAB (Composite Application Block), which targets now WPF developer.

-Klaus

My Book "Pro SQL Server 2005 Service Broker" consists of the following 12 chapters:

Chapter 01 - Fundamentals of Message Based Processing

Chapter 02 - Introduction to Service Broker

Chapter 03 - Service Broker in Action

Chapter 04 - Service Broker Activation

Chapter 05 - Service Broker with Managed Code

Chapter 06 - Locking and Transaction Management

Chapter 07 - Distributed Service Broker Applications

Chapter 08 - Advanced Service Broker Programming

Chapter 09 - Service Oriented Database Architecture

Chapter 10 - Real World Application Scenarios

Chapter 11 - High Availability and Scalability

Chapter 12 - Adminstration

-Klaus

Today Amazon.com announces that my book "Pro SQL Server 2005 Service Broker" is available in stock!

Yeah!!!

-Klaus

Today Microsoft announced Surface, a 30-inch tabletop display whose unique abilities allow for several people to work indepentently or simultaneously. All without using a mouse or a keyword.

Visit the offical homepage and and an introduction video on Major Nelsons blog.

-Klaus

Prof. Dr. Andreas Polze released some webcasts about operating system architectures used inside the Windows OS. The whole web casts are around 60 hours and are only available in german language...

http://www.tele-task.de/page42_mode1_series473.html

http://www.tele-task.de/page42_mode1_series591.html

-Klaus

Today a customer asked me how they can use hierarchical work items inside TFS. The answers lies in the Work Item Creator, released at Codeplex.

-Klaus

The pattern & practices team has released the Beta 1 version of the Team Development Guide at Codeplex. It's a PDF document with 360 pages - all around Team Foundation Server. Here's the TOC:

• Introduction
• Ch 01 - Introducing the Team Environment
• Ch 02 - Team Foundation Server Architecture
• Ch 03 - Structuring Projects and Solutions
• Ch 04 - Structuring Projects and Solutions in Team Foundation Server
• Ch 05 - Defining Your Branching and Merging Strategy
• Ch 06 - Managing Source Control Dependencies in Visual Studio Team System
• Ch 07 - Team Build Explained
• Ch 08 - Setting Up Continuous Integration with Team Build
• Ch 09 - Setting Up Scheduled Builds with Team Build
• Ch 10 - Large Project Considerations
• Ch 11 - Project Management Explained
• Ch 12 - Work Items Explained
• Ch 13 – MSF Agile Projects
• Ch 14 - Process Templates Explained
• Ch 15 - Reporting Explained
• Ch 16 - Team Foundation Server Deployment
• Ch 17 - Providing Internet Access to Team Foundation Server

-Klaus

This cumulative update package contains the SQL Server 2005 hotfixes that have been released since the release of SQL Server 2005 SP2.

-Klaus

The designer conference MIX07 was last week in Las Vegas. If you missed it, you should attend xtopia from October 10 - 11 in Berlin, Germany.

-Klaus

Today I got the following email from Apress:

Hi Klaus,
We've finally made it through the production process, and I'm pleased to announce that your book Pro SQL Server 2005 Service Broker shipped to the printer this morning. Congratulations on a job well done! I'm looking forward to seeing the book in print--as I'm sure you are!

Yeah!!! :-)

-Klaus

Today Microsoft has announced the first official infos about the upcoming SQL Server release code named "Katmai". The areas of improvements are:

• Mission Critical Platform for All
• Beyond Relational
• Redefining Pervasive Insight
• Dynamic Development for Data Management Solutions

I'm also looking forward if Katmai provides something for integrating Office 2007 and MOSS 2007... :-)

-Klaus

Nach langem Warten ist es endlich wieder so weit: am 31.05. findet das nächste Treffen der .NET User Group Styria am Campus02 der WIFI Stmk statt. Dieses Mal findet ein Vortrag von Stefan Schnuderl zum Thema MSBuild statt:

Ein Build ist mehr als F5.

Durchgehende Automatisierung des gesamten Buildvorganges, beginnend bei der Kompilierung und der Durchführung von Tests über die Erstellung von Setups bis hin zum Deployment ist für große und auch gar nicht so große Softwareprojekte ein entscheidendes Erfolgskriterium. Was von java-Seite über Ant und Maven hin zu NAnt führte, ist seit der 2.0er Version in Form von MSBuild fixer Bestandteil des .NET-Frameworks. Was Buildsysteme zu leisten imstande sind und wieso es Sinn macht, einen Build zu haben, der mehr tut als nur zu kompilieren, wird in diesem Vortrag von Stefan Schnuderl näher beleuchtet. Er wird NAnt und MSBuild in einen direkten Vergleich führen und die Vor- sowie Nachteile der beiden Produkte erläutern.

Stefan Schnuderl

Stefan Schnuderl ist Gesellschafter des MS-Gold-Certified Partners SOLVION und beschäftigt sich mit Systemarchitekturen und Softwareentwicklungsprozessen. Er ist Senior Consultant im Geschäftsbereich ‚Development Consulting’. Unter anderem ist er als Systemarchitekt für die RFID-Middleware You-R OPEN mit einem bisherigen Entwicklungsaufwand von über 30 Personenjahren verantwortlich. Stefan Schnuderl entwickelt Software seit seinem 16. Lebensjahr und hat in diesem Zuge über Assembler, C, C++ und Java ein weites Technologiespektrum kennen und schätzen gelernt, bevor er vor fünf Jahren auf die ersten Releases von .NET und C# stieß. Gerade dieses weite Spektrum erlaubt ihm, Technologien auf ihre Stärken und Schwächen hin optimal für den Einsatz in komplexen Softwaresystemen bewerten zu können. Seine spärliche Freizeit verbringt Stefan Schnuderl mit Projekten des Filmverein LOOM sowie der Theatertruppe ‚Die Gaukler’.

Anmeldungen werden unter Klaus.Aschenbrenner@csharp.at entgegengenommen.

-Klaus

Microsoft released the BizTalk Services SDK.

-Klaus