The Sybase Users' Group of Texas – April 2011 Newsletter
(www.sugtx.org)

Table of Contents:

 1)   SUG-TX April 26th Meeting – Improving Performance and Simplifying Administration on Sybase DBMSs
 2)   SUG-TX March Meeting Highlights
 3)   Future SUG-TX Meetings
 4)   Join the SUG-TX LinkedIn Group
 5)   Sybase IQ Delivers Best Performance Results for Enterprise-Scale Data Warehousing and Analytics
 6)   International Sybase User Group Events
 7)   Sybase Events
 8)   OpenSolaris / Houston User Group for Sun (HUGS) Meeting
 9)  Sybase Training Schedule (Mar - Jun)
 
 
1)  SUG-TX April 26th Meeting – Improving Performance and Simplifying Administration on Sybase DBMSs
 
The Sybase Users’ Group of Texas will hold their next meeting on Tuesday, April 26, 2011. The presentation will be “Improving Performance and Simplifying Administration on Sybase DBMSs” by Michael Garza.

Abstract:

When it comes to managing Sybase database systems, DBAs have been left with few database administration tool alternatives. And some of those tools such as DBArtisan often cost thousands of dollars and are out of budget for many DBAs, making it difficult to efficiently manage common administration tasks and ensure high performance.

Don’t miss Quest Software’s Sybase Lead Developer for Toad for Sybase, Michael Garza, discuss the development initiatives behind Toad for Sybase. With several million users worldwide, the Quest Software Toad Community requested support for Sybase databases and the Quest team has made that a priority for 2011 with the introduction of Toad for Sybase, an integrated Sybase database management tool that improves Sybase performance and simplifies database administration and performance management.

In this presentation Michael will discuss the following:

•           Simplifying how to view, edit, and modify ASE database objects

•           How to improve performance View and kill currently running sessions

•           Quickly comparing data between one or more servers

•           How to improve productivity by automating repetitive tasks 

Speaker Bio:

Michael Garza is a Software Development Team Lead.  He joined Quest in 2005 as a developer for SQL Litespeed.  He brings over 11 years of experience of development on database tool products and is currently designing and developing Toad for Sybase..

Agenda:
 
  4:00pm - 4:30pm      Introduction, Welcome, Q&A
 
  4:30pm - 5:45pm     Sybase Interoperability in a Virtualized World
 
  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, 4543 Post Oak Place, Suite 200, Houston, TX 77027 (map at www.hal-pc.org/map.html).  Members frequently continue discussions at Champps Sports Bar after the meeting while waiting for traffic to subside.

2) SUG-TX March Meeting Highlights
 
Jeffry Wong presented an interesting topic on virtualization that concerned itself with the techniques necessary to ensure that Sybase products interoperate with Windows 7 and NAT networked VMware Linux and Windows XP guest virtual machines. The Sybase products covered included Replication Server 15.6, ASE 15.5, Oracle 10.2g XE and Sybase IQ 15.2. Additionally, Stunnel 4.x configuration to enable guest VM connectivity out of the NAT to the Windows 7 host O/S was covered.

3)  Future SUG-TX Meetings

Mark your calendar for future topics for SUG-TX Meetings:

Suggested future topics for 2011 include: PowerBuilder 12.5, Appeon 6.5, Sybase Unwired Platform (SUP), ASE 15.7/16, Replication Server, RAP, IQ, Afaria. Send other suggestions to secretary@sugtx.org.
 
Topics for future meetings are subject to change based on speaker availability and scheduling.  Watch the newsletter for details for each meeting.  A meeting will not be held in November due to proximity to the Thanksgiving holiday.  December is the annual holiday party.  SUG-TX usually meets on the 4th Tuesday so add a recurring appointment on your calendar and watch for future meeting announcements and newsletters for details.
 
 
4)  Join the SUG-TX LinkedIn Group
 
The Sybase Users’ Group of Texas has a group in LinkedIn.  If you wish to join, submit a request.  You can find the group by searching for “Sybase Texas” in the groups directory.  Contact secretary@sugtx.org if you have any questions.
 
 
5)  Sybase IQ Delivers Best Performance Results for Enterprise-Scale Data Warehousing and Analytics
 
Industry-Leading TPC-H Benchmark Result Achieved For Performance at 1 TB Scale Factor on IBM System

DUBLIN, CALIF. – FEBRUARY 11, 2011 — Sybase, Inc., an SAP® company (NYSE: SAP) and industry leader in enterprise and mobile software, today announced that Sybase® IQ v.15.2, the industry's leading column-oriented analytics server, working with the IBM® POWER® 780 Model 9179-MHB server and running the Red Hat® Enterprise Linux® 6 Operating System (OS), achieved the best overall performance results among non-clustered systems for the TPC-H benchmark at 1 TB scale factor(1) .

This benchmark simulates decision support systems that analyze enterprise-scale data volumes, execute queries with a high degree of complexity, and give answers to critical business questions. The test results provide another example of how the Sybase IQ 15.2 innovative architecture and query parallelism delivers maximum performance while requiring less overall IT resources by fully utilizing available assets, which significantly reduces ownership costs.

"Today's forward-looking enterprises are searching for the fastest and most affordable ways to deliver results for mission-critical analytics, business intelligence and reporting solutions," said Dan Lahl, Director of Analytics for Sybase.  "This benchmark demonstrates that Sybase IQ, combined with IBM Power systems, delivers on Sybase IQ's promise of unsurpassed analytics speeds for complex queries on terabytes of data, delivered to thousands of users at exactly the right time."

(1) TPC-H, QphH, $/QphH TM of Transaction Processing Performance Council (TPC) More info http://www.tpc.org.  IBM Power 780 Model 9179-MHB using Sybase IQ 15.2 ESD #2 - 164,747.2 QphH@1000GB, $6.85/QphH@1000GB available 3/31/11.

For the full story, go to http://www.sybase.com/detail?id=1091600.

6)  International Sybase User Group Events
 
The International Sybase User Group (ISUG) sponsors events for Special Interests Groups (SIGs), Virtual User Groups, and members.  Sign up for ISUG Membership for as little as $25 for a basic membership and get access to events and online material.  For more details, visit:
 
http://www.isug.com/common/JoinISUG.html
 
 
7)  Sybase Events
 
Seminars, Conferences, Webcasts, Tradeshows, Sports events — whichever way you want to get information from Sybase, they deliver!  Check out future events at:
 
http://www.sybase.com/about_sybase/events
 
If you'd like to give feedback on what types of events you think Sybase should offer please email them at events@sybase.com

8)  OpenSolaris / Houston User Group for Sun (HUGS) Meeting
 
The OpenSolaris / Houston User Group for Sun meets on the second Tuesday of every month at the HAL-PC.  The next meeting will be on March 8th.
 
Web Site: http://opensolaris.org/os/project/hugs
Subscribe to the mailing list: http://mail.opensolaris.org/mailman/listinfo/ug-hugs
 
 
9)  Sybase Training Schedule (Mar - Jun)
 
     Sybase Dallas Learning Center
     14800 Quorum Drive, Suite 505
     Dallas, Texas 75240
     Contact:  972-687-6400
     Register: 1 800-8-SYBASE            

Mar 14, 2011 5 days  Sybase IQ Administration
Apr 04, 2011 4 days  Data Modeling with PowerDesigner 15
Apr 18, 2011 3 days  Business Process Modeling with PowerDesigner 15
May 16, 2011 5 days  Fast Track to Adaptive Server Enterprise
May 23, 2011 5 days  Fast Track to Adaptive Server Enterprise
May 31, 2011 4 days  Sybase IQ for Developers
Jun 06, 2011 5 days  System and Database Administration: ASE
Jun 13, 2011 5 days  Performance and Tuning: Configuring ASE 15
Jun 27, 2011 5 days  Sybase IQ Administration
 
Please verify class availability with Sybase registration or http://sed.sybase.com/Osiris/osiris_location_NAA1.htm#DL
 
 
Send news to: secretary@sugtx.org
 
Do you have suggestions for our group?  Would you like to present your Sybase solutions to the Sybase Users’ Group of Texas?  The group is always looking for compelling presentations for our monthly meetings.  Let us hear them!
 
Please forward this newsletter to anyone interested in learning more about Sybase products.  To be added to or removed from the SUG-TX mailing list, subscribe to the mailing list at the SUG-TX Community on the My.ISUG.com website.  Contact secretary@sugtx.org if you have any questions.