Pages

Monday, November 28, 2011

VTC Online Training

During the past couple of months I've been using the online video training modules at Virtual Training Center, an online training tool that covers topics from Networking to Applications use and administration, programming and more. They accept content, delivered in a uniform manor, from a small pool of  "teachers". While each teacher has his own style, the training modules I've watched thus far have all been done very professionally and are worth the time.

Here are a few recent releases:
What I have not mentioned is that cost is VERY affordable.  If you watch only one module and get just a couple of things from it, you've received your value.
VTC produces and delivers at least one new course a week, sometimes more often, via a dedicated team of authors and editors based in our office in USA.

Get Started!

One Step Closer to France.

Friday, November 25, 2011

Newegg Black Friday Refurb Deals

If you are like the average computer you don't need to spend a lot of money to meet your computing needs.  I'll define the "average computer user" as someone who uses the internet/email, perhaps wants to install Microsoft office (or an open source equivalent like Libre Office or Open Office), maybe uses a simple photo/graphic program like MS Publisher, or Photo Elements, wants to download photos from a camera, iTunes and such.

Here is a link to the Newegg site, with some good options for very little money (and no-hassle parking!).


Check out this EMachine and more.






 


Happy Shopping. 

One Step Closer to France.

Monday, November 14, 2011

HP Smart Buy Mini 3105 - GREAT BUY!

HP Smart Buy Mini 3105 : 1.6GHz E-Series 11.6in display
This is a GREAT little computer for $299 from PC Connection Express.
Free Shipping too!!

  • It's a perfect solution/alternative to a tablet
  • Weighs just 3.5 pounds
  • Built for long battery life
  • Windows 7 Professional ($300 value right there!)
  • 2GB RAM - expandable to 8GB (but only go to 4GB - all Win 7 will use).
  • AMD E-Series 350 processor, Dual Core, won't work well for super heavy software (i.e. Illustrator) but plenty good for MS Office and the like.
  • Gigabit Ethernet (A/G/N)
  • HDMI & VGA connections
  • 3 USB ports
  • Card reader
  • Built in Camera
  • Radeon HD 6310M
  • Lots for little$$
The cheapest I see this same Notebook going for today is $439.
This video is from Tiger Direct, good info (they are charging $530!).


One Step Closer to France.


Friday, November 11, 2011

Updating Windows XP Product Key

Updating Windows XP Product Key
  1. Click on Start and then Run.
  2. In the text box in the Run window, type regedit and click OK. This will open the Registry Editor program.
  3. Locate the HKEY_LOCAL_MACHINE folder under My Computer and click on the (+) sign next the folder name to expand the folder.
  4. Continue to expand folders until you reach the HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\Current Version\WPAEvents registry key.
  5. Click on the WPAEvents folder.
  6. In the results that appear in the window on the right, locate OOBETimer.
  7. Right-click on the OOBETimer entry and choose Modify from the resulting menu.
  8. Change at least one digit in the Value data text box and click OK. This will deactivate Windows XP.
    Feel free to close Registry Editor at this point.
  9. Click on Start and then Run.
  10. In the text box in the Run window, type the following command and click OK.
    %systemroot%\system32\oobe\msoobe.exe /a
  11. When the Let's activate Windows window appears, choose Yes, I want to telephone a customer service representative to activate Windows and then click Next.
  12. Click the Change Product Key button at the bottom of the window.
    Don't worry about filling anything out on this screen.
  13. Type your new, valid Windows XP product key in the New key: text boxes and then click the Update button.
  14. You should now reactivate Windows XP by following the instructions on the Activate Windows by phone window which you should now be seeing or via the Internet by clicking the Back button and following the instructions on that screen.
    If you'd rather postpone activating Windows XP until a later date, you can click the Remind me later button.
  15. After activating Windows XP, you can verify that activation was successful by repeating steps 9 and 10 above.
    The Windows Product Activation window that appears should say "Windows is already activated. Click OK to exit."

    Step by Step Guide to Changing the Windows XP Product Key.  

    Thanks to:
    Tim Fisher

    PC Support Guide
    Sign up
    for His Newsletter



    One step closer to France.

Thursday, November 10, 2011

Edit Files That Require Admin Privileges


There are certain files and folders in Windows that you can only access when you are logged in as the administrator of that computer.  Even if you have administrator privileges, you will not be able to edit some file unless are logged in a THEE Administrator.  Here is one way around it, that keeps things secure.
For instance, if you ever need to block a website on your home computer through the hosts file, your would require administrative privileges. Similarly, you may not be able to execute all the commands at the command prompt if you not logged in as the admin.
File Permission Error
Sometimes Administrators Cannot Edit Files
There’s another related problem that mostly concerns the home consumers of Windows 7 and Vista.
Sometimes you are the admin (and the only user) of your home computer and yet, when you try to open some protected file, it says “access denied”. This is confusing because you are logged in as the super-user and if you don’t have access to all parts of the system, who else will?
The fix is simple though. I will illustrate this with Windows hosts file but you can apply the workaround to virtually all files that you are unable to read / edit in Windows because of permission problems.
Step 1. Open your Windows start menu, search for the notepad application and then right click the notepad icon.
Step 2. Choose “Run as administrator” and then, while inside notepad, browse to folder (/windows/system32/drivers/etc) that contains the hosts file.
You can now edit and save that file in the same folder without any issues. To recap, the trick is that instead of directly opening a protected file in the associated application, you run the application first as an administrator and then open the file inside it.
Thanks to: http://www.labnol.org/software/edit-hosts-files-as-administrator/13673/
I will cover other techniques in a following post.
One step closer to France.

Monday, November 7, 2011

Marcin Jakubowski: Open-Sourced Blueprints for Civilization

A friend introduced this You Tube video to me on Facebook.  Oddly, when I clicked on the FB link, it linked me to some 'occupy' propaganda and then to the video.  I'm not sure why the occupy people thought Marcin Jakubowski would some how be in alignment with their thoughts??  At no time does he say I felt I was oppressed by big business so I made signs and sat on my butt for days on end whining and complaining about what others do or don't do for me.  

What Marcin Jakubowski DOES say is:  things weren't working out for him the way he wanted them to, so he came up with an idea.  What he did was get creative & PRODUCTIVE.  What he did was roll up his sleeves and WORK. And then he shared what he'd created and found others wanted to co-create with him and they came to share and WORK with him.  


Marcin Jakubowski: Open-Sourced Blueprints for Civilization



One step closer to France.

Wednesday, August 31, 2011

Important Firefox Security Update!

Important Security Notice
==========================

If you are running Firefox 6.0 as your web browser, please upgrade to Firefox 6.0.1 as soon as possible.

Why is this important?
======================

A company that issues SSL certificates was breached and their signing certificate was stolen. Fake certificates for Google have been signed using this stolen certificate. If you click on a link in an email that takes you to a fake Google site, and you enter your credentials in that site, you could be providing access to all sites where you use your Google login. These sites may also come up as the result of a Google search.

The latest updates to Firefox and Google Chrome have revoked the trust relationship for these certificates. Google Chrome will update automatically, but we recommend you update Firefox manually if it has not already updated. To update in Firefox go to Help >> Check for Updates.

(Thank you to my boss for this info!)


One step closer to France.

Sunday, August 28, 2011

Google Calendar not Syncing with Android Device

I had a problem with my Google Calendar events not syncing with my Android device (a modified, CM7 Nookcolor).  If you are having this issue too, here are some simple steps to try before you get frustrated!


Step 1: I went into: Settings >> Applications >> Manage Applications
Step 2: I chose the "All" tab.
Step 3: Found and selected Calendar and pushed "Clear Data". Did the same for Calendar Storage and for Calendar Sync Adapter.
Step 4: Settings >> Accounts, and the gmail account in question, and performed a "Sync Now".


I tested by adding an event to my Google Calendar on my computer, it synced automatically and quickly to my device, and then tried adding an event to my device, found it to sync well to my computer.  I did the same thing with deleting the events to make sure they would update too!


Thanks "boster" on the Android Forum for the good, simple instructions!


One step closer to France.

Wednesday, August 17, 2011

Cisco CM/Unity Basics: Busy, No Answer Call Fwd to Another Voicemail Box


Forward a Call from an Extension Without Voicemail to Another Voicemail Extension Configuration Example


Log into Cisco Call Manager Administration:


Call Routing >> Directory Number
Find the DN you would like to have to go another’s Voicemail, tick the boxes in the Call Forward & Call Pickup Settings section that apply.


For Example:
Forward Busy and No Answer Call forward:
Forward Busy Internal
Forward Busy External
Forward No Answer Internal
Forward Unregistered Internal
Forward Unregistered External


Leave the “Destination” fields empty.




Log into Cisco Unity Connection Administration.


Call Management >> Call Routing >>Forward Routing Rules


Add New
Create a Name for Rule >> Save

Status = Active
Send Call to = User with Voice Mailbox
>>Click find to choose the Mailbox you want the DN (extension) to use
>>Click Attempt Transfer if you would like that extension to ring first before going to Voicemail box.
>> Click Go Directly to Greeting, otherwise

Under Section Titled: Routing Rule Conditions
Add New
Configure Condition(s).
Example: to have x229 & x336 use the Mailbox selected >>
Click Dialed Number >> In >> type “229, 336” in space provided
>>Save


To review Click Forwarding Routing Rules from LH nav or Top Nav and select the routing rule you just configured.




One step closer to France.

Monday, August 15, 2011

MySQL Basics: STRING Data Types


MySQL supports a number of data types in several categories, my next few posts will cover the different types of data used in MySQL.

MySQL Data Types Overview:

Numeric - (reviewed in earlier post)
Date and Time - (reviewed in this post)
String (character) - (review here)


•MySQL interprets length specifications in character column definitions in character units. (Before MySQL 4.1, column lengths were interpreted in bytes.) This applies to CHAR, VARCHAR, and the TEXT types.
•Column definitions for many string data types can include attributes that specify the character set or collation of the column. These attributes apply to the CHAR, VARCHAR, the TEXT types, ENUM, and SET data types:
•The CHARACTER SET attribute specifies the character set, and the COLLATE attribute specifies a collation for the character set. For example: 
CREATE TABLE t
•(
•c1 VARCHAR(20) CHARACTER SET utf8,
•c2 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs
•);
•This table definition creates a column named c1 that has a character set of utf8 with the default collation for that character set, and a column named c2 that has a character set of latin1 and a case-sensitive collation. 
The rules for assigning the character set and collation when either or both of the CHARACTER SET and COLLATE attributes are missing are described in Section 9.1.3.4, “Column Character Set and Collation”. 
CHARSET is a synonym for CHARACTER SET.
•Specifying the CHARACTER SET binary attribute for a character data type causes the column to be created as the corresponding binary data type: CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB. For the ENUM and SET data types, this does not occur; they are created as declared. Suppose that you specify a table using this definition: 
CREATE TABLE
•(
•c1 VARCHAR(10) CHARACTER SET binary,
•c2 TEXT CHARACTER SET binary,
•c3 ENUM('a','b','c') CHARACTER SET binary
•);
• 
The resulting table has this definition: 
CREATE TABLE t
•(
•c1 VARBINARY(10),
•c2 BLOB,
•c3 ENUM('a','b','c') CHARACTER SET binary
•);
•
•The ASCII attribute is shorthand for CHARACTER SET latin1.
•The UNICODE attribute is shorthand for CHARACTER SET ucs2.
•The BINARY attribute is shorthand for specifying the binary collation of the column character set. In this case, sorting and comparison are based on numeric character values. (Before MySQL 4.1, BINARY caused a column to store binary strings and sorting and comparison were based on numeric byte values. This is the same as using character values for single-byte character sets, but not for multi-byte character sets.)

•Character column sorting and comparison are based on the character set assigned to the column. (Before MySQL 4.1, sorting and comparison were based on the collation of the server character set.) For the CHAR, VARCHAR, TEXT, ENUM, and SET data types, you can declare a column with a binary collation or the BINARY attribute to cause sorting and comparison to use the underlying character code values rather than a lexical ordering.
Section 9.1, “Character Set Support”, provides additional information about use of character sets in MySQL.

•[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] 
A fixed-length string that is always right-padded with spaces to the specified length when stored. M represents the column length in characters. The range of M is 0 to 255. If M is omitted, the length is 1. 
Note
Trailing spaces are removed when CHAR values are retrieved. 

Before MySQL 5.0.3, a CHAR column with a length specification greater than 255 is converted to the smallest TEXT type that can hold values of the given length. For example, CHAR(500) is converted to TEXT, and CHAR(200000) is converted to MEDIUMTEXT. However, this conversion causes the column to become a variable-length column, and also affects trailing-space removal. 
In MySQL 5.0.3 and later, a CHAR length greater than 255 is illegal and fails with an error: 
mysql> CREATE TABLE c1 (col1 INT, col2 CHAR(500));
•ERROR 1074 (42000): Column length too big for column 'col' (max = 255);
•use BLOB or TEXT instead
•CHAR is shorthand for CHARACTER. NATIONAL CHAR (or its equivalent short form, NCHAR) is the standard SQL way to define that a CHAR column should use some predefined character set. MySQL 4.1 and up uses utf8 as this predefined character set. Section 9.1.3.6, “National Character Set”. 
The CHAR BYTE data type is an alias for the BINARY data type. This is a compatibility feature. 
MySQL permits you to create a column of type CHAR(0). This is useful primarily when you have to be compliant with old applications that depend on the existence of a column but that do not actually use its value. CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string).

•[NATIONAL] VARCHAR(M) [CHARACTER SET charset_name] [COLLATE collation_name] 
A variable-length string. M represents the maximum column length in characters. In MySQL 5.0, the range of M is 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in MySQL 5.0.3 and later. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. For example, utf8 characters can require up to three bytes per character, so a VARCHAR column that uses the utf8 character set can be declared to be a maximum of 21,844 characters. See Section E.7.4, “Table Column-Count and Row-Size Limits”. 
MySQL stores VARCHAR values as a one-byte or two-byte length prefix plus data. The length prefix indicates the number of bytes in the value. A VARCHAR column uses one length byte if values require no more than 255 bytes, two length bytes if values may require more than 255 bytes. 


Note:
Before 5.0.3, trailing spaces were removed when VARCHAR values were stored, which differs from the standard SQL specification. 

Prior to MySQL 5.0.3, a VARCHAR column with a length specification greater than 255 is converted to the smallest TEXT type that can hold values of the given length. For example, VARCHAR(500) is converted to TEXT, and VARCHAR(200000) is converted to MEDIUMTEXT. However, this conversion affects trailing-space removal. 
VARCHAR is shorthand for CHARACTER VARYING. NATIONAL VARCHAR is the standard SQL way to define that a VARCHAR column should use some predefined character set. MySQL 4.1 and up uses utf8 as this predefined character set. Section 9.1.3.6, “National Character Set”. NVARCHAR is shorthand for NATIONAL VARCHAR.

•BINARY(M) 
The BINARY type is similar to the CHAR type, but stores binary byte strings rather than nonbinary character strings. M represents the column length in bytes.
•VARBINARY(M) 
The VARBINARY type is similar to the VARCHAR type, but stores binary byte strings rather than nonbinary character strings. M represents the maximum column length in bytes.
•TINYBLOB 
A BLOB column with a maximum length of 255 (28 – 1) bytes. Each TINYBLOB value is stored using a one-byte length prefix that indicates the number of bytes in the value.
•TINYTEXT [CHARACTER SET charset_name] [COLLATE collation_name] 
A TEXT column with a maximum length of 255 (28 – 1) characters. The effective maximum length is less if the value contains multi-byte characters. Each TINYTEXT value is stored using a one-byte length prefix that indicates the number of bytes in the value.

•BLOB[(M)] 
A BLOB column with a maximum length of 65,535 (216 – 1) bytes. Each BLOB value is stored using a two-byte length prefix that indicates the number of bytes in the value. 
An optional length M can be given for this type. If this is done, MySQL creates the column as the smallest BLOB type large enough to hold values M bytes long.

•TEXT[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] 
A TEXT column with a maximum length of 65,535 (216 – 1) characters. The effective maximum length is less if the value contains multi-byte characters. Each TEXT value is stored using a two-byte length prefix that indicates the number of bytes in the value. 
An optional length M can be given for this type. If this is done, MySQL creates the column as the smallest TEXT type large enough to hold values M characters long.
•MEDIUMBLOB 
A BLOB column with a maximum length of 16,777,215 (224 – 1) bytes. Each MEDIUMBLOB value is stored using a three-byte length prefix that indicates the number of bytes in the value.
•MEDIUMTEXT [CHARACTER SET charset_name] [COLLATE collation_name] 
A TEXT column with a maximum length of 16,777,215 (224 – 1) characters. The effective maximum length is less if the value contains multi-byte characters. Each MEDIUMTEXT value is stored using a three-byte length prefix that indicates the number of bytes in the value.

•LONGBLOB 
A BLOB column with a maximum length of 4,294,967,295 or 4GB (232 – 1) bytes. The effective maximum length of LONGBLOB columns depends on the configured maximum packet size in the client/server protocol and available memory. Each LONGBLOB value is stored using a four-byte length prefix that indicates the number of bytes in the value.

•LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name] 
A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 – 1) characters. The effective maximum length is less if the value contains multi-byte characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in the client/server protocol and available memory. Each LONGTEXT value is stored using a four-byte length prefix that indicates the number of bytes in the value.

•ENUM('value1','value2',...) [CHARACTER SET charset_name] [COLLATE collation_name] 
An enumeration. A string object that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special '' error value. An ENUM column can have a maximum of 65,535 distinct values. ENUM values are represented internally as integers.

•SET('value1','value2',...) [CHARACTER SET charset_name] [COLLATE collation_name] 
A set. A string object that can have zero or more values, each of which must be chosen from the list of values 'value1', 'value2', ... A SET column can have a maximum of 64 members. SET values are represented internally as integers.

Friday, August 12, 2011

MySQL Basics: DATE TIME Data Types

MySQL supports a number of data types in several categories, my next few posts will cover the different types of data used in MySQL.

MySQL Data Types Overview:

Numeric - (reviewed in earlier post)
Date and Time - (reviewed in this post)
String (character) - (post pending)

Each data types will also be defined by certain characteristics:

Storage Requirements
Out of Range & Overflow

MySQL DATE TIME DATA TYPES:

DATE:

A date. The supported range is '1000-01-01' to '9999-12-31'. MySQL displays DATE values in 'YYYY-MM-DD' format, but permits assignment of values to DATE columns using either strings or numbers. 

DATETIME:

A date and time combination. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. MySQL displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format, but permits assignment of values to DATETIME columns using either strings or numbers. 

TIMESTAMP: 

A timestamp. The range is '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. TIMESTAMP values are stored as the number of seconds since the epoch ('1970-01-01 00:00:00' UTC). A TIMESTAMP cannot represent the value '1970-01-01 00:00:00' because that is equivalent to 0 seconds from the epoch and the value 0 is reserved for representing '0000-00-00 00:00:00', the “zero” TIMESTAMP value. 
A TIMESTAMP column is useful for recording the date and time of an INSERT or UPDATE operation. By default, the first TIMESTAMP column in a table is automatically set to the date and time of the most recent operation if you do not assign it a value yourself. You can also set any TIMESTAMP column to the current date and time by assigning it a NULL value. Variations on automatic initialization and update properties are described in Section 10.3.1.1, “TIMESTAMP Properties”. 
A TIMESTAMP value is returned as a string in the format 'YYYY-MM-DD HH:MM:SS' with a display width fixed at 19 characters. To obtain the value as a number, you should add +0 to the timestamp column. 

TIME: 

A time. The range is '-838:59:59' to '838:59:59'. MySQL displays TIME values in 'HH:MM:SS' format, but permits assignment of values to TIME columns using either strings or numbers. 

YEAR[(2|4)]:

A year in two-digit or four-digit format. The default is four-digit format. In four-digit format, the permissible values are 1901 to 2155, and 0000. In two-digit format, the permissible values are 70 to 69, representing years from 1970 to 2069. MySQL displays YEAR values in YYYY format, but permits assignment of values to YEAR columns using either strings or numbers.

More detailed information on MySQL DATE & TIME data types.

Wednesday, August 10, 2011

MySQL Basics: NUMERIC Data Types

MySQL supports a number of data types in several categories, my next few posts will cover the different types of data used in MySQL.

MySQL Data Types Overview:

Numeric - (reviewed in this post)
Date and Time
String (character)

Each data types will also be defined by certain characteristics:

Storage Requirements
Out of Range & Overflow

M indicates the maximum display width for integer types. For floating-point and fixed-point types, M is the total number of digits that can be stored. For string types, M is the maximum length. The maximum permissible value of M depends on the data type.

D applies to floating-point and fixed-point types and indicates the number of digits following the decimal point. The maximum possible value is 30, but should be no greater than M–2.

Square brackets (“[” and “]”) indicate optional parts of type definitions.


If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column.

Numeric data types that permit the UNSIGNED attribute also permit SIGNED. However, these data types are signed by default, so the SIGNED attribute has no effect.

SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.

SERIAL DEFAULT VALUE in the definition of an integer column is an alias for NOT NULL AUTO_INCREMENT UNIQUE.

------------------------------

MySQL NUMERIC DATA TYPES:

BIT[(M)]:

A bit-field type. M indicates the number of bits per value, from 1 to 64. The default is 1 if M is omitted.
Before 5.0.3, BIT is a synonym for TINYINT.

TINYINT[(M)] [UNSIGNED] [ZEROFILL]:

A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

BOOL, BOOLEAN:

These types are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true. The values TRUE and FALSE are merely aliases for 1 and 0, respectively.

SMALLINT[(M)] [UNSIGNED] [ZEROFILL]:

A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.

MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]:

A medium-sized integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.

INT[(M)] [UNSIGNED] [ZEROFILL]:

A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

INTEGER[(M)] [UNSIGNED] [ZEROFILL]:

This type is a synonym for INT.

BIGINT[(M)] [UNSIGNED] [ZEROFILL]:

A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

SERIAL is an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.

Some things you should be aware of with respect to BIGINT columns*:

*All arithmetic is done using signed BIGINT or DOUBLE values, so you should not use unsigned big integers larger than 9223372036854775807 (63 bits) except with bit functions! If you do that, some of the last digits in the result may be wrong because of rounding errors when converting a BIGINT value to a DOUBLE.

FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]:

A small (single-precision) floating-point number. Permissible values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.

M is the total number of digits and D is the number of digits following the decimal point. If M and D are omitted, values are stored to the limits permitted by the hardware. A single-precision floating-point number is accurate to approximately 7 decimal places.

UNSIGNED, if specified, disallows negative values.

Using FLOAT might give you some unexpected problems because all calculations in MySQL are done with double precision.

DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]:

A normal-size (double-precision) floating-point number. Permissible values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308. These are the theoretical limits, based on the IEEE standard. The actual range might be slightly smaller depending on your hardware or operating system.

M is the total number of digits and D is the number of digits following the decimal point. If M and D are omitted, values are stored to the limits permitted by the hardware. A double-precision floating-point number is accurate to approximately 15 decimal places.

UNSIGNED, if specified, disallows negative values.

DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL], REAL[(M,D)] [UNSIGNED] [ZEROFILL]

These types are synonyms for DOUBLE. Exception: If the REAL_AS_FLOAT SQL mode is enabled, REAL is a synonym for FLOAT rather than DOUBLE.

FLOAT(p) [UNSIGNED] [ZEROFILL]:

A floating-point number. p represents the precision in bits, but MySQL uses this value only to determine whether to use FLOAT or DOUBLE for the resulting data type. If p is from 0 to 24, the data type becomes FLOAT with no M or D values. If p is from 25 to 53, the data type becomes DOUBLE with no M or D values. The range of the resulting column is the same as for the single-precision FLOAT or double-precision DOUBLE data types described earlier in this section.

FLOAT(p) syntax is provided for ODBC compatibility.

DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]

For MySQL 5.0.3 and above:

A packed “exact” fixed-point number. M is the total number of digits (the precision) and D is the number of digits after the decimal point (the scale). The decimal point and (for negative numbers) the “-” sign are not counted in M. If D is 0, values have no decimal point or fractional part. The maximum number of digits (M) for DECIMAL is 65 (64 from 5.0.3 to 5.0.5). The maximum number of supported decimals (D) is 30. If D is omitted, the default is 0. If M is omitted, the default is 10.

UNSIGNED, if specified, disallows negative values.

All basic calculations (+, -, *, /) with DECIMAL columns are done with a precision of 65 digits.

Before MySQL 5.0.3:

An unpacked fixed-point number. Behaves like a CHAR column; “unpacked” means the number is stored as a string, using one character for each digit of the value. M is the total number of digits and D is the number of digits after the decimal point. The decimal point and (for negative numbers) the “-” sign are not counted in M, although space for them is reserved. If D is 0, values have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. If D is omitted, the default is 0. If M is omitted, the default is 10.

UNSIGNED, if specified, disallows negative values.

The behavior used by the server for DECIMAL columns in a table depends on the version of MySQL used to create the table. If your server is from MySQL 5.0.3 or higher, but you have DECIMAL columns in tables that were created before 5.0.3, the old behavior still applies to those columns. To convert the tables to the newer DECIMAL format, dump them with mysqldump and reload them.

DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D])] [UNSIGNED] [ZEROFILL], FIXED[(M[,D])] [UNSIGNED] [ZEROFILL]

These types are synonyms for DECIMAL. The FIXED synonym is available for compatibility with other database systems.

For more details (yes, it can get more detailed!) visit MySQL-Numeric Data Type

Tuesday, August 9, 2011

Microsoft Exchange Basics: Creating a Distribution Group


In e-mail applications, a distribution list is a group of mail recipients that is addressed as a single recipient. Distribution lists are used to send e-mail to groups of people without having to enter each recipient's individual address. A distribution list is different from an e-mail list in that members cannot reply to the distribution list's name to send messages to everyone else in the group. In MS Exchange, Groups are also managed in conjunction with Active Directory Users.

Login/RDT into Exchange Server

Navigate to Exchange Management Console in All Programs

>>LH Nav, Under Recipient Configuration, Right-Click Distribution Group

>>Choose New Distribution Group

>>New Group    >>Next

>>Group Type  = Distribution

>>Click Browse to choose right “bucket” for Group

>>Name: GroupName

>>Name (pre-Windows 2000): GroupName

>>Alais:  GroupName 
>>Click Next    >> Click New

Stay in new group created:

>>Email created will be GroupName@yourdomain.com

>>Click on Members Tab   

>>Click “+Add” to add members to Group

>>Click Apply      >> Click Ok

Click on Group Information:

>>Check Managed By box

>> Browse for Manager Name     >>Click OK

Click Mail Flow Settings:

>>Highlight Message Delivery Restrictions    >> Properties

>>Add/Remove Senders under “Accept messages from”

>>  Uncheck “Require that all senders are authenticated”   
(to allow people to send from a server other then corp/designated server)

>>Add/Remove from “Reject messages from”

>>Click OK

Sunday, August 7, 2011

MySQL Basics - Creating User Account

I'm learning MySQL, so I'll be sharing some basic MySQL commands I'm learning. I had to start somewhere, so the basics it is.

Here's one basic thing I learned today:

Creating a Database User:

CREATE USER 'username' @ 'localhost' IDENTIFIED BY 'password';

In this case we create a user called username with a password called password on our database located on the computer (localhost).

Now we need to give the user access to our database(s):


GRANT ALL *.* TO 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL = Gives all permissions to the user we just created above (read, write, delete!!) on localhost
First * = All Databases, the user has access to all databases
Second * = All tables, the user has access to all tables

Always remember to end a command line with a semi-colon! ;

Friday, August 5, 2011

ISO 27001 Certification

Each year at my workplace we go through the paces of an  ISO 27001 certification for Data & Information Security audit.  As our software product process a LOT of data, our customers require this independent certification to have some confidence in the security and the information they place/process through our software.  That said, there is not a company on the planet can guarantee 100% data security.  What this certification shows is that a company has processes and policies in place to protect information and data.

About ISO:
ISO (International Organization for Standardization) is the world's largest developer and publisher of International Standards. ISO is a network of the national standards institutes of 162 countries, one member per country, with a Central Secretariat in Geneva, Switzerland, that coordinates the system.

ISO is a non-governmental organization that forms a bridge between the public and private sectors. On the one hand, many of its member institutes are part of the governmental structure of their countries, or are mandated by their government. On the other hand, other members have their roots uniquely in the private sector, having been set up by national partnerships of industry associations. 

The ISO 27001 are a collection of self-imposed security processes, based on best practice and ISO standards.

According to ISO Experts, IMSM:
ISO/IEC 27001: 2005
Information and Data Security
Earn high respect with low risk information security

To be competitive, profitable and trusted, information security is a must. ISO 27001 offers a comprehensive set of controls, based on best practice in information security, comprising of components such as confidentiality, integrity and availability. ISO 27001 gives both clients and suppliers the confidence to trust an organisation with the safe-keeping of their information.   

A recent survey by the Independent Oracle User Group (IOUG) found that many businesses are not doing enough to protect their data:

    * 48% of businesses admitted that they were not aware of all of their own databases that contained sensitive information
    * 75% of businesses cannot prevent special access users from tampering with databases

ISO 27001 quickly produces a return on investment, giving you thorough guidance on complying to regulatory and contractual requirements regarding data security, privacy and IT governance. This benchmark of quality demonstrates due diligence and makes it easy for you to provide stakeholders with information about your IT management policies, standards and procedures.

Take control of your assets and assure customers that their data is 100% secure.

Thursday, August 4, 2011

CT Bus Cables & Electronic Voice Services

My guess is not many people have had a need to order H 100 CT Bus Cables - (8 Drop in my case).  I, on the other hand, have had to on several occasions (lucky girl that I am).   I bring this up today because I have found a GREAT supplier for these cables.  Not only do they have a great price, but WONDERFUL service too, Electronic Voice Services (EVS).  First I have borrowed a good definition of what a CT Bus Cable is/does from Interfacebus.com then I have posted an excerpt for EVS for reference.  Do business with these people - they are great!

A Bus is an electrical pathway through which the processor communicates with the internal and external devices attached to the computer.  The CT [Computer Telephony] Bus is a Telecommunications bus [Telcom bus] which may be implemented on either a PCI or cPCI card as a sub bus. The CT bus provides a TDM [Time Division Multiplexing] scheme over PCI and CompactPCI (cPCI) bus architectures. The TDM bus carries real-time voice and fax traffic across the TDM bus that implements 4,096 bidirectional time slots (64 Kbits/sec each). The bus can support up to 2,048 full-duplex calls.

H.100 CT Bus is a mezzanine bus used with PCI. The bus works over ribbon cables between normal PCI cards connected on a PCI bus.

"The CT Bus is a bit-serial, byte oriented, synchronous, TDM transport bus operating at 8.192MHz. It consists of two clocks, two frame sync pulses, one backup network timing reference, and 32 independent bit-serial data streams. Voice/data transfer on the bus is accomplished by assigning one or more time-slot numbers and bus stream numbers to the sender and receiver(s). At the selected time-slot, the software-selected sender drives the bus and somewhere on the bus, the receiver(s) clock in the data bits.".. "The H.100 specification documents CT Bus Clocks and Synchronization; data bus lines, interface device requirements, data bus timing, clock skew, reset, power on, and other timing requirements; electrical specifications, mechanical specifications including the design and location of connectors, pin assignments, PCB layouts, and cable requirements; support for partial implementations and optional signals; and inter-operation with other buses."
A mezzanine bus would basically be a sub-bus in addition to the main PCI bus.

In short, it links up multiple telephone network cards so they can communicate with one another.

About EVS:
Electronic Voice Services, Inc. (EVS) was incorporated in January 1993 in Dallas, Texas.  Our corporate sales office is located in Addison, Texas (a suburb of Dallas), plus we have an office in Massachusetts.  We have on-staff programmers and technicians. 
We design and sell Computer Telephony, Interactive Voice Response (IVR) software, and Dialing software using “Voice Boards” made by Dialogic and PIKA Technologies as well as board-less technology.  EVS also designs and manufactures computer telephony hardware, such as our Speedy Dialer.  We’ve sold our products in every state in the USA, in over 70 countries on every continent, except Antarctica. 
EVS is a member of the Dallas Better Business Bureau, the Better Business Bureau OnLine, and the U.S. Chamber of Commerce. 
Our goals are to provide user-friendly software, high quality hardware, friendly and c

Wednesday, August 3, 2011

Miscrosoft Exchange Basics - Forwarding Email on Exchange Server

Forward Email to Another User Account on Exchange

1. Using Exchange Management Console, access the Properties dialog box for the user’s mailbox. Right-Click on User and select Properties.

2. On the Mail Flow Settings tab, select Delivery Options, and then click Properties.

3. In the Delivery Options dialog box, select the Forward To check box, and then click Browse.

4. In the Select Recipient dialog box, select the User Account, and then click OK three times. You can now use the user account to forward mail to another mailbox.

Friday, July 29, 2011

Discovering No-Cost Business Intelligence Solutions - Part I

I'm new to the Business Intelligence profession and have been looking at several different Business Intelligence (BI) solutions.  Most of the solutions cost 10's, if not 100's of thousands of dollars to implement with on-going maintenance and support costs.  While my current employee was behind my desire to look into data integration, management and analysis solution/s I had no budget to do so! This left me looking for open source or otherwise no-cost solutions.  I narrowed it down to 2 different no-cost solutions.

The first, MicroStrategy (http://www.microstrategy.com) who offers a free Reporting Software, going you limited access to some of their data reporting tools.  MicroStategy is a Microsoft based solution, but can be installed on most platforms. MicroStategy also offers a free "hands-on" Intro to BI course, "Designed for individuals without MicroStrategy experience, this free, hands-on course introduces MicroStrategy from the perspective of people who benefit from the insight enterprise BI applications provide to their daily business activities and responsibilities."  I took this class, a 1-Day intro course that was very professionally presented, and yes totally free (including lunch!). I was very impressed with the knowledge of the instructor.  He was French (I'm a sucker for a French guy!) and an engineer, not just someone that could walk you through the software.  He was able to answer all the questions of those attending the class that day who ranged from entry level users to developers and systems engineers. Impressed I was. Needless to say, after attending the class I was anxious to install the software back at the office. There, my enthusiasm waned.

Let me say again, I'm new to many thing IT, but I did have lots of help thanks to a trusted and patient colleague. I attempted to call and email for assistance but really found none.  I never did get the software configured or up and running.  As I had another cost-free solution waiting in the wings, I abandon MicroStrategy and moved on.  That said, I do plan on going back to it and trying it again in the near future.  In the several weeks that followed the MicroStategy experience, while implementing another solution, I learned a LOT that I know would help me to implement MicroStrategy.  So, MicroStrategy, I be back!!