KeyNotes 2008

Die Keynotes finden direkt im Anschluss an die Mitgliederversammlung statt.

Session - Presented by Sascha Lorenz

Sascha Lorenz ist
Gesellschafter der PSG
Projekt Service GmbH

Sascha Lorenz ist Gesellschafter der PSG Projekt Service GmbH und arbeitet als Lösungsarchitekt und Senior Consultant (MCDBA, MCSE, MCTS & MCITP) mit dem Fokus auf Microsoft Technologien und Tools (SQL Server & BizTalk). Seit 1996 ist er beteiligt an diversen Business Intelligence Projekten, Workshops und Präsentationen. Er repräsentiert sein Unternehmen als Sprecher auf Veranstaltungen, Konferenzen (u.a. European PASS Conference 2008 & SQL Days) und Usergroup Treffen. Des Weiteren ist er tätig in der deutschen SQL Server Community PASS als RGV für den Großraum Hamburg. Sascha teilt seine Erlebnisse mit der Community in seinem Blog saschalorenz.blogspot.com und als regelmäßiger Sprecher in der lokalen PASS Gruppe Hamburg.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Community Dev Project - BI meets Web 2.0

In dieser Session wird demonstriert, wie unter der Verwendung von aktuellen Microsoft Technologien ein Web Client für den Zugriff auf einen Analysis Services OLAP Cube unter SQL Server 2005 möglich ist. Als konkretes Beispiel für ein rollenbasiertes Frontend wird ein interaktives Wasserfalldiagramm vorgestellt. Des Weiteren wird die sinnvolle Integration von Sparklines an diesem Beispiel vorgestellt. Sowohl das vorgestellte Frontend als auch die genutzten Dienste für die Erzeugung der Grafiken sind Teil eines deutschen Community Projektes.

 

KeyNote - Presented by Brent Ozar

Brent Ozar,
SQL Server
Domain Expert,
Quest Software


Brent Ozar is a SQL Server Domain Expert based in the Houston area with Quest Software. Brent has a decade of broad IT experience, performing systems administration and project management before moving into database administration. In his current role, Brent specializes in performance tuning, disaster recovery and automating SQL Server management. Previously, Brent spent 2 years at Southern Wine & Spirits a Miami-based wine & spirits distributor. Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at www.brentozar.com.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

SQL Server 2008: What’s New, What’s Great, Why it’s Worth the Wait

SQL Server 2008 is intended to provide a comprehensive data platform for both structured and unstructured data that is more secure, reliable, manageable, and scalable than previous releases. In addition, SQL Server 2008 pushes the envelope with powerful new features for developers, enabling them to create new applications that store and consume all sorts of data on everything from tiny mobile devices to corporate “big iron” servers. SQL Server 2008 also provides a number of new features to turn all of that data into actionable information that enables your users to make informed decisions with new levels of insight and prescience.
SQL Server 2008, like SQL Server 2005, provides a plethora of new features and capabilities, as well as the usual bevy of bug fixes and performance improvements. Microsoft, however, has identified three areas where they’re focusing their improvements:

  • Trustworthiness of the platform, its data, and its users: provide the security, reliability, and scalability that are required by the most demanding business applications
  • Productivity of database administrators and developers: offer an array of new data-driven management solutions that reduce the time and cost of managing and developing applications
  • Business intelligence: provide a comprehensive platform for delivering and consuming intelligence when and where your users want it

That’s how Microsoft has divided up the main elements of their marketing thrust for SQL Server 2008. However, as a working DBA and developer, my mind is not on the marketing as much as it is on the particulars within SQL Server 2008 that will make my life easier and solve my particular points of pain. With that in mind, this presentation will introduce you to the features and capabilities in SQL Server 2008 that I find to be the most exciting and valuable:

Discussion Topics
  • Status check on SQL Server 2008
  • Policy-Based Management
  • Auditing & Compliance
  • GUI Improvements
  • Data Type Changes
  • Migrating to SQL Server 2008

“The Rundown” on SQL Server 2008

  • LINQ
  • Data Compression
  • Hot Adding a CPU
  • Tools
  • Resource Governor

 

>> Zurück zur Homepage

 

 

 

PASS Deutschland e.V.
Otto-Hahn-Str. 22
65520 Bad Camberg
www.sqlpass.de