Totally Nothing...Do-Dads and Fix-Its For the Web.

SQL Server Installation Gotcha

The installation of SQL Server is a no brainer, for the most part.  Any dba should also know by now that dbs should NOT be installed on the system drive (typically C:) and if you're really going all out on a major production system, dbs and trans logs should be on separate drives as well, where the logs drive has better performance. 

Now, I've installed SQL at least a half a gazillion times since 1998 and I typically go through each screen with a fine tooth comb, especially on a cluster.  However, if I haven't installed it in a while there is sometimes a gotcha that requires me to uninstall SQL and install it again.  This post is just as much a reminder for myself (& punishment for forgetting) as it is for anyone reading it.  

In the newer versions of SQL, when you get to the screen that asks which components you want to install and the drive location, each component has it's own drive location.  So, when you set the drive location below, you're only setting it for that specific component that is highlighted.  Therefore, you need to highlight each component and change the drive location.  This is also true even if you set the drive location at the parent component level.

Got it self? Good.  If I forget again, I'll come back and add screenshots or something for more punishment to myself.

I am aware there are ways to move the system dbs and such, but it's no picnic (unless you mean Problem In Chair Not In Computer) and definitely not worth it if you haven't done much work on the SQL server yet.  Do it right the first time or uninstall and do it over, if you can.

Ok, hope this is helpful to someone, my uninstall should be done, time to go back and do it right...

P.S. Don't forget to delete all the files SQL leaves laying around after the uninstall.  It won't affect the new install, but it could lead to confusion in the future and is just overall better administration.

Connect to the internet via Globe, Smart Buddy, Nokia and Ovi Suite

If you are in the Philippines and trying to connect to the internet using your Nokia cell phone as a modem through OVI suite, Smart Buddy and Globe are the two main competitors here.  You can get tolerable speeds from both providers depending on your coverage.  This also assumes you can already browse the internet through your phone browser (i.e. internet is enabled for your phone through your provider)

My Smart Buddy sim worked immediately upon connecting it to the computer and OVI suite.  The initial setup is:

Tools > Options > Connect to Internet > Use this Network Operator:

Home Country: Philippines

Home Operator: SMART

Choose OK

Then choose Tools > Connect to Internet

At this point you should be using your SMART Buddy sim to browse the internet through your computer.  Globe (prepaid), however, was not quite as easy...unless you know the trick.  Upon connecting my Nokia (with Globe sim) to OVI suite, I continued to get this error on my phone:

"subscribe to packet data first"

After messing with the APN and every network settings on my phone and wasting several hours, I found the solution (or at least the proper address) on another website spoken in either Tagalo or Cebuano.  Anyway, get rid of any changes that you made to your phone, then go to the OVI suite:

Tools > Options > Connect to Internet

If you pick GLOBE from the Home Operator settings mentioned above, you can see below (in OVI suite) that it populates the "Use Manual Settings" with: (this setting is correct if you are a postpaid customer...although I'm not sure why anyone would be)

Bullet the "Use Manual Settings" option and change that value to:

That should do it. Be sure to disconnect when you are done browsing as it costs you n load every x minutes, depending on your provider and if you haven't subscribed to a promotion.  Happy Browsing.