11.16.10
Posted in SQL Server at 2:01 pm by Jim
If you keep your SQL Servers behind a firewall, you may have the same problem I did when I attempted to connect via SQL Server Integration Services (SSIS). The problem is that the port is set randomly. To get around this problem, you can add a registry setting for endpoints and code it to a specific port.
Here is an example of how to do it. However, for SQL Server 2008 R2, the GUID used was different. Our GUID started with “FAAFC69C-”, so you can try that one if you are on R2.
Now, I just need to know how to do analysis services through a firewall.
Permalink
10.21.10
Posted in Development, Technology at 3:35 pm by Jim
I haven’t blogged on much lately, but this is pretty cool (to a long-time SQL Server coder like myself at least).
On the census website, you can download all types of map data for the United States. You can then import that data into SQL Server 2008 R2 (and future releases) using their new geometry data types. For this import you need to use a free tool called Shape2SQL. Let me just add that the tool is unsupported and, at least for me, there is a bug where it doesn’t create the table to store the imported data, but you can get the SQL to make the table by using SQL Profiler to see the code it is trying to execute. Once you have imported the census shape files, using SQL Server Reporting Service 2008 R2 and beyond, you can use those shape files to create maps. However, unless you have the cross-referenced column (County name for example on a county-based map of Oklahoma), you cannot immediately map anything into those shapes because they are just polygons with names. However, if you have the coordinates of a group of somethings, let’s say the coordinates of a bunch of addresses of businesses or people, you can use the geometry functions to determine if a specific point is in a specific one of those shapes.
The real trick is in doing this in a join yielding a set operation instead of performing a loop and doing it point by point.
So, below is code I wrote that will do it in a join:
Select PL.ID, CTOk.NameLSAD00 from database.dbo.PersonList PL cross join GIS.dbo.CensusTractsOklahoma CTOk where geometry::STGeomFromText('Point('+convert(varchar(10),GPSLongitude)+ ' ' + convert(varchar(10),GPSLatitude) +')' , 0).STWithin(geom) = 1 and PL.GPSLongitude is not null
Pretty funky looking SQL, but that should do the trick.
Permalink
09.11.10
Posted in Gadgets at 5:09 pm by Jim
Wow, over a year since I posted. I guess I am due.
I recently got a new laptop through work, and absolutely love it. So, here is my mini-review. If you are looking for a powerful, small laptop, this is the best I’ve run across at a price that is cheap. The laptop is the ASUS U30JC-B1
. It has a Core i3 processor (2.4GHz), and 4GB of DDR3, and a nice bright screen. It has two graphics processors – an Intel Chipset for basic Windows work, and an nVidia GeForce 310m. This helps with performance and battery life. You can actually play games on this laptop and get good performance, but the only games I play are flash based. It has no problem with Hulu HD streams at 720p via wireless (it has Wireless N). As the purpose of the laptop is to be able to give demos on-demand and take notes in meetings, I also had work buy me what is currently one of the fastest SSD (Solid-state-disks) on the market – the 120GB G.Skill Phoenix PRO 2.5″ SATA SSD (285MB/sec read, 275MB/sec write)
. My boot times are now about 25 seconds, and applications open in a flash. The battery life on this thing is also great, as it goes about 4-5 hours for me with various usage. I got the perfect fit from the Case Logic VNC-13 13-inch Value Slimline Laptop Case
. That bag is well-padded and very small compared to previous laptop bags I’ve had with larger laptops. You can get all that and a bag of chips for about $1200.
Permalink
06.14.09
Posted in Finance at 10:20 pm by Jim
Last November, I wrote a bit about bubbles. One of the bubbles I talked about was college education. Specifically, the large Universities, their endowments and the current overall cost of education. To follow-up on that, here is an article about Harvard and their dramatic drop in endowment (some $11 Billion) and the decisions that is leading them to make.
An interesting name is pretty key in the article, one Larry Summers.
Further squeezing Harvard was a transaction Summers had pushed it into in 2004, when he successfully argued that the university should engage in a multibillion-dollar interest rate swap with Goldman Sachs and other large banks. Under the terms of the deal, Harvard would pay Goldman a long-term fixed rate while Goldman paid Harvard the Federal Reserve rate.
You can guess how that turned out when the Fed started cutting rates last year. Ouchie. Has this guy ever really made a good financial decision?
Permalink
05.17.09
Posted in Family, Running, Will at 12:30 pm by Jim
Well, I have to say I don’t post here much since I joined Facebook. That is probably bad, I think. Facebook is ok for communication, but it is kinda lacking for historical purposes. So, maybe I should do some more here.
The Fullmoon Run was this last week. I managed a good time – around 25:30. Actually, it was several seconds better than last year, but off my time from two years ago by about 30 seconds. I figure I am older and a bit heavier, so that makes it a pretty good time, considering. I did my 5-mile tempo run this morning. It felt pretty good – time was around 43 minutes, which is right at my typical time for that distance in a tempo. I bought some new shoes this season. They are Nike’s and I learned something. I haven’t worn Nike running shoes in years and so I was surprised to learn they run a bit small. My size nine’s are borderline too small for me. Actually, the right one is probably too small by a hair and the left one feels just right. Anyway, I am going to stick with them and see if my feet/legs suffer any. So far, no blisters or shinsplints so maybe they work out.
Will has to start wearing underpants to school in a couple weeks. So, this weekend we started pull-ups and potty training in earnest. He has taken to it right away, mostly due to the reward technique Melanie developed. He gets to choose something from a bag of dollar store toys or a tiny candy each time he actually uses the potty successfully. Now, he wants to go every 20 minutes!
Mom has moved to town, not sure if I have mentioned that before now. She is a great help with Will and he loves having her around. This week, Melanie is off to another drug rep meeting and Mom is going to pick him up from daycare each day. I’m sure they will have a ton of fun.
Permalink
04.23.09
Posted in Big Brother, Technology at 5:00 pm by Jim
I came across this article recently. It is from 2008. The article details technology Intel is designing into computers that allows complete remote monitoring of your PC covertly. Yes, that means regardless of who is logged into the PC, this technology would allow the right person (or wrong person which to me is basically everyone) complete access to your computer – including all passwords, keystrokes, encryption keys, etc. Got a webcam on that PC/laptop?
Elsewhere in the same article it talks about Echelon. Echelon is a technology already in your cell phone. Guess what it does? It allows the government to turn ON your microphone and go through your phone’s data without you knowing about it. How does that grab you? Your phone won’t look any different, it will just be transmitting everything you say to whoever is listening. I remember way back when people got freaked out just thinking that somehow the government was watching them through their TV. Now, no one is freaked out and they really can listen to you. No big deal you say? Well, you might also want to think about the fact that your phone most likely has a camera on it and can probably record video too.
If you still aren’t freaked out, think about this. The TV’s coming out later this year will be able to connect directly to the internet. Very soon, I am sure you will be able to place video calls from your den/bedroom on your TV. Or, the government might just be watching you. One thing will be sure – if they want to watch you, they will be able to watch you.
Permalink
03.30.09
Posted in Entertainment, Will at 1:27 pm by Jim
Well, I haven’t said much lately. I guess I have been pretty busy.
Let’s do some updates. First off, I joined Facebook.com. So, a lot of my shorter things to say I am posting there. If you aren’t on Facebook, you should give it a try. Within a couple weeks of signing up, I found my best friend from Elementary School, who I had not seen in 30 years, plus many of my old coworkers from Conoco and classmates from High School.
Secondly, if you like sweets, I highly recommend Kupcakz of Tulsa. They have some really good creations on the menu. Not cheap, but sometimes you just have to indulge in a good cupcake.
Finally, we took Will to his first movie at a theater this weekend. It was Monster vs. Aliens. $30 for tickets, popcorn and a drink and we left 10 minutes after it started. It was a little loud and scary for him. I think he would do OK at a kindler gentler movie, but perhaps we will just wait until Toy Story 3 comes out next year.
Permalink
03.05.09
Posted in Finance at 11:46 pm by Jim
I am sick and tired of the news over the last week. Certain stations would have you believe that the recently proposed budget would tax you into oblivion. The latest spin is to imply that mortgage interest tax deductions are going away. Articles like this would leave you to believe the end is near for mortgage interest deductions. The truth is far different. The budget is simply proposing a cap on the rate at which you can deduct it. Essentially, if you are in the 28% or below bracket, you would see no change. Guess what? That includes 90-95% of Americans because that bracket ends at over $200k in income per year. For people above that, IF they have a large mortgage, they will simply get capped at a 28% deduction instead of the full 36% or whatever bracket they are in. This means they lose about 20% of their deduction. Boohoo. Guess what Mr. Over 200k earner? You have been living off of the future incomes of your children and grandchildren for too long, and now it is time to pay the piper. As for the rest of America, don’t let the alarmists out there freak you out about your taxes. You should be so lucky that your biggest concern going forward was a slightly higher tax bill.
Permalink
02.03.09
Posted in Gadgets at 7:33 pm by Jim
Well, that was surely a lot faster than I anticipated. After submitting an online form at Live’s cashback website, receiving a reply that blamed Paypal and responding to that email with a rather nasty nastygram, I am now in possession of all my cashback funds.
Kudos to the Live team for coming through for me. Final cost on my laptop was under $350 due to the cashback.
Permalink
01.30.09
Posted in Finance, Gadgets at 11:29 pm by Jim
During the holidays (November/December 2008), Microsoft made an interesting effort to gain search engine users. Essentially, if you used their Live.com search site and followed all the rules, you could get cashback on your purchases at various stores. Big deal you say…you’ve heard of sites that offer this like Fatwallet.com, right? Well, the difference here was that some sites offered up to 35% cashback..in fact, some very random purchases were eligible for much higher amounts of cashback.
Ebay was a pretty steady 25-35% number during this time. I took advantage of the offer and bought a laptop on Ebay and some handmade flannel racecar sheets for Will’s bed. I love a bargain and made sure I followed all the rules to the letter…even going so far as to NOT use the coupon Ebay sent me because the cashback was voided by any use of coupons.
My live.com cashback account immediately showed the monies, but said I had to wait 60 days before I could claim the cash. No, problem. That is pretty typical of other sites that do things like this. By making you wait, they ensure you didn’t return the item.
Well, to make a long story short, this week my 60 days are up and my Live.com cashback account is now showing that payment to my paypal account “failed”. Specifically, their error message elaborates to say:
We’ve encounterd a problem depositing your cashback reward into the PayPal account that you used for your eBay purchase. But we will keep trying.
Sounds weird right? Well, plenty of other people are getting the same message. Here is a thread on Fatwallet about the Failed issue.
So, I’m going to document my pursuit of my approximately $150 here on my blog. We’ll see how it goes. I have screenshots and emails that prove my case. So, worst case I figure I file in small claims court and get my money there.
EDIT: Found another thread on Slickdeals where people are getting the same issue.
Permalink
« Previous entries Next Page » Next Page »