Posts

Showing posts from October, 2015

Tidy badly encoded DB TABLE french chars

These few SQL lines came in handy when wanting a quick-fix for a poorly imported table UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô') UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î') http://stackoverflow.com/questions/5127744/how-to-convert-these-strange-characters-%C3%83-%C3%83-%C3%83%C2%AC-%C3%83%C2%B9-%C3%83

Home Truths

Image
  Had to pinch a couple of these       https://www.facebook.com/MicrosoftDeveloper/photos/a.237767339690433.61184.231824870284680/533208980146266/?type=3&theater           http://www.wickedfire.com/shooting-the-shit/175475-anyone-else-hate-not-being-programmer.html       And one I could not find….   There is a graph showing how much as a percentage a programmer thinks a project is completed, vs how much its actually completed.   If someone knows where I can find this graph  - please let me know.    Here is the rough idea: