SQL Anywhere Education Seminar - SOLD OUT
Registration for this seminar has reached maximum capacity, and we are no longer able to accept new registrants. If you are interested in being added to a waiting list, please email sybase.techwave@sybase.com.
Overview
SQL Anywhere offers database and synchronization technologies proven by 12,000 customers to perform in demanding workgroup, embedded, and mobile applications. This in-depth technical track will explore introductory and advanced topics in database and synchronization, as well as new features in SQL Anywhere 11 (including full-text search, server monitoring tools, in-memory mode, Blackberry support, and Relay Server synchronization architecture). Delivered by SQL Anywhere experts, the track offers novice and advanced SQL Anywhere developers the chance to learn about performance and tuning, .NET integration, Web development, synchronization and much more.
On Wednesday, attendees will hear senior staff from the SQL Anywhere engineering team discuss best practices for developing database and synchronization solutions and insight into SQL Anywhere 11 and beyond. On Thursday, two parallel SQL Anywhere tracks are offered: Data Management and Synchronization. The Data Management track will take an in-depth look at new tools like the SQL Anywhere Monitoring tool and Hibernate driver as well as Performance Analysis and other developer enhancements. The Synchronization track will focus on MobiLink functionality and features, BlackBerry and Windows Mobile application development, security considerations and mobile applications of the future.
Who Should Attend?
Wednesday Afternoon:
Existing and prospective SQL Anywhere customers and partners wanting an overview of Sybase SQL Anywhere, and its future direction.
Thursday:
Existing and new SQL Anywhere users will benefit from this second day of in-depth training.
Agenda
Wednesday afternoon
SQL Anywhere State of the Union
The extreme demands of a wide range of server, embedded and mobile applications are handled by SQL Anywhere today – from a mobile field service application synchronizing 140,000 users daily, to a departmental database server processing over 20,000 transactions per minute. This session will introduce you to SQL Anywhere’s database and synchronization technologies and educate you on different ways your workgroup, embedded and mobile projects can benefit from using SQL Anywhere. In addition to learning about the latest capabilities that SQL Anywhere has to offer, attendees will also get a glimpse into future plans and roadmaps.
SQL Anywhere Development Best Practices
This talk focuses on application development best practices with SQL Anywhere. A wide range of topics are covered, with the overall goals of improving application performance and extending the longevity and robustness of client applications through the application of solid design techniques. Topics covered include aspects of schema design, choice of isolation level, and tradeoffs of various application components including cursor types, user-defined functions, and other related topics.
Taking it all offline with SQL Anywhere
Despite all the benefits of web applications (such as easy application deployment and management), they universally suffer from one key limitation: they can only be used when a network connection is available. This requirement prevents web applications from working in an occasionally-connected model. This talk will examine how SQL Anywhere can help solve this problem, and take your current web application offline by locally hosting, managing, serving, and synchronizing your application and data with your current database.
Thursday – Track 1: Data Management with SQL Anywhere
Introducing the SQL Anywhere Monitor
The SQL Anywhere Monitor is a new browser-based tool that provides you with information about the health and availability of SQL Anywhere databases and MobiLink servers. It allows you to store and view months of diagnostic data about your servers, giving you access to historical information when diagnosing problems or determining usage patterns. This talk will explore the features of the SQL Anywhere Monitor including installation and setup.
Object Relational Mappers: Friend or Foe?
Object relational mappers (ORMs) such as LINQ, Hibernate, and ActiveRecord bridge the gap between the relational database world, and the object-oriented world. By abstracting the database into “virtual database objects”, they let programmers develop in any language and environment that they like without ever writing a line of SQL. It sounds great, but is the ORMs sweet song actually a siren’s call? This talk will put ORMs on trial to help us find the answer.
Developing Applications for SQL Anywhere using Visual Studio
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 that apply directly to the .NET platform.
Cloud and Multi-Tenant Architectures with SQL Anywhere
SQL Anywhere supports a variety of capabilities that ease the shift from an on-premise database sever to a hosted server environment. This session will examine different architectural approaches for designing and developing multi-tenant applications to be hosted in a SQL Anywhere Server. Additionally, several operational considerations for hosted SQL Anywhere environments will be discussed.
Web Development with SQL Anywhere
So you have decided that the next version of your application should be web-based, but have quickly become buried in the dizzying array of presentation technologies (Flash, Silverlight, HTML), frameworks (Django, Ruby on Rails), and languages (PHP, Python, Ruby, ASP.NET) that are available. This talk will bring some sense to the technology soup, and focus on the features of SQL Anywhere you will want to know about before starting to develop a web application.
SQL Anywhere Server Performance Analysis
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 V11 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.
Thursday – Track 2: Synchronization with SQL Anywhere
Getting Started with MobiLink in SQL Anywhere 11
This presentation will discuss MobiLink synchronization technologies available with SQL Anywhere. This is an introduction to how MobiLink synchronization works, geared towards an audience that has minimal knowledge of data synchronization. Topics covered will include MobiLink architecture, the synchronization process, how to determine what data to synchronize, and setting up a synchronizing environment.
Developing Blackberry Enterprise Applications with SQL Anywhere
What's involved in building and deploying BlackBerry applications? The first half of this talk looks at the choices available to application developers and IT organizations as they look to provide applications for this popular smartphone, with an emphasis on Java-based line-of-business applications and enterprise integration. The second half zooms in on how to use SQL Anywhere to build BlackBerry applications.
Security Considerations for Mobile Applications
With the explosion of mobile devices available in the market, enterprises are continuing to move towards mobile applications to enable workers on the front lines with access to the data they require. This presentation will discuss security considerations for synchronizing data outside the data center to a mobile application. This includes discussions on secure storage of data on the mobile device, securing data transfer across public networks and through intermediary servers, and securing the data storage in the enterprise system.
What's Next for Smartphone Applications?
A survey of current trends and future directions for mobile application development, with a focus on smartphone applications. Topics covered include: application stores, application pricing, application categories, the cross-platform challenge, current and future application architecture trends, and mobility infrastructure trends. This talk will involve speculation, so bring your opinions and be ready to share them.
Developing Database Applications for Windows Mobile Using SQL Anywhere
This presentation provides an overview of how to successfully develop a database application running on a Windows Mobile handheld device. It introduces SQL Anywhere for Windows Mobile and shows how developers can create powerful mobile applications that take advantage of rich database functionality as well as robust data synchronization. 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.
MobiLink Performance Testing and Benchmarking Considerations
This presentation will outline the purposes and associated challenges with testing and benchmarking mobile applications developed with MobiLink synchronization technologies. Discussions include how to conduct testing to provide valuable information and feedback for identifying bottlenecks, gauging performance, modeling production hardware requirements and testing robustness when acceptable load is exceeded.
Speakers
Tom Slee
Tom Slee has worked in the mobile and embedded database industry for the last 15 years. most recently as part of Sybase's product management team. He has worked closely with customers in the design and implementation of mobile solutions and has been involved in the design of Sybase's own mobile products. He also holds a PhD in theoretical chemistry and has recently published a book on Game Theory that is being used in several university social science courses.
Chris Kleisath
With more than twenty years of experience, Chris Kleisath’s responsibilities include product engineering, product management, technical documentation, localization, and software quality for SQL Anywhere. Mr. Kleisath has lectured extensively worldwide on database, mobile computing, embedded and intranet solutions. He holds a Bachelor of Mathematics degree from the University of Waterloo in Waterloo, Ontario, Canada.
Joshua Savill
As a Product Manager of Data Synchronization Technologies for Sybase Inc., Joshua Savill is focused on the development of “occasionally connected” environments – enabling remote workers to maintain productivity regardless of network availability. This includes work with design, implementation, and deployment of enterprise mobility solutions. Additionally, he has worked in North America and EMEA conducting training seminars, and enhancing current enterprise and consumer mobility solutions. Joshua Savill holds a Bachelor of Science degree in Computing and Information Science and a Bachelor of Science minor in Psychology from the University of Guelph in Guelph, Ontario, Canada.
Eric Farrar
As a Product Manager for SQL Anywhere, Eric focuses on database integration with the latest web technologies. Prior to joining Sybase, Eric was an application developer at Applied Tooling Systems Inc, Morgan Stanley, and Platform Solutions Inc. Eric Farrar holds a Bachelor of Applied Sciences degree in Computer Engineering from the University in Waterloo in Waterloo, Ontario, Canada.
Glenn Paulley
Glenn Paulley is a Director with Sybase iAnywhere engineering, where he manages the research and development team responsible for query processing in the SQL Anywhere server. He joined Sybase iAnywhere in 1995. During his 20-year industrial career Glenn has held previous positions at Amdahl Corporation and at a large Canadian insurance company. Glenn holds a PhD in Computer Science from the University of Waterloo in Waterloo, Ontario, Canada.