Subscribe Add to Google Reader or Homepage Add to My AOL Subscribe in Bloglines

Whaddya know the world smallest HD Camcorder?

. Sunday, November 16, 2008
0 comments

I'm surfing the Internet today and saw this Flip Video MinoHD Camcorder, 60 Minutes (Black) in the main page of Amazon website as the world smallest HD Camcorder (as of this date ofcourse).

As someone who has shown an interest in electronics, you might like to know about the newest member of the highly popular Flip Video famiy, the Flip MinoHD.

Flip Video MinoHD Camcorder offers all the signature Flip Video features you love with its sleek design; simple user interface; flip-out USB arm; rechargeable internal Li-ion battery; built-in editing and sharing software; instant uploads to Youtube, RandomPage.com, MySpace, and AOL Video; plus stunningly crisp, clear HD-quality video (1280x720 resolution at 30 frames per second; 16:9 widescreen).

Example of Out of Office Reply for Terminated Employee

. Wednesday, November 12, 2008
0 comments

This is a sample message that I used for terminated employees, unless HR staff specified a different message.


=== Example for KING.NET Employee ===
John Doe (employee or consultant) is no longer with KING.NET effective June 1, 2008 (termination date). For matters relating to "Project Name here" please direct your concerns to John Smith at johnsmith@king.net (Manager or Supervisor). For all other matters, please direct your email to Mary Smith HR at marysmith@king.net.

Please call our main office 703-345-6789 if you have other concerns.

Thank you.

=== end of message ===

Whaddya know how to FTP using your Virtual Dedicated server?

. Tuesday, November 11, 2008
0 comments

Managing a dedicated server is easy and straight forward, this is not the same for "Virtual" Dedicated Server. Let me share with you my experience in Virtual Dedicated Server.


Why move from Dedicated Server to Virtual Dedicated Server?
I need to cut hosting cost so I need to move from Dedicated Server (which I am the only user of a server) to Virtual Dedicated Server (which I only get portion of server memory, disk space and bandwidth). Big change huh! Well not exactly, my primary website Hardworking.com is only for my IT Consulting Business (side job) to showcase what I can do for a business or a specific project. So, I think my website will work just fine in Virtual environment.

First of all, where did I get my Virtual Dedicated Server? Go to Moscom.com for a cheaper or discounted price. I've got the economy Virtual Dedicated Server. It took 24-48 hours to setup my virtual server and few technical issues.

Now, let's go manage the Virtual Dedicated Server. I login to my account at www.moscom.com, and click the My Product link (left hand side) to see your server.  Click the Server(s) to see your virtual dedicated server, then click Launch Manager it will open a new window.

In Hosting Control Panel, click Support tab, then choose to Launch Simple Control Panel.
In Simple Control Panel, it will ask you to login again. First setup a domain name, for example add king.net as your first domain name in your control panel. Remember the username and password that you use to assign for this account, you will use it later for your FTP access.

After adding your new domain name, click the Server Configuration, click FTP. In FTP Settings, General Settings, put check on Enable Server, and don't forget to remove the check for Annonymous FTP users. Click on SAVE to continue. This step is necessary for you to use the FTP service. The FTP service is disabled by default.

For other features in Simple Control Panel and if you have specific questions. Please join me at http://www.RandomPage.com/group/Help , post your question, start a new discussions to get answers.

For other TECH Tips, please continue reading ...

Thank you.

Sponsors:
- NeedName.com - Domain Name Registration.
- Moscom.com - Virtual Dedicated Server, Webhosting plans, and Dedicated Servers

Whaddya know how to install MS SQL Management Studio Express?

. Friday, November 7, 2008
0 comments

Here's the step by step procedure on how to install MS SQL Management Studio Express. If you are looking for MS SQL Server 2000 Enterprise Manager (client tool) install guide, clik it here. Let's begin:

  • First download the MS SQL Management Studio installer (SQLServer2005_SSMSEE). Please note, x64 is a different file to download.
  • Double click the install exe to begin the installallation.
  • You will be prompted by a welcome screen. Click Next to continue.
  • In Program Maintenance, select Modify, click Next
  • In Feature Selection, click the down arrow to see which feature(s) will be installed. Click on Next
  • Ready to Modify the program, click Install, then wait ... 
  • When you see Completing the Microsoft SQL Server Management Studio Express Setup, click Finish.
To test your installation, start the program.
  • Click on Start check your All Programs, Microsoft SQL Server 2005, select SQL Server Management Studio Express. It will start the program, please wait. 
  • Select the Server name and the Authentication (Windows or SQL Server login)
  • then Connect
If you have the right db server name and login information, you should be able to connect to your SQL Server 2005.


Whaddya know how to manage different version of MSSQL Database?

. Thursday, November 6, 2008
0 comments

I've asked the question because I have different version of MS SQL databases version 2000 and 2005. I normally managed my database in MSSQL Server 2000 using Enterprise Manager tool and I am using SQL Server Management Studio to manage MSSQL Server 2005 database.


The Enterprise Manager is not available for download. You can install the client tools from the CD.

"The Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy to use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services" (Microsoft.com, 2008).

Here's the download link.

How to install Enterprise Manager (client tools) for MS SQL Server.
  • Insert your MS SQL Server CD, browse the CD, go to e:\english\SQL2000\ent ; this is what I have in my installation CD.
  • Double click on AUTORUN
  • Select the SQL Server 2000 components to continue.
  • Click on Install Database Server; the install shield will begin.
  • In Microsoft SQL Server 2000, click on Next
  • Computer Name, select Local Computer then click Next ; I'm using my test computer for this install so I choose local computer.
  • In Installation Selection, put check on Create a new instance of SQL Server, or install Client Tools, click on Next.
  • In User Information, type your Name and Company, click Next to continue.
  • Software License Agreement, click Yes to accept.
  • In Installation Definition, select Client Tools Only, click Next.
  • Select Components, I select Management Tools, Client Connectivity, Books Online, and Development Tools.
  • Click Next
  • Start Copying Files, click on Next ... setup is preparing to copy files.
  • Click on Finish.
To test your Enterprise Manager (client tools) installation, simply run the program. It should be added to your All Programs, Microsoft Server, Enterprise Manager.

How to connect to DB Server?
  • When you open your Enterprise Manager (client tools), you don't have anything setup.
  • In SQL Server Enterprise Manager, highlight Microsoft SQL Servers, right click and select New SQL Server Group
  • In Name, type Testing, click Ok ;I use Testing for my own test only, you can change this ofcourse.
  • Select the group Testing (the you just created), right-click and select New SQL Server Registration.
  • In Register SQL Server Wizard, click Next
  • Select a SQL Server in Available Servers, click Add, then Next
  • Select an Authentication Mode, Windows Authentication or The SQL Server login information. I choose the SQL Server login so I can use the built-in sa account for testing.
  • Select Connection Option, Login automatically or Prompt. I prefer Prompt for the SQL Server account information when connecting to provide extra security.
  • Add the SQL Server to an existing SQL Server group. I created Testing group or you can choose the default SQL Server Group (most db admin do anyway). I create my own group so I can organize DB connection management.
  • Completing the Register SQL Server Wizard, click Next, then Close to end.
The installation of Management Studio for SQL Server 2005 should be the same approach. You can't go wrong by accepting default. Visit our Geek community for assistance.

Thank you,
EM @KING.NET 

Site Statistic