Cannot forward events from SQL Server 2005
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

Answer Question   |  November 1, 2010  4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent

JAVA! Isn’t effort saved spent elsewhere?
OK. So, JAVA is said to be platform independent since it generates Bytecode on compilation. There is a JVM for each platform which avoids the need for having a JAVA compiler for each platform. Does that not indicate that the effort saved in writing  Java compilers  for each  platform was spent in writing JVMs  for each  platform?

Answer Question   |  November 3, 2010  3:01 PM
Compilers, Java, JAVA jvm, JVM

Importing a “flat” field into a Lookup Table format in SQL database
    * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…).     * I have created a table called tblPurpose with the [...]

Answer Question   |  November 5, 2010  10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input

Forcing HTTP/HTTPS Traffic Thru a Specific Connection
Hello I have several sites connected via a MPLS network for MS Exchange and other shared resources. Currently we have an Internet connection going into one site and making HTTP/HTTPS traffic accessable to the other sites over the MPLS network. We would like to use a secondary Internet connection (Cable for example) and a firewall get the HTTP [...]

Answer Question   |  November 1, 2010  10:32 PM
Exchange, Firewalls, HTTP, HTTPS, Traffic management

How to remove specific lines from a text files using either vbs or bat.
We have a text file that is a result of an export from an application we have. We use the following bat file to rename and remove blank lines from it based on the way it exports the export options/format cannot be changed. I would like a way to add to this bat file a [...]

Answer Question   |  November 9, 2010  5:07 PM
Batch file, Batch job, SQL, Text manipulation, VBS, Visual Basic Script, Windows Server 2003 Standard Edition

Total Balance for Concatenated Unique ID in Access and Excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]

Answer Question   |  October 29, 2010  2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel

I am writing a batch file that will be run from a DVD to copy some necessary files to a location specified by the user.
I am writing a batch file that will be run from a DVD to copy some necessary files to a location specified by the user. I have used switches to get Yes or No input in the past. How do I get a drive location from the user and then verify that on the current [...]

Answer Question   |  November 1, 2010  5:29 PM
Batch, Batch files, DOS, Scripting languages, Windows 7, Windows Batch Files

SQL Server 2005 Enterprise Edition SP3 Performance
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]

Answer Question   |  January 31, 2011  3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

How do you deal with crunch time during testing?
How do you deal with crunch time during testing?

Answer Question   |  March 14, 2011  12:14 AM
Quality assurance, Software testing, Software testing methodologies, Testing

TFS Test management
Have you used TFS Test management tool or attended any seminar or training for it? Is your organization planning to move to TFS?

Answer Question   |  October 27, 2010  7:15 PM
Functional testing, Quality assurance, TFS, TFS 2010

ACCESS 2007 setting up repetitive entry form
I’m doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

Answer Question   |  November 19, 2010  6:24 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP

Write Record to table as XML from RecordSet destination
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

Answer Question   |  October 27, 2010  3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML

Open IT Forum: What services have you adopted after a trial period?
Amazon Web Services will start its one-year trial subscription on November 1st, and we’re wondering who’s going to give it a try. If not AWS, what services have you adopted by first giving them a trial run that you might otherwise have not gotten off the fence about?

Answer Question   |  November 3, 2010  3:09 PM
Amazon Web services, AWS, Open IT Forum, Trial period software

SQL SERVER 2005 Database Options
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?

Answer Question   |  October 28, 2010  3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

Java development career
i am student of doeacc society i want a job in it and i am complete my java development and i have done scjp exam how to improve my resume

Answer Question   |  March 6, 2012  2:53 PM
IT careers, Java developers, Java development, Java/J2EE

ESXi v4.1 White Box
I’m looking to put together a server to run ESXi v4.1.  I’ve selected the following hardware components and would appreciate any advice/input good/bad:  Case: Athena Power CA-SWH02BH7  Mobo: TYAN S8230GM4NR-DL  PSU: Athena Power AP-P4ATXK110FEP  CPU: AMD Opteron 6134 Magny-Cours 2.3GHz  64gig RAM: Kingston 8GB KVR1333D3E9SK2/8G x 8  2 500gig drives – RAID1: This partition will [...]

Answer Question   |  October 27, 2010  1:18 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008

Retrieving Last 7 days Details in AS/400
I’ve a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i’m subtracting 7 from today’s date (1101027 – 7), i got 1101020. If i subtract 40 means i got 1100987. Can [...]

Answer Question   |  November 1, 2010  6:30 AM
AS/400 Function Logic, AS/400 Query, MAX

Convert generic mailbox to dynamic DL in Exchange 2003
All of our ~150 remote offices use a generic mailbox in addition to the local staff mailboxes. Due to a conflict with our new single sign-on product, the site staff are unable to access the generic mailbox. So we are creating a dedicated dynamic distribution list for each office, and the generic mail will be [...]

Answer Question   |  October 27, 2010  9:32 PM
Automation, DDL, Dynamic Distribution Groups, Exchange 2003, Exchange 2003 SP2

ACCESS 2007 setting up repetitive entry form
I’m doing a database for our transportation company. I need help with setting up expenses for multiple vehicles. We want to be able to enter for reporting monthly gas, repairs, license, etc.. Want to be able to enter 50 gas receipts for one vehicle a few times a month. Reports will be monthly with a [...]

Answer Question   |  October 27, 2010  9:17 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access Database Design, Windows XP

Suggestions of training materials for CISCO 3560
I am looking for training material that will help me in configuring a CISCO 3560 switch to be used for machine controllers. What I have is multiple PLC’s on ethernet-IP. I need to be able to connect to each one and they are on different subnets. Any suggestions will be greatly appreciated.

Answer Question   |  November 17, 2010  7:57 PM
Cisco 3560, ControlLogix, Ethernet, Ethernet connection, Ethernet-IP, PLC, Rockwell Automation