Today I was trying to pull some IP Addresses through a Linked Server connection on SQL Server 2008 from a MYSQL server. The IP Addresses were stored as integers using MYSQL’s INET_ATON() function. The problem was when I ran the query through openquery I started getting gibberish back:
SELECT * FROM OPENQUERY(MYSQL, ‘SELECT d_ip,INET_NTOA(d_ip) FROM IP_ADDRS [...]
Archive for the ‘Tech’ Category
OPENQUERY with INET_NTOA (or reason # 5,643,532 varchar(16) is better)
July 20th, 2010
No Comments
Thoughts On My HTC G1 Phone
February 24th, 2009
No Comments
I’ve had my G1 (or Google phone) for almost a month now and I thought it would be to write up my thoughts now that I have a little more experience with it. Let me preface this all by saying I am not a phone guy. Hit up Engadget or Gizmodo if you are looking [...]
Power Twitter Tricks
February 23rd, 2009
No Comments
One of the reasons I love Twitter so much is that it is so extensible. You can use it to accomplish a ton of tasks with almost no work on your part. Recently, several friends had of mine had joined Twitter and asked about how I do some things. I thought it might be beneficial [...]
Federal Cyberattacks Soared in 2008 [IT Security]
February 17th, 2009
No Comments
USA Today has in interesting article today on the increasing number of cyberattacks on government networks over the last year. According to the article :
Federally tracked accounts of unauthorized access to government computers and installations of hostile programs rose from a combined 3,928 incidents in 2007 to 5,488 in 2008, based on data provided to [...]
All aTwitter Redux : 9 Months In
January 26th, 2009
1 Comment
It’s been almost 9 months since I started using Twitter and it’s kind of been a revelation. I was looking at my old post back when I first joined and laughed when I saw how skeptical that I was that I was going to find it at all useful. As it stands now, Twitter is [...]
Better Marriage Planning Through Technology
July 29th, 2008
No Comments
I’m getting married on August 16th. And while I’m running around like a crazy person, I’ve found some tools that make things a lot easier for us to keep somewhat organized. I’m not talking about marriage websites like theknot.com or similar.
What has been saving my skin time and time again is Remember the Milk and [...]
Some Cool Things I Learned at PodcampOhio
July 1st, 2008
No Comments
This weekend, I went ot PodcampOhio. It was just a really awesome new media conference here in Columbus. I learned a whole bunch and met some cool people. I thought I would share some of the things I picked up for everyone who couldn’t attend.
Blackbird – A lightweight Twitter client for the Blackberry. No need [...]
Setting Up Wordpress on an Addon Domain
June 15th, 2008
1 Comment
This weekend I was working to setup a new blog that I have been getting ready. I had the wordpress installation all set and ready to go and I ordered the domain name from GoDaddy.com. I then pointed the new domain at the directory on the webserver that would be hosting the new site and [...]
Installing A Brother MFC 7420 Laser Printer / Scanner in Ubuntu
May 9th, 2008
No Comments
This post moved to MadBuntu.com. Go to it here.
A Couple Linux Tips
May 5th, 2008
No Comments
This week I went ahead and installed Ubuntu 8.04 on my laptop and am generally pretty happy with it. As usual the install was painless quick from the upgrade button on the Update manager. I have been holding off on installing on my desktop because I want to make sure everything is running [...]
