Date: 05/31/06 (Web Development)    Keywords: cms, php, mysql, database, asp, sql, security, web

Hi all, a quick question.

I use PHP mostly because it's the only web language I know well enough to do what I need to do on a daily basis, but my place of employment is considering redesigning the web site - and letting me have control over how it's developed and in what languages, etc. Is there any advantage of using ASP over PHP, or any other language over another? I integrate a lot with a database (MySQL) (calendars, event listings, internship databases, video archive, etc) and currently run on a Sun box, but I also need to integrate (in the future) with a SQL database on an IIS server, which required me to develop in ASP. I didn't know ASP so we had to contract it out, and I'd rather avoid doing that again in the future - unless there's an added security benefit to asp or something like that. Opinions anyone, on what language to use vs another, or any opinions on a sort of "dream set up" (including CMS - I've never used a third party so recommendations would be interesting) I might be able to go after?

Thanks everyone!

Source: http://community.livejournal.com/webdev/325474.html

Date: 05/31/06 (PHP Development)    Keywords: php, mysql, html, sql, java, web

I've created a site hoping to archive php coded forums from the world wide web. This way an internet surfer can login and search categorized listings of forums so they can easily find what they're looking for.

Since there are thousands of php coded forums of all different content, I'd like to set up categories and list them under it.

unfortunately I know very little php. I know how to implement MODS into my forums and that's just about it.

Here's the site I'm working on. http://phpforumarchive.com/

Any suggestions or anyone willing to help? I am sure this will be a decent site when completed and people (internet surfers) will probably use it frequently. Forum owners will like it because of the free advertising they get for their site.

I know html, some javascript, no php beyond pre written MODS that show you how to instal them. MySQL? Forget it.

Tell me I'm in over my head.

Source: http://community.livejournal.com/php_dev/69050.html

Date: 05/31/06 (WebDesign)    Keywords: asp, sql, web, hosting, spam

My org's website is being redesigned, and in the near future we are going to have a backend members only area written in. Because of this, we need to switch hosts, and because our hosting company is going under. These are the items that the company doing our web design/develop listed as us needing in a host.

Basically, what you'll need is the following:
1.) ASP/ASP.net capable
2.) several e-mail accounts (with Web-based access as well, which I believe is standard)
3.) SPAM filtering (we use an application called "Postini" for a small fee per mailbox)
4.) In the near future, we may need either MS Access or SQL Server for your MO area. It's not totally necessary to have this right out of the gate. I would just make sure that one of these can be added to the server if/when it becomes necessary. It will probably cost extra.

They suggested this company: http://www.irides.com but the small disk space and transfer limits concerned me.

Does anyone have any reliable hosting suggestions that they've used for business site needs?

Source: http://community.livejournal.com/webdesign/1118308.html

Date: 05/31/06 (PHP Community)    Keywords: php, mysql, html, database, sql, microsoft

Alright guys, I'm having a bit of a problem. I'm in the process of writing this small document-tracking application for my mother's work and was writing it on my own site. It worked almost perfectly except for some functionality that I had yet to add.

But when I went to upload it to the server it was supposed to be on, I found out they were running an older version (4.4.1) than the one I had been writing for (5.1.2). So, I went in to go fix the problems (like removing Try-Catch statements), and I seem to have gotten most of them worked out, except one: for some reason the mail() function isn't actually sending any mail.

I've tried it with many different email addresses and no luck. Now, the server this is currently on (the server it will have to be run from as well) is using Microsoft Exchange which I don't really know much about. We've been looking at some of the other applications that are run on this server with working mail functionality and can't figure out why this application isn't running.

//File Name: docFunctions.php
//Author: Lisa Obenauf
//
//For use by Union Station of Kansas City (http://www.unionstation.org) only.

function generateEmail()
  {
    //MYSQL DB Connection and Table selection removed for privacy puroses//
    
    //Verify the connections to the Database and Table
    if (!$email_connect || !$db_select)
    { 
      die("Problem connecting or selecting a database."); 
    } //end if

    //initialize variables
    $sender = $_POST['docFrom'];
    $attachment = $_FILES['docAttachment']['name'];

    $headers = "From:" . $_POST['docFrom'] . "\r\n";
    $headers .= "Reply-To:" . $_POST['docFrom'] . "\r\n";
    $headers .= "Content-Type: text/html;\r\n charset=\"iso-8859-1\"\r\n";

    $body = "    
      
        
      

      
        

          File: " . $_FILES['docAttachment']['name'] . "

          Respond By:" . $_POST['docDue'] . "
        
        

          " . $_POST['docDescription'] . "
        
      
    ";
    
    //Verifies that a recipient has been selected.  If not, an error is displayed.
    if ($_POST['docTo1'] === "")
    {
      die("Please choose someone to receive the attached document.");
    } //end if
    else
    {
      //Initialization of the $query statement for INSERT
      $query = "INSERT INTO `doc_tracking` ( `doc_id` , `doc_from` , ";
      $query .= "`doc_to_1` , `doc_to_2` , `doc_to_3` , `doc_to_4` , `doc_to_5` , `doc_to_6` , `doc_to_7` , `doc_to_8` , `doc_to_9` , `doc_to_10` , ";
      $query .= "`doc_route` , `doc_distribution` , `doc_due` , `doc_action_1` , `doc_action_2` , `doc_action_3` , `doc_action_4` , `doc_action_5` , ";
      $query .= "`doc_action_6` , `doc_action_7` , `doc_action_8` , `doc_action_9` , `doc_action_10` , `doc_description` , `doc_attach` ) ";
      
      $query .= "VALUES (NULL , '" . $_POST['docFrom'] . "', '" . $_POST['docTo1'] . "', ";

      //Sets the recipient of the email
      $recipient = $_POST['docTo1'];

      //if there are more recipients, they are added to $recipient for use in mass mailing.  
      //The $query variable is also augmented with either the person's email address or NULL if no address was selected.
      if ($_POST['docTo2'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo2'] . "', ";
        $recipient .= ", " . $_POST['docTo2'];
      } //end else

      if ($_POST['docTo3'] === "")
      $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo3'] . "', ";
        $recipient .= ", " . $_POST['docTo3'];
      } //end else
    
      if ($_POST['docTo4'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo4'] . "', ";
        $recipient .= ", " . $_POST['docTo4'];
      }  //end else
    
      if ($_POST['docTo5'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo5'] . "', ";
        $recipient .= ", " . $_POST['docTo5'];
      } //end else

      if ($_POST['docTo6'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo6'] . "', ";
        $recipient .= ", " . $_POST['docTo6'];
      } //end else
    
      if ($_POST['docTo7'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo7'] . "', ";
        $recipient .= ", " . $_POST['docTo7'];
      }  //end else
    
      if ($_POST['docTo8'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo8'] . "', ";
        $recipient .= ", " . $_POST['docTo8'];
      }  //end else
    
      if ($_POST['docTo9'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo9'] . "', ";
        $recipient .= ", " . $_POST['docTo9'];
      }  //end else
    
      if ($_POST['docTo10'] === "")
        $query .= "NULL ,";
      else
      {
        $query .= "'" . $_POST['docTo10'] . "', ";
        $recipient .= ", " . $_POST['docTo10'];
      }  //end else
      
      //Initialization of the "Respond By" information
      $dueBy = $_POST['docYear'] . "-" . $_POST['docMonth'] . "-" . $_POST['docDay'];

      //Continuation and conclusion of the INSERT statement
      $query .= "'" . $_POST['docRoute'] . "', 'all' , '" . $dueBy . "', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '" . $_POST['docDescription'] . "', '" . $attachment . "');";

      //Email Information to be displayed to the user.  Contains the information sent in the email.
      echo "Document Number: " . $_POST['docID'] . "

";
      echo "From: " . $_POST['docFrom'] . "
";
      echo "To: " . $recipient . "

";
      echo "Attachment: " . $_FILES['docAttachment']['name'] . "

";
      echo "Respond By: " . $_POST['docMonth'] . "-" . $_POST['docDay'] . "-" . $_POST['docYear'] . "
";
      echo $_POST['docDescription'];

      //Inserts information into the Database
      $result = mysql_db_query("test", $query);

      //Checks to see if the email needs to be sent to each person Sequentially or all at once.  
      //If sequentially, then the e-mail is just sent to the first recipient, and will be sent to the rest of the recipients.
      //through confirmation via a different form.
      if ($_POST['docDistribution'] === "all")
        mail($recipient, "", $description, $headers);
      else
        mail($_POST['emailTo1'], "File: " . $_POST['docAttach'], $body, $headers);
     
      //verifies the successful insertion of the information into the database.
      if (!$result)
      {
        die("
Invalid Query: " . mysql_error() . "
");
      } //end if
      else
      {
        echo "
Insert successful.
";
      } //end else
    } //end else
    mysql_close();
  } //end generateEmail()

Source: http://community.livejournal.com/php/455409.html

Date: 06/02/06 (SQL Server)    Keywords: database, sql

Okay, so we finally got SQL Server 2005 installed on my machine. (Wiped and started from scratch. Took a week to get it done right. Don't ask.) First thing I have to do: a vendor is changing table structures on me, so I need to go in and change the tables. Simple enough matter. Most of the tables change fine. Two of them, however... when I hit "save," I get a warning box: "saving definition changes to tables with large amounts of data..." then it bleeds off the side of the screen, but in essence it's a warning that the table will be locked. I hit OK, and about a minute and a half later, I get a timeout expired error.

Is there any way to do this without stripping the data, copying the table structure, or anything like that? (In other words, is there any way to save definition changes to a large, heavily populated database table as is?)

Source: http://community.livejournal.com/sqlserver/49376.html

Date: 06/03/06 (C Sharp)    Keywords: sql, web

I'm getting an error on my sql INSERT statement where I’ve bolded.
I just want to update one field called subject, and it keeps giving errors during debug.
Can anyone tell me what might be wrong?

Also, without using stored procedures, is this a good safe way to do an INSERT?


protected void Button1_Click(object sender, EventArgs e)
{
string conn = string.Empty;
ConnectionStringsSection connectionStringsSection = WebConfigurationManager.GetSection("connectionStrings") as ConnectionStringsSection;
if (connectionStringsSection != null)
{
ConnectionStringSettingsCollection connectStrings = connectionStringsSection.ConnectionStrings;
ConnectionStringSettings connString = connectStrings["defaultConnectionString"];
conn = connString.ConnectionString;

using ( SqlConnection connection = new SqlConnection(conn))
using (SqlCommand command = new SqlCommand("INSERT into POST (subject) VALUES (@subject)", connection))
{
connection.Open();
command.ExecuteQuery();
connection.Close();
}
}

}

Source: http://community.livejournal.com/csharp/64748.html

Date: 06/06/06 (WebDesign)    Keywords: php, mysql, sql, web, hosting

I'm looking for a new webhost, and I've been through a bunch of the old posts here asking for host suggestions, so far though nearly all of them still only support php 4.* not php 5. Do any of you guys have any hosting solutions that offer mysql, and php 5 for relatively cheap(~10$/mo)?

Source: http://community.livejournal.com/webdesign/1121239.html

Date: 06/06/06 (PHP Community)    Keywords: mysql, database, sql

this has been driving me mad for several hours now :(

how on earth do I convert cyrillic characters into something that can be safely stored and retrieved from a mysql database?

From playing around with wordpress etc, I know I need to do this:

привет -> привет

but I have no idea what function(s) to use. Thanks :)

Source: http://community.livejournal.com/php/458161.html

Date: 06/07/06 (PHP Community)    Keywords: php, programming, mysql, sql, linux, apache

Hello Friends

I am a programmer in a Linux/Apache/MySQL/PHP shop. I also do some Windows programming in Delphi and have done lots of other stuff academically.

I'm looking for a book on PHP that will help me with "bigger picture" and "higher level" design considerations. I'm looking for a book that contains complete solutions and ideas for solving medium to large problems. Object-oriented designs are a big plus.

I'm also looking for a great reference manual.

I've been poking around looking at reviews, but I would like to have the opinions of some serious PHP programmers first.

Thank you!

Source: http://community.livejournal.com/php/458470.html

Date: 06/08/06 (PHP Community)    Keywords: php, mysql, sql

In MySQL there is a way to do this:

SELECT something FROM tablename WHERE something IN (2,3,4,5,6);

Source: http://community.livejournal.com/php/458704.html

Date: 06/09/06 (PHP Community)    Keywords: mysql, sql

I know it's an age-old question, but I just wanted your opinions on it: How should I be santizing my data before using it in my MySQL queries so as to prevent against nasties like SQL injection attacks?

At the moment I'm using the function below - is this sufficient?

Thanks in advance. :)


/*
safeVar Function
Rids variables of nasty characters


$var = safeVar ($var);

*/
function safeVar ($value) {
// stripslashes
if (get_magic_quotes_gpc ()) {
$value = stripslashes ($value);
}

// Quote if not integer
if (!is_numeric ($value)) {
$value = "'" . mysql_real_escape_string ($value) . "'";
}

return $value;
}

Source: http://community.livejournal.com/php/458935.html

Date: 06/09/06 (Asp Dot Net)    Keywords: database, asp, sql, web

My struggles continue.





Ok so I've been assigned the daunting task of setting up our documents to be sent to our new content management system from our current one which was written by a bunch of dumb brits who stole 80% of their code from Wrox. I need to bring out all the current and old documents. They are housed
in 1 database in 2 tables. All the current documents are in 1 table, and all their old versions are in the other. They use keys to communicate with each other, so every versioned document references the id of its current document. Also, not every current document has more than one version, so not every document in the current table has a corresponding record in the old table (the information in these tables is not totally consistent either, but that's a whole other issue that I'm not delving into now.)

The problem I'm having is that while my query will return all versioned records and current records WITHOUT any subsequent versions, it does NOT return the most current record of the versions. What I mean is that if there is four versions of a document, 3 of the documents are in the old table and 1 (the current version) is in the current table. My query only returns the 3 from the old table, and not the most recent one which resides on the current table.

My query looks like this. Some of the information is extraneous. The bold part is the main function I feel refers to this.

SELECT d.mdItemID AS CurrentID, d.mdFileDescription AS CurrentFile, d.mdFileName as CurrentFileName, d.mdCreatedByUser AS Creator, d.mdCreatedDate AS SubmittedDate,
tblMics_Docs_Versions.mvSubItemID AS OldID, tblMics_Docs_Versions.mvVersionedDate AS VersionedDate,
tblMics_Docs_Versions.mvFileName as OldFileName, tblMics_Docs_Versions.mvNotes AS VersionNotes,
tblDepartment.dpNAME AS DepartmentName FROM tblMics_Docs AS d INNER JOIN
tblDepartment ON d.mdDepartmentID = tblDepartment.dpID LEFT OUTER JOIN tblMics_Docs_Versions ON
d.mdItemID = tblMics_Docs_Versions.mvItemID
WHERE d.mdArchived = 0 ORDER BY mdItemID ASC, VersionedDate ASC

tblMics_Docs is the current table, tblMics_Docs_Versions is the old table.

People have suggested using temp tables or a UNION command to fix this issue, but the problem is that I got a 2.5 in SQL in college and its not my strong suit.


This is for a program that's being written in C# and binding to a datagrid (the webform version, NOT the ASP.Net version.) I figured this would be a good place to ask this question. If anyone could help me with this it would be greatly appreciated. Thanks.

Source: http://community.livejournal.com/aspdotnet/70280.html

Date: 06/12/06 (C Sharp)    Keywords: database, sql

I’m currently working with C# and SQLExpress 2005, and I’m doing some database stuff.

I have a table that has two columns, [Index] and Descriptor. It looks like:

0 Inactive
1 Active
etc.



Relevant code:

DataSet DS2 = new DataSet();

//cbostatus is a combo box containing a list of descriptors that the user can choose from

string getstat = "SELECT [Index] FROM status WHERE Descriptor = '" + cboStatus.Text + "';";

conn.Open();
SqlDataAdapter stat = new SqlDataAdapter(getstat, conn);
stat.Fill(DS2);

//The stat.Fill command should return a single value, since the sql query only returns 1 value

int status = Convert.ToInt32((DS2.Tables[0].Rows[0]));

// This is where I get an error, and the error is "InvalidCastException was unhandled Unable to cast object of type 'System.Data.DataRow' to type 'System.IConvertible'."

conn.Close();


Any ideas on how I can get this to return an int, or convert the dataset element to an int?

Thanks!

Source: http://community.livejournal.com/csharp/65023.html

Date: 06/13/06 (SQL Server)    Keywords: sql, microsoft

Does anyone know of a place to grab the single file any more? Microsoft has taken down the page for it, and the MDAC 2.8 files don't seem to want to install on XP. They say that all of the components are already available, but SQL Server does not show up in the "available drivers" when I try to create a new DSN. (My computer was wiped and redone from scratch a few weeks ago.)

In any case, I need the SQL Server ODBC driver, and Microsoft doesn't want to give it to me. Anyone have it?

Source: http://community.livejournal.com/sqlserver/49579.html

Date: 06/13/06 (C Sharp)    Keywords: asp, sql, microsoft

Hello, guys. Experts-exchange couldn't help. Microsoft support couldn't help. Though, the problem seems easy to solve, just a technicality.

When you program for ASP.NET 2.0, you can use TableAdapters in Visual Studio 2005 to connect your program with the stored procedures on the SQL Server 2005. Like, you need a function for getting a client by his id. You go to DataSet designer, and add a new TableAdapter. You choose the pre-made stored procedure in the "SELECT" field, and everything is perfect. Here's the problem: when you try to create a TableAdapter for "INSERT" or "UPDATE", it asks you to map the parameters to columns in some datatable. But even if I add a new datatable to the DataSet designer, and create columns corresponding to parameters in my stored procedure, I still can't select them when wizard asks me to map them. These colums are simply not there. How can I map something in my program to those Stored Procedure parameters through TableAdapter? Please, help.

P.S. I realize this isn't an ASP or VS.NET community, but this subject is very popular within c# circles, so hope I'm not causing any inconvenience.

Source: http://community.livejournal.com/csharp/65255.html

Date: 06/17/06 (MySQL Communtiy)    Keywords: database, sql

I am looking for work in the Atlanta area and I have been taking skills tests for the last two weeks. One of the companies that I went to had this strange(to me) concept of a super id. All their tables in all their databases had an auto incrementing id plus a superId that was unique through the database. They told me to only use the superID to deal with the data. They had some functions that would handle the superID and I just had to pass them SQL. The functions also kept track of date created and date modified for each record. Each table would look something like this:

superID | date_modified | date_created | table_id |~ fields for the table ~|

I get that its easier to use in some ways but they could not really explain the concept to me. Has anyone ever heard of this or done it?

Source: http://community.livejournal.com/mysql/97788.html

Date: 06/19/06 (WebDesign)    Keywords: php, mysql, database, sql, web

Hi
I recently asked your opinions on my site, groovescapeonline.net!
Well, I really don't think this is the place to do it, and i'll just delete the post once I get in trouble for it (if this isn't in fact the place for it)-- But would anybody here be willing to help me in creating some sort of database that users upload information to? I've looked all around the net, looked at all sorts of scripts (some worked, some didn't, and then-- ahhhh).

There's a thing on this website ( http://ddrfreak.com ) -- If you go to "machine locations", users submit locations of machines and they go up in an organized fashion. (I'm not looking for something that complicated or as complicated---) OR-- like a site like www.bemanistyle.com -- how users are able to submit "simfiles" (a zip file, i guess), which posts itself in a searchable database.

I just wanted some tips or maybe somebody's assistance on how I would create something like this. I have a MySQL database thing for my forum (phpbb)-- and I just want to make a database of some sort, that users could either submit files to a searchable extent-- OR just to submit locations (for another site of mine: http://piuzone.com . there's been a promised 'locations database' that I still haven't done because I just can't figure it out.)

Thanks, and I apologize if this is the wrong place for this, and i'll go about deleting the post if that's the case. :)

(P.S: I changed the links to pink to match the banner uptop. Good? :D )

Source: http://community.livejournal.com/webdesign/1126476.html

Date: 06/19/06 (Java Web)    Keywords: sql, web

rgod has discovered a vulnerability in Mambo & Joomla, which can be exploited to conduct SQL injection attacks. Input passed to the “Name” field when submitting a web link isn’t properly sanitised before being used in a SQL query. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code. The vulnerability has been confirmed [...]

Source: http://blog.taragana.com/index.php/archive/mambo-joomla-sql-injection-vulnerability/

Date: 06/20/06 (C Sharp)    Keywords: programming, database, sql, web

I'm writing a program in C# 1.1 that extracts documents from our current database to be then transferred into our new content manager/collaborator or whatever. Anyways I have basically written the program and it successfully extracts the documents that I tell it to, but the problem is that its a major memory hog, and when I monitor the memory and the heap size it is just staggering. The problem is that I basically have loops that are going and grabbing sometimes hundreds of documents at a time, and when the documents are over 1mb in size it almost starts to get scary. I should also point out that I've never written a program like this before and I have learned more about programming and memory management than I ever cared to know. I don't know if there's anything I'm programming wrong, or if I'm not releasing resources correctly. My "expertise" is more in Web development than this, and it doesn't help that not alot of people at my company know C#. Anyways below is the code I have for grabbing multiple documents.

{
con.Open();

SqlDataAdapter da = new SqlDataAdapter("Select * FROM tblMics_Docs_Versions WHERE mvItemID = " + number + " ORDER BY mvVersionedDate DESC", con);

int i = 0;
int j = 1;

byte[] MyData = new byte[0];

da.Fill(ds.Tables[1]);
da.Dispose();

DataRow myRow;

for (i = 0; i <= ds.Tables[1].Rows.Count - 1; i++)
{

myRow=ds.Tables[1].Rows[i];
MyData = (byte[])myRow["mvContent"];

string thefile;

string theid;

thefile = myRow["mvFileName"].ToString();

theid = myRow["mvItemID"].ToString();

int ArraySize = new int();
ArraySize = MyData.GetUpperBound(0);

string s=System.IO.Path.Combine(dept, "ID " + theid + " Version " + j + " " + thefile);
DirectoryInfo di = Directory.CreateDirectory(@"c:\BMS Old\" + dept);
FileStream fs = new FileStream(@"C:\BMS Old\"+ s, FileMode.OpenOrCreate, FileAccess.Write);
fs.Write(MyData, 0,ArraySize);

fs.Close();



myRow = null;
MyData = null;
j++;
s = null;
di = null;
thefile = null;
theid = null;

}
ds.Dispose();
ds.Tables[1].Dispose();
ds.Tables[1].Clear();

con.Close();

//con.Dispose();
//con = null;
}

I'm sure this code isn't great, but at the very least it WORKS. Now I need to clean it up so we can run this in a production environment. Thank you.

Source: http://community.livejournal.com/csharp/65808.html

Date: 06/20/06 (SQL Server)    Keywords: software, database, sql, security

Please email me directly: jason@froebe.net

these are permanent positions (sorry, no H1B visas) to be filled within a couple weeks. (Second job description is for MS SQL Server)

The group description didn't mention if job postings were allowed or not. Please let me know if they are ok or not.


Job posting #1:
===============
Sybase Database Administrator
Description
The database administrator for Sybase ensures the control and security of data and efficient use of system resources. Provides technical assistance to users. Develops methods to improve operational and production functions. Assists in the install of complex system software.

Essential Duties and Responsibilities
Sybase Replication Server – ongoing maintenance and setup for new servers as needed
As needed - SQL tuning advisory consulting and hand on trouble shooting for development team. Assists in new product development, implementation or enhancements.
Ongoing operational Sybase admin support for various applications
Sybase device and database performance and disk space allocation/ monitoring
Familiarity with DBArtsian for Sybase
Performs Disaster Recovery planning and testing.
Perform Sybase ASE 12.5.X Server installations, and version/patch upgrades
Experience, knowledge as SQL Server and/ or Oracle DBA is preferred.
On-call support as required (rotational)
Proactive attitude and passion for process improvement; scripting; issue resolution for internal and external customers
Able to take direction, switch priorities, and have tenacity to follow through on issues and see through resolution.
Reports to Team Leader on plans, projects, and problems.

Job Requirements
To perform this job successfully, an individual must be able to perform each essential duty. The requirements listed are representative of the knowledge, skill, and/or ability required
Experience with ASE performance tuning and monitoring.
Experience with Sybase ASE 12.X. and ASE 12.5.X versions and its new features

Education
Bachelor's Degree in Computer Science or equivalent. Minimum 4 years experience in data processing.


Job posting #2:
===============
SQL Server Database Administrator
Description
The database administrator for SQL Server ensures the control and security of data and efficient use of system resources. Provides technical assistance to users. Develops methods to improve operational and production functions.

Essential Duties and Responsibilities
SQL server replication – ongoing maintenance and setup for new servers as needed
As needed - SQL tuning advisory consulting and hand on trouble shooting for development team. Assists in new product development, implementation or enhancements.
Ongoing operational & development DBA support for various applications
Database performance and disk space allocation/ monitoring
Familiarity with DBArtsian, SQL Enterprise, etc.
Assists in the install of complex system software at client sites – as needed
Performs Disaster Recovery planning and testing.
Perform SQL 2000, 2005 SQL Server installations, and version/patch upgrades
Experience, knowledge as Sybase Server and/ or Oracle DBA is preferred.
Be able to travel (approx aggregated 1-3 weeks/ year)
On-call support as required (rotational)
Proactive attitude and passion for process improvement; scripting; issue resolution for internal and external customers
Able to take direction, switch priorities, and have tenacity to follow through on issues and see through resolution.
Reports to Team Leader on plans, projects, and problems.

Job Requirements
To perform this job successfully, an individual must be able to perform each essential duty. The requirements listed are representative of the knowledge, skill, and/or ability required
Experience with SQL Server performance tuning and monitoring.
Experience with SQL Server 2000, 2005 versions and its new features

Education
Bachelor's Degree in Computer Science or equivalent. Minimum 4 years experience in data processing.

Source: http://community.livejournal.com/sqlserver/49739.html