SQLdays ist die Konferenz für die deutschsprachige SQL Server Community vom 19.-20. Oktober 2010 in Rosenheim. Freuen Sie sich auf drei parallele Tracks mit über 20 Sessionszu SQL Server Administration, Entwicklung und Business Intelligence. Treffen Sie Datenbank- und BI-Experten wie Klaus Aschenbrenner, Markus Raatz, Steffen Krause, Thomas Grohser oder Willfried Färber persönlich und erfahren Sie News aus erster Hand und wertvolle Tipps und Tricks aus der Praxis. In ganztägigen Workshops vor und nach der Konferenz haben Sie zudem die Gelegenheit spezielle Themen nochmal bis ins Detail zu vertiefen.

Sichern Sie sich jetzt Ihre Teilnahme unter www.SQLdays.net

As announced in my sessions and my workshop at the Solid Quality Summit in Vienna, you can download the materials from here:

• FILESTREAM Storage Attribute
• SQL Server 2008 R2 StreamInsight
• SQL Server 2008 Database Internals
• Understanding SQL Server Execution Plans
• SQL Server 2008 Index- and Performance Tuning

Thanks for attending my sessions and have fun :-)

-Klaus

As announced in my Developer Camp workshop in Berlin you can download my workshop material from here:

• SQLCLR/Service Broker

Thanks for attending my workshop and have fun :-)

-Klaus

As announced in my European PASS session you can download my session material from here:

• FILESTREAM Storage Attribute

Thanks for attending my session and have fun :-)

-Klaus

As announced in my VSOne sessions and in my workshop you can download my session material from here:

• FILESTREAM Storage Attribute
• StreamInsight
• Effektive SSIS ETL Prozesse
• Data Warehouse/Busines Intelligence Workshop

Thanks for attending my sessions and have fun :-)

-Klaus

As announced in my FILESTREAM talk you can download my session material from here:

• The FILESTREAM storage attribute

Have fun and thanks for attending my session :-)

-Klaus

As announced in my SQLdays sessions and in my workshop you can download my session materials from here:

• Message in a Bottle: Service Broker from 1 to 100
• FILESTREAM Storage Attribute
• T-SQL 2008 Enhancements
• Data Warehouse/Business Intelligence Workshop

Have fun :-)

-Klaus

SQL Server 2008 Developers Summit - Das Power-Event zur SQL Server 2008 Programmierung!
Lernen Sie konzentriert das, was Sie zur SQL Server 2008 Programmierung benötigen.
Sichern Sie sich diesen Herbst Ihren Technologievorsprung zum SQL Server 2008!

Zielpublikum: SQL Server 2005 Programmierer/innen
Termine: Montag 14.12.2009 bis Freitag 18.12.2009
Ort: Palais Strudlhof, Pasteurgasse 1, A-1090 Wien, Anfahrtsinformationen
Kosten: € 1.300,00 (im Betrag ist keine Umsatzsteuer enthalten)
Es ist ein eigenes Notebook mitzubringen!

Tagesablauf:

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

• 5 Tage Power-Workshops zum .NET SQL Server 2008
• Aktuelles Buch zum SQL Server 2008
• Begrüßungskaffee/Tee
• Vormittagsjause
• 3-gängiges Mittagessen
• Nachmittagsjause
• Konferenzgetränke

• Resource Governor
• Policy based Management
• Data Collector
• Change Data Capture
• T-SQL 2008
• Business Intelligence Inside/Outside
• Managed SQL Server 2008 Programmierung
• Preview: SQL Server 2008 R2!

Weitere Informationen zum genauen Inhalt und zur Anmeldung finden Sie unter http://developers-summit.csharp.at

-Klaus

After a long time of work, I finally finished today my presentations for the Solid Quality Summit which takes place next week here in Vienna. I’m presenting the following sessions:

• ADO.NET Enhancements
• Spatial Data support in SQL Server 2008
• Service Broker Scaleout scenarios
• T-SQL Enhancements in SQL Server 2008

On friday I’m doing a whole day workshop about the SQLCLR integration in SQL Server 2008. As you can see, I have a lot of work to do next week. I’m looking forward to next week, to see many good friends from Solid Quality :-)

-Klaus

As announced in both of my sessions at the European PASS conference in Neuss/Germany last week, you can download the sample code here:

• T-SQL enhancements in SQL Server 2008
• Spatial data support in SQL Server 2008

I hope you have enjoyed my sessions :-)

-Klaus

Wir nähern uns mit großen Schritten dem Solid Quality Summit vom 22. bis 26. Juni, dem SQL Server Event des Jahres in Wien. Nun ist auch der Session Schedule fixiert. Einige Mentoren wie Dejan Sarka, Davide Mauri oder Klaus Aschenbrenner schleifen auf der European PASS Conference in Neuss gerade Ihre Sessions zurecht, um für das anspruchsvolle Publikum in Wien optimal vorbereitet zu sein. Aber auch Itzik  Ben-Gan, dessen Buch „SQL Server 2008 Query Tuning“ soeben erschienen ist, Herbert Albert, Gianluca Hotz und die anderen Vortragenden scharen bereits in den Startlöchern, um Sie an ihren neuesten Erkenntnissen teilhaben zu lassen. Erleben Sie die einzigartige Kombination aus High-End Content und familiärer Atmosphäre beim Solid Quality Summit in Wien!

Alle Detailinformationen zum Summit finden Sie hier.

Anmeldeseite:.

Seminare:

Montag, 22.06.2009:
Itzik Ben-Gan: Inside T-SQL for SQL Server 2005 and 2008 (Room1)
Herbert Albert: Disaster Recovery (Room2)

Freitag, 30.06.2009:

Dejan Sarka: Data Modelling Essentials (Room1)
Klaus Aschenbrenner: Managed Code Development with SQL Server 2008 (Room2)

Session Schedule:

Day	Time	Speaker	Room1	Speaker	Room2
23.06.2009	09:00-10:15	Itzik Ben-Gan	Minimally Logged Inserts and other Data Modification Enhancements in SQL Server 2008	Dejan Sarka	Advances in Relational Databases
10:30-11:45	Aaron Johal	Help! My operational system is getting slower and slower!	Helmut Knappe	Implementing Many-to-many Relationships in SQL Server Analysis Services to Model Complex Business Solutions
13:30-14:45	Itzik Ben-Gan	Islands and Gaps Problems	Michael Sass	Meta Data Locks -  Analysis and Performance Problems
15:00-16:15	Aaron Johal	Using Visual Studio Team System 2008 Database Edition to resolve the data perception	Helmut Knappe	Charts in Reporting Services 2008
16:30-17:45	Itzik Ben-Gan	Advanced T-SQL Tips & Tricks	Andreas Schindler	Best Practice ETL
24.06.2009	09:00-10:15	Klaus Aschenbrenner	Scaleout scenarios with SQL Server & Service Broker	Dejan Sarka	Understanding XQuery,
10:30-11:45	Itzik Ben-Gan	Using the HIERARCHYID Datatype in SQL Server 2008	Davide Mauri	Set Based solution: an approach for developers
13:30-14:45	Klaus Aschenbrenner	T-SQL Erweiterungen im SQL Server 2008	Gianluca Hotz & Herbert Albert	Implementing SQL Server 2008 Policy Based Management
15:00-16:15	Itzik Ben-Gan	Aggregating Data in SQL Server 2008 Using Grouping Sets	Gianluca Hotz & Herbert Albert	SQL Server 2008 Policy Based Management and multi-server administration
16:30-17:45	Klaus Aschenbrenner	ADO.NET Enhancements für SQL Server 2005/2008	Davide Mauri	Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
25.06.2009	09:00-10:15	Dejan Sarka	Design Myths	Andreas Schindler	Solving Business Problems with MDX
10:30-11:45	Helmut Knappe	Business Intelligence Myths	Aaron Johal	Why must I shoehorn my data into tables? I need total flexibility to develop in an agile way!
13:30-14:45	Dejan Sarka	Temporal Data in SQL Server 2008	Andreas Schindler	Change Management für Analysis Services Cubes
15:00-16:15	Gianluca Hotz	Oracle to SQL Server migration for Developers I	Helmut Knappe	Using Windows PowerShell in BI
16:30-17:45	Gianluca Hotz	Oracle to SQL Server migration for Developers II	Klaus Aschenbrenner	SQL Server 2008 und der GEOGRAPHY Datentyp

Preise:

Full Summit 5 Tage inkl. 1Day Classes(regulär): 1.990,00 Euro (exkl. Ust.)

Full Summit 5 Tage inkl. 1Day Classes(Early Bird): 1.790,00 Euro (exkl. Ust.)

Early Bird bis 11.05.2009

1Day Class only 590,00 Euro (exkl. Ust.)

Slim Conference 3 Tage 1.490,00 Euro (exkl. Ust.)

Anmeldung:

Für Gruppen ab 3 Teilnehmern gibt es spezielle Ermäßigungen. Näheres dazu erfahren Sie per Mail unter flechnitz@solidq.com bzw. am Telefon unter +43 (676) 5397927

Bitte beachten Sie bei der Anmeldung für 1Day Classes, dass Full Conference Teilnehmer bevorzugt behandelt werden, sollten die vorhandenen Plätze knapp werden.

Ort:

it-versity

Schottenfeldgasse 69

1070 Wien

Wir freuen uns darauf, Sie im Juni beim Solid Quality Summit 2009 in Wien, dem SQL Server-Event des Jahres begrüßen zu dürfen.

As announced in my session at the SQLBits conference in Manchester, you can download the sample code here. I hope you enjoyed my session and my attractive back :-)

-Klaus

As announced in both of my sessions here at the DevWeek conference in London, you can download the sample code here. But the download files will be online on Sunday, when I'm returning to Vienna :-)

• ADO.NET Enhancements for SQL Server 2005/2008
• Building a distributed enterprise application with the .NET framework 3.5

I hope you have enjoyed my sessions :-)

-Klaus

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

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

Thanks for attending one of my SQL Service Broker sessions at the DevWeek Conference in London last week. As announced in both of my sessions, you can download the whole material (Slides & Demos) for both SQL Service Broker sessions here. Enjoy it! :-)

-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

Für den SQL Server 2008 Developer Day sind noch ein paar Restplätze frei - wer also daran Interesse hat, kann mir eine Email schreiben.

-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

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

Brian hat einen sehr guten Blogeintrag verfasst, der beschreibt warum der SQL Server 2008 nicht mehr den IIS für die Reporting Services (Report Manager, Report Web Services) verwendet. Im SQL Server 2008 werden die Reporting Services direkt durch die Verwendung von HTTP.SYS gehostet.

-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

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

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

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

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

-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