• Source control for database items

    For our database, we really don't have a good process for versioning our schema changes. We do a ton of backups but we're worried (security reasons). We know something will just go wrong and we'll lose everything. What's the best way to approach this?

    ITKE372,225 pointsBadges:
  • Changing plain text VBA to HTML, when sending an email

    I've never used HTML, and I built some VBA to send out an Outlook email from Access... my code is as follows, and I'm wondering how hard this would be to translate over to HTML, for a novice? Function Aonq_Email() On Error GoTo Error_Message Call cmdInputBox_Click DoCmd.SetWarnings False...

    JimmyJames5 pointsBadges:
  • Should I use mysql_* functions?

    I'm pretty new to MySQL and my friend told me not to use mysql_* functions. Can anyone tell me why this is the case? Security concerns?

    ITKE372,225 pointsBadges:
  • What is a DB?

    I'd like to learn how to know when users are talking about a DB, applications, networks, application management.

    Arniches5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • INSERT or CREATE record in SQL Server database

    I have this SQL Server table structure: MyTable(KEY, datafield1, datafield2...) And now I have to update an existing record / create a new one if it doesn't appear. What's the best way to do that?

    ITKE372,225 pointsBadges:
  • Access 2003 question

    My form has an address field tied to a table. Previously I could input an address in that field and it would copy into the table. I could then perform a lookup in that form by the address and it would pull that record up. Now when I put the address in the address field, it is not copying into the...

    tempnorm5 pointsBadges:
  • How can I become a DBA?

    I'm in a 2nd year CS engineering student and want to be a DBA. How shall I proceed?

    HritikaMehta5 pointsBadges:
  • Hardware sizing for the infrastructure

    Hi, I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, network and other if related to sizing required to setup centralized for 2000 to 50000 concurrent...

    12480355 pointsBadges:
  • conversion problem

    how do you convert DCF files into CSV files for export to Excel Spreadsheet

    ironpony45 pointsBadges:
  • Declare flat file in CL programming

    How would I declare a flat file in CL programming?

    mahalakshmi4375 pointsBadges:
  • Rename a MySQL database

    Is there a way to rename a MySQL database? I know that I can just dump the database / reimport it but I can't do that with mine. It's a huge database. Also, it needs to work with InnoDB. Thanks!

    ITKE372,225 pointsBadges:
  • Check if a column exists in SQL Server database

    In a SQL Server database, is there a way to check if a column exists in a table? This is what I came up with but it keeps returning false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') Thanks!

    ITKE372,225 pointsBadges:
  • Secure database passwords in PHP

    I have a PHP application that makes a database connection but it also has a login / password. I'm using a minimum permission login for the app so the PHP just needs to know that login / password. What would be the best way to secure that password? I don't want to write in PHP code.

    ITKE372,225 pointsBadges:
  • List tables in SQLite database

    In a SQLite database, is there a way to list tables? Specifically when I attach the database file with the ATTACH command on the SQLite command line tool. Thanks so much!

    ITKE372,225 pointsBadges:
  • Which database to use with NAS?

    My company has recently shifted to NAS and we are looking for a database option to implement.

    arp122515 pointsBadges:
  • Need to split the values in few cells in all the cells in CSV

    Need to split Database-A and 40005 and need to place Database-A in Column A4 and need to replace 1414 with 40005 in Column B4.   Column A  ColumnB URL Port Application-a.com 1414 Application-b.com 1414 website-x.com 25025 website-y.com 20208 Database-A,40005 1414 Database-B,40000 1414

    ManojD0595 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • Access – Word Mail Merge email address duplication

    I have an email field in my Word document when the data comes over from Access it lists the email address but then repeats it again surrounded by # signs ex. blahblah@yahoo.com#mailto:blahblah@yahoo.com# Any tips on a switch I could use to remove the # signs and duplicate address? Thank you!

    jengrn265 pointsBadges:
  • Crystal Reports 2008 – CSV Export

    We've installed CR 2008 onto our server and now having issues with CSV Exports. Previously when using Crystal reporter 9 the CSV exports would have all items in quotations. e.g. "ABC","$100,000.00","2015-06-30" Now, when running the reports from our recently installed Crystal Reporter 2008, the...

    cbinsydney5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.