Hexabytes

Microsoft SQL Server, by Antoine Gémis (Toulouse, France). Working now with GPS tracking systems
Jul
12.
2009
Bill Gates last day at Microsoft
During the CES 2008, Bill Gates talked of him being moving from full-time employee at Microsoft to full time working at foundation in the month of July 2008. So he made a video about what the last day is going to be like… Featuring Bill Gates, Brian Williams, Steve Ballmer, Matthew McConaugheyr, Robbie Bach, Jay-Z, Bono, Steven Spielberg, George Clooney, Jon Stewart, Kevin Turner, Hillary Clinton, Barack Obama, Al Gore, Ray Ozzie and Craig Mundie. Enjoy!
Posted: Jul 12 2009, 23:19 by antoine | Comments (33) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: Fun
Tags:
Social Bookmarks: E-mail | Kick it! | DZone it! | del.icio.us
Jul
11.
2009
IP address Geolocation using SQL Server 2008
Yesterday, I’ve read this nice article at SQLServerCentral: Map IP Address to a Geographical Location.  I wanted to do some trial using SQL Server 2008 Spatial Datatypes.  The goal was to try to geolocalize my IP address and display something like google analytics in Management Studio, using only data provided by GeoLiteCity: http://www.maxmind.com/app/geolitecity Populating tables We have to populate data. My GeoLiteCity_Location table is a little different from the table used by Oscar D Garcia... [More]
Posted: Jul 11 2009, 21:06 by antoine | Comments (66) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SQL ETL | SQL Spatial
Tags: , ,
Social Bookmarks: E-mail | Kick it! | DZone it! | del.icio.us
Jul
10.
2009
Solving TSQL Challenges #10 using PL/SQL!
A few weeks ago, Waldar talked about solving  TSQL Challenges using SQL Server and Oracle, for the fun! Comparing SQL Server and Oracle ways to solve the same problem is interesting. mnitu wrote a PL/SQL solution for Challenge #10, using Oracle objects.
Posted: Jul 10 2009, 00:47 by antoine | Comments (47) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SQL Challenges
Social Bookmarks: E-mail | Kick it! | DZone it! | del.icio.us
Jul
8.
2009
SQL Injection Attacks – Part 1/2
We often talk about relational database engines, so why not talk about fuel injection ?  Maybe not fuel in fact, but code :-)  SQL injection attacks are code injection techniques. The principle is to hack SQL statements to gain control or alter data.  These attacks mainly target websites, however, any trusting application using dynamic SQL or not filtering its inputs could be compromised. SQL Injection attacks are well known from long ago. Measures to be on the safe side are well known, at le... [More]
Posted: Jul 08 2009, 22:33 by antoine | Comments (42) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SQL Security
Social Bookmarks: E-mail | Kick it! | DZone it! | del.icio.us