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


Added a link to Jason Froebe's handy SQL UDF for
date formatting:
        http://www.sypron.nl/udf.html


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



If you're a DBA or developer for ASE, you can't afford not
to have a copy of the following books. 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

-------------------------------------------------------------
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
10/22/2007 1:30:59 AM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies
476 Views

Similar Articles

[PageSpeed] 25

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
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
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
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 #76
24 May 2010: Recent updates at www.sypron.nl -------------------------------------------- This month's quiz question is about a strange problem I had last week with long identifier names in ASE 15.x... http://www.sypron.nl/quiz I've added some additional information to the answer to the question from April, about ways of making a query run slower: http://www.sypron.nl/quiz2010a.html#apr2010upd I finally managed to post the solution to my exercise-for-the-reader question from my 2009 ISUG Journal article on 'missing statistics': ...

Recent updates at www.sypron.nl #5
30 April 2007: Recent updates at www.sypron.nl ---------------------------------------------- This month's quiz question is about a quick way of findings errors in BCP input data... http://www.sypron.nl/quiz Added a new tool, named 'sp_exec_table'; a handy and versatile stored proc that's especially useful for DBAs and for use in tools: http://www.sypron.nl/exectab.html Recently I received my first-ever orders from Colombia and Peru for my books on ASE and RepServer. This brings the number of countries where the books are used to 69. To...

Recent updates at www.sypron.nl #5
01 October 2002: Recent updates at www.sypron.nl ------------------------------------------------ This month's ASE quiz question is about the unique EBF number that identifies each ASE release: is it possible that two ASE executables actually have the same EBF number ? If you think the answer is "no", go to: http://www.sypron.nl/quiz.html By user request, a new procedure 'sp_shutdown' has been added to allow specific non-priviliged users to shutdown the ASE server without giving those users 'sa_role'. The code can be downloaded from: htt...

Recent updates at www.sypron.nl #6
01 September 2002: Recent updates at www.sypron.nl -------------------------------------------------- Can two different objects in one database have the same object ID ? If you think the answer is "no", check out this month's ASE quiz question: http://www.sypron.nl/quiz.html Added a link to the location where the free Developer's Edition of ASE 12.5.0.1 can be downloaded. Also added links to the evaluation versions of SQL Expert and the new jBuilder-for-Sybase. http://www.sypron.nl/get_ase_soft.html Added Sam Lakkundi's presenta...

Recent updates at www.sypron.nl #53
25 March 2007: Recent updates at www.sypron.nl ---------------------------------------------- This month's quiz question is about quickly generating test data... http://www.sypron.nl/quiz Fixed a problem with sp_recreate that sometimes caused the trigger's SQL source text to be concatenated incorrectly: http://www.sypron.nl/recreate.html Removed some dead links and added new ones: http://www.sypron.nl/syblinks.html If you're a DBA or developer for ASE or Replication Server, check out my books -- you'll probably find them useful....

Recent updates at www.sypron.nl #54
20 May 2007: Recent updates at www.sypron.nl -------------------------------------------- This month's quiz question is about string manipulation... http://www.sypron.nl/quiz My books about ASE and Replication Server are still being used every day by DBAs around the world. if you don't have a copy on your desk, follow the links below to check the book's contents or order your own copy: - 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:/...

Recent updates at www.sypron.nl #65
15 February 2009: Recent updates at www.sypron.nl ------------------------------------------------- This month's quiz question is about the best way of re-evaluating whether forced query plans are still the best option in ASE 15... http://www.sypron.nl/quiz Added some useful tools provided by Manish Negandhi and Vishi R: http://www.sypron.nl/misctools Updated the overview of identity column features with the reserve_identity() function (new in 15.0.2): http://www.sypron.nl/idgaps About books: I am receiving many queries when the ASE QuickR...

Recent updates at www.sypron.nl #3
17 December 2001: Recent updates at www.sypron.nl ------------------------------------------------- Thanks to Raymond Mardle, there is now a quick reference guide for ASIQ: http://www.sypron.nl/asiq_qref.html Raymond also produced a quick reference guide for Historical Server: http://www.sypron.nl/hs_qref.html A new ASE Quiz question: in 12.5, you can have long strings of 16Kb. But can you also store these ? http://www.sypron.nl/quiz.html "The Complete Sybase ASE Quick Reference Guide" is finding its way to ever more places around the world -- inc...

Recent updates at www.sypron.nl #15
15 July 2001: Recent updates at www.sypron.nl --------------------------------------------- "The Complete Sybase ASE Quick Reference Guide" is finding its way to ever more places around the world. I've noticed that ASE DBAs not only live in London and New York but also in places such as Fairbanks, Alaska (USA), Lower Hutt (New Zealand), Santiago (Chili), and Volketswil (Switzerland). The book can still be ordered online at www.sypron.nl/qr. A new ASE Quiz question about the "disk init" command. There are two improvements in ASE 12.5 (one is undocumented),...

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 #3
01 December 2002: Recent updates at www.sypron.nl ------------------------------------------------- I've been on vacation in November, so there's not a lot of new stuff. Nevertheless, I hope you like this month's quiz question. And although it is still a few weeks away: Merry Christmas! This month's ASE quiz question is about object names. Or rather, about the absence of them... http://www.sypron.nl/quiz.html My book "The Complete Sybase ASE Quick Reference Guide" is used every day by thousands of ASE DBAs and developers around the ...

Recent updates at www.sypron.nl #14
19 August 2001: Recent updates at www.sypron.nl ----------------------------------------------- I am proud to announce that the International Sybase User Group (ISUG) has awarded me the ISUG Outstanding Achievement Award last week during the Techwave 2001 conference in San Diego (USA). More details at http://www.sypron.nl/cv_rob.html#award One of the things ISUG mentioned in their statement about the ISUG Award was "The Complete Sybase ASE Quick Reference Guide" which was published earlier this year. The book can still be ordered online at http://www.sypron....

Recent updates at www.sypron.nl #60
09 March 2008: Recent updates at www.sypron.nl ------------------------------------------------ This month's quiz question is about a problem that made me seriously doubt my sanity ... http://www.sypron.nl/quiz Updated/added various links, including two new whitepapers related to ASE 15 optimization, written by a well-known author: http://www.sypron.nl/syblinks 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 belo...

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, chec...

Recent updates at www.sypron.nl #2
14 January 2002: Recent updates at www.sypron.nl ------------------------------------------------- Best wishes for 2002! The webite had grown too big for the rather outdated layout, and things started to look increasingly messy. The site has been redesigned now, and should be much easier to use and navigate. I hope you like it... Other topics: A new ASE Quiz question: how can you find out the server page size in 12.5, and why does @@pagesize have nothing to do with this ? http://www.sypron.nl/quiz.html Thanks to Raymond Mardle, users of ASE 12.0 can use sp_syntax aga...

Recent updates at www.sypron.nl #30
05 April 2004 : Recent updates at www.sypron.nl ----------------------------------------------- This month's ASE Quiz Question is about fixing concurrency problems with transaction isolation level 0 ... http://www.sypron.nl/quiz The page about professional Sybase certification has been updated with infomation about new and announced certifications. http://www.sypron.nl/certtips.html My ASE books "Tips, Tricks & Recipes for Sybase ASE" and "The Complete Sybase ASE Quick Reference Guide" are used DBAs in moe than 60 countries aroun...

Recent updates at www.sypron.nl #2
06 January 2003: Recent updates at www.sypron.nl ------------------------------------------------ Best wishes for 2003! May your servers keep running, and may your end-users not complain about performance! This month's ASE quiz question is about the deeper meaning of the words "Transact-SQL"... http://www.sypron.nl/quiz.html My article "Generating DDL Statements with 'ddlgen'", as published in the ISUG Technical Journal, is now available here: http://www.sypron.nl/ddlgen.html Finally, Sybase has now released the...

Recent updates at www.sypron.nl #35
07 November 2004 : Recent updates at www.sypron.nl ------------------------------------------------ This month's quiz question is about how deep stored procedure calls can be nested... http://www.sypron.nl/quiz Sybase Germany has created a bootable Linux CD with a preconfigured ASE server on it. They'll send it to you for free. http://www.sypron.nl/ase_free Added a link to a GUI query tool by Dmitry Lukyanov: http://www.sypron.nl/syblinks.html#qtool My books are considered 'must-haves' by many ASE DBAs, but please see for yoursel...

Recent updates at www.sypron.nl #24
05 October 2003: Recent updates at www.sypron.nl ------------------------------------------------ This month's ASE Quiz Question: can T-SQL code still be executed even if it contains syntax errors? http://www.sypron.nl/quiz My latest book "Tips, Tricks & Recipes for Sybase ASE" is getting great reviews (another review has just been published in the PowerBuilder Developer's Journal). For more information about this book -including the table of contents, excerpts, and some reviews-, and for placing an order online, go here: http://www.sypron...

Web resources about - Recent updates at www.sypron.nl #58 - 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 ...

Melbourne Storm v Gold Coast Titans: Live score, updates, blog in NRL round 2
A SECOND half wind has delivered the Storm a comfortable 34-16 win over a gallant Titans outfit at AAMI Park.

Kodak Moments App Receives Storytelling Update on iOS
Kodak Alaris has introduced a new version of its Kodak Moments app on iOS, giving users new storytelling features for turning their images into ...

Telegram gets major 'Supergroups' update
... of the best cross-platform chat solutions, being available for Windows, Android, iOS, Ubuntu, etc. Best of all, it is constantly being updated. ...

***Live Updates*** Sanders, Clinton Participate in Ohio Town Hall
***Live Updates*** Sanders, Clinton Participate in Ohio Town Hall

Fallout 4's 1.4 update is hitting consoles this week
[ Update: Fallout 4 's 1.4 console patch is now live .] Ah Fallout 4 . You had so many good things going for you, but Bethesda kind of...forgot ...

NCAA March Madness App Gets Cast Support, Big Update Just Before Tourney
... bracket for 2016, which means it’s time for another DL Bracket Challenge. But before we get there, make sure you take a look at the updated ...

Resources last updated: 3/14/2016 10:49:03 PM