Friday, 24 July 2015

The political system in Canada is broken.

The national post posted this infographic regarding polling results shortly after the child care benefit program was launched.



It’s almost hard to accept that for the past year the Conservatives were third in polling against the Liberal’s and the NDP, only to, what appears to have bought votes, to put themselves back into a commanding majority – perhaps even a majority strong enough to ensure they remain the majority government – which I would deem a form of terrorism in of itself.


But how is it possible to have so easily bought a majority?


Math. and low voter turn outs.


This program is said to be benefiting 4 million families, by doubling the existing child benefits – and – rather then presenting them as tax refunds they are mailed out cheques in advance of the tax


It’s really difficult to not support the guy who just gave you a hundred dollars.


Now for the math: 4 million families represents 8 million high percentage voters. A mom and a dad, both voters, have notably good access to voting centers that tend to be schools or other facilities their children use.


8 million is not a majority in a population of 34 million Canadians. It is though a large chunk when you factor in that there are only 24 million eligible voters.


(Side Note: I don’t understand how there are 10 million Canadians not eligible for voting… Especially considering Canadians have an average of 2 children per family – there is no way that 25% of the population is under 18)


Of the 24 million eligible voters we had in the last election there was only a horrific 15 million people who casted votes. Now, that 8 million voters look more like 1/3rd of the vote.


The steak through the heart: Above and beyond all this, there is the existing voter base. The best metric in identifying a voter base in my opinion is to evaluate the popular vote – and – identify the lowest result for the past 20 years for each party:

  • Block Quebecois = 6%
  • Conservative = 12%
  • Green = .2%
  • Liberal = 19%
  • NDP = 7%


Even though a voter-base always favoured the Liberal’s, the fact that the each party has a strong base leaves the election to be decided amongst 56% of the population eligible voters active voters, which means the election campaign has to be directed at 8.4 million people.


The question is. I wonder how many of those 8 million voters in the families that were paid off are part of the 8.4 million that decide our next government.




/Alex Casamassima




Le References



Friday, 3 July 2015

Safer way to delete a record in SQL Server


The problem with a typical SQL Delete transaction is that you only know how many records you deleted until after the transaction is complete:


(1023 row(s) affected)


There are of course ways in which you can “Commit” changes to your database after a preview of data, but such organization defeats the purpose of quickly modifying the database and is certainly excessive if the intention to make a one time “Delete”

To avoid disasters with DELETE statements, try using the “TOP” clause to restrict potential hazards:

WHERE        (Transaction_Alias = 'S42CN35')


I recommend using it to restrict the results to one more than the intended deletion of records. After executing the statement, if you see that the records affected matches the clause – you have a problem with the criteria in your statement – and you can then thank me for not losing a whole table worth of data in the process.



Page Hits