The Sybase Users' Group of Texas - September 2006 Newsletter (www.sugtx.org)
![[Houston City Skyline]](../images/HomeBanner.jpg "Go to the home page")
1) SUG-TX September Meeting
Highlights
2) Next SUG-TX Meeting –
September 26, 2006
3) Sybase Signs Definitive Agreement to
Acquire
4) Sybase iAnywhere Announces the Release
of SQL Anywhere 10
5) Sybase Delivers Sybase IQ 12.7 Analytics
Server
6) Houston User Group for
Sun (HUGS) Meeting
7)
8) Sybase Training Schedule (Sep -
Nov)
1) SUG-TX August Meeting
Highlights
The Sybase Users’
Group of Texas held their August meeting on Tuesday, August 22nd with
a wrap-up of the recent TechWave 2006 conference held in August 6th –
10th in
http://main01.hostcast.com/custom/sybase/archives/keynote3.html
Next, Don Clayton
shared the highlights of the activities around the development products. Don discussed some of the interesting
announcements on PowerBuilder, PowerDesigner, and WorkSpace. Don also showed portions of the second
keynote on Tuesday morning, “Today’s Development
Trends are Driving Tomorrow’s Technologies,”
also hosted by Dr. Raj Nathan. This
keynote recording can be viewed at:
http://main01.hostcast.com/custom/sybase/archives/keynote4.html
TechWave 2006 was
filled with excellent presentations from Sybase users and employees. Most of the conference content can be
downloaded at:
https://1bosweb3.conferon.com/Events/Sybase/Techwave2006/Agenda/agenda_search_category.html?type=
Be sure to stay tuned
for details on TechWave 2007, location and dates to be
announced.
2)
Next SUG-TX Meeting –
September 26, 2006
The Sybase Users’ Group of Texas
will hold their next meeting on Tuesday, September
26, 2006. Christophe
Dufourmantelle of Novalys will present on their tools, such as Visual Guard and
Visual Expert.
Abstract:
* Managing
PowerBuilder and Transact-SQL applications with Visual Expert
5.7
(Impact Analysis,
Source Code Documentation, Code Review, code exploration...)
We all meet the same problems while
working on large applications. It is difficult to master the whole
project, especially for the parts that were developed by other people. The
objective of this presentation is to in explain that good solutions exist, and
demonstrate with case studies how to implement them.
Visual Expert
5.7 adds Transact-SQL support to the PowerBuilder and PL/SQL one. It
analyses both PowerBuilder and stored Procedure code at the same time. As
its previous versions, Visual Expert provides impact analysis, code exploration,
code review and technical documentation.
The following are examples
situations we will discuss using real case studies and code examples:
- I want to modify the DB Schema and I need to understand the
complete effect of this change over the PB components and Stored
Procedures.
- I want to modify a stored procedure: which other
procedures and PB components may be affected?
- I have just
arrived in a new project, which is maintaining a large application. How can I
discover and master this code quickly?
- How can I clean up the
code to make it easier to maintain?
Create and manage user
profiles and permissions for PowerBuilder applications with Visual Guard
10.0
With Visual Guard, you can create
and manage user profiles and permissions. You can implement security in any new
or existing PowerBuilder or .NET Applications.
Below are two case studies
that we will be discussing:
The application has many users, but they
don't have the same permissions…
- How to Control access to each window of
the application
- How to filter information according to the user profile
- How to hide items of a window (menu, field, control, tab,
etc.)...
Building a security management system is complex and takes a
long time
- How to give power users the possibility to manage permissions
without involving the development team?
- How to manage a large number or
users and profiles
- How to define date/time ranges for user
profiles
This presentation will show you how
to solve these problems.
Agenda:
4:00pm - 4:15pm Introduction, Welcome,
Q&A
4:15pm - 5:45pm Visual Expert and Visual
Guard
Christophe
Dufourmantelle, Novalys
5:45pm - 6:00pm Wrap Up
6:30pm -
Post meeting discussions at Champps Americana (at the Uptown location)
The meetings are held at
HAL-PC,
3) Sybase Signs Definitive Agreement to Acquire
DUBLIN,
Calif. — September 5, 2006 — Sybase, Inc.
(NYSE: SY), a leading provider of enterprise infrastructure and mobile software,
today announced that it has signed a definitive agreement to acquire Mobile 365,
the global leader in mobile messaging and content delivery, in an all cash
transaction. The purchase price set forth in the definitive agreement is $425
million, which is subject to adjustment based on
For its fiscal year
ended March 31, 2006,
Through this
extensive network of carriers and unmatched global footprint, Mobile 365 also
enables the world’s leading content providers, media companies, and global
brands to mobilize their content and applications, such as voting, live event
contests, broadcasts, and mobile alerts, to consumers around the globe.
Companies like Citibank, Yahoo!, MSN, AOL, and Sony Pictures use
“This acquisition
extends our Unwired Enterprise vision with the addition of two new enterprise
channels — wireless carriers and content providers — making Sybase the leading
mobile enterprise software and services provider in the world,” said John Chen,
Sybase chairman, CEO and president. “The mobile messaging market in the
For the full story, go to http://www.sybase.com/detail?id=1043524.
4) Sybase iAnywhere Announces the
Release of SQL Anywhere 10
“This is a very
significant release in SQL Anywhere’s 15-year history,” said David Neudoerffer,
vice president of Engineering, Sybase iAnywhere. “SQL Anywhere 10 goes to new
heights in its ability to handle larger and larger volumes of data on the front
lines of the enterprise where there is little or no administration
capability.”
Key new features and
enhancements include:
·
New database server
performance features: including
materialized views, intra-query parallelism, snapshot isolation, parallel
backups, additional indexing methods, and several internal enhancements.
·
Enhanced methods for
data protection, including: built-in
high-availability data mirroring and Veritas cluster agent options, along with
robust data security additions.
·
Expanded developer
productivity resources and platform support, including: tools for performance
analysis and application profiling, .NET 2.0 support, tight integration with
Microsoft Visual Studio 2005 and new support for Symbian devices.
·
Data exchange
innovations in synchronization and service-oriented architectures (SOA),
including: new graphical
administration tools for architecture setup and deployment, expanded enterprise
integration options, message management and monitoring, and mobile Web
services.
For the full story, go to http://www.sybase.com/detail?id=1042264.
5) Sybase Delivers Sybase IQ 12.7 Analytics
Server
LAS
VEGAS — SYBASE TECHWAVE 2006 CONFERENCE — August 7, 2006 — Sybase, Inc. (NYSE:
SY), a leading provider of enterprise infrastructure and mobile software, today
announced Sybase IQ® version 12.7, a highly optimized analytics server that adds
enhanced query performance, improved data privacy and features that support
compliance of regulations such as Sarbanes-Oxley.
Sybase IQ 12.7
includes functionality that will enhance loading and ease of data migration from
operational systems and analytics including additional online analytical
processing (OLAP) functions. Other key enhancements include the new
Encrypted Column Option, a patented encryption technology that makes data on
disk unintelligible to unauthorized viewers.
“Sybase IQ is used
for mission-critical data especially in highly regulated government and
financial service organizations,” said Kathleen Schaub, vice president, Sybase
Information Technology Solutions Group. “Tighter regulations are resulting in
large amounts of data. Sybase 12.7 allows companies to better manage this
data and use it to identify trends.”
“Using business
intelligence to address privacy and Sarbanes-Oxley compliance is important to
many companies,” said Claudia Imhoff, president, Intelligent Solutions, Inc.
“Sybase consistently provides products such as Sybase IQ that ensure compliance,
accelerate ROI and add real-world value for business users.”
For the full story, go to http://www.sybase.com/detail?id=1042268.
6) Houston User Group for Sun
(HUGS) Meeting
The Houston User Group for Sun
meets on the second Tuesday of every month at the
7)
a) Webcast – Avaki
Avaki Enterprise
Information Integration software provides a flexible, scalable and efficient way
to access, integrate and deliver disparate data to enterprise applications. By
creating a single data services layer with standardized access to multiple data
sources, including structured and unstructured data, it eliminates the
complexity of linking data with applications.
Date: Tuesday, September 19, 2006
Time: 11:00am – 12:00pm
CDT
Register at http://response.sybase.com/219483?elqpurlpage=64&salesperson=CEC.
b) Webcast – Mirror
Activator
Mirror Activator
minimizes database downtime for business-critical applications by providing a
continuously-available standby system, increasing availability and lowering
total cost of ownership. It enhances traditional database replication and
improves the economics of high-end storage replication systems by reducing
network costs, accelerating recovery time and extending the usefulness of
standby systems by utilizing them for reporting and decision
support.
Date: Tuesday, September 26, 2006
Time: 11:00am – 12:00pm
CDT
Register at http://response.sybase.com/5E2ED7?elqpurlpage=64&salesperson=CEC.
c) Seminar - The Seven Secrets of Successful Business
Intelligence
A
Complimentary Breakfast Briefing
Today most organizations are either
implementing a Business Intelligence (BI) project or making plans to do so.
Unfortunately, far too many of these initiatives will not
succeed.
Beat the odds. Make
sure your BI undertaking is not one of these ill-fated and excessively costly
endeavors by attending The Seven Secrets of Successful Business Intelligence.
Based on in-depth studies and years
of research, we have identified seven proven and yet little-known best practices
that will show you how to put your BI initiatives on the right track and deliver
the results you are looking for. By asking the right questions and solving the
right problems, you will be able to implement the appropriate solutions,
increasing the efficiency and effectiveness of your
organization.
We’ll explain in detail seven key
concepts in the areas of strategy, data management, performance, ROI, and
project management. We’ll demonstrate how to achieve real-time analytics and
accelerate reporting and data mining. These straightforward, reliable steps will
enhance the value of your BI initiatives. The longer you delay putting your
information assets to good use, the more opportunities you will forego to your
competition.
This complimentary executive
briefing will feature Sid Adelman, the Principal in Sid Adelman &
Associates, a firm specializing in planning and implementing data warehouses
(DW) and establishing data architecture. Sid has developed a methodology for
assessing an organization’s systems for security, availability and performance.
He will reveal innovative approaches to operational BI, data warehousing and
corporate performance management in his Seven Secrets to help your business work
smarter and become more agile.
Date: Tuesday, September 26, 2006
Time: 9:00am – 11:30pm CDT (Registration
starts at 8:00am)
Where: Renaissance Houston Hotel,
6 Greenway Plaza East,
Agenda and registration information
for
http://www.sourcemediaconferences.com/conferences/SSBI06/agenda.html#2
8) Sybase
Training Schedule (Sep - Nov)
18
Sep 2006 5 days System and Database Administration:
ASE
25 Sep 2006 5 days Fast Track to Replication Server
Administration
02 Oct 2006 5 days Fast Track to Unwired Orchestrator
5.0
02 Oct 2006 5 days Performance and Tuning: ASE Query
Optimizer
09 Oct 2006 5 days Mastering Reuse: Enhancing Your
PowerBuilder Skills for
nTier Dev
16
Oct 2006 5 days Performance & Tuning for
PowerBuilder 10: Advanced
Tips
and Techniques
23
Oct 2006 3 days Data Modeling with PowerDesigner
12
26
Oct 2006 2 days Moving to PowerBuilder
10.5/11.0
06
Nov 2006 1 day Introduction to
SQL
06
Nov 2006 5 days Fast Track to ASE
13 Nov 2006 5 days Fast Track to
PowerBuilder
13 Nov 2006 5 days System and Database Administration:
ASE
27
Nov 2006 2 days Advanced PowerBuilder 8.0
Controls
27
Nov 2006 5 days Advanced Client/Server Development
techniques using
PowerBuilder
27
Nov 2006 5 days Performance and Tuning: Configuring ASE
15
29
Nov 2006 3 days Mastering the DataWindow Object in
PowerBuilder 9.0
Please verify class availability
with
Send news & events
to:
Do you have suggestions for our
group? Let us hear them. We have new web site features that
include member self-service functions and member feedback
capabilities.
Would you like to present your
Please forward this newsletter to
anyone interested in learning more about