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. 
        http://www.sypron.nl/grant_sa.html


If you didn't already, your New Year's resolutions should 
include getting a copy of my book "Tips, Tricks & Recipes 
for Sybase ASE", (preferably on your boss' budget, of course).
For the table of contents, excerpts and reviews, and 
online orders, go here:
         http://www.sypron.nl/ttr


"The Complete Sybase ASE Quick Reference Guide" is still the
most useful book for an ASE DBA.
You can still order your copy here:
        http://www.sypron.nl/qr

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

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

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

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
1/6/2004 11:50:13 AM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies
445 Views

Similar Articles

[PageSpeed] 22

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 #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 #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 #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 #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 #27 - 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 ...

Samsung rolling out a battery-improving update to the Gear S2
... Time when it comes to the battery department, but perhaps the Tizen-powered wearable will inch closer to the 7-day mark after its latest update. ...

Fitness update, my 2015 summation
Building strength, power, and endurance are our goals (along with minimizing disgusting body fat) until we reach a point of satisfaction and ...

Minor updates coming to 2017 Chevy Volt
... , Chevrolet , Electric , Hybrid The 2016 Chevrolet Volt has just appeared at dealerships, but already the talk has turned to the mildly updated ...

Update Flash right now, or just get rid of it: Christmas hack edition
... than guarding the security of their computers. Adobe has acknowledged the issue in a security announcement, and you should definitely update ...

Cleanthony Early Hospitalized: Updates on Knicks SF After Being Shot in Knee - Bleacher Report
... Cleanthony Early is reportedly in stable condition after getting shot in the knee during a robbery early Wednesday morning. Continue for updates. ...

Coming up for Windows 10: Needed upgrades, forced updates
Windows 10 was the biggest news story out of Microsoft in 2015, and looking forward to the coming year, it’s slated to continue as one of the ...

Resources last updated: 12/31/2015 5:05:06 AM