Archive | February, 2012

How to check GoldMine SQL database size

Posted on 27 February 2012 by Jay Dymond

1. Open GoldMine.

2. Go to menu Tools->SQL Query…

3. Copy/paste the following text into the query window:

Select cast(convert(decimal, size)/(128*1024) as float) as Size_in_GB, Name

from sysfiles

4. Add up all the values in the “Size_in_gb” column to get the total database size, data file plus log file. (below example: 7.63 + 0.28 = 7.91 GB)

Database size

Database size

Note: Query returns actual physical data stored, additional allocation for growth is not reflected in results.

Comments (0)

GoldMine Login User Name

Posted on 09 February 2012 by Bob Ritter

In order to set your GoldMine desktop shortcut so that when you log into your GoldMine your "User Name" appears in the window of the log in splash screen, here is what you:

1. Log out of GoldMine and then find the GoldMine icon on your desktop* and "right click" on it and choose "properties."

2. When the GoldMine Properties dialogue window opens, up select the "Shortcut" tab.

3. In the "Target" box add put your cursor at the end of the expression that is already there and add a space and then type a forward slash / followed by the capital letter "U" and your actual GoldMine user name.  There should be NO space between the forward slash / and then a colon  followed by your GoldMine Username.  (Do NOT edit anything that is already in the target window ... you are only appending to what is there.)  When you are done it should look something like this:

"C:\Program Files\GoldMine\gmw.exe" /U:Bob

4. Log back in.  Your user name should now appear in the User window of the GoldMine splash screen!

*NOTE: This must be done at the users workstation!

 

Comments (0)

The Balanced Entrepreneur

Posted on 08 February 2012 by Bob Ritter

A little known fact about me, Bob Ritter President of First Direct Corporation, is that I attended Babson College in Mass. and I am the first of 5 students to graduate with what was a new major at that time "Entrepreneurial Studies."  Babson has a world-class reputation in business education and entrepreneurship especially.

A good friend of mine from "Babo" who also finished his undergraduate studies and majored with me was a man named Mark Simon.  Mark went on to earn a doctorate and is now a Professor of Entrepreneurship at Oakland University.  Check out Dr. Simon's new book titled The Balanced Entrepreneur that is available on Amazon.

The phrase "Balanced Entrepreneur" sounds like an oxymoron.  Which is probably why a book was needed on the subject!

Dr. Simon also has two blogs that should interest entrepreneurs.  You can find them at [link to blogs].  Recently I wrote two articles which Mark posted to his blog. Here's a link to my most recent article:

The Entrepreneur and Change: Just as a flame is fed with oxygen, change can flame the fires of success for the entrepreneur

I hope you'll visit my friend Mark's site and find something that interests you and help your business!   Tell him "Critter" sent you!

Comments (0)