# Monday, December 22, 2008

SuperOffice 6.web, Windows Server 2008 Certified

After nearly a year-long grueling process, 6.web is now officially certified for Windows Server 2008!

clip_image002

 

Best regards.


Tony Yates
# Monday, December 15, 2008

SQL Server 2008 Upgrade Technical Reference Guide

Although not officially supported yet, SQL Server 2008 will eventually get the SuperOffice nod, and when it does, you should be ready.

You will find a nice upgrade guide for this purpose available for download on Microsoft.com.

http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

Overview

A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote plan sufficiently for the upgrade, and match the complexity of your database application. Otherwise, you risk costly and stressful errors and upgrade problems. Like all IT projects, planning for every contingency and then testing your plan gives you confidence that you will succeed. But if you ignore the planning process, you increase the chances of running into difficulties that can derail and delay your upgrade. This document covers the essential phases and steps involved in upgrading existing SQL Server 2000 and 2005 instances to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks.

  • Chapter 1 gives an overview of the technical issues and decisions that are involved in an upgrade to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.
  • Chapter 2 addresses issues related to upgrading to SQL Server 2008 Management Tools.
  • Chapters 3 through 8 focus on upgrade issues for SQL Server relational databases.
  • Chapter 9 addresses upgrading to SQL Server 2008 Express.
  • Chapters 10 through 14 focus on upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.
  • Chapter 15 addresses the implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.
  • Appendix 1 contains a table of allowed SQL Server 2008 version and edition upgrade paths.
  • Appendix 2 contains an upgrade planning checklist.

Tony Yates
# Wednesday, December 10, 2008

DevNet Site Feedback is GOOD

So I was sifting through email this morning and ran across the following message:

"Hi Tony,

How is the next/previous thread functionality supposed to work? When I look at a thread under "General eJournal issues", and click "previous thread", I get to posts in other forums. Bug or feature?

What I would like, is the possibility to quickly read through all the posts in a single forum by using these links."

The email is referring to the << Previous Thread    Next Thread >> text above the top post when viewing a particular thread item.

image

It just so happened that no one ever seemed to notice this feature before, or the quirks associated with it. The idea behind it is that when viewing a post-thread in a particular forum, you can use these two links to navigate back and forth between the various threads in that forum.

Take a look at how the posts appear in the ShowForum view. The posts are ordered so that the thread with the most recently edited post is on top. To click on the "Previous Thread" link is supposed to show the next thread down the list - containing an older post, while clicking the "Next Thread" link will show the next thread above the current one. After reading the email I went to the forums to test it out and sure enough, the result was not as expected.

image

I do not know how many know this, but DevNet forums is based on the last beta version of CommunityServer forums - first debuting on asp.net many many moons ago. I rarely have to crack the source and fiddle around with the forum-site functionality, but when the opportunity presents itself, I really enjoy it. There is so much more to the application than viewed online.

So, getting back to the problem...

What it turned out to be was a mistake in one of the stored procedures in the database. What the stored procedure did was get the thread ID's for both the previous and next thread based on the current thread. These values were then passed back to the application as post ID's and placed inside the hyperlink string. The resulting behavior ensured a user never knew what threat they would view next, not to mention what forum. Someone playing with the feature could justifiably conclude they were viewing the forum threads randomly.

I ended up patching the stored procedure by getting the first posts associated with the previous and next thread ID's, then return both of those post ID's instead. No compiled code changes required. :-|

So, what have I learned from this? Well, if nothing else, I have learned that either 1) the site features are underused, or 2) very few people submit useful feedback about the application. Neither of which case I prefer, but at least hope it is not more a result of the latter.

I appreciate any comments you may have, so please provide feedback about your experience. It is a community site, after all.

Best regards.


Tony Yates
# Thursday, November 27, 2008

Diagrammatic Awesomeness

I love http://www.websequencediagrams.com/


Type in some text
  ContactRow->ContactSentry : GetTableRights

and get a diagram you can paste into your documentation in return.
For free!
Without clicking and dragging little shapes.
Without getting "Model validation error 6091"



Sequence diagrams are great - because they communicate how the objects talk to each other.
Who is saying what, and who is listening.
Sequence diagrams is an incredibly useful design tool, and I think the world is a better place thanks to this little web-site. It is much easier to write a little text than it is to drag boxes around in visio, especially in a tightly constrained domain like this.
Don't forget to check out the help text to get the full details on the diagramming syntax.

Christian
# Thursday, November 06, 2008

Expander World 2008: Questions & Answers about Travel

Special thanks to R&D's Margrethe Halvorsen Romnes and Kirsti Aakerholt for taking the time and initiative to provide these post-session questions and answers.

Q: Template and Script

  • How do they synchronize between central db and Remote Travel or Satellite?
  • Both ways? One way? No way?
  • It is especially the questions about script no one where sure of, who a RT/Satellite user can change the script that locally or on satellite server. Will these scripts be over written by the ones that comes from the central so_arc?

A: Scripts and templates are only synched down, from central to travel user. There’s no automatic sync between central and satellites, so here xcopy batchfiles set up in the gateway have been used by consultants to copy files between the locations.

Q: Remote Travel and others documents

  • If RT user set setting to synchronize others documents, what will happen if RT user change these documents out on Travel?
    • Will the documents be synched back to central archives?
    • On next synchronization, what will happen with the changes locally? Will the changes be over written by the document synched from central archives?
    • Blir de synket tilbake til central? (Is it sync'd back to central?)

A: SORT automates this and it happens when the user request it by clicking on the travel icon to sync with the central database.

Workflow:
1. Making a connection with the server, using RAS, FTP or direct connection (Router)
2. Generate the UP file
3. Start the copy process
4. Copy: Wish list from local to central
5. Copy: Copy the down-files from central to local
6. Copy: Copy the up-files from local to central
7. Copy: Copy the templates from central to local
8. Copy: Copy the user documents from local to central (my documents)
9. Copy: Copy the script directory and files from central to local
10. Copy: Copy the result of the wish list from central to local
11. Copy: Copy the files from the wish list from central to local
12. Close the dialup connection
13. Read the down-file

It’s just MY documents who are copied from the travel user to central, so secretary mode does not work.

Also, it checks the file date to compare.

Q: Corrupted dwn-files from RT user

  • Will these files be deleted on RT user local archive and on central archive?
  • Is it possible to make corrupted dwn-files locally at RT user, or shall this not be possible?

A: No deletion of corrupted files, gateway will just continue and give an error in the logfile, admin/crm client gives an error on screen. There have been wishes to have it automatically delete and force a re-create of a new up/dwn file, but this is still only a wish

Since up/dwn files are copied there’s always the change that any line break may cause a corruption in the files, but SORT will give you a warning if the file is unreadable by the client.

I logged a wish with id 5810

Q: Travel Gateway – corrupted up/dwn files (from Olav Lange Hansen, Kontineo)

  • TGW will read throu all files from RT users and Satellites, hits a corrupt file and ends the whole reading. That means that files from users after this corrupted file will not be read.
  • It should be sent a message that it is a corrupt file, wich file and from whom, so the administrator can do something about it and a new file is written from the right person.

Or make a more informative log file with more information about the corrupted file, or just log the errors and not all log in log out information.

A: Have logged this as wish/bug (id 5810)

Q: Copy list

  • The documents that are not visible for the user inside SuperOffice, will these documents get into the copy-list file?
  • If so, documents that are not visible for the user will be downloaded locally on the RT user archive.
  • This should not happen.

A: Yes – I’ll log it as a bug with id 5807

Q: Travel Gateway Light

  • A more easy Travel gateway function from SuperOffice Admin client, a little more like SORT.exe.

A: More specification please, what exactly do you want?

Note - the travel interface is available via COM and you may create your own “light” client.


Tony Yates
# Sunday, November 02, 2008

How did you spend your weekend? Watching PDC Sessions Of Course!

Oki, so this is not exactly SuperOffice material, but definitely developer/development related!!!

Greedily copied from http://blogs.msdn.com/nigel/archive/2008/11/03/128-pdc-breakout-sessions-available-now.aspx

*** Scrape Begins ***

There is a wealth of resources available at http://channel9.msdn.com/pdc2008/ but I couldn’t find a single complete list of PDC sessions available so I created one here.


Tony Yates
# Monday, October 27, 2008

NetServer 3.1 SR 1, 6.web 6.2 SR 1 and IntellisyncConnector and Transaction.

Starting with NetServer 3.1 SR 1 on Microsoft SQL server, unless explicitly turned off by a configuration value, default behavior is now to read data in a “Read Uncommitted” transaction. This means that reading data will not result in any locks and any locks in the database will not be respected when reading data.
Jens M. Glattetre
# Friday, October 24, 2008

A Few Photos Taken During Expander World 2008

With more than 110 participants this year (74 partners), we had a great time presenting partner case studies, technical sessions, and core development sessions. Here are a few snaps from various sessions and moments throughout the event.

Me talking about DevNet Roadmap

Tony

Frode Lillerud discussing Advanced Troubleshooting.

Frode 

Christian Mogensen discussing the SDK Roadmap.

Christian

Conrad, discussing User Preferences and everything else under the sun.

Conrad

Frode Bernsten - SUO Server and Client Setup Tips and Tricks

FrodeB

Jan Andersen spreading knowledge about Intellisync Server.

JanA

SuperOffice R&D: Open Season

QnARnD

Evening Event: Octoberfest!

EveningEvent

EveningEvent_II

EveningEvent_III 

Bavaria in Oslo...

EventDelivery

Foosball!

Foosball

We're definitely looking forward to next year!


Tony Yates

Expander World 2008 Resources

Hi Everyone! 99% of presentation and video's are now posted on the Expander World 2008 Download page:

http://devnet.superoffice.com/ew2008

There you will find links to all decks and videos for each session.

Best regards.


Tony Yates