Taoffi's blog

prisonniers du temps

MOD: Mur Oriented Development

MOD est un pattern connu de gestion de projets. Il s'agit de réussir son entrée dans le mur !

Sa pratique est assez simple : elle consiste justement à éviter, au dernier moment, de rentrer dans le mur. Adopter MOD est facile. Le maîtriser et le réussir est une autre affaire !

Champollion: 20 months and 20 days in ancient Egypt

 

Jean-François Champollion who made the first translation of the ancient hieroglyph (in 1822-1824, before ever going to Egypt) made his first (and last) journey to Egypt in 1828-1829. He spent 20 months and 20 days in this journey (of which the last 60 days in quarantine in Toulon when he was back homeJ).

An amazing book "Lettres écrites d'Égypte et de Nubie en 1828 et 1829 by Jean-François Champollion" (there should be an English translation… don't really know) contains a collection of letters - written to his friends, family and some officials- that recount this journey in a very smooth and pedagogic way. In an annex, the book contains a very dense description of the History of ancient Egypt and neighboring civilizations.

Champollion was evidently passionate about ancient Egypt. During this journey, he seems to be revisiting places and events that he knew quite well. And he recounts all of this in a fascinating way.

One thing that may seem a little strange for us, is the time spent in travelling. For instance: it took him several months to travel from Paris to Luxor (in the south of Egypt)… which really seems too long now (probably unacceptable!).

In the same time, he could compose (with his small team), in less than 2 months, more than 600 entire exact colorful drawing copies of all the monuments he visited (including endless hieroglyphic texts!). All in quite harsh travelling conditions between the Nile cataracts.

Near the end of his journey, he heard that Jerusalem's Archbishop decided to honor him with a distinguished prize (Croix de chevalier du saint-sépulcure). He recounts that getting hold of the prize was too expensive for him (200 Louis)!

The book is also available in an audio version (in French) on the great Free Litérature audio web site.

(Not sure you can write code while hearing such a bookJ)

SQL Replication: Windows Sync Manager and orphaned subscriptions

It is quite useful and handy to synchronize SQL replicated databases through the Windows Synchronization Manager. You simply click the Sync Manager / Click Microsoft SQL Server / Right-click the desired subscription to synchronize and click Sync. Easy and great!

 

Annoying problems appear in some particular cases. I encountered one of these cases when I had an orphaned subscription (i.e. a subscription that doesn't have any more a declared publication). This may happen when, for instance, the publisher server doesn't exist anymore… or when the publication had been deleted in some circumstances.

The annoyance is that in this case, Windows Sync Manager continues to display the orphaned subscription and you have no means to delete it as this requires contacting the publisher which may not exist anymore and/or deleting the subscription from a publication which may not exist either!.

At this phase, you indeed have little choices… the most reasonable would be to leave this orphaned subscription displayed and simply ignore it (though a little frustratingJ)… That was what I did until I found some time to dig through (little information, if any, is available on this):

 

I ended up by finding that Windows Synchronization Manager reads the list of its displayed subscriptions in the registry key:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10.INSTANCE\Replication\Subscriptions

(MSSQL10.INSTANCE is the SQL version and instance of the subscriber server… which, in the figure below, is MSSQL10.SQL2008).

The subscriptions node contains one key per subscription with required synchronization settings.

 

I simply deleted the key related to the orphaned subscription. To avoid Windows mysteries, I also restarted the machineJ. That now works as I would like. (Craftsmanship again!)