Minyan

Alberta and Jonny went to the Sunday night Minyan again. They said Kaddish 8 times in the Mencha and Mairiv services combined, in a total of 20 minutes. Jonny will be listening to the KiTavo parsha shortly. Oops he just got an email. Ah it was junk mail. Lea Thompson's program emailing that it didn't work correctly. Then another email saying it is now working correctly. They always come in pairs like that. Jonny is so tired. Wouldn't it be nice if there was a way to see how many words long this post is as it is being typed. Jonny is a tape and a half away from finishing Monday the Rabbi Went Away or something like that title. He is on page 311 of Union Prayer book. Last night Lorraine wanted to read to him for 30 minutes. It was the Pendrick sisters. He was so sleepy and fighting sleep. He wanted to doze off. The daughter wouldn't let the dad sleep. So after she read and went to bed he drifted in and out of sleep on the couch from 9:30 to 10:30 pm. Then he awoke and immediately stepped in dog pee. The shark. Oops email again. Penny Fuller saying she got to work late. She said it took longer to find parking than it did to get here. Another email. The timesheet for the month of September is due. Jonny used the Shark a lot. All these emails are a bit distracting. Jonny has a bunch of them to file. He did painting over the weekend. Jonny is so tired he just might go to his car now and take a nap. Then after that eat an early lunch. Jonny just discovered another web invention. There are so many to waste time on. This one is called weblogs.com. It has a scrolling marque of every blog updated. It is a little behind since it says 1:30 PM. Is Jonny rambling or is there a point to all this. Hopefully he can get to bed earlier than last night. He plans to drink no coffee today either. Jonny got DBA's to delete 49,000 duplicate records out of the database. There are another 49,000 in another table. And there are 800 related records in two other tables. These will all be deleted today on Jonny's say so. See code below.

SELECT COUNT(*)
FROM epat.person
WHERE pk_person >= 7017
AND pk_person <= 56435;

49134 <- delete

SELECT pk_person, person_code, fk_form
FROM epat.person,
er_formslinear
WHERE pk_person >= 7017
AND pk_person <= 56435
AND pk_person = id;

807 <- delete

SELECT COUNT(*)
FROM epat.person,
er_patfacility
WHERE pk_person >= 7017
AND pk_person <= 56435
AND pk_person = fk_per;

49134 <- delete

SELECT COUNT(*)
FROM epat.person,
eres.er_patforms
WHERE pk_person >= 7017
AND pk_person <= 56435
AND pk_person = fk_per;

807 <- delete

These are all records that were loaded by the migration from the Ingress database to the Oracle database. The front end was called Horton. The new front end is called VASE. Penny always calls the old one Horton hears a Who.

Jonny has a garbage encounter with his neighbor to the immediate West. This guy last week it started to bother him that the garbage sits in front of his house. Jonny said ok. But this guy put his garbage there and so he and his son in law had to look at their garbage out their window. Jonny put his garbage can all 96 gallons of it right on the line. It was behind a huge oak so Jonny couldn't see it but the guy could. He has his puny 64 gallon dumpster 6 feet from Jonny's then his single green container recycling bin. Next was his 96 gallon brown compost dumpster. Jonny had no compost this week. It was too wet to rake leaves. This isn't the kind of compost like making a compost pile in your house. This is more like yard waste. You could make a compost pile but Angelina doesn't like the idea of throwing waste like mellon rinds in your back yard.