Archive for November, 2007

Motorola Q and Sprint

Posted in Taz, Technical with tags , , , on November 29, 2007 by tazspaz

So, okay, Sprint is a bit out dated.  I really get annoyed at times with them.  Here is a new wrinkle.  Let me start with I use to be a loyal Sprint customer for about 6 years.  Then they started, and I’m not the only person who had/has experienced this, having billing issues.  Double billing, over billing, and it was up to us the customer to figure out why we didn’t owe what they said we owe.  You know the whole “Guilty until PROVEN innocent” thing?  So I switched.  Finally ending up at Verizon.  Not to get off on a side note but I really like Verizon, the new company will only pay the bill if it is Sprint though.  *Sigh*

So anyhow, all the providers that use the Motorola Q have an OTA (Over The Air) update function.  You dial a *+# and then your phone starts the update, sometimes needs to reboot (it is a windows device after all :p ).  Sprint however, you have to go to their site, get redirected to Motorola, download a file, sync your phone after backing it up because the way Sprint works you may lose your data, and then your phone is updated.  Or you can drop it at the store for a day … ya, like that is really an option! *heavy sarcasm*

So when will Sprint get smart and start OTA updates …. The world may never know!

Merrily we go along …

Posted in Taz, Travels with tags , , , , , on November 29, 2007 by tazspaz

Let’s see, where have I been traveling to as of late? I’ve been to L.A. several times, D.C., Chicago, Elgin, Pittsburgh, Wilmington, Burbank, and getting ready to head back to L.A. between this Sunday, Monday, or Tuesday.  I’ll be in L.A. about a week.  The reason I don’t know the time I’m leaving yet is due to some shipment issues.  Once those are cleared up I’ll know more. 

My trips average 1 week each before coming home.  This can be rather fun, but at other times trying at best.  See, I love to travel but I hate when it interferes with seeing my kids.  That “law” is finally understood here at the office.  If you ask me to leave town on the 1st, or 3rd weekend of the month you best be prepared to hear me say “NO!”  Why do I say trying at best?  Let me give you an example; 2 weeks ago I was on a location where some issues cropped up.  This required a lot of my time and direct effort to bring their production systems back online.  I spent a total of 118 hours that week on the client’s site, in the cold (64 degrees Fahrenheit, come on I’ve acclimated to Texas weather now it IS cold!), standing in front of server racks typing away.  All the while 4 people were bringing me caffeine-laden products to me like you’d bring shots to your best friend at their birthday party!  What was really nice though about this one in particular is that it ran to the week of Thanksgiving and the customer’s personnel asked for us to join them in their food celebration.  So when I did take a break I had these ladies just coming in with plates piled high with food.  I had to ask them to stop because they had placed like 6 meals in the matter of a few minutes in front of me.  They didn’t quiet understand what I meant I guess as several plates of desserts came in right there after.  :p  However, when I’m onsite it is not uncommon to have 90+ hour work weeks.  I do not mind this for the most part though as anything over 40 hours I still get paid straight time an hour for which is really nice. 

In L.A. I usually travel my butt to Montebello for the Hilton Garden Inn & Suites.  For those of us that travel often it is nice to find a good hotel.  When you do, if you visit that area often, you remember them and ensure you get a room there.  This is one of those places.  I get a King size bed with a room that always has an excellent view, amenities are second to none, and the room service is great.  Front desk can be trying at times as they usually only have one person at the front desk and many visitors.  But with the attached venues and the golf course (I stay an extra day to play :p) I love this place! 

More to follow; just a quick update for everyone!

Help with: sys.server_role_members

Posted in Taz, Technical on November 26, 2007 by tazspaz

Here is an interesting problem and it seems I’ve been queried on several times in the past month so let’s see if I can’t give you a quick fix or “answer” as it were here today.  The question has been: 

“I created a userid that has db_datareader membership in master so that I can view all logins.  However, it only returns itself and the sa accounts. I know that isn’t right but the only way I can make it see all logins is if I make the account a member of db_owner.  Is there a way I can do this without the accounts being db_owner?” 

In SQL 2000 and earlier editions all users had read access to all metadata.
Now enter SQL 2005.  By default users cannot see metadata for which they do not have privileges. 

Let’s try and keep it simple shall we? 

“VIEW DEFINITION” allows you see the definition of an object, not the definition of a view. 

Did that help?

Travel

Posted in Taz, Travels with tags , , , , , , , , , on November 26, 2007 by tazspaz

Hello Readers –

Sorry it has been awhile. With the new job I have done a lot of traveling. Oddly I have been with this company for almost 3 months now and have only been in the office for now (as of today) 10 actual days. The rest of the time I have spent on the road.

Many things to share, from places to faces, food to fashion, techno mumble to “Oh hell what was that rumble?!?!”

I will be updating over the next few days, stay tuned!