Archive for September, 2009
Verizon….A love hate relationship and why their FIOS customer service sucks….
Posted by Brian Seekford in General Thoughts, Personal on September 30, 2009
I have been a Verizon customer for many years now. I was generally happy with the service until now. The tv service provides a great picture and the Internet speeds are rediculously fast.
They just suck when you try and order the service. How can that be you ask? How can a company not bend over backwards to earn you as a customer? Below is part of my email to the buggers.
I have spent roughly 4+ hours on the phone with your people to place my order for a move of service. I am moving to Tampa and just wanted to keep FIOS.
A week later, bungled order and mistake and issue after issue I am here.
I first called last week to setup my service. I placed the order and went through the entire process only for my order to freeze. So the representative said they would call me back that night once they were able to get the order to unfreeze. Well a few days went by and I called back. Enter this Monday. I talk with a representative that promises me to take care of placing the order.
Mind you, I am trying to BUY your services. Shouldn’t this be painless? Shouldn’t I be treated really well? Isn’t Brighthouse just a call away?
Anyway, I talk with the agent about my order and she says it locked in limbo. She reconfirms my order and promises to take care of the issue and guaruntee my Friday installation.
Well, we speak again Tuesday and she says the order is still locked up. She has to call me back 3 times. The day ends with no service setup.
I call today and get a new representative. She says she can’t transfer me to my old representative but promises to take care of it all.
She pulls up the order and says its locked. We 3 way call into some other office and they tell her its locked and to place another order then hang up on us. Quite rude.
I then place my order AGAIN with her. This is getting old as you can see. I go through the whole thing again and she sets up the order. They then give me an installation date of NEXT WEEK.
This is just rediculous. I placed the order LAST WEEK.
—-
Yes….A week of effort to place an order.
Where did that Visual Studio 2008 menu go….
Posted by Brian Seekford in .NET Development, C# on September 24, 2009
So I was working in Visual Studio had a hankering for debugging an already running process. Easy right? Debug -> Attach to Process. Well, it’s not so easy to do when the menu option dissapears. I pulled up my Debug menu and it had 4 options. Windows, Start,Step Over, Step Into. Hmmm.. missing something there right.
Well, after pulling a few hairs out I figured out how to get my Attach to Process option back.
Its painful but effective. Tools -> Import and Export Settings. Reset to Visual Studio default. Pick the best generic settings and finish the wizard.
All your menus will be back to normal. You just lose all of your keyboard shortcuts and custom settings you painstakingly setup.
How to delete those pesky duplicate SQL records…
Posted by Brian Seekford in SQL on September 20, 2009
So every once in a while I find that I have some duplicate records in my database as a result of testing or development or plain oversight. How to remedy the situation?
Well, its as easy as this simple SQL.
delete sourceTable
from YOURTABLENAME sourceTable, YOURTABLENAME compareTable
where sourceTable.fieldWithDuplicatesToMatch= compareTable.fieldWithDuplicatesToMatch
and sourceTable.PrimaryKey > compareTable.PrimaryKey
Basically, replace YOURTABLENAME with the name of your table.
Replace fieldWithDuplicatesToMatch with the field on the table that has the duplicates. Such as SKU or Email.
Replace the PrimaryKey with the table PrimaryKey or a time stamp (DateTime) field or whatever you want to use as the basis for which record to keep.
Voila! Duplicates be gone.
.NET Illuminator v1 Alpha Released to the wild
Posted by Brian Seekford in .NET Development, C#, SQL, White Hat Hacking on September 11, 2009
So….I finally decided to release my alpha version to all you hooligans who want to see whats under the hood of fellow .NET’ers applications. You can use .NET Illuminator to see all the UI objects in another .NET application and even manipulate them. Yes, pretend like you are in Visual Studios Form Designer and just start viewing and changing properties.
You can also view all connection strings the application has used to any SQL servers.
I will post more when I add more. Happy hacking!
Joining to a domain and getting error code 1355
Posted by Brian Seekford in Network Stuff on September 4, 2009
So…I was trying to add a computer to the domain today, a VM image, and continually got the error code 1355. What was seemingly a confounding issue turned out to be just a can’t find domain controller issue.
I changed the VM image to use bridged (direct connect) and reset the connection in the machine to reconnect and voila! The computer successfully connected.
Market is down down down…
Posted by Brian Seekford in Investing on September 2, 2009
Looking over the stock today (Sep 1 2009), I noticed a deeply disturbing trend. The entire market seems to retreating from the strong rally we have all so much enjoyed. The price of the stocks I follow fell by 5 -20% today alone. CitiGroup (C) fell by 9.2% to $4.54 which is a far drop from a few days ago when it was in the mid $5′s. Bank of America (BAC) fell to $16.46, a 6.42% drop in value. Freddie Mac (FRE) and Fannie Mae (FNM) both dropped by 17%, almost in harmony. A-Power (APWR) fell another 2.68% and the rediculously overpriced AIG fell over 20% down to $36.00 flat.
September is generally a crappy month for investing, but heres to hoping it gets better.