Thursday, June 26, 2008

Techwave Picks

Here's a chronological list of all the SQL Anywhere sessions at this year's Techwave conference, with my personal picks marked.

For more information about the conference content, go here.

Tuesday 1:00 pm – 2:45 pm
Tuesday 3:00 pm – 5:30 pm
Wednesday 9:45 am – 12:00 pm
Wednesday 1:30 pm – 3:45 pm

These 9+ hour lectures over the first two days have been developed especially for TechWave by Sybase iAnywhere subject matter experts. The sessions include lab materials for the product releases being instructed when available. This intensive training allows you to return to your office with better skills than when you left. An incredibly high value proposition not available anywhere else. SQL Anywhere customers will have the option to attend education sessions in two categories, Data Management or Database Synchronization. Data Management sessions focus on data management and data exchange technologies that enable the rapid development and deployment of database-powered applications. The Data Synchronization session focus on extending information in corporate applications and enterprise systems to databases running in mission-critical frontline environments. Each of these tracks will include a first-hand look at the new features and capabilities of SQL Anywhere 11.

(My Pick) Improving Performance with SQL Anywhere

In this session we will discuss a range of performance topics for getting the most out of SQL Anywhere. We will illustrate new performance-related features of the Panorama release of SQL Anywhere, including a comprehensive description of materialized view support: definitions and motivation, benefits and penalties, design and creation issues, and maintenance techniques. We will describe in detail new functionality provided by the MERGE statement. In addition, we will describe useful diagnostic information provided by the server for pinpointing performance problems. Finally, we will describe a methodology for performance evaluation and capacity planning of SQL Anywhere database applications. We will discuss the merits of conducting systematic performance analyses, and will describe some common pitfalls of conducting performance evaluation tests which can lead to erroneous conclusions.

MobiLink Synchronization Fundamentals

This course provides an in-depth understanding of MobiLink synchronization technologies. Topics covered include distributed design concepts and techniques, maintaining uniqueness across distributed environments, handling data conflicts during synchronization, implementing security, and studying the behavior of the synchronization server and clients.



Wednesday 4:00 pm – 5:30 pm

(My Pick) Full Text Search in SQL Anywhere
Audience: IS/IT Management (I hope that's a mistake)
Exploit the new full text search capabilities in the SQL Anywhere Panorama release! This session will describe how full text indexes are built, maintenance, and how results can be combined with ordinary SQL search conditions in the same SQL query to provide a high-performance, integrated search solution for both structured and semi-structured data.

UltraLite and MobiLink - Performance Measurement & Optimization for your Mobile Solution
Audience: DBA, System Analyst, IS/IT Management, Corporate Management
This presentation will disclose lessons learned and best practices utilized by Accenture to develop large scale mobile
solutions with Sybase iAnywhere SQL Anywhere.



Thursday 8:30 am – 10:00 am

(My Pick) SQL Anywhere in a Web 2.0 World
Audience: Application Developer, DBA, System Analyst, Object Administrator, Consultant
The internet is a fast, dynamic space. The past year has seen the development of a number of new RIA (Rich Internet Application) technologies that promise a new generation of web applications. This session will examine these new technologies and explain how SQL Anywhere fits into the new web world. Examples will inlcude SQL Anywhere integration with Microsoft Silverlight, Adobe AIR , JavaFX, and Ajax using a service-based database access model.

Welcome to SQL Anywhere 11 (also Friday 1:00 pm, different description)
Audience: Application Developer
This presentation will focus on the new features delivered in the latest release of SQL Anywhere. Topics include the enhancements around performance, frontline analytics, data synchronization, and developer freedom. Also a discussion on the behavior changes and upgrade issues introduced in SQL Anywhere 11 and assist those users needing to migrate their existing databases and applications.

New MobiLink Features in SQL Anywhere 11 (also Friday 1:00 pm, same description)
Audience: Application Developer
This presentation will discuss new MobiLink synchronization features that are available in SQL Anywhere 11. Features discussed will include the Relay Server, SQL Passthrough, MobiLink Client API, end-to-end encryption, and synchronizing to a MySQL consolidated database. Also included will be a discussion on enhancements to the MobiLink server, such as the new non-blocking download acknowledgement feature, for improved efficiency and performance.



Thursday 10:30 am – 12:00 pm

Developing Database Applications for Windows Mobile using SQL Anywhere
Audience: Application Developer, DBA, System Analyst, IS/IT Management, Corporate Management, Other
Using code examples, the presentation offers an in-depth look at creating mobile database applications using leading development environments such as PocketBuilder and Visual Studio. Other topics presented include implementation best practices and handling security in mobile database applications.

Utilizing UltraLiteJ to Quickly Extend Existing SQL Anywhere Applications to BlackBerry Devices
Audience: Application Developer, System Analyst, Consultant
This session will provide methodology by which developers can extend their existing SQL Anywhere-based applications to BlackBerry devices quickly, easily, and cost-effectively by utilizing UltraLiteJ and MobiLink.

(My Pick) Offline Wikipedia with SQL Anywhere
Audience: Application Developer, Object Administrator, Consultant
Wikipedia, a popular open-content encyclopedia, is the largest and fastest growing general-reference resources on the internet. The entire wikipedia content is freely available for download, weighing in at approximately 15 gigabytes of text. While it is possible to create a complete, offline version of Wikipedia on a laptop, the lack of space and computing resources on a mobile device make it impractical on such platforms. This talk will examine a solution that allows users to keep a user-defined set of articles for offline use on a mobile device. This solution, based on SQL Anywhere, allows synchronization through services to a MySQL-based web application (MediaWiki). This talk will also explore the more general question of using a staging database to add synchronization to a web application that lacks it as a native feature.



Thursday 2:15 pm – 3:45 pm

Developing Applications for SQL Anywhere using Visual Studio
Audience: Application Developer, DBA, System Analyst, IS/IT Management, Corporate Management, Other
This session provides an overview of how to use Visual Studio to develop SQL Anywhere applications both for the desktop and for the web. The session will include an overview of ADO.NET, the data access API in the .NET Framework, and demonstrate SQL Anywhere’s support for the most recent features of Visual Studio 2008 including LINQ (Language Integrated Query) and the Entity Framework. A number of examples and demonstrations will be given including a demonstration of SQL Anywhere’s integration within the Visual Studio environment. As well, we will look at other new features of SQL Anywhere 11 that apply directly to the .NET platform.

Migrating to SQL Anywhere
Audience: Application Developer, System Analyst, Consultant, IS/IT Management
This session will provide some tips, tricks and techniques for migrating data and applications from other RDBMS vendors into a SQL Anywhere database so you can take advantage of SQL Anywhere’s capabilities in your next generation applications.

(My Pick) Leveraging Your Web Infrastructure to Create High Availability MobiLink Data Synchronization
Audience: Application Developer
Data synchronization has become an important part of many corporate information systems. Synchronizing high availability databases and setting up synchronization systems without a single point of failure are two challenges that organizations face as they bring synchronization systems to the 24/7 requirements of modern data systems. This presentation will outline architectural design considerations for leveraging existing web infrastructure to create a high availability data synchronization environment. Discussions will include synchronizing high availability consolidated and remote databases, removing single points of failure from the synchronization system, and the challenges of running 24/7 data synchronization environments. This will include discussions on the Relay server, MobiLink server farms, load balancing, and hot failover.



Friday 8:30 am – 10:00 am

(My Pick) Web Development with SQL Anywhere and PHP
Audience: DBA, System Analyst, Other
PHP is the most popular language for creating applications for the Web. SQL Anywhere has many features that make it ideal for Web applications. This talk will explore development and architecture of PHP Web applications using SQL Anywhere and deployed on IIS, Apache, or the SQL Anywhere HTTP server. We will talk about creating Web pages with dynamic content and using Web services and JavaScript with Ajax to create rich internet applications (RIAs). We will also discuss how SQL Anywhere technology can enable exciting new applications such as maintaining local copies of your Web applications or taking your Web applications off-line.

Synchronizing SQL Anywhere Databases in a .NET Environment
Audience: Application Developer, DBA, System Analyst, Object Administrator, Consultant, IS/IT Management
NET development technologies provide the ability to rapidly develop, mange, and deploy secure applications in a Windows environment. This provides easy integration of new solutions into existing infrastructure to meet growing business needs. SQL Anywhere technologies provide an array of tools and APIs to easily integrate MobiLink data synchronization in to your .NET environment. This presentation will provide development considerations when synchronizing a SQL Anywhere database in a .NET environment. Topics will include the new MobiLink client (dbmlsync) synchronization API, the MobiLink server API, object-based data flow using the Direct Row Handling API, writing .NET synchronization scripts, and server initiated synchronization.



Friday 10:30 am – 12:00 pm

Seamless Synchronization and other UltraLite Features
Audience: DBA, System Analyst, Consultant, IS/IT Management, Corporate Management
Wireless networks change many things for mobile applications, including the demands on data synchronization. No longer a batch process, data sync must now take place seamlessly behind the scenes without interrupting the user. This talk shows how to implement seamless synchronization with UltraLite databases. It also provides an overview of other new UltraLite features in SQL Anywhere 11.

Mobilizing ASE, Oracle and SQL Server Databases
Audience: Application Developer, System Analyst, Object Administrator, Consultant, IS/IT Management, Other
This presentation demonstrates how to mobilize data stored in existing enterprise backends using SQL Anywhere and MobiLink technology. Using the visual tools available in SQL Anywhere, the presentation shows the simplicity of defining and deploying data synchronization models, no matter where the enterprise data resides. The presentation illustrates data synchronization to Sybase ASE, Oracle, and Microsoft SQL Server by mobilizing the existing sample databases included with those products.



Friday 1:00 pm – 2:30 pm

Welcome to SQL Anywhere 11 (also Thursday 8:30 am, different description)
Audience: Application Developer
With any software release offering an abundance of new features, it’s often easy for a few to be overlooked. This presentation will focus specifically on the new features delivered in the latest release of SQL Anywhere - Version 11. Topics include a discussion of the enhancements around performance, frontline analytics, data synchronization, and developer freedom. The talk will include a discussion on the behavior changes and upgrade issues introduced in SQL Anywhere 11 and assist those users needing to migrate their existing databases and applications. A great introduction to SQL Anywhere 11 without having to read the documentation!


(My Pick) New MobiLink Features in SQL Anywhere 11 (also Thursday 8:30 am, same description)
Audience: Application Developer
This presentation will discuss new MobiLink synchronization features that are available in SQL Anywhere 11. Features discussed will include the Relay Server, SQL Passthrough, MobiLink Client API, end-to-end encryption, and synchronizing to a MySQL consolidated database. Also included will be a discussion on enhancements to the MobiLink server, such as the new non-blocking download acknowledgement feature, for improved efficiency and performance.

No comments: