Questions & Answers

  • PostgreSQL: List all databases and tables

    I'm pretty new to PostgreSQL and I've just started to learn more administration techniques (including the PSQL command line). Now, when I login with psql --username=postgres, how can I list all databases and tables? Thank you very much.

    ITKE434,585 pointsBadges:
  • How to increase sales for my business via mobile?

    Mobile is increasingly important to the life of each of us. So how can we better business via mobile?

    kanesimicart80 pointsBadges:
  • Role of QIR

    If someone is a QIR and they are going to install the certified payment application at a merchant site, but find that the merchant is running a non-compliant OS, then doesn't the QIR have to stop the install or proceed to perform the install but note that it was not installed per the applications...

    kbrown19135 pointsBadges:
  • AS/400 authority to make changes to OUTQ parameters

    What is the minimum authority one needs in order to make changes to OUTQ parameters?

    LordVoldemort5 pointsBadges:
  • SQL host variable with data structure array

    I am trying to write Printer file format using Data structure. Below is the code: Dcl-Ds abc extname('prtf':'data':*output) qualified template; End-Ds; dcl-ds test likeds(abc) dim(100); I am fetching records using fetch first for n rows statement into test DS array and every time it is giving me...

    Abhi583910 pointsBadges:
  • Should I be concerned with SQL Server in-place upgrades?

    Our team is upgrading from SQL Server 2008 to 2012 but we need to use the same hardware. But here's the thing: We're worried bout doing an in-place upgrade and we're on a time crunch. Before we continue, can anyone share any experiences with in-place upgrades?

    ITKE434,585 pointsBadges:
  • DB2 on iSeries V7R1

    Hello all, Can any one help on communicating db2 database on iSeries (V7R1) with DB2 v9.7 client on Red Hat linux ( RHEL6) ..? Thanks in advance. Regards, shankar

    umashankar2a120 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE434,585 pointsBadges:
  • SQL Server 2012 query errors

    In SQL Server 2012, I'm running several queries but not all of them are working. The first one goes through but not the second. Also, when I try to run it without the WHERE clause, everything fails. The queries are below. Thank you. create table #temp (id int primary key) create table #temp2 (id...

    ITKE434,585 pointsBadges:
  • SQL Server: Document databases

    Over the course of the past month, my department has noticed that several of our clients are not documenting their SQL Server databases and that's making us worried. First off, should we be worried? If so, then what should we do? Thanks!

    ITKE434,585 pointsBadges:
  • Moving MySQL database to another server

    We have a MySQL server that is using a InnoDB table and the size is right about 30GB or so. Now, we actually need to move to our new server. How can we go about doing this?

    ITKE434,585 pointsBadges:
  • Installing HP c7280 photosmart without disk

    I lost the installation disk, so what other way can I install this printer (HP photosmart C7280 series)?

    Tirischa5 pointsBadges:
  • RealPlayer on Audiogasm plugin

    How do I get RealPlayer on Audiogasm Plugins?

    PaulaRaul10 pointsBadges:
  • How to read Apple mail data to Outlook

    I want to convert Apple mail data to Outlook. How can I do that?

    methwgibbs20 pointsBadges:
  • Retrieve .webarchive from a Mac

    Are saved pages that are .webarchive on a Mac accessible on the drive?

    RalphLC5 pointsBadges:
  • .MAR File opening with Microsoft Access

    How can I open a MS access report shortcut file using MS Access?

    NehaSoni5 pointsBadges:
  • Which virtualization certification is better: VCP or MCSA?

    Hi Everyone, I'm Siddique. I have experience as a System Administrator working in Server 2012 R2 Hyper-V environment and certified only in Cisco and MCITP server 2008 R2. Now I'm planning to do certification in virtualization. Because I have past experience in VMware and currently working in...

    Siddique5 pointsBadges:
  • Can I use private SSL for sub domain?

    Hello, I will be pleased if someone cloud tell me, can I use private SSL for sub domain? Thank you!

    harrythomas260 pointsBadges:
  • Disable replication on MySQL database

    For the past month of so, I've been running dual master MySQL replication but now I need to move to just one database that doesn't have a replication. Is there a way to completely disable replication on each database? Thank you

    ITKE434,585 pointsBadges:
  • SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE434,585 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.

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

Following