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
Das ergibt 5 x 8 Stunden gepowertes SQL Server 2008 BI Know-How zum Preis von nur € 1.300,00. Dieser Preis beinhaltet: - 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
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
- 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)
- 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
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: - 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... :-( - 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. - 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: - Protocols, and connection and startup options:
Use SQL Server Configuration Manager - Database Engine features
Use the Declarative Management Framework - SSAS features
Use the property settings in SQL Server Management Studio - 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
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
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
These days the SQLPASS community summit in Denver has announced the spotlight speakers, and I'm one of them! Due to high demand, this assembly of industry experts and attendee favorites has been selected to present the 2007 Spotlight Sessions. Sessions will be longer (90 minutes), and each will include Q&A upon completion. Selected based on the highest scores from previous PASS events, these presenters have been identified by the user-community as some of PASS' most valuable resources. Spotlight speakers to date include:
Here are the AppDev Spotlight speakers: - Dejan Sarka - Open Schema
Dejan Sarka, MCP, MCITP Database Administrator, MCITP Database Developer, MCT, SQL Server MVP, Solid Quality Learning Mentor, is a trainer and consultant working for many MS CPLS's and other companies. Besides training he continuously works on OLTP, OLAP and Data Mining projects, especially at the design stage. He is a frequent speaker on some of the most important international conferences like TechEd, SqlDevCon and PASS. He is also indispensable on regional MS events, for example on the NT Conference, the hugest MS conference in Central and Eastern Europe. He is the founder of the Slovenian SQL Server and .NET Users Group. As a guest author, he added some parts of two books - Inside Microsoft SQL Server 2005 - T-SQL Querying and Inside Microsoft SQL Server 2005 - T-SQL Programming, both written by main author Itzik Ben-Gan. He is the main author for the self-paced training kit 441 (for exam 70-441) for MS Press. Dejan Sarka also developed two courses for Solid Quality Learning - Data Modeling Essentials and Data Mining with SQL Server 2005. - Itzik Ben-Gan - Datetime Calculations and Temporal Queries
Itzik Ben-Gan is a Mentor and Founder of Solid Quality Learning. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of Inside Microsoft SQL Server 2005: T-SQL Querying (MSPress), Inside Microsoft SQL Server 2005: T-SQL Programming (MSPress), and a co-author of Advanced Transact-SQL for SQL Server 2000 (APress). He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik's speaking activities include Tech Ed, DevWeek, PASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Learning's events to name a few. - Joe Webb - Building Developing Scalable Solutions Using SQL Server Notification Services
Joe Webb is the Chief Operating Manager of WebbTech Solutions, a Microsoft Certified Partner based in Nashville, Tennessee. Joe also serves as a volunteer on the PASS Board of Directors (since January 2002) where he is the Director of Event Operations. He has over 13 years of industry experience and has consulted extensively with companies in the areas of software development, database design, and technical training. In addition to helping his consulting clients, Joe enjoys writing and speaking at technical conferences.
Joe received a Bachelors Degree in Electrical Engineering and a Masters in Business Administration, both from Auburn University. He has also earned the Microsoft SQL Server MVP, Microsoft Certified Database Administrator (MCDBA) and Microsoft Certified Trainer (MCT) accreditations as well as other non-Microsoft certifications such as the Linux Professional Institute Level I (LPIC-1). Joe is the author of Rational Press "The Rational Guide To: IT Consulting" and The Rational Guide To: SQL Server Notification Services. - Klaus Aschenbrenner - Scaleout scenarios with Service Broker
Klaus Aschenbrenner works as a Software Architect for ANECON (Microsoft Gold Certified Partner Data Management Solutions/ISV) in Vienna - Austria. Klaus has worked with the .NET Framework and especially with SQL Server 2005 from the very beginning. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. He currently travels around the world teaching clients the core concepts of SQL Server 2005. Klaus is also the author of the book Pro SQL Server 2005 Service Broker (ISBN 1590598423) published by Apress in June 2007. - Paul Nielsen - Modeling OOA/D in SQL Server using Nordic
Paul Nielsen, SQL Server MVP, is the author of the SQL Server Bible series and presentor for Total Training's SQL Server videos. He serves as Director of Global Community Development for PASS, adn leads workshops on Smart Database Design. His website is www.SQLServerBible.com - Peter DeBetta - New T-SQL in SQL Server 2005
Peter DeBetta is an independent consultant specializing in Microsoft SQL Server design, development, implementation, and deployment. Peter DeBetta is the primary consultant at DeBetta Software, but also consults and exclusively trains SQL Server topics for Wintellect. Peter develops software using SQL Server, .NET, and other technologies. In addition to teaching SQL Server programming courses, he also speaks about SQL Server at various conferences around the world, including Microsoft's Launch Event 2005, Microsoft's SQL Server Summit, Microsoft's Visual Studio 2005 DevCon , SQL PASS Community Summit, VSLive!, DevTeach, Devscovery, TechExpo, and SQL Connections. Peter has written courseware, books and articles on the subject, including articles for MSDN Magazine and a new Microsoft Press book entitled Introducing SQL Server 2005 for Developers. Peter is a Microsoft MVP for SQL Server, an MCP, President of the North Texas SQL Server User Group, and a member of PASS. When Peter isn't working with SQL Server, you can find him singing and playing guitar, taking pictures, or simply enjoying life with his wife, son and new daughter. I'm very proud to see my name beside other SQL Server gurus like Itzik -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: -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
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
Today I've submitted the last corrections and reviews for my upcoming book "Pro SQL Server 2005 Service Broker". Thanks to all who helped me to realize this great project!!! 
-Klaus
This year I'm doing a spotlight session at the SQLPASS Community Summit taking place in Denver from September 18 - 21. My session is titled "Scaleout scenarios with Service Broker". Stay tuned for more information. 
-Klaus
A few days ago, the Pattern & Practises Team released Enterprise Library 3.0. With this new release Microsoft had made some changes in the existing application blocks (Data Access Application Block, Exception Handling Application Block, Logging Application Block), but also provides 2 new application blocks: - Validation Application Block
- Policy Injection Application Block
Furthermore Enterprise Library 3.0 consists of a Software Factory - the Application Block Software Factory. -Klaus
In the last weeks Georg Drobny (Application Development Consultant from Microsoft Austria) and I presented a session about Visual Studio 2005 Team System at the Microsoft Big>Days. The Big>Days were on 4 different locations around Austria:
-Klaus
In the last weeks and months I've read a lot about .NET 3.0 development, and there are 3 books I'll recommend on .NET 3.0 if you're new in this area: But please keep in mind, that Juval and Dharma/Bob are not presenting step by step tutorials for WCF and WF. Both authors are more concentrating on the more technical details about WCF and WF. If you want to get more out of these technologies, just read these books -Klaus
It tooks a lot of time, but my upcoming book about SQL Service Broker is already available on Amazon.com: 
-Klaus
After the succesful installation of TeamPlain on Windows Vista (please keep UAC in mind ), you can access directly from the TeamPlain website each running Team Foundation Server inside your network. After you've connected to an instance of TFS, you're redirected to the start page of TeamPlain: 
From the start page you've access to the WorkItems, the Reports, the Sharepoint Document Libraries and also the source code repository. Enclosed you'll find a few screenshots I've taken inside TeamPlain. 
For more information please refer to Harry's posting. -Klaus
This article on CodeProject.com explains the core concepts behind Windows Card Space.
Microsoft has released a great whitepaper explaining how you can do branching and merging with the Team Foundation Server. -Klaus
You must be very careful when you install SQL Server 2005 SP2 and when you've deployed a custom data processing extension for Reporting Services, because the installation of SP2 overrides the configuration files used by the Business Intelligence Development Studio and by Report Server.
-Klaus
Buck Hodges announced that Microsoft has acquired TeamPlain. TeamPlain is a web client frontend for Visual Studio 2005 Team System: Today we are announcing that Microsoft has acquired DevBiz Business Solutions, the makers of the popular TeamPlain Web Access for Team System. TeamPlain is a web front end for VSTS that enables users to access the majority of TFS functionality from within a Web browser. The focus of TeamPlain is on work item tracking but it also includes some valuable version control capabilities (like viewing history/change sets, diffing files, browsing the source base, etc.), some SharePoint integration, Reporting services integration, and some upcoming build support. TeamPlain gives VSTS a new avenue to reach a broader array of people within the development team who don’t use Visual Studio today and don’t want to install Visual Studio clients on their machines. It also improves reach by enabling some access from non-Windows clients. You can download TeamPlain without any additional charge and licensing costs from here. -Klaus
Microsoft has released some detailed information about the roadmap of Visual Studio 2005 Team System. This include information about the upcoming Orcas release and also about the Rosario release, that follows the Orcas release.
-Klaus
As Naysawn has announced the unit testing functionality is also available in Visual Studio Orcas Professional Edition. This is a big improvement, because currently you need Team System to use the unit testing functionality.
-Klaus
During the preparation for a sample for my upcoming book about SQL Service Broker I encountered a very interesting detail of the SQLCLR:
Let's assume that you want to instantiate a class through the design pattern Factory in SQLCLR. Have a look at the following code:
public interface ITask
{
void Execute();
}
public class ConcreteTask : ITask
{
public void Execute()
{
SqlContext.Pipe.Send("Hello world from ConcreteTask");
}
}
[Microsoft.SqlServer.Server.SqlProcedure]
public static void ManagedStoredProcedure(string TypeName)
{
ITask task = InstantiateTask(TypeName);
}
The interesting thing is now how you implement the method InstantiateTask. The first try was that I used the method call Activator.CreateInstance and pass the assembly name and the class name for the requested type as a parameter. But when you do this you get the following error message from SQL Server 2005:
Msg 6522, Level 16, State 1, Procedure ProcessJobServerTasks, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ProcessJobServerTasks':
System.IO.FileNotFoundException: Could not load file or assembly 'JobServer.Implementation' or one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Activator.CreateInstance(String assemblyName, String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, Evidence securityInfo, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(String assemblyName, String typeName)
at JobServer.Implementation.JobServerFactory.GetJobServerTask(String MessageType)
at JobServer.Implementation.JobServer.ProcessJobServerTasks(SqlString MessageType, SqlXml Message)
Finally I got a hint from John Mollman (http://blogs.msdn.com/mollman) from Microsoft. He suggested to use the method Type.GetType instead of Activator.CreateInstance. Here's the necessary code:
private static ITask InstantiateJobTask(string fqAssemblyName)
{
if (null == fqAssemblyName || fqAssemblyName.Length == 0)
throw new ArgumentException("AssemblyName parameter cannot be null or empty", fqAssemblyName);
Type type = Type.GetType(fqAssemblyName);
if (null == type)
{
throw new ArgumentException(string.Format(CultureInfo.InvariantCulture, "Requested type {0} not found, unable to load", fqAssemblyName), "fqAssemblyName");
}
ConstructorInfo ctor = type.GetConstructor(new Type[] { });
ITasktask = (ITGask)ctor.Invoke(new object[] { });
return task;
}
The parameter fqAssemblyName has for example the following format: JobServer.Implementation.DoNothingTask,JobServer.Implementation, Version=1.0.0.0,Culture=neutral, PublicKeyToken=neutral
As you can see from this sample you can do very interesting things with the SQLCLR in SQL Server 2005. You can write and host your own service logic programs with the SQLCLR in SQL Server 2005 and you also have the possibility to dynamically extend your service logic with patterns like the Factory design pattern described in this post.
-Klaus
My name is Klaus Aschenbrenner and I come from Vienna, Austria. I've worked with the .NET Framework and the SQL Server 2000 since the summer of 2000. For about 3 years I've worked and taught SQL Server 2005. In Austria I've also founded a user group called the .NET User Group Styria (http://www.csharp.at/). There we have monthly meetings on .NET topics. In the years 2004 & 2005 I was awarded with the Visual C# MVP award by Microsoft for my tremendous support ofthe local .NET community in Austria. I'm also the country lead of SQLPASS Austria, where we start in September with monthly meetings on SQL Server 2005 topics - stay tuned...
I'm employed as a Software Architect at ANECON (http://www.anecon.com/) in Vienna, where I'm leading several big .NET & SQL Server projects for several customers around Europe. It's a very nice place to work I'm also a regular writer on Asp Today and for the German .NET magazine DotNetPro.
In the last 2 years I have worked so much on SQL Server 2005, that I decided that I want to share this know-how with you, so that you can take advantage of it in your own SQL Server 2005 projects. In the beginning of this year I've also organized an event around SQL Server 2005 called the SQL Server 2005 Developers Summit. This was one intensive week about SQL Server 2005 where some collegues and I presented Hands-On-Labs on SQL Server 2005. All in all we had about 40 attendees, which is just great for Austria
In June my new book about SQL Server 2005 Service Broker is released by Apress: Pro SQL 2005 Service Broker. The whole book is about SQL Service Broker and how you can use the powerful messaging functionality of Service Broker in your own distributed SQL Server 2005 scenarios. So one aspect of this blog is also to give you more detailed information about my upcoming book and I will also discuss some topics and areas of the book directly here in my weblog, so that you can give me directly feedback to my opinions about this great topic!
Another big project that I've started with my girlfriend is building a house. I'll also cover about this great project, but only in german, because there are so many specific terms that I don't know in english...
So stay tuned...
-Klaus
Welcome to my new blog on http://www.csharp.at
My weblog will cover posting from the following areas:
- .NET Framework 3.0 / SQL Server 2005
- All about flying
- Our house building project (only available in german language)
Happy reading and stay tuned!
-Klaus
|