<?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>Wed, 15 Feb 2012 03:22:28 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>When was the last full backup of your database?</title>
		<description><![CDATA[dbcc dbtable tells you when the lastest database backup was performed on your Sybase database.]]></description>
		<link>http://sybase-addict.com/2011/02/27/when-was-the-last-full-backup-of-your-database/</link>
			</item>
	<item>
		<title>List tables with allpages or datarows locking scheme</title>
		<description><![CDATA[Transact sql statements to list tables with allpages or datarows locking scheme in Sybase ASE database.]]></description>
		<link>http://sybase-addict.com/2011/02/04/list-tables-with-allpages-or-datarows-locking-scheme/</link>
			</item>
	<item>
		<title>Using &#8220;dump marker&#8221; to resync a warm standby</title>
		<description><![CDATA[I recently had to resync a warm standby database for a customer. When I can&#8217;t stop the transactions on primary database I use the &#8220;dump marker&#8221; clause while recreating the connection to the warm standby database with replication server. Indeed, you can resync a warm standby database anytime with no downtime on the primary database [...]]]></description>
		<link>http://sybase-addict.com/2011/01/04/re-sync-a-warm-standby-database-with-dump-marker/</link>
			</item>
	<item>
		<title>ASEMON: monitor Sybase products performances !</title>
		<description><![CDATA[A database administrator regularly need to address database performance issues. ASEMON is a FREE efficient and reliable tool that collect and store performance metrics from various Sybase products. ASEMON helps DBA to find bottlenecks to solve performance issues.]]></description>
		<link>http://sybase-addict.com/2010/10/31/asemon-monitor-sybase-products-performances/</link>
			</item>
	<item>
		<title>Query Optimization Secrets</title>
		<description><![CDATA[Embarcadero software and ISUG (International Sybase User Group) offer a free online webinar about query optimization for Sybase ASE. In this particular webinar, you will be able to ask directly your questions to optimize your sql queries with a bunch of top Sybase ASE experts like Peter Dobler and Kevin Sherlock. Query performances, Sybase ASE [...]]]></description>
		<link>http://sybase-addict.com/2010/10/14/query-optimization-secrets/</link>
			</item>
	<item>
		<title>Find and delete duplicates records</title>
		<description><![CDATA[Wonder how to display or delete duplicate records ? Sometimes, under certain circumstances duplicate data may occur. Then it should be deleted.
In this example, we are going to create a dummy table with an identity column as a unique key, and with two varchar columns. Then we are going to insert data and duplicates manually. [...]]]></description>
		<link>http://sybase-addict.com/2010/08/29/find-and-delete-duplicates-records/</link>
			</item>
	<item>
		<title>Sybase Replication Server Looks to Cut Latency</title>
		<description><![CDATA[Sybase announced high volume replication technology with low latency.]]></description>
		<link>http://sybase-addict.com/2010/08/14/sybase-replication-server-looks-to-cut-latency/</link>
			</item>
	<item>
		<title>Stored procedures as proxy tables</title>
		<description><![CDATA[How to use proxy table to store a stored procedure's result set in a table.]]></description>
		<link>http://sybase-addict.com/2010/08/07/stored-procedures-as-proxy-tables/</link>
			</item>
	<item>
		<title>Change &#8216;group by&#8217; behaviour with traceflag 450</title>
		<description><![CDATA[Thanks to traceflag 450, you can change ASE 15 "group by" behaviour like it was with previous ASE versions.]]></description>
		<link>http://sybase-addict.com/2010/08/06/change-group-by-behaviour-with-traceflag-450/</link>
			</item>
	<item>
		<title>SAP buys Sybase !</title>
		<description><![CDATA[German software company SAP wants to buy Sybase Inc for $6 billion.]]></description>
		<link>http://sybase-addict.com/2010/05/12/will-sap-buy-sybase/</link>
			</item>
	<item>
		<title>End of Life Notice: Sybase IQ Version 12.7</title>
		<description><![CDATA[This is an External End of Life Notice for Sybase IQ Version 12.7]]></description>
		<link>http://sybase-addict.com/2010/05/09/end-of-life-notice-sybase-iq-version-12-7/</link>
			</item>
	<item>
		<title>Sybase sql stored procedures to use MDA tables</title>
		<description><![CDATA[MDA tables are very useful to understand what's going on within your dataserver to carry out accurate and successful performance and tuning campaigns. In this post I publish few basic Sybase stored procedures to use with MDA tables that focus on databases objects activity only (but I may release more MDA stored procedures in the future).]]></description>
		<link>http://sybase-addict.com/2010/05/01/sybase-sql-stored-procedures-to-use-mda-tables/</link>
			</item>
	<item>
		<title>Replication Server 15.5 Technical Webcast Series</title>
		<description><![CDATA[Sybase webcasts series are very valuable to acquire additional knowledge from Sybase experts. Register to 3 new webcasts about Replication Server 15.5.]]></description>
		<link>http://sybase-addict.com/2010/04/19/replication-server-15-5-technical-webcast-series/</link>
			</item>
	<item>
		<title>Save money ? Get rid off Sql BackTrack for Sybase.</title>
		<description><![CDATA[In this hard economic area, you can help your company to cut costs by skipping Sql BackTrack. How ? By using only new backup features Sybase implemented this last decade, and some work !]]></description>
		<link>http://sybase-addict.com/2010/04/17/save-money-get-rid-off-sql-backtrack-for-sybase/</link>
			</item>
	<item>
		<title>HowTO migrate syslogins from ASE v12.5 to ASE v15 through bcp</title>
		<description><![CDATA[First, &#8220;bcp OUT&#8221; syslogins from your ASE v12.5 dataserver:
bcp tempdb..syslogins out master.v125.syslogins.bcp -c -t"&#124;" -r"\n" -Usa -SSYBPARFRDEV02_DS
Then, connect to your ASE v15 dataserver and create in tempdb a table based on the v12.5 syslogins table (you can reverse the syslogins ddl from Sybase Central or from DDLgen tool):
isql -Usa -SSYBPARFRDEV01_DS -w1000
create table tempdb..ase125logins (
suid  [...]]]></description>
		<link>http://sybase-addict.com/2010/04/05/migrate-syslogins-from-ase-v12-5-to-ase-v15-through-bcp/</link>
			</item>
	<item>
		<title>Is DIRECT IO supported for Sybase ASE v15 on your platform ?</title>
		<description><![CDATA[This sql query tells you if Direct IO is supported on your platform:
select low from spt_values
where  type='io'
A value of 1 means &#8220;Yes, direct io is supported on this platform&#8221;.
A value of 0 means &#8220;No, direct io is NOT supported on this platform&#8221;.
Read this nice post from David Wein about Direct I/O device option.
]]></description>
		<link>http://sybase-addict.com/2010/04/02/is-direct-io-supported-for-sybase-ase-on-your-platform/</link>
			</item>
	<item>
		<title>Tell what platform Sybase ASE is running on, with a sql query</title>
		<description><![CDATA[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
go
For me it shows:
 name
 --------------------------------------------------------
 linux
Nice&#8230;
]]></description>
		<link>http://sybase-addict.com/2010/03/31/tell-what-platform-sybase-ase-is-running-on-with-a-sql-query/</link>
			</item>
	<item>
		<title>Sybase TechWave 2010</title>
		<description><![CDATA[Sybase TechWave 2010 hosted in Washington DC August 9-11.]]></description>
		<link>http://sybase-addict.com/2010/03/29/sybase-techwave-2010/</link>
			</item>
	<item>
		<title>Move or copy a Sybase ASE database with mount unmount and quiesce commands</title>
		<description><![CDATA[HowTo move or copy Sybase ASE database with mount, unmount and quiesce commands. No needs for dump/loads commands to make your databases transportable !]]></description>
		<link>http://sybase-addict.com/2010/03/21/move-or-copy-a-sybase-ase-database-with-mount-unmount-and-quiesce-commands/</link>
			</item>
	<item>
		<title>End of Life Notice: ASE Database Expert Option &amp; ASE SQL Expert Option</title>
		<description><![CDATA[Sybase will be discontinued ASE Database Expert Option and ASE SQL Expert Option.]]></description>
		<link>http://sybase-addict.com/2010/03/07/end-of-life-ase-database-expert-option-ase-sql-expert-option/</link>
			</item>
</channel>
</rss>

