Please comment on the singers’ names please 
Category: TechWave
Dear ISUG Member,
ISUG is pleased to announce that the special TechWave
issue of the ISUG Technical Journal is now available. Green and Gold members can access the issue online at http://my.isug.com/p/do/sd/sid=1308&type=0 (Gold members will also receive the printed copy within the next 2-4 weeks.)
Basic and Associate Members can see an abstract of the issue, containing the first page of each article at http://my.isug.com/p/do/sd/sid=1311&type=0 — if you like what you see and want to read more, simply upgrade your membership today and you can read the full online version!
Plus! Green and Gold members can now also view the Journal using the iViewer technology from PCS. Simply goto www.isug.com/iViewer (login using your my.isug.com account if requested) and you’ll be on your way!
Regards,
Bryan Enochs
President, ISUG
If you’re not a member of ISUG, please join today or at Sybase’s TechWave, in Las Vegas, to gain access to the ISUG Technical Journal
International Sybase User Group
Id Enhancement Title
3347 Allow for load with no_data into a smaller database
3090 Maintenance user update only for replicate database in warm standby.
3351 Add suid argument to sp_addlogin
3053 Allow for dropping of an audit table
3257 Change MDA datatypes to unsigned 2/4/8 byte integer
International Sybase Users Group
s
3252 J2EE connector for ASE
3125 grantable create/drop index
3092 Getting stats about the total amount of log generated by a query
3057 sp_add_resource_limit works now for the datasegment for tempdb, extends also for the log segment
3277 The MDA table monSysStatement PagesModified volumn is always 0
3088 Extract SQL statements from ASE log
3099 Provide a “zero-fill” function – or more generic “fill” function
3118 Concurrency issue
3133 Allow computed columns to be defined in terms of another computed column(s)
2452 Allow ASE Replicator login to be aliased to ‘dbo’.
3355 # tables / Stored Procedures managment
3273 add support for CURRENT_TIMESTAMP and CURRENT_USER ANSI standard features
3228 sp_dboption ‘no auditing’
3354 Stored Procedure Complilation
3286 Allow UDF to reference another UDF which hasn’t been created yet.
3323 Introduce array structures (varying arrays) and user-defined object datatypes
3234 generic function/procedure parameters
3325 Ability to store and extract sql for jTDS stored procedures
3453 Collect MDA stats at the stored procedure level
3376 Implement ANSI SQL-99 “WITH clause” in SELECT statement
3408 Allow creation of stored procs refereencing #tables when #tables don’t exist
3416 Handle ‘LIKE’ as effectively as ‘=’ when no pattern matching performed
3404 force load
3434 Less restrictive login name rules
3417 LDAP – Allow authentication to multiple domains on a per account basis
3377 Add windowing analytic clause in aggregates for complex calculations
3331 Enforce ANSI limitations on GROUP BY
3345 Allow output of ASE 15 optmizer diagnostics to client without DBCC TRACEON(3604)
3429 Release ASE for MAC OSX Intel
3449 Add CREATE [TEMPORARY] SEQUENCE to T-SQL
3375 Add GREATEST() and LEAST() built-in list functions
3450 Allow builtins/UDFs as arguments to SPs/UDFs
2067 Sybase Engineering’s Proposed CR #270078
3440 Implement Multiversion Consistency/Concurrency Control (MVCC)
3419 Support compiler directives in T-SQL procedures/functions
3403 New Feature Request to handle Money format for Indian Currency(Fetaure Request 447294)
What is with the ISUG Enhancements versus Sybase CR/Bugs on the sybase-product-futures mailing list?
In the MSA and System transactions performedby maint user thread on the sybase-product-futures mailing list, Jeff Tallman mentions that someone needs to create an ISUG enhancement or a Sybase change request (CR). Mike Harrold let everyone know that even through creating a Sybase CR is put in the Sybase engineering queue, it doesn’t mean that an engineer will actually look at it let alone have product management approve it to be implemented.
Jeff hits the nail on the head. You have a voice with the ISUG enhancements process. Use it. And yes, you have to be paid member to vote. Sorry, but we are a non-profit and your membership fees keep us running! You can vote as a Basic Member – you do not need to join at the higher membership levels (but you should so you can read all the wonderful articles Jeff writes for us). The more votes, the easier it is for engineering to justify spending staff resources on it when they go to management. Encourage all of your peers to join and vote as well. If you work for a business with several Sybase users, convince your boss to pay for a corporate membership and get all your colleagues to vote as well.
Regards,
Mike Harrold
Executive Director
and
Having an “internal enhancement” (aka a CR) doesn’t mean it gets implemented. It means there’s a CR for it. It might be a great idea, but without backing (and a user request + an engineer doesn’t mean it has backing; look how long it took for UDFs, mathematical functions, etc.) it doesn’t get allocated any development resources. Without development resources, it doesn’t get implemented.
Bottom line, a CR doesn’t mean it’s a “planned” feature.
Regards,
Mike Harrold
Executive Director
International Sybase User Group
I would recommend voting for the ISUG enhancements (this week). I and several other ISUG Board members will be going through the ISUG enhancements this weekend to present a subset to Sybase product management at TechWave next month.
I haven’t seen many ISUG enhancements being requested lately or voted upon for that matter. The higher the votes for a particular enhancement, the more likely Sybase will pick it up.
So please, everyone go vote on the ISUG enhancements!
Not only is Adrian Bri
dgwater a blogger for ZDNet UK’s Core Techs, he is the editor for the ISUG Technical Journal. He has been nominated for a Computer Weekly IT Blog Award. Please go cast a vote for our Adrian!
Computer Weekly IT Blog Award -> Programming and technical blogs -> Adrian Bridgwater: Software application development
ZDNet’s biography of Adrian:
Adrian Bridgwater a freelance journalist specialising in cross platform software application development as well as all related aspects of software engineering and project management.
Adrian is a regular blogger with ZDNet.co.uk covering the application development
landscape and the movers, shakers and start-ups that make the industry the vibrant place that it is.
His journalistic creed is to bring forward-thinking, impartial, technology editorial to a professional (and hobbyist) software audience around the world. His mission is to objectively inform, educate and challenge – and through this champion better coding capabilities and ulti
mately better software engineering.
Adrian has worked as a freelance technology journalist and public relations consultant for over fifteen years. His work has been published in various international publications including the Wall Street Journal, The Register, BBC World Service magazines, the UAE’s Khaleej Times and SYS-CON’s Web Developer’s Journal. He has worked as technology editor for international travel & retail magazines and also produced annual technology industry review features for UK-based publishers ISC.
In previous commercially focused roles, Adrian directed publicity work for clients including IBM, Microsoft, Compaq, Intel, Motorola, Computer Associates, Ascom, Infonet and RIM. Adrian has also conducted media training and consultancy programmes for companies including Sony-Ericsson, IBM, RIM and Kingston Technology.
He is also a published travel writer and has lived and worked abroad for 10 years in Tanzania, Australia, the United Arab Emirates, Italy and the United States.
Please go cast a vote for our Adrian!
