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


2017/11/06
By
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
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 »

Crossing Pemigewasset Wilderness through Twin Brook Trail

2017/11/04
By
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
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
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
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 »

Cold comparison of Soul destiny under Easter and Western traditions

2017/10/31
By
Cold Comparison

Communists abolished the religion in 1917 and advanced a new world vision.  Here, in this cold emotionless article I want to compare several world religions (including communism) in just one aspect – origin and destiny of soul.   Several generations of Soviet people were living and dying without promise of afterlife. How did they do it?   Let us compare how various concepts of afterlife can work from purely statistical point of view?   Communist Faith   Under Communist regime, you work and die for the benefit of next generations, and your soul (you thoughts and your deeds) will be carried forward in the hearts and minds on the next generations. …

Read more »

IIS Reverse Proxy. It Even Works. Can’t Modify HTTP Response Headers.

2017/10/30
By
IIS-Reverse-Proxy

Description of a Problem You have a custom WEB application that runs inside your enterprise on some internal server and on some custom port.  How to make this application accessible from outside through a published HTTP link on port 80?   Proposed Solution On your production IIS server you create a directory that is accessible from outside on port 80.  Then you configure a Reverse Proxy solution described here.  This way neither you, nor your clients have to open custom ports on their firewalls.   How Does It Work IIS server receives HTTP request on port 80 through corporate firewalls. It then translates request according to routing rules to a destination on…

Read more »

Aug 20 MON – Firenze (Day 3) – Collodi

2017/10/29
By
Firenze - Via del Proconsolo

  We woke up at 6:45, and were out on the streets at 07:07.  The heat is gone. What a relief from afternoon heat.  It is nice and breezy on the streets at this hour.  We wanted to see all major Firenze sites one more times before the crowds. We saw 3 young (most likely German) tourists next to the wall of the Duomo.  They were just waking up and gathering their colorful sleeping gear.  They travel on a very low budget, and no one bothered them sleeping in front of the Duomo. Quickly we reached Piazza della Signoria and realized that arches here (Loggia dei Lanzi) remind us arches on Odeonsplatz in Munich,…

Read more »

How to Re-Install SQL Server 2008 Evaluation

2017/10/28
By
Sandy-Beach-2017

You have 180 days to evaluate.  You can check number of days till expiration:   open your SQL Server Management Studio and widen first line in Help — About box. What if your trial is about to expire, and you need just a few more days to evaluate? You can switch to a free Express edition, or you can follow this cumbersome procedure.   =01= Un-Install SQL Server 2008 Drop all your custom databases Run your Maintenance Plan one last time Save all your maintenance plans (this step was not tested) Go to Control Panel – Programs and Features Uninstall Microsoft SQL Server 2008 – Remove Check Rules – Next Select Features –…

Read more »

2013 July 03-07 – Hiking from Gorham to Wild River Trail – Biking back

2017/10/27
By
07-11 First picture of the day

  July 3, Wednesday Around 13:30 on Wednesday things seemed slow enough at work that I saw an opportunity to make an early start for the White Mountains.  I quickly gathered all the things, and departed by 15:00. Around 15:20 a phone call caught me on route 128, and I made a stop on a Rest Area to connect to work and do some fixes.  The connection was unusually slow, and I couldn’t get close to the windows (for better signal) because of the sun.  Around 16:46 I was done, traffic became a solid menace by this time.  Instead of braving the traffic for several hours on the way to New Hampshire, I decided to…

Read more »