Death To Identity Thief

No I am not talking about the movie.  But this will give you a run for your money.

identitytheft

Have you noticed that the keywords “death” and “dead” are the most popular?

At first I thought it was part of a “goth” or “freddy” or maybe “scissorhand” fetish for the horror movie genre.  You know.  Just like the Star Trek has Trekkies, I thought these were Deathies.

But then at 3 AM in the middle of the night I sat up in bed and realized, these are hackers. They are looking for obituaries.  And why would they do that?  To find identities to steal! 

How many people are going to realize that their identity was stolen if they are dead?

Let me put this another way.  Which is the least likely demographic to object and retaliate for identity theft?  Right.  Dead people.

This has been a community service announcement.

Oh, by the way, the Identity Thief movie is pretty good.

STEM The Tide of Illiteracy

Ride the technology wave.

ride-wave

The U.S. needs more people with skills in …STEM

 

 

 

 

 

 

We can do this.  To make these…

robot 

If you like magic or mystery you will like STEM.science

Summary of Obama’s 2013 State of the Union Address

First, the winner of the evening: pastel ties.

stateofunion2013

Now the goals. [Responsibility Key: C-Congress A-Administration S-States E-Everybody]

  • Put the nation’s interests before party. (C)
  • Cut deficit by $1.5 trillion. (C)
  • Embrace the need for modest reforms (to) our retirement programs. (C)
  • Enact Medicare reforms proposed by the bipartisan Simpson-Bowles commission. (C)
  • Reduce taxpayer subsidies to prescription drug companies. (C)
  • Ask more from the wealthiest seniors. (C)
  • Base medical bills on the quality of care that our seniors receive. (C)
  • Get rid of tax loopholes and deductions for the well-off and well-connected. (C)
  • Pass a budget that replaces reckless cuts with smart savings and wise investments in our future. (C)
  • Ask ourselves three questions as a nation every day: (E)
    • How do we attract more jobs to our shores?
    • How do we equip our people with the skills needed to do those jobs?
    • And how do we make sure that hard work leads to a decent living?
  • Pass the rest of the American Jobs Act to create more than one million new jobs. (C)
  • Create a smarter government that sets priorities and invests in broad-based growth. (C)
  • Make America a magnet for new jobs and manufacturing. (E )
  • Launch of three more manufacturing hubs, state-of-the art labs (A)
    • Where new workers are mastering new technologies
    • Where businesses will partner with the Departments of Defense and Energy and
    • Where regions turn into global centers of high-tech jobs.
  • Create a network of fifteen of these hubs and guarantee that the next revolution in manufacturing is Made in America. (C)
  • Reach a level of research and development not seen since the height of the Space Race. (C)
  • Pursue a bipartisan, market-based solution to climate change. (C)
  • Generate even more Wind energy. (E)
  • Drive costs down even further for Solar energy. (E)
  • Keep cutting red tape and speeding up new oil and gas permits. (A)
  • Encourage research and technology that helps natural gas burn even cleaner and protects our air and water. (C)
  • Use some of our oil and gas revenues to fund an Energy Security Trust that will drive new research and technology to shift our cars and trucks off oil for good. (C)
  • Free our families and businesses from the painful spikes in gas prices we’ve put up with for far too long. (C)
  • Cut in half the energy wasted by our homes and businesses over the next twenty years. (C)
  • Give federal support to states with the best ideas to create jobs and lower energy bills by constructing more efficient buildings. (C)
  • Upgrade our infrastructure, so they’ll bring even more jobs. (C)
  • Start a “Fix-It-First” program to put people to work as soon as possible on our most urgent (infrastructure) repairs. (C)
  • Create a Partnership to Rebuild America that attracts private capital to upgrade what our businesses need most: (C)
    • Modern ports to move our goods;
    • Modern pipelines to withstand a storm; and
    • Modern schools worthy of our children.
  • Pass a bill that would give every responsible homeowner in America the chance to save $3,000 a year by refinancing at today’s rates. (C)
  • Streamline the home buying process, and help our economy grow. (A)
  • Equip our citizens with the skills and training to fill those jobs. (E)
  • Work with states to make high-quality preschool available to every child in America. (A)
  • Give every American student opportunities like graduating their high school with the equivalent of a technical degree from one of our community colleges. (S)
  • Reward schools that (C)
    • Develop new partnerships with colleges and employers, and
    • Create classes that focus on science, technology, engineering, and math.
  • Change the Higher Education Act, so that affordability and value are included in determining which colleges receive certain types of federal aid. (C)
  • Release a new “College Scorecard” that parents and students can use to compare schools based on the most bang for your educational buck. (A)
  • Put more boots on the southern border. (A)
  • Establish a responsible pathway to earned citizenship. (C)
  • Fix the legal immigration system (C) to
    • Cut waiting periods,
    • Reduce bureaucracy, and
    • Attract the highly skilled entrepreneurs and engineers.
  • Send me a comprehensive immigration reform bill in the next few months. (C)
  • Pass the Violence Against Women Act. (C)
  • Declare that women should earn a living equal to their efforts, and pass the Paycheck Fairness Act this year. (C)
  • Raise the federal minimum wage to $9.00 an hour. (C)
  • Tie the minimum wage to the cost of living. (C)
  • Offer incentives to companies that hire Americans who’ve got what it takes to fill that job opening, but have been out of work so long that no one will give them a chance. (C)
  • Put people back to work rebuilding vacant homes in run-down neighborhoods. (C)
  • Partner with 20 of the hardest-hit towns in America to get these communities back on their feet. (A)
  • Work with local leaders to target resources at public safety, education, and housing. (A)
  • Give new tax credits to businesses that hire and invest. (C)
  • Work to strengthen families (C) by
    • Removing the financial deterrents to marriage for low-income couples, and
    • Doing more to encourage fatherhood.
  • Bring another 34,000 American troops come home from Afghanistan. (A)
  • Negotiate an agreement with the Afghan government that focuses on two missions (C) :
    • Training and equipping Afghan forces and
    • Supporting counterterrorism efforts.
  • Help countries like Yemen, Libya, and Somalia provide for their own security (C).
  • Help allies who take the fight to terrorists, as we have in Mali. (C)
  • Take direct action against those terrorists who pose the gravest threat to Americans. (C)
  • Forge a durable legal and policy framework to guide our counterterrorism operations. (A)
  • Ensure that our targeting, detention, and prosecution of terrorists remains consistent with our laws and system of checks and balances. (A)
  • Ensure that our efforts are even more transparent to the American people and to the world. (A)
  • Lead the effort to prevent the spread of the world’s most dangerous weapons. (C)
  • Stand by our allies, strengthen our own missile defense, and lead the world in taking firm action in response to these (North Korean) threats. (C)
  • Do what is necessary to prevent them (Iran) from getting a nuclear weapon. (C)
  • Engage Russia to seek further reductions in our nuclear arsenals. (A)
  • Lead the global effort to secure nuclear materials that could fall into the wrong hands. (A)
  • Face the rapidly growing threat from cyber-attacks. (A)
  • Strengthen our cyber defenses (A) by
    • Increasing information sharing, and
    • Developing standards to protect our national security, our jobs, and our privacy.
  • Give our government a greater capacity to secure our networks and deter attacks. (C)
  • Complete negotiations on a Trans-Pacific Partnership. (A)
  • Launch talks on a comprehensive Transatlantic Trade and Investment Partnership with the European Union. (A)
  • Join with our allies to eradicate such extreme poverty in the next two decades (A):
    • By connecting more people to the global economy and empowering women;
    • By giving our young and brightest minds new opportunities to serve and helping communities to feed, power, and educate themselves;
    • By saving the world’s children from preventable deaths; and
    • By realizing the promise of an AIDS-free generation.
  • Remain the anchor of strong alliances (A)
    • From the Americas to Africa;
    • From Europe to Asia
    • In the Middle East.
  • Stand with citizens as they demand their universal rights, and support stable transitions to democracy. (A)
  • Do not dictate the course of change in countries like Egypt. (A)
  • Insist on respect for the fundamental rights of all people. (A)
  • Keep the pressure on a Syrian regime that has murdered its own people. (A)
  • Support opposition leaders that respect the rights of every Syrian. (A)
  • Stand steadfast with Israel in pursuit of security and a lasting peace. (C)
  • Do whatever we must to protect those who serve their country abroad. (C)
  • Maintain the best military in the world. (C)
  • Invest in new capabilities, even as we reduce waste and wartime spending. (C)
  • Ensure equal treatment for all service members, and equal benefits for their families – gay and straight. (C)
  • Draw upon the courage and skills of our sisters and daughters. (E)
  • Give our veterans the benefits, education, and job opportunities they have earned. (C)
  • Do our part to make sure our God-given rights are protected here at home. (C)
  • Announce a non-partisan commission to improve the voting experience in America. (A)
  • Protect our most precious resource: our children. (E)
  • Reduce gun violence (C) by
    • Adding background checks
    • Sign tough new laws to prevent anyone from buying guns for resale to criminals.
    • Get weapons of war and massive ammunition magazines off our streets.
  • Make what difference we can, to secure this nation, expand opportunity, and uphold our ideals through the hard, often frustrating, but absolutely necessary work of self-government. (C)
  • Look out for our fellow Americans the same way they look out for one another, every single day, usually without fanfare, all across this country. (E)

Whew!  We have some work to do.

New Monopoly Piece Is The Cat’s Meow And Cat’s Pajamas At Same Time

Talk about your day of reckoning.  All the Cat-loving Dog-hating people have finally got their way.  [Okay.  I am sure there are a few Cat-loving Dog-loving people out there.  Will you please stand up?]  

monopoly_cat 

Since the game of Monopoly was first sold over a hundred years ago, there has been a Dog albeit a Scottish Terrier.  But there has never been a Cat – until today.

A Monopoly contest was held this past month and a new piece was chosen.

Cat-lovers are ecstatic. 

Some protagonists can hardly wait for the day when the Cat and the Dog end up on the same Monopoly board square.

But the same contest chose a loser.  Yes the much maligned and hardly used Iron piece was chosen for the dumpster.  Nobody liked ironing anyways.

Setting My Watch At Snack Time

I used to go to work and leave my watch at home.

watch

Recently one of our employees named Steve retired.  He was a fairly skinny guy. Boy did he have a busy schedule before he left us.

He had peanuts at 10 AM.  Then potato chips at 1 PM and finally an Ice Cream bar at 3 PM.  This was on top of his lunch at noon. 

He added credence to the idea that you will NOT gain weight if you eat a lot of small meals.

popcorn

A long time ago I worked on the West Coast Shuttle effort.  A lot of my time was spent in the same building with the Operations Maintenance Documentation (OMD) Group.  I liked to call it the OMG department because at exactly 2 PM one of the large data entry personnel would pop a bag of popcorn.  OMG!  The smell of popcorn would permeate the whole building.

My point is those snack times allowed me to either set my watch at 2 PM every day or just leave my watch at home.  But alas those were the good ole’ days.

Why Are We Possessed With Zombies and The Dead?

The IMDb database for movies and television shows has 840 shows just for zombies and 6779 shows involving death.

zombie

“HELP!  I can’t watch all those shows by myself!”

Could anyone but Leonard Maltin possibly watch all of them?

Even angels appear in only 357 shows and a fairy in only 140.  I am paraphrasing but Woody Allen said the only constant was death and taxes. Despite that taxes are only found in 151 shows. 

Looks like nobody got over the excitement, fear, and anxiousness of mysterious creatures under our beds and in our closets when we were kids.  Mercer Mayer and his children’s books involving the little Monsters made Monsters seem fun.

Now we can’t get enough of them.

My all time favorite show is Zombieland with Woody Harrelson. That is the one with a zillion Twinkies.

twinkies

The thought of Zombies after every Twinkie purchase is probably what killed Hostess.

May every Twinkie and Zombie die or live in peace.

The Road To A Legacy

This post is about my great, great, great, great, great, great, great, great, great, great, great, great, great, great, great, great-grandfather, Reuben Dye.  He settled in the Flint Township area of Michigan back in 1843 so he wasn’t that old but he was really great.

dye_roadThe reason he was so great is he was ahead of his time.  He was one of the first of about eight settlers in that Michigan area.  He had a farm and a road that eventually became Dye Road.  This was 50 years before gas buggies were invented.

Eventually Flint, the town to the east, became the automotive capital of the world.. So whether he was forward thinking or just plain lucky, I will never know. But what I do know is he is dead but his legacy lives on via that well-traveled road in Michigan.

Cheating Death By Procrastination

Here is my logic.  If most people retire at age 65 and the average life expectancy is 84 years, than that means most people live 19 years after retirement.

pushretirementThus if you postpone retirement, you should postpone death.

In other words, if I delay retirement until age 75, then I should live to age 94, right?

I gotta think positive.  I need time to rebuild my nest egg.

Sybase SQL Challenge – Sum Of Max Values

--------DATA in Cat_Tbl---------------------------
Cat1           Cat2          Value
a              e1            113
b              e1            14
a              e2            15
c              e3            13
a              e1            13
a              e2            11
c              e4            1

Sybase

PROBLEM:

For each distinct value in Cat1, user wants to find maximum of Values grouped by Cat2 and then sum them up. 

 

 

Step 1: User wants to extract the following rows for example where Cat1 = ‘a’.

Cat1 Cat2 Value 
a    e1   113 
a    e2   15 
a    e1   13 
a    e2   11

Step 2: User wants to extract maximum corresponding to Cat1 and Cat2:

Cat1 Cat2 Value 
a    e1   113 
a    e2   15

Step 3: User wants to sum the Values for Cat1.

Cat1 SumOfValueColumn 
a    128 
b    14 
c    14

stackoverflow

 

 

 

 

SOLUTION 1 USING TEMPORARY TABLE #Max_Cat_Tbl

select Cat1, Cat2, max(Value) Maxvalue 
into #Max_Cat_Tbl from Cat_Tbl 
group by Cat1, Cat2 order by 1, 2 
select Cat1, sum(Maxvalue) 
from #Max_Cat_Tbl 
group by Cat1 
order by Cat1 
drop table #Max_Cat_Tbl 
go

SOLUTION 2 USING VIEW Max_Cat_Tbl_View

create view Max_Cat_Tbl_View 
( Cat1, Cat2, Maxvalue ) as 
select Cat1, Cat2, max(Value) 
from Cat_Tbl 
group by Cat1, Cat2 
select Cat1, sum(Maxvalue) 
from Max_Cat_Tbl_View 
group by Cat1 
order by Cat1 
go

Good SQL, good night.

How do you catch a log suspend error in Sybase?

Sybase

You have two issues.

One is the UNIX/Linux script does not detect errors correctly.

Secondly the transaction log is filling up frequently.

First the script needs to have the standard output AND the error output go to your log file. When you use the > it is using file descriptor 1. When you want to capture error output you need to use 2> for file descriptor 2. So the command would look like the following.

isql    > error.log    2> error.log

Better yet, use this.

isql    2>&1    > error.log

The previous command says to have file descriptor 2 go to file descriptor 1 which goes to a log file.

Now to detect errors, look for “Msg” which all Sybase errors have in front by using the grep command.

stackoverflow

 

 

 

 

Secondly to resolve the transaction log space, you need to grow the size of the log which should be on its own device separate from data. Then you need to set the threshold to dump aka flush the completed transactions to a disk file automatically. You need to investigate the following commands to do this.

alter database, sp_helpthreshold, sp_addthreshold, sp_thresholdaction

Good SQL, good night.