<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9" -->
<rss version="0.92">
<channel>
	<title>Sybase ADDICT</title>
	<link>http://sybase-addict.com</link>
	<description>Sybase tips, howto and technical informations - All in a blog !</description>
	<lastBuildDate>Sun, 07 Mar 2010 10:54:21 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>End of Life Notice: ASE Database Expert Option &amp; ASE SQL Expert Option</title>
		<description><![CDATA[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 &#8220;Quest SQL Optimizer Suite for Sybase ASE&#8221; at no additional charge.
Details [...]]]></description>
		<link>http://sybase-addict.com/2010/03/07/end-of-life-ase-database-expert-option-ase-sql-expert-option/</link>
			</item>
	<item>
		<title>QweryBuilder &#8211; An SQL Editor, SQL Query Tool and Database Development Tool</title>
		<description><![CDATA[QweryBuilder, is a unique database development tool with a very simply purpose, to make accessing data from a database simple, quick, accurate and efficient. QweryBuilder implements innovative ideas to make this possible. An end user can extract and update data without writing a line of SQL. Database developers can create procedures, tables, views and triggers [...]]]></description>
		<link>http://sybase-addict.com/2010/02/19/qwerybuilder-an-sql-editor-sql-query-tool-and-database-development-tool/</link>
			</item>
	<item>
		<title>Sybase ASE v15 Apache and PHP compilation</title>
		<description><![CDATA[Recently, I successfully compiled Apache and Php to use a Sybase ASE v15.0.3 dataserver on CentOS v5.4 (32 bits). Apache was compiled with DSO support to use Php as a dynamically loadable module. This is how I did it:
1°) Linux Requirements:
You&#8217;ll need to download the Apache 2.0.63 and Php 5.3.1 sources.
To compile Php and Apache, [...]]]></description>
		<link>http://sybase-addict.com/2010/01/16/sybase-ase-v15-apache-and-php-compilation/</link>
			</item>
	<item>
		<title>Find out all &#8220;Defined Rules&#8221; in a Sybase ASE database</title>
		<description><![CDATA[The following transact-sql code will help you to find all defined rules in a Sybase ASE database.

select sysobjects.name as "rule name",
object_name(syscolumns.id) as "table name",
syscolumns.name as "column name"
from sysobjects, syscolumns
where object_name(syscolumns.domain)=sysobjects.name
and sysobjects.type = 'R'
go

The output displays the table and column to which the rules are bound.
]]></description>
		<link>http://sybase-addict.com/2010/01/10/find-out-all-defined-rules-in-a-sybase-database/</link>
			</item>
	<item>
		<title>&#8220;Application Tracing&#8221; feature in Sybase ASE v15</title>
		<description><![CDATA[As of Sybase ASE v15.0.2, Sybase introduce the &#8220;Application Tracing&#8221; feature.
&#8220;Application Tracing&#8221; allows you to collect useful diagnostic information for a running client session (like execution plan, i/o cost etc&#8230;), and capture the trace output into a text file. Very helpful to debug some performance bottlenecks ! All you need to know to use this [...]]]></description>
		<link>http://sybase-addict.com/2010/01/03/application-tracing-feature-in-sybase-ase-v15/</link>
			</item>
	<item>
		<title>Identify Sybase dataserver&#8217;s processes easily on Unix</title>
		<description><![CDATA[On Unix/Linux machines hosting some Sybase dataservers running multiple engines, it is always difficult to find out quickly what dataservers engines belong to. When you have dataservers running multiple engines,  &#8220;showserver&#8221; or &#8220;ps&#8221; command line always show something like this:

sybase 9510 8892 246 Jul 11 ? 1858:08 ./ase/1503/ASE-15_0/bin/dataserver -ONLINE:1,0,0xffffff

Of course, with some Unix commands [...]]]></description>
		<link>http://sybase-addict.com/2009/12/18/identify-sybase-dataservers-processes-easily-on-unix/</link>
			</item>
	<item>
		<title>End of Life Notice: Replication Server v15.0.x</title>
		<description><![CDATA[This is an External End of Life Notice for Replication Server Version 15.0.x
See more here
]]></description>
		<link>http://sybase-addict.com/2009/09/12/end-of-life-notice-replication-server-v150x/</link>
			</item>
	<item>
		<title>Job Scheduler &#8211; Demo</title>
		<description><![CDATA[Watch this short demo to learn how to use ASE&#8217;s newest self-management feature, the Job Scheduler, to automate common database administration tasks.
See it in action  here
]]></description>
		<link>http://sybase-addict.com/2009/09/05/job-scheduler-demo/</link>
			</item>
	<item>
		<title>HowTo install Job Scheduler in Sybase ASE</title>
		<description><![CDATA[Job scheduler allows DBA to create and schedule administration tasks. Since ASE v15.0.3, lot of bugs are solved, making job scheduler to be workable. By the way, I will suggest to heavily test it before to go in production environment !
So how to install it ?
Job scheduler is a separate external process running as an [...]]]></description>
		<link>http://sybase-addict.com/2009/09/05/howto-install-job-scheduler-in-ase/</link>
			</item>
	<item>
		<title>Sybase Announces Support for Android Platform</title>
		<description><![CDATA[Sybase iAnywhere announced recently a new version of its Software Developer Kit that will help developers and product managers incorporate Bluetooth® capabilities into Android devices.
See more here
]]></description>
		<link>http://sybase-addict.com/2009/07/11/sybase-announces-support-for-android-platform/</link>
			</item>
	<item>
		<title>ASE v15.0.3 on Linux Slackware, libpam issue&#8230;</title>
		<description><![CDATA[Sybase ASE (Adaptive Server Enterprise) can now be installed easily on Linux distribution running kernel 2.6.x.
So i tried to install ASE 15.0.3 ESD1 on my favorite Linux: Slackware 12.2. Why Slackware ? Because it rocks !! In my opinion, the best Linux distribution ever, and 64 bits release came out recently.
But this come with a [...]]]></description>
		<link>http://sybase-addict.com/2009/05/24/ase-v15-on-linux-slackware-libpam-issue/</link>
			</item>
	<item>
		<title>Find tables with identity columns</title>
		<description><![CDATA[Quickly find out the database&#8217;s tables having identity columns:
select object_name(id) as "tablename",name as "column_name"
from syscolumns where status =128
go
Enjoy  
]]></description>
		<link>http://sybase-addict.com/2009/05/23/find-tables-with-identity-columns/</link>
			</item>
	<item>
		<title>Data Protector: Backup your Sybase ASE databases directly to TSM</title>
		<description><![CDATA[Did you ever think about an integration between Sybase ASE and &#8220;Tivoli Storage Manager&#8221; (TSM)  provided by IBM ?
As far as I knew, IBM did not offer such kind of tool to interface Sybase ASE and TSM and, as far as I knew, no such kind of interface exist from any other vendor.  Sure, [...]]]></description>
		<link>http://sybase-addict.com/2009/04/30/data-protector-backup-your-ase-databases-directly-to-tsm/</link>
			</item>
	<item>
		<title>Sybase ASE &#8220;Performance &amp; Tuning&#8221; Podcasts</title>
		<description><![CDATA[Sybase regularly provides podcasts or webcasts about their products.
Here is a bunch of podcasts about ASE (Adaptive Server Enterprise) targeting various &#8220;perfomance &#038; tuning&#8221; topics. Enjoy  
+ General Best Practices
Tune in with Sybase ASE experts and special guest Peter Thawley, senior director and architect for Sybase engineering, to explore the best practices in performance [...]]]></description>
		<link>http://sybase-addict.com/2009/01/24/sybase-ase-performance-tuning-podcasts/</link>
			</item>
	<item>
		<title>Find out the Sybase ASE dataserver&#8217;s page size</title>
		<description><![CDATA[Find out the dataserver&#8217;s page size without using global variables like @@pagesize or @@maxpagesize.
When you work with heterogeneous versions of Sybase Ase (12.0.x and 12.5.x or 15.x), this query can help you while coding your dba stored procedures&#8230;
declare @page_size int
select  @page_size = low /1024 from master.dbo.spt_values
where type = 'E' and number = 1
go
It will [...]]]></description>
		<link>http://sybase-addict.com/2009/01/07/find-out-the-dataservers-page-size/</link>
			</item>
	<item>
		<title>Find text/image columns in a database</title>
		<description><![CDATA[Might be a good idea to share some usefull code snippet. Let&#8217;s start with a simple query to find out text/image columns in a database. This one will build a list of columns using text/image columns for each tables:
select user_name(o.uid) as "owner",
o.name as "table",
c.name as "column"
from   sysobjects o, syscolumns c
where  o.type = [...]]]></description>
		<link>http://sybase-addict.com/2009/01/06/find-textimage-columns-in-a-database/</link>
			</item>
	<item>
		<title>Sybase Sets Guinness World Record for Largest Data Warehouse</title>
		<description><![CDATA[This happened in May 2008, Sybase and Sun Microsystems have build the world&#8217;s largest data warehouse based on Sybase IQ and a Sun SPARC Enterprise M9000 server.
The data warehouse is certified to support one Petabyte of mixed relational and unstructured data.
In total, the data warehouse contains six trillion rows of transactional data and more than [...]]]></description>
		<link>http://sybase-addict.com/2008/12/02/sybase-largest-data-warehouse-in-the-world/</link>
			</item>
	<item>
		<title>Display ASE&#8217;s non default configuration parameters</title>
		<description><![CDATA[Hello,
A quick way to list all ASE&#8217;s configuration parameters having values different than &#8220;default value&#8221;, is to log into isql as &#8220;sa&#8221;, and run this query:
sp_configure "display"
go
Hope this helps&#8230;
Note: this will works with ASE v15.
]]></description>
		<link>http://sybase-addict.com/2008/12/01/display-ases-non-default-configuration-parameters/</link>
			</item>
	<item>
		<title>HowTo set up MonTables (MDA tables)</title>
		<description><![CDATA[Adaptive Server includes a set of system tables that contains monitoring and diagnostic informations. Known as &#8220;MonTables&#8221; or MDA tables, they provide a &#8220;statistical snapshot&#8221; of the state of ASE. You can query these system tables pretty much as the same way you query any other tables.
Here is a quick HowTo to set them up.

First, [...]]]></description>
		<link>http://sybase-addict.com/2008/10/25/howto-to-set-up-montables-mda-tables/</link>
			</item>
	<item>
		<title>Correction to End of Life Notice for PowerBuilder 10.5.x</title>
		<description><![CDATA[This is an External Correction to End of Life Notice for PowerBuilder 10.5.x]]></description>
		<link>http://sybase-addict.com/2008/09/26/correction-to-end-of-life-notice-for-powerbuilder-105x/</link>
			</item>
</channel>
</rss>
