Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!
<a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>Mr. Denny</a> <a href=”http://blogs.technet.com/b/virtualization/”>MS Hyper-V Team blog</a>
View Answer
| February 3, 2011 5:10 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
<a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>Mr. Denny</a> <a href=”http://blogs.technet.com/b/virtualization/”>MS Hyper-V Team blog</a>
View Answer
| February 3, 2011 5:10 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Earn 50 knowledge points by tweeting out our iPad contest!
Thanks so far to members who’ve already shared the news on Twitter! I’ve added points to: <ul> <li>Saturno</li><li>Shillu13</li><li>BruceWayne</li><li>Slack400</li><li>Batye</li><li>AndreaF</li> </ul> You have until February 16th to qualify for the drawing! If you post a link to someone else retweeting your tweet about the contest, I’ll throw in 50 more points! Thanks! Melanie
View Answer
| February 3, 2011 3:53 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Thanks so far to members who’ve already shared the news on Twitter! I’ve added points to: <ul> <li>Saturno</li><li>Shillu13</li><li>BruceWayne</li><li>Slack400</li><li>Batye</li><li>AndreaF</li> </ul> You have until February 16th to qualify for the drawing! If you post a link to someone else retweeting your tweet about the contest, I’ll throw in 50 more points! Thanks! Melanie
View Answer
| February 3, 2011 3:53 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
How to concat SQL Server 2005 data with line feed
Try: <pre> + char(13) + char(10) +</pre> If I remember well chr(13) = CR, and chr(10) = LF, and you should add CRLF (not LFCR). -CarlosDL ——————–
View Answer
| February 1, 2011 11:11 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
Try: <pre> + char(13) + char(10) +</pre> If I remember well chr(13) = CR, and chr(10) = LF, and you should add CRLF (not LFCR). -CarlosDL ——————–
View Answer
| February 1, 2011 11:11 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
Courses to Take for QMF beginner
I haven’t used QMF is a long time. But when I learned it, I never took any classes. One can play around a little, read the manual and the user guide, and then dig in. Same approach to learning most anything in this business. You might also check out your local user group(s). Contact other [...]
View Answer
| February 1, 2011 7:53 PM
IT career planning, QMF, Query Management Facility, Query Manager
I haven’t used QMF is a long time. But when I learned it, I never took any classes. One can play around a little, read the manual and the user guide, and then dig in. Same approach to learning most anything in this business. You might also check out your local user group(s). Contact other [...]
View Answer
| February 1, 2011 7:53 PM
IT career planning, QMF, Query Management Facility, Query Manager
COmplex update takes a 90 minutes to run in Oracle
Bulk binding is useful to speed up multiple individual statements by reducing the context switches between the PL and the SQL engines, but in this case you have a single UPDATE statement, so context switches are not a factor and thus I don’t think bulk binding will help. In fact, I guess it would be [...]
View Answer
| February 1, 2011 5:29 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query
Bulk binding is useful to speed up multiple individual statements by reducing the context switches between the PL and the SQL engines, but in this case you have a single UPDATE statement, so context switches are not a factor and thus I don’t think bulk binding will help. In fact, I guess it would be [...]
View Answer
| February 1, 2011 5:29 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query
Usual type of work available in AS/400
I would say technical (programming). There is not much maintenance.
View Answer
| February 1, 2011 3:02 PM
AS/400, AS/400 careers, IT career development, IT careers
I would say technical (programming). There is not much maintenance.
View Answer
| February 1, 2011 3:02 PM
AS/400, AS/400 careers, IT career development, IT careers
Customizable IT software for examination process and question database
It is better to contact to a renowned software development company which can help u to overcome this query. According to ur Q, it is possible to aggregate all in a one program. If the cost is no matter for u, As mentioned u r using Access, so better match is Visual Basic 6 (not [...]
View Answer
| February 1, 2011 6:40 AM
CMS, Content Management Systems, Custom software development, Database
It is better to contact to a renowned software development company which can help u to overcome this query. According to ur Q, it is possible to aggregate all in a one program. If the cost is no matter for u, As mentioned u r using Access, so better match is Visual Basic 6 (not [...]
View Answer
| February 1, 2011 6:40 AM
CMS, Content Management Systems, Custom software development, Database
Free IT Book: Computer Incident Response and Product Security
Just answered <b>OWA connection problem with Exchange 2010</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/exchange-server-8/”>here</a>. Another answer to <b>Cisco Catalyst and Juniper VLANs</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/cisco-catalyst-and-juniper-vlans/”>here</a>. A tip to the question <b>Exchange 2003 IMAP Configured for VPN Only</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/exchange-2003-imap-configured-for-vpn-only/”>here</a>. Another tip <b>OCS and AutoLogon BSOD Issues</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/ocs-and-autologon-bsod-issues/”>here</a> About <b>Mitigating cloud server risks during DDoS attacks</b> , I <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mitigating-cloud-server-risks-during-ddos-attacks/”>pointed [...]
View Answer
| January 31, 2011 10:19 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Just answered <b>OWA connection problem with Exchange 2010</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/exchange-server-8/”>here</a>. Another answer to <b>Cisco Catalyst and Juniper VLANs</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/cisco-catalyst-and-juniper-vlans/”>here</a>. A tip to the question <b>Exchange 2003 IMAP Configured for VPN Only</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/exchange-2003-imap-configured-for-vpn-only/”>here</a>. Another tip <b>OCS and AutoLogon BSOD Issues</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/ocs-and-autologon-bsod-issues/”>here</a> About <b>Mitigating cloud server risks during DDoS attacks</b> , I <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mitigating-cloud-server-risks-during-ddos-attacks/”>pointed [...]
View Answer
| January 31, 2011 10:19 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
How to get started in SAP
According to ur background, there r several opportunities to doing SAP. As u completed MCA and worked for IT deptt, it is better to go for SAP ABAP or SAP BI. For SAP BI, please link <a href=”http://itknowledgeexchange.techtarget.com/itanswers/need-assistance-to-decide-a-career-in-sap-bi/”>Here</a> And for SAP ABAP, please link <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sap-abap-from-siemens/”>Here</a> There is also IT Security course, here is <a [...]
View Answer
| January 31, 2011 6:01 AM
IT careers, SAP, SAP careers
According to ur background, there r several opportunities to doing SAP. As u completed MCA and worked for IT deptt, it is better to go for SAP ABAP or SAP BI. For SAP BI, please link <a href=”http://itknowledgeexchange.techtarget.com/itanswers/need-assistance-to-decide-a-career-in-sap-bi/”>Here</a> And for SAP ABAP, please link <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sap-abap-from-siemens/”>Here</a> There is also IT Security course, here is <a [...]
View Answer
| January 31, 2011 6:01 AM
IT careers, SAP, SAP careers
Open IT Forum: How did you get into IT?
I was working for a geophysical exploration company and moved through special projects into an R&D type role. I needed changes to to the software to enable my tests to run. Eventually the programmers got fed up with me asking for chnages so they they said “Do it yourself”. So I did and the rest [...]
View Answer
| January 29, 2011 1:41 PM
Giveaways, iPads, IT career development, IT career planning, IT careers, Knowledge Points, Open IT Forum
I was working for a geophysical exploration company and moved through special projects into an R&D type role. I needed changes to to the software to enable my tests to run. Eventually the programmers got fed up with me asking for chnages so they they said “Do it yourself”. So I did and the rest [...]
View Answer
| January 29, 2011 1:41 PM
Giveaways, iPads, IT career development, IT career planning, IT careers, Knowledge Points, Open IT Forum
Dir() Function doesn’t find .pdf files in Access 2003
This has been resolved. See discussion.
View Answer
| January 28, 2011 3:40 PM
Access 2003, Dir() function, PDF, VBA, VBA editor, Visual Basic
This has been resolved. See discussion.
View Answer
| January 28, 2011 3:40 PM
Access 2003, Dir() function, PDF, VBA, VBA editor, Visual Basic
Experience applying SP4 to SQL 2005?
The SQL Server service packs are usually applied to the server and it can easily tell what version of the softwares are running by either issuing a T-SQL command or by SQL Server Management Studio / SQL Server Enterprise Manager. Needless to say, the client tools also need to be updated to ensure the latest [...]
View Answer
| January 28, 2011 6:40 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
The SQL Server service packs are usually applied to the server and it can easily tell what version of the softwares are running by either issuing a T-SQL command or by SQL Server Management Studio / SQL Server Enterprise Manager. Needless to say, the client tools also need to be updated to ensure the latest [...]
View Answer
| January 28, 2011 6:40 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
Cumulative totals in Access 2003
Can you use a report to display this information? Reports has a Running Sum property for an object. Or use could use VB in the report to keep a running sum. If you want it in a query, you could create a function in a module. You would have your running total dimmed in the [...]
View Answer
| January 25, 2011 4:45 PM
Access 2003, Access 2003 forms, Access Database, Access query
Can you use a report to display this information? Reports has a Running Sum property for an object. Or use could use VB in the report to keep a running sum. If you want it in a query, you could create a function in a module. You would have your running total dimmed in the [...]
View Answer
| January 25, 2011 4:45 PM
Access 2003, Access 2003 forms, Access Database, Access query
Upgrading for database structure
the best way to to this upgrade, is to use an ETL like Talend ou Informatica. Talend is an open source we use it for our data migration. for more informations you can visit talend web site best regards
View Answer
| January 25, 2011 9:50 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server
the best way to to this upgrade, is to use an ETL like Talend ou Informatica. Talend is an open source we use it for our data migration. for more informations you can visit talend web site best regards
View Answer
| January 25, 2011 9:50 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server
Application Upgrade and Data migration
The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will [...]
View Answer
| January 24, 2011 9:36 PM
Database, Development, Oracle, SQL Server, Web application development
The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will [...]
View Answer
| January 24, 2011 9:36 PM
Database, Development, Oracle, SQL Server, Web application development
Just started learning java programming, how do I become a Java Programmer?
Try these respources: http://www.javacoffeebreak.com/tutorials/gettingstarted/index.html http://www.freejavaguide.com/corejava.htm http://www.javabeginner.com/ http://richardbowles.tripod.com/java/guide/menu.htm http://www.quickjavaguide.org Hope these help!
View Answer
| January 21, 2011 11:57 AM
Career development, IT careers, IT salaries, Java developers, Java programming, JavaScript
Try these respources: http://www.javacoffeebreak.com/tutorials/gettingstarted/index.html http://www.freejavaguide.com/corejava.htm http://www.javabeginner.com/ http://richardbowles.tripod.com/java/guide/menu.htm http://www.quickjavaguide.org Hope these help!
View Answer
| January 21, 2011 11:57 AM
Career development, IT careers, IT salaries, Java developers, Java programming, JavaScript
Database management advice
@MS Ashura, according to ur background, u may proceed for Database Management Courses for global certifications. There several global certifications like DBA from Oracle, MCTS from Microsoft on Sql Server 2008 / MCDBA or MySql certifications and so on. Amongst them, I prefer OCP, coz at present Oracle takes the lion share of the market. [...]
View Answer
| January 19, 2011 9:07 AM
Database management, Database Management Systems, IT careers
@MS Ashura, according to ur background, u may proceed for Database Management Courses for global certifications. There several global certifications like DBA from Oracle, MCTS from Microsoft on Sql Server 2008 / MCDBA or MySql certifications and so on. Amongst them, I prefer OCP, coz at present Oracle takes the lion share of the market. [...]
View Answer
| January 19, 2011 9:07 AM
Database management, Database Management Systems, IT careers
Excel 2007 – creating a graph from CSV data with a macro
I would record a macro of yourself doing what you said by the mouse and then view that macro. I have this from someone that finds the last row for my sheet since it varies all the time too: Sub findLastRowA() Dim lastRow As Long lastRow = Range(“A” & Rows.Count).End(xlUp).Row End Sub
View Answer
| January 18, 2011 4:01 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP
I would record a macro of yourself doing what you said by the mouse and then view that macro. I have this from someone that finds the last row for my sheet since it varies all the time too: Sub findLastRowA() Dim lastRow As Long lastRow = Range(“A” & Rows.Count).End(xlUp).Row End Sub
View Answer
| January 18, 2011 4:01 PM
CSV, Excel 2007, Excel 2007 macros, Windows XP
Converting from Access 2003 to Access 2007
Microsoft has confirmed that Access 2007 and Access 2010 share the same native file format. With SharePoint Server, it is possible to create web database and allow users to access a database in a web browser. Of course, you need Access 2010 to make changes to the database itself. I refer two links for clear [...]
View Answer
| January 17, 2011 12:25 PM
Access, Access 2003, Access 2007, Access Database
Microsoft has confirmed that Access 2007 and Access 2010 share the same native file format. With SharePoint Server, it is possible to create web database and allow users to access a database in a web browser. Of course, you need Access 2010 to make changes to the database itself. I refer two links for clear [...]
View Answer
| January 17, 2011 12:25 PM
Access, Access 2003, Access 2007, Access Database
NOC engineer career
I’m not a senior, but I do have more than twelve years in th IT field, various positions, jobs and employers. I think everyday you should learn something and in this field particularly you should be able be always learning. I think you need to be open-minded. This is a key concept. In my opinion [...]
View Answer
| January 15, 2011 4:02 PM
CCNA, CCNA Certification, IT careers, MCSE
I’m not a senior, but I do have more than twelve years in th IT field, various positions, jobs and employers. I think everyday you should learn something and in this field particularly you should be able be always learning. I think you need to be open-minded. This is a key concept. In my opinion [...]
View Answer
| January 15, 2011 4:02 PM
CCNA, CCNA Certification, IT careers, MCSE
