function ucountr () { document.write(Math.round(Math.random()*100000)); }

function fromwhere() {
document.write('<b>' + document.referrer + '</b>');
}

function kemail(who, fname, doma, domb, subj){ 
    if (subj) {
    document.write('<a href="javascript:kmailme(\''+who+'\', \''+fname+'\', \''+doma+'\', \''+domb+'\', \''+subj+'\')">'+who+'@'+domb+'.'+doma+'</a>');
    }
    else {
    document.writeln('<a href="javascript:kmailme(\''+who+'\', \''+fname+'\', \''+doma+'\', \''+domb+'\')">'+who+'@'+domb+'.'+doma+'</a>');
    }
}

function kmailme(who, fname, doma, domb, subj) {
var mail;
    mail='mailto:'+fname+' <'+who+'@'+domb+'.'+doma+'>'; 
    if (subj) { mail=mail+'?subject='+subj; }
    window.location=mail;
}

function openwin(theURL,winName) { //v2.0
  window.open(theURL,winName,"");
  return false;
}

function upBox(whic) {
if (whic == "vb") {
document.getElementById("txtBox").innerHTML = "<p>&nbsp;</p><p class=\"punch\">VB &amp; VB.NET</p> \
<p class=\"shiftUp\">It&rsquo;s not taught in basic DBA courses but the ability to write a program can be a real advantage and time saver for a DBA.  Over the years I've written programs in perl, VB6 and VB.NET that interact with databases in various ways.  Here&rsquo;s an example.</p> \
<p class=\"shiftUp\">A company vice president spent about two hours each month downloading and manipulating a spreadsheet.  He then passed his work on to a DBA who further formatted the data then inserted the results into a database table.  A short .NET program allowed the VP&rsquo;s assistant to complete the entire process and generate a summary report in under ten minutes</p> \
<p class=\"shiftUp\">So, what repetitive task is wasting your time?  Let me know and let&rsquo;s see what can be done to save you time and money.</p>"; }
else if (whic == "web") {
document.getElementById("txtBox").innerHTML = "<p>&nbsp;</p><p class=\"punch\">Web Sites</p> \
<p class=\"shiftUp\">HTML - CSS - javascript - perl - php - ASP<br />\
I have over 9 years experience with web pages.  On most sites at least some pages use perl, \
php or asp to interact with databases on MS SQL, Sybase or MySQL servers.</p>  \
<p class=\"shiftUp\">Many of the pages I&rsquo;ve done are on company intranets[1] but there are three sites \
listed on the Home page you can visit.</p><p>1.<span class=\"smaller\">Also one out of \
business dot com but we don&rsquo;t need to talk about that.</span></p>"; }
else if (whic == "sql") {
document.getElementById("txtBox").innerHTML = "<p>&nbsp;</p><p class=\"punch\">SQL DBA</p> \
<p class=\"shiftUp\">Production - Initial installation, secutiry concerns, index analysis, backup strategy, disaster recovery or giving your on-call DBA a break.</p> \
<p class=\"shiftUp\">Development - simple or complex selects, triggers, stored procedures, views or optimizing a slow running stored procedure.</p> \
<p class=\"shiftUp\">Whatever your SQL Server needs with 16 years of DBA experience I can help.</p> \
<table class=\"shiftUp\"><tr><th>Key Skill</th><th>Experience</th></tr> <tr><td>SQL DBA</td><td>16 years</td></tr> \
<tr><td>Performance Tuning</td><td>16 years</td></tr> <tr><td>Stored Procedures</td><td>16 years</td></tr> \
<tr><td>Triggers</td><td>16 years</td></tr> <tr><td>TSQL</td><td>16 years</td></tr> \
<tr><td>MS SQL 2000</td><td>11 years</td></tr> <tr><td>DTS</td><td>11 years</td></tr> \
<tr><td>Replication</td><td>8 years</td></tr> <tr><td>Clustering</td><td>7 years</td></tr> \
<tr><td>MS SQL 2005</td><td>5 years</td></tr> <tr><td>SSIS</td><td>4 years</td></tr></table>"; }
return false;
}

function dnBox() {
document.getElementById("txtBox").innerHTML = "<p>&nbsp;</p>\
<p><span class=\"punch\">Here to Help</span><br />Whether your need is SQL, VB, perl, php, javascript, AJAX, HTML or a combination. <b>I&rsquo;m here for you</b>.</p> \
<p><span class=\"punch\">SQL:</span> From table design to managing replication I can help. <br /> With over 16 years experience as a production and development DBA I can understand your needs and help you achieve your goals.</p> \
<p><span class=\"punch\">VB &amp; VB.net:</span> If your need is for a stand-alone program or a snippet of code as part of another process I can help.</p> \
<p><span class=\"punch\">Web Work:</span> From a minor addition to your present site to a complete site re-write I have the expertise your web site needs.<br />  \
Visit some of the sites I&rsquo;ve recently helped and see if you don&rsquo;t agree.<br /> &nbsp; &nbsp; (Links open in a new Tab or Window.)</p> \
<div style=\"margin-left:7em; padding-left:2em;\"><ul> \
<li class=\"shiftUp\"><a href=\"http://knollwoodlodge.com\" onclick=\"return openwin('http://knollwoodlodge.com');\">Knollwood Lodge</a></li>  \
<li><a href=\"http://tranquilityconcierge.com\" onclick=\"return openwin('http://www.tranquilityconcierge.com/');\">Tranquility Concierge</a></li> \
<li><a href=\"http://nega-bsa.org\" onclick=\"return openwin('http://www.nega-bsa.org/');\">Northeast Georgia Council, Boy Scouts of America</a></li> \
<ul></div>"; 
return false;
}
