Blog Archives

Aug 23 THU – Cinque Terra [… in progress …]

2017/11/10
By
Modified: 2017/09/16
Monterosso al Mare - Seashore

[…in progress…] Our bus to the train station was scheduled for 09:10, so we woke up at 07:30 and went down to have a large free breakfast. Fruits and eggs, and several cornetti (croissants).  Very good. At the front desk I did buy  2 LEVANTO – LA SPAZIA unlimited one day train tickets with rights to use the Park trails (€10×2 = €20 cash). Five for usage of the park, and five for unlimited rides between La Spezia and Levanto. We took a free hotel-provided shuttle at 09:10 to La Spezia train station, and at 09:26 I already validated the tickets in one of the yellow machines on the platform.  Single…

Read more »


How to make favicon.ico to work in IE

2017/11/09
By
Modified: 2017/11/05
favicon.ico Works in IE8

Did you notice that some sites have an icon next to the address in your browser?  And this icon will be saved next to the link, if you add the site to your Favorites. This article is about how to make this icon to appear not only in all other web browsers, but also in IE8. This article is a response to a great many  blogs, and comments, and posts.  People are complaining that, if you place favicon.ico in the root of your site, it immediately works for Firefox, but stubbornly will not work in IE8.  I hope  I am providing here a comprehensive answer on how to solve this problem.…

Read more »

Trip to Montreal – July 2011 – Through New Hampshire

2017/11/08
By
Modified: 2017/11/05
Place-des-Arts

There are only 3 warm long weekends in a year - Memorial, July 4-th and Labor Day. Get an extra day off and get away from the city every time. This article is about wonders of Sawyer Pond in New Hampshire and fantastic Montreal in French-speaking Quebec. Read all about 2 bikes, 4 nights, $700 and 800 miles.

Read more »

Macros to “Paste as Text” for Word and Excel

2017/11/07
By
Modified: 2017/11/05
Macros to “Paste as Text” for Word and Excel

These two macros will save you a lot of time.  They used, when you need to copy something from Internet page into a Word or Excel document, but  you do not need all the colors and formatting.   You just need the text. Usually you would do this with Paste Special, but this is several awkward clicks and many seconds lost.  Over the course of the day this is a huge inefficiency. Let’s write a macro for Word first. As of 2012-01-11 WED, I adopted this little macro as final version: Sub PasteText() On Error GoTo Unicode Selection.PasteSpecial Link:=False, DataType:=wdPasteText, _ Placement:=wdInLine, DisplayAsIcon:=False GoTo Done Unicode: Selection.PasteAndFormat (wdFormatPlainText) Done: End Sub This macro…

Read more »

Aug 22 WED – Lucca (Toscana) – La Spezia (Liguria)

2017/11/06
By
Modified: 2017/09/16
La Spezia - Hotel Ghironi

  Today we woke up at 9:15 in Lucca.  This is a middle of a second week and it is a midpoint in our trip.  This is night number 12 out of 24. Right now (10:37) we are finishing our fruit breakfast in the kitchen, and planning to stroll around the city over the city walls.   Lucca – City walls are so thick that a wide comfortable boulevard is forming a unique circle around the center Lucca – Basilica di San Frediano – 13:16   First, we climbed the city wall (11:52) near our hotel (Corso Garibaldi) and walked our marry ways along with other pedestrians and bicyclists. The walls…

Read more »

2015 BMW 535i xDrive Gran Turismo – Dark Graphite

2017/11/05
By
Modified: 2017/11/05
Test-Drive-Day-2015-06-14-S

This article is to record all the random and wonderful coincidences and events that led to finding and purchasing a new 2015 535i xDrive Gran Turismo on Sunday, June 14 2015. This article started on Wednesday, June 17, 2015.  This car has a few days of history with me, but it was sitting in the showroom long enough to be discounted and get into an “attractive” zone.  The earliest date on the documentation provided is 2014-09-19 when this car went through inspection before entering a showroom.   Date Event 2015-06-01 MO 15:01 I received an email from BMW to schedule a routine free service appointment for my 2013 BMW 320Xi. 16:12 I…

Read more »

15 Game Results 2017-11-04 SA Boris Sh. causes stir even off the field

2017/11/04
By
Modified: 2017/11/04
Lyonya G 2017-10-28 Warren

  Game Overview Borish Sh. got injured early in the game and this painful episode became the most controversial point in the game.  While he was leaving the field and players returning to their positions high balls goes into the the net.  Disallowed. Lyonya G. picked for WHITEs   Yura D. picked for DARKs  Second Saturday we are playing on over-sized field with over-sized teams  Sasha N. and Abdoul were pick number one for WHITEs  Zhenia T. was pick number one   Game Timeline 09:40 – 0:0 – Start 13-on-13 09:46 – 1:0 – Ruslan opener – too easy * * *  Boris Sh. twists his ankle and falls heavy on the…

Read more »

Crossing Pemigewasset Wilderness through Twin Brook Trail

2017/11/04
By
Modified: 2017/09/16
Stone-Profile

Crossing a huge body of wilderness often involves a question of returning back to your car.  This itinerary suggests such a crossing, if you have one car, one bike and 3 nights to spend in the woods.  At no point you are required to carry your tent and your sleeping bag on your back.  Instead, you will stay two nights in a campground and one night in the hut, where they have beds and blankets. New Hampshire White Mountains are only 2 hours from Boston (140 miles to Lincoln, NH).  They are close enough and large enough to explore several times a year. Here is a bird-eye view of your itinerary:…

Read more »

Allow to Pass Optional Parameters to a Stored Procedure

2017/11/03
By
Modified: 2017/09/16
Mount Carrigain NH 1427m

This article shows how to use string parameters to make selection on Boolean fields. What is it you need to select "true", "false" of "ALL" records. How WHERE statement will look like in that case?

Read more »

Aug 21 TUE – From Pescia to Lucca

2017/11/02
By
Modified: 2017/11/03
Collodi - Old Town I

  We are in Pescia in a Villa Vezzani somewhere near even smaller Collodi.  We added this village into our itinerary, because we thought that there is a link exist between Collodi the village and Collidi the author of Pinocchio.  There are none. We woke up at 7:30 and took a quick walk around the villa.  We contemplated the sun and the eternal summer.  We slept with all three windows wide open (second floor) and did not have any bites from insects.  Temperature has never fallen to a chilly level, just comfortable.   Rise and shine Pescia – Villa Vezzani Where is Juliaetta on the balcony? This was our fist experience to live…

Read more »

SQL – Count combinations of values in several columns

2017/11/01
By
Modified: 2017/09/16
Life is a Passage

You have a large table (in my case it has 8,697,647 records) with an Asset Number and a Business Unit, and you would like to know if any asset has record with multiple Business Units. You can count records of unique Asset/BU combinations, but this is not what you want: SELECT FLNUMB, FLMCU, COUNT(FLAID) AS COUNT FROM JDE_CRP.CRPDTA.F1202 GROUP BY FLNUMB, FLMCU ORDER BY FLNUMB, FLMCU This query will return results similar to these: FLNUMB FLMCU COUNT 84865 12000 66 84866 12000 66 84867 12000 75 84867 12704 18 84867 12705 28 84868 12000 75 84868 12715 22 84868 12717 32 84869 12000 66 84870 12000 75 84870 12535 40 84871…

Read more »