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

As you might already know from my previous blog postings, I’m currently building a fully-sized Boeing 737-800 flight simulator based on Microsoft Flight Simulator X. Please refer to this blog category for more information and pictures. The feedback along the several past months about this eciting project was very great and constructive:

• “Klaus, you are just insane!”
• “Keep going”
• “Nice idea, when can I come flying?”
• “Just great, when you arrange the next flying evening – I’m bringing the beer ”
• “It can’t be described with words – it’s just fabulous”
• “Can you bring your flight simulator to my next customer event? I think they will like it…”

As you can see from this feedback, I think I’m on the right direction with this amazing project. But when I looked at this feedback, I was thinking a lot of time about the last statement: “Can you bring your flight simulator to my next customer event? I think they will like it…”. The (short) outcome of the thinking process is easy – with the current configuration and the big size of the flight simulator, I’m not able to move it out of the room – so there’s no chance to move it out of my house…

But, there was more! The other outcome of my thinking process leaded me to the following idea: I’m currently building a 2nd “mobile” version of the flight simulator which can be taken from one place to other places very easy, because it is based on several distinct modules, which can be disassembled very easily. This 2nd version of my flight simulator just consists and simulates the pilot side of the Boeing 737-800, and NOT the co-pilot side, which is far enough for this “simplified” version. With this version, which will be available within the next 1 – 2 months (it mainly depends on my workload in my real-life), I’m then able to “fly” from event to event – AND also to YOUR events!

So if you think that this flight simulator will be an attractive/amazing option for YOUR event, just drop me line at Klaus.Aschenbrenner@csharp.at, and I will get back to you to discuss further details, how we can bring your event to a new dimension through flight simulation technology

-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

Das ergibt 5 x 8 Stunden gepowertes SQL Server 2008 Know-How zum Preis von nur € 1.300,00. Dieser Preis beinhaltet:

• 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

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

Top-Themen:

• 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

Here are some impressions of my first maiden flight in my own Boeing 737-800 flight simulator. I’m currently running the whole Project Magenta software suite for the captain side consisting of the MCP, the PFD, the ND, the EICAS, and the FMC. As a computer hardware foundation I’m using 4 PCs dedicated to the following roles:

• PC #1: Run’s the flight simulator with FSUIPC
• PC #2: Run’s the Glass Cockpit consisting of PFD and ND, and the MCP software
• PC #3: Runs’ the lower and upper EICAS software
• PC #4: Run’s the FMC software

During the maiden flight with this flight configuration was situated around the area of Vienna – LOWW. I departured at RW 29 heading to the west of Vienna.

As you can see I’m the auto pilot has taken me to 9000ft, with a cruising speed of 300kt with the heading 295. (Yes, I know there’s the speed restriction of 250kt under 10.000ft, but I’m in a simuator ). Here you can see the programmed FMC for the SITN2X SID from RW 29 in LOWW (but only for demonstration purposes, because I didn’t activated the programmed route)

After crossing Tulln (LOXT), I was on course towards Langenlois (LOAG) where I returned back home on course 114 heading to RW 11 in LOWW.

As you can see the auto pilot (in a single channel approach) is establishing the plane on the glideslope and localizer of RW 11. We are 6,5 miles away from the touchdown point at around 2600ft at 210kt.

We are cleared to land

Last corrections are done by the auto pilot…

Everything is fine.

Stay tuned

-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

On May 23, we (Karin & I) had our wedding in Salzburg. Enclosed some impressions:

For our entertainment Tricky Niki joined us. Niki is a magician specialized in card tricks, pickpocketing and ventriloquism. The following picture shows Niki with Emil during his ventriloquism act

So if you have a party, wedding etc, and need some entertainment don’t hesitate to contact Niki - just trust me: you will have a lot of fun!!!

-Klaus & Karin

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.