Bnpositives Blog

Blog

By

10 Best Hosting Companies

I’ve been a happy customer of GoDaddy for quite sometime now. I know there are a number of people, close friends included, that will lambaste me for going with GoDaddy, but they’ve given me great service and support for an affordable price.

10best-hosting

After mentioning a comment about hosting though recently, someone sent me a link for the 10BestHosting2009.com website.

The website provides their list of best websites based on price and services. There are some sites that provide better price than I’m paying now for sure. My problem is that it’s such a pain to switch hosting companies. I’ve got 50 plus clients that I’m managing and I don’t even want to contemplate the amount of effort it would take to migrate and change all those websites to a new host and email provider.

But if you’re looking to setup your first website or to make a move to a new host for whatever reason, go uncover some options for yourself at 10BestHosting2009.com website.

By

How to Stop Relying on Others for the Simple Stuff

I had a request asked of me the other day that confused me for a bit. Someone wanted me to email directions to someone else. Two thoughts came to my mind, the first of which was trying to determine at what point I was going to get around to doing that simple, little task. The second thought was why in the world did I need to be the one to complete the simple little task?

fishing

We’ve all heard the analogy of giving a man a fish or teaching him to fish. The same holds true for technology. I can keep doing something for you, or I can teach you how to do it. The great thing is that sometimes the task is really so simple I don’t even need to teach you. You just need to do it yourself a couple of times and you’ll figure it out.

If you need directions somewhere, go visit Google Maps (https://local.google.com) which is my personal preference and put your address in. Then you can click on the little link that says get directions and put your other address in. Done! Print it out, email the directions, embed the map into your website or blog.

Need a phone number? Don’t call me and ask me what it is. Use the Internet and you can find just about anything you want.

Now, if you’ll excuse me I have to call my dad and remind him how to move files from his 3.5" disk over to a CD-ROM.

By

Open Table Option Missing in SQL 2008

I’m getting my first experience working with the newest version of Microsoft’s SQL Server. We recently installed SQL Server 2008 at a client and we are setting up a web application on their servers now.

open-table-missing-sql-2008

In  my experience with SQL when I needed to edit data in a table I would right-click on the table name and select "Open Table" to display all the data in that table. I realize this probably isn’t the preferred or perhaps even "correct" method to use, but for me it worked, was quick and allowed me to immediately edit data in the table.

With SQL Server 2008 the "Open Table" option is now gone. Instead the select statement defaults to the Top 200 results. You can switch to SQL view and remove the "Top 200" specification, but it’s another step in the process.

What should have been done is to allow the user a configurable setting. Somewhere in preferences let the user specify if they’d rather have the entire table open or a "Top" list that they can still specify the number of rows to return.

My other challenge is that my SQL Server Management Studio 2005 application doesn’t suppress the "Open Table" command from the right-click contextual menu. Instead, it just gives me the error shown above. Now debating on whether I need to go ahead and upgrade to the latest version of the studio application. Hoping it won’t have negative impact on the older versions of SQL we’re also managing on other servers.