From the Sybase Workspace 2.0 team:

Thursday, February 14, 2008
1:00 pm EDT / 10:00 am PDT

Join us on Valentine’s Day and you will learn how to:

• Visually debug stored procedures and triggers
• Visually create and edit tables, stored procedures and events
• Navigate and manipulate database objects in the enterprise
• Export and import database objects and services to database server

Don’t forget to sign up for the webcast! :)  Sybase will send the dial in/web address to your email so you can participate.

I’m not sure if this is the same presentation as Sybase WorkSpace for ASE:  Learn to Love SQL Development Webinar that was hosted by Samir Nigam, Director of Engineering at Sybase, last month.

Listen to this podcast

Hi everyone!

After a horrible flight (I really really hate United Airlines - I swear this is the very last time I ever fly with them. Fly the Friendly Skies my a$$.), I arrived at the Mandalay Bay Resort for Sybase TechWave 2007.

If you came last year, the inside of the Mandalay Bay Resorts looks awfully like Caesar’s Palace did. So much so, that you will have strong feelings of déjà vu. For that matter, the Rio did also. Is this a common thing for Las Vegas casino/hotels to do?

A friend of mine told me that many of the casino/hotels like Caesar’s Palace and Mandalay Bay have hidden cameras in the rooms for security reasons - that if there was any issues, the tapes are reviewed by security staff. I don’t know if that is true of just an urban legend. I guess with cameras being so tiny now, it would be difficult to locate any without a radio frequency detector (try getting an RF detector through airport security and I bet you will disappear to Guantánamo Bay.)

I met up with fellow TeamSybase members at the TeamSybase dinner tonight and was able to have a bit of food before the food was taken away. Damn you United Airlines! The best part of TechWave, and I can say this will hold true even on Friday when I return to Chicago, is that my good friend Loren Corbridge, project manager of Sybase Workspace, knit two baby stocking caps for my wife’s and my munchkin. A red stocking cap for a new born and a blue stocking cap for a year old. THANK YOU LOREN!!! I’ll be posting pictures of these beautiful stocking caps tomorrow.

Listen to this podcast

For those of you that are eagerly awaiting Sybase’s Workspace version 2.0, it is scheduled for a Q4 2007 release and is currently in internal beta testing.

The biggest news about it, in my opinion, is that it is based on Eclipse 3.3. I’m hoping that Sybase will eventually integrate the Mylyn (originally Mylar) into Workspace

Webinar: Task-Focused Programming with Mylar by Mik Kersten (56 min, Oct 2006)
5-15 min: task management demo
15-30 min: task context demo
34-40 min: technology & frameworks

The Adobe presentation works on Mac OSX and Windows but not in Linux.

Listen to this podcast

The class registration and listing is available on Sybase’s TechWave website

Here is my current schedule:

My Agenda     Time Session Title Learning Track Status Tuesday, August 7, 2007 2:30 pm - 5:00 pm  EDU106-1 Performance and Tuning: ASE Query Optimization   Education Courses and iAnywhere TechSummits Registered Wednesday, August 8, 2007 8:00 am - 10:15 am  EDU106-2 Performance and Tuning: ASE Query Optimization   Education Courses and iAnywhere TechSummits Registered 1:00 pm - 2:00 pm  DAT508 Using Java and Web Services within Adaptive Server Enterprise (ASE)   Enterprise Database, Data Management and Business Continuity Registered 2:15 pm - 3:45 pm  DEV311 Designing High Performance Applications/Transaction Design (Prevention not Diagnosis & Medication)   Application Development Trends Registered 4:00 pm - 5:30 pm  DEV339 Case-Express: Using Sybase tools and bleeding edge technologies for a feature-rich web application   Application Development Trends Registered Thursday, August 9, 2007 8:00 am - 10:15 am  EDU114-3 Migrating from ASE to Sybase IQ: An ASE DBA’s perspective   Education Courses and iAnywhere TechSummits Registered 1:00 pm - 2:00 pm  IAW410 Setting up Replication Server and OpenSwitch for Continuous Availability and Disaster Recovery   Data Integration, Analysis, and Warehousing Registered 3:30 pm - 5:00 pm  DEV319 Connecting Adobe Flex and Flash to Sybase Adaptive Server Enterprise (ASE) using Web Services   Application Development Trends Registered Friday, August 10, 2007 8:00 am - 10:15 am  EDU106-4 Performance and Tuning: ASE Query Optimization   Education Courses and iAnywhere TechSummits Registered 1:00 pm - 2:30 pm  DAT502B Top Ten Adaptive Server Enterprise (ASE) MDA Tables   Enterprise Database, Data Management and Business Continuity Registered

Listen to this podcast

I was looking through the help docs of Sybase Workspace when I ran across a link to the Workspace Videos. For anyone that wants to take a look at Workspace before purchasing or downloading the Evaluation:

• WorkSpace Eclipse Environment Overview
  High level overview of the Eclipse environment and how to access the Sybase tooling.
• Database Tooling Videos:
  • Database Development Overview
    High level overview of the database development environment.
  • Using the SQL Debugger
    High level overview and demonstration of using the SQL Debugger.
  • #Temp Table Tools
    Demonstration of several tips on using #temp tables in stored procedures.
  • Replication Server Tooling Overview
    High level overview of the Replication Server support within the Database Development Tooling.
• Integrated Development
  Example of modeling, building, and testing a database application.
• Service Oriented Development of Applications (SODA) Videos:
  • SODA: Building Services
    High level overview of SOA and building/packaging/testing a service.
  • SODA: Orchestrating Services
    High level overview of orchestrating services.
  • SODA: Calling Services From a Business Process
    High level overview of building a BP service that invokes other services.
  • SODA: Calling a BP Service From a JSF Web Application
    High level overview and example of calling a BP service from a JSF Web Application.
• Mobile Development Overview
  Overview of the Mobile Development environment.

Listen to this podcast

In “MyMobileServer” project (dummy project created by Workspace on install):

Right click on project -> New -> File -> select MyMobileServer giving any name (i.e. ‘j’) as the file name

Right click on File -> Properties -> Info -> check mark “Executable”.

Click “Apply” - the check box is now uncheck marked.

I opened a case with Sybase Technical Support and the TSE (thanks Kevin!) created CR 465942 to get this fixed.

Listen to this podcast

I’ve been using Sybase’s Workspace 1.7 for developing and maintaining a myriad of maintenance scripts, web pages, and other interesting things.  I ran into an interesting issue that is worthwhile to take note:
In most of the 3rd party plugins, the .components directory properly shows up in their perspectives.  For example, the EPIC plugin shows the .components directory in the project with no problems.

None of Sybase’s eclipse plugins show the .components directory.  I believe this is based on the assumption that since Workspace only runs on windows, that dot directories are rare or nonexistent.  This is a minor bug but one that people should be aware of in case you think that Workspace ate your directory. 

Listen to this podcast

If you try to add the subversion plugin Subclipse to Sybase’s Workspace version 1.6 or 1.7, you will receive the following error:

To work around this problem, you need to start Eclipse.exe directly, usually located in your %SYBASE%\Workspace\Eclipse directory. Go to Help -> Software Updates -> Find and Install -> Search for new features. Add the url (http://subclipse.tigris.org/update_1.0.x) and Name (subclipse). When you’re given the option to install, uncheck the “Show the latest version of a feature only”.

We need to use version 1.0.5 of subclipse because Sybase’s Workspace is running on top of the older Eclipse version 3.1 software. The newer subclipse requires Eclipse 3.2 or higher to work.

Uncheck “Subclipse 1.2.0″ and check “Subclipse 1.0.5″.

Continue installing, ignore any warnings.

The other option, of course, is to install Eclipse 3.2x separately and point Workspace to it during the install of Workspace. That way we are able to use the current version of Eclipse. I have not tried this with the new Workspace 1.7 release yet. Sybase Workspace is hardcoded to work only with Eclipse 3.1.x releases.

This seems to only happen on Workspace 1.6 and 1.7 that was upgraded from 1.6. I’m investigating it some more.

UPDATE:  Sybase is going to create a techdoc explaining this behavior.  This is somewhat expected behavior because of the older 3.1x Eclipse version.

Listen to this podcast

There are a number of enhancements that are scheduled to be Sybase’s Workspace version 2.0. Keep in mind that these features are tentative and may be kept or dropped when Workspace 2.0 is released. I received permission from Sybase’s Project Management to mention this information.

• Support for Eclipse’s update service for the Sybase components of Workspace
• Enterprise Manager entirely replaces Database Manager
• embedded PowerDesigner 12.5
• Eclipse 3.3
• Possible Linux and/or Mac OSX version
• Network Installer
• Windows Vista support

Database Development

• DDL generation of multiple objects including permissions
• Visual SQL enhancements (adhoc queries)
• intelligent sql statement templates (stored procedures)
• RTMS MQ Series support
• wizard & schema support for IQ specific indexes and query plans
• multiple object wizard for drops & execution on RepServer
• enhanced integration for RepConnector Manager
• Adoption of DTP framework

Services Development

• Development of logical services
• declarative composite services
• support for ws-security API
• Publish & subscribe to JMS Topics
• Build properties editor usability enhancements

Data Federation

• better integration with ws-security framework
• connection profile to Data Federation
• awareness in services editor mobile tooling, sql editor
• access to data grid as a soap service

Web App Development

• JSF page validation support
• integration with IBM’s faces-config
• EAServer 6 support

Framework

• eclipse 3.3 support
1. help system keyword index
2. composite cheat sheets
3. new welcome framework
• enhanced packaging and development
• enhanced enterprise explorer
• support access to ldap directories, including connection profile storage
• capability support
• greater configuration of desktop

Listen to this podcast

 I received the following email from Sybase.  I’ve been testing Workspace and while there is quite a bit of work for Sybase to do before it is a viable tool for me, it does have potential.  It is based on the open source Eclipse project.

Are you tired of writing SQL by hand? Slogging through long stored procedures to find out where they may be failing? Sybase WorkSpace is just the tool you need to make your ASE development a breeze. WorkSpace is a development environment for the Sybase platform that combines industry-leading data modeling with visual SQL building, query analysis and sophisticated editing and debugging.

Read the rest of this entry »

Listen to this podcast

ISUG V-SIG for WorkSpace

ISUG now has a Virtual Special Interest Group (V-SIG) for Sybase WorkSpace. SIGs are a great way to learn more about the product and collaborate with fellow users. Every month, there will be a presentation on a new development topic, including database development, implementing services and mobile development. This is also an opportunity to ask questions of Sybase engineering and product management. Put it on your calendar today.

Upcoming Schedule and Topics:

All calls are at 11 a.m. PST / 2 p.m. EST. Phone and LiveMeeting information will be sent out via the mailing list, so be sure to sign up!

Contact Information:

Listen to this podcast