Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637
I just answered the Cisco ASA question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/asa/#viewquestion”>here</a>. Check it out! I LOVE CISCO!
View Answer
| September 20, 2011 4:46 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
I just answered the Cisco ASA question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/asa/#viewquestion”>here</a>. Check it out! I LOVE CISCO!
View Answer
| September 20, 2011 4:46 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
Separate SUM results on a single line
As mentioned in the discussion below, the subquery needs to be named.
View Answer
| September 20, 2011 1:34 PM
DB2, DB2 Views, SUM function, SUM statement
As mentioned in the discussion below, the subquery needs to be named.
View Answer
| September 20, 2011 1:34 PM
DB2, DB2 Views, SUM function, SUM statement
Free IT Book: The Python Standard Library by Example
Hi, I’ve posted an answer which you can check in the following url: http://itknowledgeexchange.techtarget.com/itanswers/power-shell-script-change-screen-resolutions/ Regards
View Answer
| September 19, 2011 10:35 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Hi, I’ve posted an answer which you can check in the following url: http://itknowledgeexchange.techtarget.com/itanswers/power-shell-script-change-screen-resolutions/ Regards
View Answer
| September 19, 2011 10:35 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: What should system documentation look like?
My documentation is written to be understood by the least knowledgable person who will be using it. If I’m writing disaster recovery procedures, they are written to be understood by the least qualified and knowledgable person in our department. This is no means a reflection on their abilities, but simply an opinion that if they [...]
View Answer
| September 15, 2011 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, System Documentation, Virtualization, VoIP, Windows Server
My documentation is written to be understood by the least knowledgable person who will be using it. If I’m writing disaster recovery procedures, they are written to be understood by the least qualified and knowledgable person in our department. This is no means a reflection on their abilities, but simply an opinion that if they [...]
View Answer
| September 15, 2011 2:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, System Documentation, Virtualization, VoIP, Windows Server
Open IT Forum: IT’s role in customer service
A timely response is always encouraged and just good customer service of course. Nothing worse than asking for help and then waiting hours or even days for a response. If you say someone will be with the customer shortly, don’t keep them waiting forever please! I don’t mind giving a level of severity. If I [...]
View Answer
| March 5, 2013 3:41 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
A timely response is always encouraged and just good customer service of course. Nothing worse than asking for help and then waiting hours or even days for a response. If you say someone will be with the customer shortly, don’t keep them waiting forever please! I don’t mind giving a level of severity. If I [...]
View Answer
| March 5, 2013 3:41 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: How do you prepare your data center for severe weather?
The main problem in our area are ice storms, freezing rain, severe thunderstorms and tornados. Most of these result in power outages which is dealt with by UPS and backup generators. Now our company has experienced growth over the past decade to the point where we are now beginning to implement 2 co-locations for our [...]
View Answer
| September 13, 2011 2:57 PM
AS/400, Business Intelligence, CIO, CRM, Data Center management, Database, DataCenter, Development, Disaster Recovery, Disaster Recovery Plan, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The main problem in our area are ice storms, freezing rain, severe thunderstorms and tornados. Most of these result in power outages which is dealt with by UPS and backup generators. Now our company has experienced growth over the past decade to the point where we are now beginning to implement 2 co-locations for our [...]
View Answer
| September 13, 2011 2:57 PM
AS/400, Business Intelligence, CIO, CRM, Data Center management, Database, DataCenter, Development, Disaster Recovery, Disaster Recovery Plan, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: Essential Skills for the Agile Developer
A series of stories.
View Answer
| September 9, 2011 12:37 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
A series of stories.
View Answer
| September 9, 2011 12:37 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Exporting all files from Windows XP to Windows 7
I’d recommend the “Windows Easy Transfer” Wizard found under Start > Programs > Accessories > System Tools. It’ll package everything up to a network location, then you run the wizard on the new machine give it the network share and it’ll download everything. I’ve used it several times and it works quite well.
View Answer
| August 25, 2011 3:37 PM
File transfers, Windows 7, Windows 7 deployment, Windows XP
I’d recommend the “Windows Easy Transfer” Wizard found under Start > Programs > Accessories > System Tools. It’ll package everything up to a network location, then you run the wizard on the new machine give it the network share and it’ll download everything. I’ve used it several times and it works quite well.
View Answer
| August 25, 2011 3:37 PM
File transfers, Windows 7, Windows 7 deployment, Windows XP
Open IT Forum: Did you buy a TouchPad?
Yep, sure did. Picked up one for me and one for the wife (got the bigger one for $150 each). Waiting for the hackers to get Android onto the devices which should just be a few more days.
View Answer
| August 24, 2011 8:19 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developers, Development, Exchange, Hackers, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Tablets, TouchPad, Virtualization, VoIP, Windows Server
Yep, sure did. Picked up one for me and one for the wife (got the bigger one for $150 each). Waiting for the hackers to get Android onto the devices which should just be a few more days.
View Answer
| August 24, 2011 8:19 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Developers, Development, Exchange, Hackers, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Tablets, TouchPad, Virtualization, VoIP, Windows Server
Stop crystal prompts for parameter value
<a href=”http://www.fetal.de/crystal-reports-ohne-den-enter-parameter-values-dialog/”>this article helped</a> me (<a href=”http://www.fetal.de/en/crystal-reports-ohne-den-enter-parameter-values-dialog/”>in english</a>)
View Answer
| August 20, 2011 8:12 PM
Crystal Reports, VB 6.0, Visual Basic
<a href=”http://www.fetal.de/crystal-reports-ohne-den-enter-parameter-values-dialog/”>this article helped</a> me (<a href=”http://www.fetal.de/en/crystal-reports-ohne-den-enter-parameter-values-dialog/”>in english</a>)
View Answer
| August 20, 2011 8:12 PM
Crystal Reports, VB 6.0, Visual Basic
Free IT Book: Fedora and Red Hat Enterprise Linux
Hey All, Check out my answer for <b><a href=”http://itknowledgeexchange.techtarget.com/itanswers/server-2003-adding-mac-and-pc-to-same-domain/#viewquestion”>Windows Server 2003 adding MAC and PC to same domain</a></b>. Hope this helps! Paul NetLock Systems
View Answer
| August 16, 2011 3:39 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Hey All, Check out my answer for <b><a href=”http://itknowledgeexchange.techtarget.com/itanswers/server-2003-adding-mac-and-pc-to-same-domain/#viewquestion”>Windows Server 2003 adding MAC and PC to same domain</a></b>. Hope this helps! Paul NetLock Systems
View Answer
| August 16, 2011 3:39 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: Cisco Firewalls
Hey Guys, It looks like I shot myself in the foot. I guess I didn’t understand the directions lol. In any event, if anyone is interested, I answer the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/permmissionswindows-7-pro/”><b>Windows 7 Professional permissions</b></a> Thanks Paul NetLock Systems
View Answer
| August 15, 2011 5:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Hey Guys, It looks like I shot myself in the foot. I guess I didn’t understand the directions lol. In any event, if anyone is interested, I answer the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/permmissionswindows-7-pro/”><b>Windows 7 Professional permissions</b></a> Thanks Paul NetLock Systems
View Answer
| August 15, 2011 5:15 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: What data center fads should be avoided?
The answer is in the question. Avoid Fads. Full stop. ‘Data Centre’ = Computer Bureaux of the early 1970′s ‘Cloud Computing’ – see above. ‘Object oriented’ – refer to ‘subroutines’ ‘Thin Client’ – oh, you mean a terminal…. One of the latest fads si to conduct surveys of course…. Enough..
View Answer
| August 15, 2011 9:40 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Data center design, Data center design and infrastructure, Data Center management, Data center operations, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The answer is in the question. Avoid Fads. Full stop. ‘Data Centre’ = Computer Bureaux of the early 1970′s ‘Cloud Computing’ – see above. ‘Object oriented’ – refer to ‘subroutines’ ‘Thin Client’ – oh, you mean a terminal…. One of the latest fads si to conduct surveys of course…. Enough..
View Answer
| August 15, 2011 9:40 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Data center design, Data center design and infrastructure, Data Center management, Data center operations, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
New Page Insert to an existing report in Crystal Reports 8.5
My solution: create an extra section in the group footer per person. Then by sextion-expert: General: surpress when: if remainder(Pagenumber, 2) = 1 Paging: select new page before and new page after Good luck.
View Answer
| August 12, 2011 3:12 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports printing, PeopleSoft
My solution: create an extra section in the group footer per person. Then by sextion-expert: General: surpress when: if remainder(Pagenumber, 2) = 1 Paging: select new page before and new page after Good luck.
View Answer
| August 12, 2011 3:12 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports printing, PeopleSoft
Open IT Forum: What to consider when building a data center?
Planning ahead is key. Servers are getting smaller and smaller so you’ll need more and more power and cooling available per rack the longer the data center will be up and running. One company I worked at didn’t plan well and could only use 3/4 of each rack in the data center because there wasn’t [...]
View Answer
| August 3, 2011 6:17 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Planning ahead is key. Servers are getting smaller and smaller so you’ll need more and more power and cooling available per rack the longer the data center will be up and running. One company I worked at didn’t plan well and could only use 3/4 of each rack in the data center because there wasn’t [...]
View Answer
| August 3, 2011 6:17 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
V6R1 restore Opt 21 to replacement box
IBM gives you I think 70 days before the keys have to be entered for that serial number. Other third party software may give you a temp, or test box key for the duplicate or Disaster Recovery system. Never hurts to ask.
View Answer
| July 28, 2011 4:09 PM
DB2, SQL development, Tape Backups, V6R1
IBM gives you I think 70 days before the keys have to be entered for that serial number. Other third party software may give you a temp, or test box key for the duplicate or Disaster Recovery system. Never hurts to ask.
View Answer
| July 28, 2011 4:09 PM
DB2, SQL development, Tape Backups, V6R1
Stored Procedure and crystal reports resources
As mentioned, probably not going to find a book that really covers both in any depth. Amazon or Bookpool or other online stores should have lots to choose from. For CR, I like Crystal Reports 2008 by George Peck. For stored procedures, there are probably books dedicated to that, but I’ve gotten by with a [...]
View Answer
| July 28, 2011 3:03 PM
Crystal Reports, Crystal Reports Stored Procedures, IT Books, Stored Procedures
As mentioned, probably not going to find a book that really covers both in any depth. Amazon or Bookpool or other online stores should have lots to choose from. For CR, I like Crystal Reports 2008 by George Peck. For stored procedures, there are probably books dedicated to that, but I’ve gotten by with a [...]
View Answer
| July 28, 2011 3:03 PM
Crystal Reports, Crystal Reports Stored Procedures, IT Books, Stored Procedures
Windows Server 2008 freezing when scanning SAS drives
This may sound adequate but this seems a good solution. Fresh re-installation of your server 2008 on a different HDD especially not being able to boot safe mode and last config…This may help you identified and eliminate your problem between software and hardware counterfeit..
View Answer
| July 13, 2011 10:34 PM
Safe Mode, SAS, SAS disks, Windows Server 2008, Windows Server 2008 error messages
This may sound adequate but this seems a good solution. Fresh re-installation of your server 2008 on a different HDD especially not being able to boot safe mode and last config…This may help you identified and eliminate your problem between software and hardware counterfeit..
View Answer
| July 13, 2011 10:34 PM
Safe Mode, SAS, SAS disks, Windows Server 2008, Windows Server 2008 error messages
Free IT Book: Building Applications in the Cloud
Answered question: http://itknowledgeexchange.techtarget.com/itanswers/entourage-blank-attachment/#viewquestion Already following and Tweeted the Deets: EricFeliciano1
View Answer
| July 12, 2011 12:04 AM
AS/400, Business Intelligence, Channel, CIO, Cloud storage, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Answered question: http://itknowledgeexchange.techtarget.com/itanswers/entourage-blank-attachment/#viewquestion Already following and Tweeted the Deets: EricFeliciano1
View Answer
| July 12, 2011 12:04 AM
AS/400, Business Intelligence, Channel, CIO, Cloud storage, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Exception Join in Crystal Reports
SELECT * FROM FILEA A WHERE NOT EXISTS (SELECT * from FILEB B where A.FIELDX = B.FIELDX)
View Answer
| July 11, 2011 2:29 PM
Crystal Reports, Crystal Reports 11, Crystal Reports XI, DB2 on AS400
SELECT * FROM FILEA A WHERE NOT EXISTS (SELECT * from FILEB B where A.FIELDX = B.FIELDX)
View Answer
| July 11, 2011 2:29 PM
Crystal Reports, Crystal Reports 11, Crystal Reports XI, DB2 on AS400
