Recent updates at www.sypron.nl #20

08 June 2003: Recent updates at www.sypron.nl
---------------------------------------------

On popular request, this month's ASE quiz question (or rather,
the answer) is a very technical one: which functionality in
an allpages table does not have a direct equivalent in a
datarows/datapages table ?
        http://www.sypron.nl/quiz


Various improvements have been made to the popular SQL-to-XML tool.
#temp tables and identity columns are now supported; a bug related to
non-sa_role users is fixed; some other small improvements/fixes were
also made (thanks to Carsten Laszlo for helpful feedback).
        http://www.sypron.nl/xml.html


My new book "Tips, Tricks & Recipes for Sybase ASE" is
nearing completion. It will be available in July 2003.
More information is available at:
        http://www.sypron.nl/ttr


"The Complete Sybase ASE Quick Reference Guide" is still
finding its way to ever more ASE DBAs around the world.
Currently, it's used in 52 countries, from Iceland to
South Africa and from Ukraine to Brazil.
You can still order your copy from:
        http://www.sypron.nl/qr
Read some reviews at:
        http://www.sypron.nl/qr#dbaquotes

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

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

New book(coming soon): 'Tips, Tricks & Recipes for Sybase ASE'
For details, see http://www.sypron.nl/ttr

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------




0
Rob
6/8/2003 3:38:02 PM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies
496 Views

Similar Articles

[PageSpeed] 17

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 #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 #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 #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 #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 #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 #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 #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 #20 - sybase.ase.general

Windows Update - Wikipedia, the free encyclopedia
Windows Update is a service provided by Microsoft that provides updates for the Microsoft Windows operating system and its installed components, ...

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 To Update Mobile Apps Every 4 To 8 Weeks
On the same day that Facebook released a bunch of mobile updates for Apple and Android devices , the social network also announced that it will ...

Grab your snowboard and Shred It! with a fun holiday update
Its time to hit the slopes with great new features in a recent update just in time for the holidays. Shred It! , the fun, snowboarding adventure ...

San Bernardino Update: Perils of Modern Journalism Edition
... been looking for the thing for 1/2 an hour and I’ll throw it up at the top of the post. Seems somehow apropos. The post San Bernardino Update: ...

Samsung updates Lollipop firmware to show Android security patch level
... to a spate of Android vulnerabilities and exploits, Samsung was one of the first companies to announce a move to monthly security updates for ...

Monthly Macro Update November: Mish Video With Gordon Long
... US subprime auto sector, the likelihood of a US recession, and other topics. It's a 30 Minute video, which we call Mish's Monthly Macro Update ...

SportsNet Central Update: Celtics lose, Bruins win
... Login Search form Search 42° Main menu Home Celtics Patriots Red Sox Bruins Revolution More WRITERS Watch Shop NECN SportsNet Central Update: ...

Hayden Panettiere Shows Off Short Hair in First Update Since Seeking Postpartum Treatment
Hayden Panettiere Shows Off Short Hair in First Update Since Seeking Postpartum Treatment

Resources last updated: 12/7/2015 6:57:55 AM