Ever had a table in SQL Server with hundreds of locations with their longitude, latitude and wanted to retrieve only top 10 which are nearest to you or those that are within couple of Kilometers away? To do so in SQL Server 2005 you needed to convert long,lat into Radians and then make a large… Read Article →
Monthly Archives: July 2010
This is what you need to do in order to fix the time when booting in Mac OS: 1. Create new file /sbin/localtime-toggle with the following contents: #!/bin/sh to_utc() { echo “localtime-toggle: Toggling to UTC.” date -f %m%d%H%M%Y `date -u +%m%d%H%M%Y` } to_localtime() { echo “localtime-toggle: Toggling to localtime.” date -u -f %m%d%H%M%Y `date +%m%d%H%M%Y` } trap… Read Article →
Did you recently installed Windows 7 on your Mac Book Pro and experience problems while watching movies or YouTube videos? This problem is comming from your audio drivers. It seems that whenever you play something on your laptop and because the microphone is always open your sound card is trying to eliminate noise and this causes… Read Article →
Ever wanted to get the current time and date from the SQL Server to avoid different times between yous server and the clients (for example having a centralized application running on many countries) ? Using LINQ to SQL there is no way to get the time from the database build in the class. What you… Read Article →
About a month ago in Greece most of the TV Channels changed their broadcast type to Digital (DVB-T). I was waiting for this change for quite some time now since i have my Media Center PC connected at a Projector (720p). On the date of the change i turned my Antenna and started to search… Read Article →