March 31st, 2010 @ 8:17 PM by Jean-Francois LEBON | 1 Comment
Want to know what platform your Sybase Adaptive Server is running on ? No need to connect to the machine to find out, just run this little query:
select name from master..spt_values
where type = 'E' and number = 1
For me it shows:
Tags: ase, howto, sql, sybase, Sybase Adaptive Server Enterprise, tips, transact-sql
March 29th, 2010 @ 7:08 PM by Jean-Francois LEBON | Be the 1st to comment
This year Sybase User Training & Solutions Conference, formerly known as TechWave, will be held August 9-11 at the Hilton Washington, in Washington, DC. Sybase TechWave is a useful and informative event where you can share or improve your products knowledge. The event is scheduled as follow: a free day for prospects and business guests, and a fee to attend the multi-day technical training. They even plan to expand the event by including an additional day of technical training.
Visit http://www.sybase.com/techwave for more details.
Tags: news, sybase, techwave
March 21st, 2010 @ 5:14 PM by Jean-Francois LEBON | 1 Comment
When speaking of moving/copying database between dataservers, database “dump and load” strategy usually come up in mind. Thanks to mount, unmount and quiesce database commands, you can sometimes replace advantageously “dump/load” operations.
1°) Moving a database:
I assume here we want to move completely the database DBLA01 from source dataserver SYBPARFRDEV01_DS to destination dataserver SYBPARFRDEV02_DS. Both dataservers are on the same machine. Database DBLAB01 has it’s own devices.
Tags: article, ase, howto, sybase, Sybase Adaptive Server Enterprise, tips
March 7th, 2010 @ 10:31 AM by Jean-Francois LEBON | Be the 1st to comment
Sybase is announcing the end of engineering support for ASE Database Expert Option and ASE SQL Expert Option for all platform as of 02/01/2011. These products will be discontinued, means Sybase will not provide these products anymore.
But Sybase customers are eligible to upgrade to “Quest SQL Optimizer Suite for Sybase ASE” at no additional charge.
Details of the upgrade program can be found here:
See more here
Tags: ase, news, sybase, Sybase Adaptive Server Enterprise