What a historical year it is? I haven't posted for over a year now, simply because it's so many changes happened in the past 1 year, the fall of bear stern, lehman brothers, stock market crash, layoff, company strategy change ..... though I was not impacted, but it's amazing to watch all these happening around me and I am not too interested on the techinical stuff at this moment.

Sybase stock was up more than 20% in May

I noticed Sybase stock (symbol SY) was up more than 20% in May. That's pretty good run. Right now it's $31.47.

DDL for master..syslogins

The DDL for syslogins comes in handy when you work on syslogins related tasks, i.e. Migrate syslogins from Sybase 12.0 to Sybase 12.5. Most DBA tools reverse DDL for user tables only.

USE
tempdb
go
CREATE TABLE dbo.jx_syslogins
(
suid int NOT NULL,
status smallint NOT NULL,
accdate datetime NOT NULL,
totcpu int NOT NULL,
totio int NOT NULL,
spacelimit int NOT NULL,
timelimit int NOT NULL,
resultlimit int NOT NULL,
dbname sysname(30) NULL,
name sysname(30) NOT NULL,
password varbinary(30) NULL,
language varchar(30) NULL,
pwdate datetime NULL,
audflags int NULL,
fullname varchar(30) NULL,
srvname varchar(30) NULL,
logincount smallint NULL,
procid int NULL)
go

1> insert master..syslogins (suid, status, accdate , totcpu , totio , spacelimit , timelimit , resultlimit , dbname , name , password , language , pwdate , audflags , fullname , srvname , logincount )
2> select * from jx_syslogins
3> go

How to stop Oracle Archive log mode

startup mount;
alter database noachivelog;
alter database open;
archive log list;

How to move a datafile using disk mirroring in Sybase12.5

Example: move audit01 device from /dir1/datafile1 to /dir2/datafile2

sp_configure ‘disable disk mirroring’, 0
go
shutdown with nowait
go

- restart dataserver

disk mirror
name = audit01,
mirror = "/dir2/datafile2"
go

disk unmirror
name = audit01,
side = "primary",
mode = remove
go

sp_helpdevice audit01
go
sp_configure 'disable disk mirroring", 1
go
- restart dataserver

Sybase reports record First Quarter Results

Highlights:
Total revenue of $260.1 million, up 13% year over year
License revenue increased 13% year over year
Services revenue increased 8% year over year
Database license revenue increased 19% year over year
Messaging revenue increased 37% year over year
GAAP operating margin of 14%, versus 9% a year ago; non-GAAP operating margin of 19%, versus 15% a year ago
GAAP net income of $24.2 million, up 60% year over year; GAAP EPS up 65% year over year
Non-GAAP net income of $35.3 million, up 42% year over year; non-GAAP EPS up 46% year over year
Cash flow from operations of $94.6 million, up 36% year over year

I think the license increase are primarily due to the fact that license key is mandatory in version 15. The older version of sybase does not need to have a key to run. Many Sybase users have setup additional sybase servers without license. As they migrate to Sybase15, they have to buy extra licenses.

Asus unveils Eee PC 9000 XP laptop

checked ebay, I was surprised that this laptop is in market already. below are the desc from 1 ebay seller. I am interested to get one with GPS build in.

Mobility & Reliability
• At half the size of regular notebooks and weighing less than 1kg, you can take the Eee PC anywhere.
• Bumps and shocks are no longer issues. With a dependable solid-state disk, you get unparalleled shock-protection and reliability.
• Power-efficient design provides longer operating time when on the go.

Ease & Technology
• With a rapid start-up time, the Eee PC 900 is always ready to get into action.
• No technical manual required with the specially designed, user-friendly and intuitive graphic interface .

Work & Connectivity
• You’re always connected with built-in WiFi 802.11 b/g that automatically detects and connects to the Internet at any hotspot.
• The Eee PC 900 includes the documents and the e-mails software, and a suite of other productivity software to help keep you on track.
• Upload photos and videos and share them instantly on Flickr or YouTube without waiting till you get home.

Media & Entertainment
• Enjoy music and videos with extensive support for a wide range of digital multimedia.
• Log on to Skype or other network, and you can connect with friends anywhere, anytime.
• Clear up wire clutter with the built-in card reader, webcam, speakers, and microphone.