storage
If you don’t know much about storage, then I do not understand why you plan to build your career on it. However, start by looking for “white papers” on the web, and reading up on various storage vendors. Storage is an odd (unusual) choice by itself. There is a lot to learn, but unless it [...]
View Answer
| January 30, 2012 8:24 AM
Arrays, Backup & recovery, Commvault, Computer Associates, Disk drives, EMC, Fibre channel, HP, IBM, NAS, Optical, RAID, SAN, SCSI, Storage, Storage management, Storage products and equipment, Tape drives/Libraries, Veritas
If you don’t know much about storage, then I do not understand why you plan to build your career on it. However, start by looking for “white papers” on the web, and reading up on various storage vendors. Storage is an odd (unusual) choice by itself. There is a lot to learn, but unless it [...]
View Answer
| January 30, 2012 8:24 AM
Arrays, Backup & recovery, Commvault, Computer Associates, Disk drives, EMC, Fibre channel, HP, IBM, NAS, Optical, RAID, SAN, SCSI, Storage, Storage management, Storage products and equipment, Tape drives/Libraries, Veritas
Report from check disk on active NTFS partition
In the event log. The name on the event will be: winlogon this will be found in the system event log. === Event log is also possible to record the checkdisk execution of your computer system. However, the best thing you can do is to perform a regular checkdisk scan to avoid any future problem [...]
View Answer
| January 30, 2012 8:17 AM
DataCenter, Desktops, Disk drives, Hardware, Management, Microsoft Windows, OS, Security, Servers, Software, SQL Server, Storage, Storage products and equipment, Storage servers, Tech support
In the event log. The name on the event will be: winlogon this will be found in the system event log. === Event log is also possible to record the checkdisk execution of your computer system. However, the best thing you can do is to perform a regular checkdisk scan to avoid any future problem [...]
View Answer
| January 30, 2012 8:17 AM
DataCenter, Desktops, Disk drives, Hardware, Management, Microsoft Windows, OS, Security, Servers, Software, SQL Server, Storage, Storage products and equipment, Storage servers, Tech support
Automated Query iSQL
You can schedule tasks in Windows XP using the task scheduler and here is a link to a Microsoft technet article that shows you how to schedule recurring tasks/jobs – http://support.microsoft.com/kb/308569. All you need to do is put your iSQL commands in a DOS command shell script and schedule the script to run or schedule [...]
View Answer
| January 29, 2012 12:47 PM
Automated SQL Query, isql, SQL
You can schedule tasks in Windows XP using the task scheduler and here is a link to a Microsoft technet article that shows you how to schedule recurring tasks/jobs – http://support.microsoft.com/kb/308569. All you need to do is put your iSQL commands in a DOS command shell script and schedule the script to run or schedule [...]
View Answer
| January 29, 2012 12:47 PM
Automated SQL Query, isql, SQL
Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Some hot topics I would like to know more about are Virtual Desktop technologies (VDI), SQL Server 2012, and Cloud Computing. It would also be nice to be able to search across all TechTarget Search*.com sites at once when researching a topic. -Tech Talker
View Answer
| January 28, 2012 2:26 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Compressing Old Files
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
Hi there, I have been working with PC’s for a long time and I have been compressing files through disk cleanup with no problems at all. When I re-format a machine I also have no problems. I would recommend you do this on a regular basis to keep your machine operational and responsive. Compression does [...]
View Answer
| January 26, 2012 11:16 AM
Access, Adapters/Interfaces, Administration, Backup & recovery, Business/IT alignment, Career development, Certifications, CRM, Data analysis, Data management and storage, Data mining/analysis, Database, DataCenter, DB2, Desktop management applications, Desktops, Disk drives, E-business, Ecommerce applications, Exchange, Exchange security, Fax and print management, File, Hardware, Hardware selection and management, Management, Microsoft Windows, Monitoring, Online transaction processing, Oracle, OS, Patch management, PC/Windows Connectivity, Performance and availability, Project management, Replication, Sales force automation applications, Security, Servers, Software, Spam, SQL Server, Storage, Storage management, Storage products and equipment, Storage servers, Systems management software, Tape drives/Libraries, Tech support, Training, Web development
anti-virus
What error message is popping up? 9 times out of ten your issue is going to be security on the server. 2003 comes a lot more locked down then previous versions. Who are you logged on as? Administrator? If not you can RUNAS administrator by right clicking on the setup file and choosing RUNAS and [...]
View Answer
| January 26, 2012 3:00 AM
Antivirus, Network, Software, Windows Server 2003
What error message is popping up? 9 times out of ten your issue is going to be security on the server. 2003 comes a lot more locked down then previous versions. Who are you logged on as? Administrator? If not you can RUNAS administrator by right clicking on the setup file and choosing RUNAS and [...]
View Answer
| January 26, 2012 3:00 AM
Antivirus, Network, Software, Windows Server 2003
how to retrieve current date and time in SQL400
i got the perfect answer… <b>SELECT CURDATE() FROM SYSIBM/SYSDUMMY1 SELECT CURDATE() FROM SYSIBM.SYSDUMMY1</b> In inteactive SQL – F13 last item on page is Naming convention *SYS/*SQL *SYS support ” / ” *SQL support (dot) ” . ” <b>SELECT CURTIME() FROM SYSIBM/SYSDUMMY1 SELECT NOW() FROM SYSIBM/SYSDUMMY1 </b> – for both date and time… thanks Mr. Phil [...]
View Answer
| January 24, 2012 5:59 AM
SQL/400
i got the perfect answer… <b>SELECT CURDATE() FROM SYSIBM/SYSDUMMY1 SELECT CURDATE() FROM SYSIBM.SYSDUMMY1</b> In inteactive SQL – F13 last item on page is Naming convention *SYS/*SQL *SYS support ” / ” *SQL support (dot) ” . ” <b>SELECT CURTIME() FROM SYSIBM/SYSDUMMY1 SELECT NOW() FROM SYSIBM/SYSDUMMY1 </b> – for both date and time… thanks Mr. Phil [...]
View Answer
| January 24, 2012 5:59 AM
SQL/400
Printing from adobe 10x
When trying to print an adobe pdf file from an e-mail, a box comes up and says “adobe reader stopped working.” Windows then closes the program and no printing occurs. Thinking my previous adobe reader was corrupt or something, I uninstalled it and download a “fresh” version of 10x. Same result.
View Answer
| January 23, 2012 8:57 PM
Adobe Acrobat, HP Pavilion, Microsoft Windows Vista
When trying to print an adobe pdf file from an e-mail, a box comes up and says “adobe reader stopped working.” Windows then closes the program and no printing occurs. Thinking my previous adobe reader was corrupt or something, I uninstalled it and download a “fresh” version of 10x. Same result.
View Answer
| January 23, 2012 8:57 PM
Adobe Acrobat, HP Pavilion, Microsoft Windows Vista
how to create autonumber
using a sequence for that
View Answer
| January 23, 2012 4:29 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
using a sequence for that
View Answer
| January 23, 2012 4:29 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
Java —- 100% OO Language
This is the best way I can sum it up: OOP emphasizes making the programming language fit the constraints of the representation. Think of a bike (it is an object). It has many parts bolts, screws, chains, bars, etc. It has many functions. In Java you would program with the intent to model those functions. [...]
View Answer
| May 15, 2013 3:56 PM
Java, Object-oriented programming
This is the best way I can sum it up: OOP emphasizes making the programming language fit the constraints of the representation. Think of a bike (it is an object). It has many parts bolts, screws, chains, bars, etc. It has many functions. In Java you would program with the intent to model those functions. [...]
View Answer
| May 15, 2013 3:56 PM
Java, Object-oriented programming
How to make my VB.Net application communicate with a barcode scanner
The scanner should come with some documentation, which should help you get started. For most scanners you just need to set focus to a text field, and the scanned text will be automatically copied into that text field without any intervention from the application.
View Answer
| January 20, 2012 2:09 PM
VB.NET, VB.NET 2008
The scanner should come with some documentation, which should help you get started. For most scanners you just need to set focus to a text field, and the scanned text will be automatically copied into that text field without any intervention from the application.
View Answer
| January 20, 2012 2:09 PM
VB.NET, VB.NET 2008
Failed ODBC USER DSN connection to SQL Server 2005
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
<a href=”http://computerallofsolution.blogspot.com/”>
View Answer
| January 20, 2012 4:11 AM
SQL Server 2005, VB.NET
Why can’t I connect to SQL Server 2005 through ODBC ?
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
Your connection string should look something like this. <pre>Provider=SQLNCLI;Server=backend;Database=zkp_database;Uid=myUsername; Pwd=myPassword;</pre> Don’t bother with the SQL Alias. When you use this connection string what is the error message that you are getting?
View Answer
| January 19, 2012 10:59 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
How can do iSQl*Plus login for DBA
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
Oracle stopped supporting iSQL*Plus starting with Oracle11g. I would recommend switching to SQL Developer which can be downloaded for free from http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html. SQL Developer can do all of the same things iSQL*Plus can do, plus more. There are other third-party Oracle DBA/Developer tools available for purchase which I will not promote in this post, but [...]
View Answer
| January 17, 2012 7:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server
DateTime to DateTimeOffset
I suppose this is on SQL Server. If you expect to be able to add some offset when altering the column, then (I’m almost sure) that is not possible. The database will assign an offset of ’00:00′ because the offset is not included in the datetime type, so your data doesn’t contain an offset. You [...]
View Answer
| January 17, 2012 4:31 PM
DataType, DateTime
I suppose this is on SQL Server. If you expect to be able to add some offset when altering the column, then (I’m almost sure) that is not possible. The database will assign an offset of ’00:00′ because the offset is not included in the datetime type, so your data doesn’t contain an offset. You [...]
View Answer
| January 17, 2012 4:31 PM
DataType, DateTime
Letting users upload pictures MYSQL Database
I would recommend using the Drupal open source content management platform (www.drupal.org) as it integrtes seamlessly with MySQL and has easy to install, configure, and use image/photo upload functionality known as Modules.
View Answer
| January 17, 2012 1:08 AM
MySQL, MySQL Database, SQL
I would recommend using the Drupal open source content management platform (www.drupal.org) as it integrtes seamlessly with MySQL and has easy to install, configure, and use image/photo upload functionality known as Modules.
View Answer
| January 17, 2012 1:08 AM
MySQL, MySQL Database, SQL
SQL400 Strip non-numeric from a column
What type of format do you want it in? You might be able to use the strip, replace: SELECT REPLACE(clphone, ‘/’, ‘-’) (field, character being replaced, replace with) FROM Customers You would need to do several of these depending on the characters being changed. If there is a blank and you know the position you [...]
View Answer
| January 16, 2012 6:14 PM
AS/400, non-numeric, SQL/400, Striping
What type of format do you want it in? You might be able to use the strip, replace: SELECT REPLACE(clphone, ‘/’, ‘-’) (field, character being replaced, replace with) FROM Customers You would need to do several of these depending on the characters being changed. If there is a blank and you know the position you [...]
View Answer
| January 16, 2012 6:14 PM
AS/400, non-numeric, SQL/400, Striping
Access 2007 DB Project
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
Regression On Large Systems – How To Test
Regression testing is paramount no matter what size the system is! Start by committing resources and time towards establishing a regression testing team/strategy and execute accordingly. There is no excuse for not regression testing and quality issues will invariably occur if overlooked. A little focus will go a long way so start regression testing immediately.
View Answer
| January 15, 2012 3:58 AM
Agile, Agile adoption, Agile testing, Automation Test, Regression
Regression testing is paramount no matter what size the system is! Start by committing resources and time towards establishing a regression testing team/strategy and execute accordingly. There is no excuse for not regression testing and quality issues will invariably occur if overlooked. A little focus will go a long way so start regression testing immediately.
View Answer
| January 15, 2012 3:58 AM
Agile, Agile adoption, Agile testing, Automation Test, Regression
Exporting a (.csv) file from SQL 2005
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
