Recent updates at www.sypron.nl #59

02 December 2007: Recent updates at www.sypron.nl
-------------------------------------------------

This month's quiz question is about a common
misunderstanding around the 'truncate table' statement:
        http://www.sypron.nl/quiz



In response to questions I get asked frequently, about
what it takes to become a DBA, I've created a new page with
some answers as well as some suggestions to get started
with ASE if you've never used it before:
        http://www.sypron.nl/dba.html



If you're a DBA or developer for ASE or Replication Server,
check out my books -- you'll probably find them useful.
To see the table of contents, or order a copy, follow the links below:

- The 4th edition of the well-known 'purple book' "The Complete
  Sybase ASE Quick Reference Guide" is updated for ASE 12.5.4
  and 15.0.1:
        http://www.sypron.nl/qr

- The 2nd edition of "Tips, Tricks & Recipes for Sybase ASE" has
  been updated for ASE 15.0 and is pretty much the only place
  that I'm aware of that describes some of the deeper aspects
  of ASE 15.0's query processing. Other than that, this edition
  is fully updated and has 80 pages of additional material compared
  with the first edition:
        http://www.sypron.nl/ttr

- "The Complete Sybase Replication Server Quick Reference Guide"
  (also known as the 'green book'): this book is currently sold out.
  I'm working on an updated second edition but I cannot yet say when
  this will be ready. But it *will*. Watch this space.
        http://www.sypron.nl/repqr



-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------


0
Rob
12/3/2007 4:43:21 PM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies
553 Views

Similar Articles

[PageSpeed] 21

Reply:

Similar Artilces:

Recent updates at www.sypron.nl: updated RepServer QuickRef guide
24 June 2001: Recent updates at www.sypron.nl --------------------------------------------- Check out some comments by DBAs who bought "The Complete Sybase ASE Quick Reference Guide" at www.sypron.nl/qr/index.html#dbaquotes The book can still be ordered online at www.sypron.nl/qr. A new ASE Quiz question about the "raiserror" command. Are you sure you know everything about it ... ? http://www.sypron.nl/quiz.html Finally, I managed to updated the Replication Server QuickRef Guide for RS 12.0. It has also been corrected and improved in many places, an...

Recent updates at www.sypron.nl
02 June 2002: Recent updates at www.sypron.nl --------------------------------------------- This month's ASE quiz question features a math problem. Test your combined math/SQL skills at http://www.sypron.nl/quiz.html A new certification exam for ASE 12.5 was released in May 2002. Some info about this exam was added to http://www.sypron.nl/certtips.html Grant Queenin kindly suggested some improvements to the SQL-to-XML tool which was added last month. The latest version is at http://www.sypron.nl/xml.html Some further troubleshooting tips about ASE Repl...

Recent updates at www.sypron.nl
28 June 2008: Recent updates at www.sypron.nl --------------------------------------------- The second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') is now in sight. I've received many questions when this would be available, but I had to wait for RepServer version 15.1 to be released by Sybase since I wanted to cover the latest available versions. As 15.1 finally came out last week (later than originally expected), I'm expecting the second edition to be available around mid-July -- stay tuned. I...

Recent updates at www.sypron.nl
01 February 2003: Recent updates at www.sypron.nl ------------------------------------------------ This month's ASE quiz question is about a really simple piece of T-SQL code I wrote recently... and took much longer than it should have... http://www.sypron.nl/quiz.html The stored procedure 'sp_restart_server' has been revitalised. It will now work with 'sqsh', run on Linux-based ASE, and also works for ASE 12.0 and later. On NT, the scheduling has been improved. In case you're wondering: 'sp_restart_server' stops, and automatically...

Recent updates at www.sypron.nl
20 May 2001: Recent updates at www.sypron.nl -------------------------------------------- "The Complete Sybase ASE Quick Reference Guide" has already been ordered by many DBAs all around the world. The book can still be ordered online at www.sypron.nl/qr. A new ASE Quiz question: when transferring a table with a simple BCP-out/BCP-in, is it guaranteed that the data will always remain unchanged ? Check out the below link, especially if you'd answer "yes" to this question... http://www.sypron.nl/quiz.html Updated "sybinit4ever" for ASE 12...

Recent updates at www.sypron.nl #41
22 July 2005: Recent updates at www.sypron.nl --------------------------------------------- This month's quiz question is about the easiest way to find out the proper parameters for system stored procedures (like sp_addsegment)... http://www.sypron.nl/quiz Admittedly, last month's quiz question was a very technical and difficult one. If you haven't seen the answer yet, check it out here: http://www.sypron.nl/quiz2005a.html#jun05 My books about ASE and RepServer are still are still very popular with Sybase DBAs from Iceland to South Africa and fr...

Recent updates at www.sypron.nl #62
30 August 2008: Recent updates at www.sypron.nl ----------------------------------------------- This month's quiz question is about a recent virus performing a SQL injection attack, and how Sybase databases may be affected by this... http://www.sypron.nl/quiz The list of changes to the MDA tables has been updated to include 15.0.2 esd#5: http://www.sypron.nl/mda As you've probably noticed, the second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') was finally released last mo...

Recent updates at www.sypron.nl #80
28 November 2010: Recent updates at www.sypron.nl ------------------------------------------------- This month's quiz question is about saving lots of keystrokes for some commonly used commands ... http://www.sypron.nl/quiz I've also updated the answer to last month's quiz question based on reader feedback http://www.sypron.nl/quiz2010a.html#oct10upd The stored proc sp_mda_monOpenObjectActivity has been enhanced to report each table's size and rowcount. Also provided a version for users of ASE 12.5. http://www.sypron.nl/mda T...

Recent updates at www.sypron.nl #40
20 June 2005: Recent updates at www.sypron.nl --------------------------------------------- In the past weeks, www.sypron.nl has moved to a new server at a new ISP. This was necessary to accomodate the growing volumes of traffic. As a result of this move, you may have experienced some downtime of parts of the site. Apologies for that -- it should all be working fine again now. This month's quiz question is about a deadlock problem that kept me busy for a while. For a change, the answer will be published in a few weeks so as to give you some time to ponder over this midsummer...

Recent updates at www.sypron.nl #61
28 June 2008: Recent updates at www.sypron.nl --------------------------------------------- The second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') is now in sight. I've received many questions when this would be available, but I had to wait for RepServer version 15.1 to be released by Sybase since I wanted to cover the latest available versions. As 15.1 finally came out last week (later than originally expected), I'm expecting the second edition to be available around mid-July -- stay tuned. I...

Recent updates at www.sypron.nl #44
13-Nov-2005: Recent updates at www.sypron.nl -------------------------------------------- This month's quiz question has to do with timezones... http://www.sypron.nl/quiz The changes to the MDA tables in ASE 15.0 have been added at: http://www.sypron.nl/mda.html Added two new dbccdb faults in ASE 15 at: http://www.sypron.nl/faultinfo.html My books about ASE and RepServer are still popular among Sybase DBAs and developers in more than 60 countries around the world. Order your own copy online: - "The Complete Sybase Replication Server Q...

Recent updates at www.sypron.nl #58
21 October 2007: Recent updates at www.sypron.nl ------------------------------------------------ First, there have been some problems with the availability of www.sypron.nl in the past few weeks. This was caused by technical problems at our hosting provider, and has now been fixed. Sorry for that. This month's updates are: This month's quiz question is about a quick way to track the progress of a DML operation: http://www.sypron.nl/quiz The list of schema changes to the MDA tables has been updated to include 15.0.2: http://www.sypron.nl/mda A...

Recent updates at www.sypron.nl #27
05 January 2004 : Recent updates at www.sypron.nl ------------------------------------------------- The solution to last month's Christmas Quiz Question is now online. Full details, plus the names of the prize winners, are at http://www.sypron.nl/quiz2003b.html#dec03 This month's ASE Quiz Question is about a rather straightforward update statement... http://www.sypron.nl/quiz Two new stored procedures were added, allowing unpriviliged users to effectively run 'dbcc sqltext' and use the optimizer-related traceflags 302, 310 and 317. ...

Recent updates at www.sypron.nl #38
13 February 2005 : Recent updates at www.sypron.nl -------------------------------------------------- This month's quiz question is about Replication Server: how can you set up a warm standby while keeping latency as short as possible? http://www.sypron.nl/quiz Brainbench has a new test for ASE 12.5; unfortunately, it isn't very good. http://www.sypron.nl/certtips.html A page has been added with links to free copies of enterprise-grade Linux (that can be used with Linux versions of ASE). http://www.sypron.nl/get_linux.html As of 1 Febr...

Web resources about - Recent updates at www.sypron.nl #59 - sybase.ase.general

Saturday Night Live Weekend Update Thursday - Wikipedia, the free encyclopedia
Saturday Night Live Weekend Update Thursday is an American limited-run series broadcast on NBC . It is a political satire news show spin-off ...

Gizmodo.com Updates
Nobody should have to use a pay phone , natural disaster or no natural disaster. So if your gadgets are out of juice after Sandy, here’s a tiny ...

Lifehacker.com Updates
By Whitson Gordon Ever run into a situation where you have multiple wireless networks available, but one is clearly better than the other? WiFi ...

Facebook Messenger For Android Update Includes Conversation Shortcuts
Facebook released an update to its Android Messenger application that incorporates the group -creation and message forwarding features in last ...

Instagram Updates Boomerang App
Instagram quietly released an update to its stand-alone Boomerang application, which converts groups of photos into high-quality videos. The ...

NVIDIA Releases Android Marshmallow Update For SHIELD Tablet K1
NVIDIA this week released over-the-air (OTA) update to Google Android 6.0 Marshmallow operating system for its SHIELD Tablet K1. The new OS is ...

Wintertime hits the Beat Sports galaxy in a terrific update
... for Apple TV is one of the top games on the platform, even recognized by Cupertino as one of the best titles of 2015. In its latest update, ...

Lamar Odom health update: Ex-NBA cager slightly walking on his own
Lamar Odom continues to show signs of improvement and the biggest progress that he has made so far is taking small steps without any aid of whatsoever. ...

TSA Updates Screening Procedure, Will Mandate Some Passengers Use Full-Body Scanners
... of full-body pat-downs by TSA agents. Under the new mandate, not everyone can opt for the pat-down procedure. According to the TSA’s update, ...

SportsNet Central Update: Celtics beat Hornets
... Login Search form Search 54° Main menu Home Celtics Patriots Red Sox Bruins Revolution More WRITERS Watch Shop NECN SportsNet Central Update: ...

Resources last updated: 12/25/2015 3:21:47 PM