Saturday, October 31, 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


Thursday, October 1, 2015

Home Truths

 

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: