tuning
One thing you could try would be to create the indexes after you insert the records. This will speed up the inserts. Depending on the number of records in the tables and the number of indexes on the tables, the index creation process will probably take longer.
View Answer
| August 31, 2005 5:24 PM
Billing and customer care, Billing Support Systems, Data analysis, Database, DB2, Oracle
One thing you could try would be to create the indexes after you insert the records. This will speed up the inserts. Depending on the number of records in the tables and the number of indexes on the tables, the index creation process will probably take longer.
View Answer
| August 31, 2005 5:24 PM
Billing and customer care, Billing Support Systems, Data analysis, Database, DB2, Oracle
Help
In what context? When googled you get over 1.2 million hits.
View Answer
| August 30, 2005 4:09 PM
AS/400, Avaya, Business Objects, Call Centers, Career development, Certifications, Cognos, Crystal Reports, Data analysis, Data Junction, Data mining/analysis, Database, DataCenter, Hyperion, IBM, Informatica, Information Builders, Microsoft Windows, NCR, Oracle, PeopleSoft, Sales force automation applications, Salesforce.com, SalesLogix, SAP, Siebel, Training
In what context? When googled you get over 1.2 million hits.
View Answer
| August 30, 2005 4:09 PM
AS/400, Avaya, Business Objects, Call Centers, Career development, Certifications, Cognos, Crystal Reports, Data analysis, Data Junction, Data mining/analysis, Database, DataCenter, Hyperion, IBM, Informatica, Information Builders, Microsoft Windows, NCR, Oracle, PeopleSoft, Sales force automation applications, Salesforce.com, SalesLogix, SAP, Siebel, Training
bios upgrade
Generally, you need to go to the web site of the board manufacturer. AMI sells BIOSes to many manufacturers, who each may require slight modifications- meaning that no one upgrade will work for all boards. Sometimes I’ve found it helpful to go over the board with a good light and a magnifying glass to find [...]
View Answer
| August 30, 2005 10:50 AM
Data analysis, Database
Generally, you need to go to the web site of the board manufacturer. AMI sells BIOSes to many manufacturers, who each may require slight modifications- meaning that no one upgrade will work for all boards. Sometimes I’ve found it helpful to go over the board with a good light and a magnifying glass to find [...]
View Answer
| August 30, 2005 10:50 AM
Data analysis, Database
MS Access – AS400 file transfer
You failed to state which method you want to use to accomplish this, Maually Get external data. Via a Macro or via visual basic.
View Answer
| August 30, 2005 10:37 AM
Database, DB2, Oracle
You failed to state which method you want to use to accomplish this, Maually Get external data. Via a Macro or via visual basic.
View Answer
| August 30, 2005 10:37 AM
Database, DB2, Oracle
The UNIX Idiot
Your DBA is right. Additionally, it be wise to invest about twenty dollars on a small Unix shells book. It will give you details of various switches to those commands: ls, mv, du, grep, more, ps, e.t.c. The kill command can be handy at times. ++ Olu
View Answer
| August 29, 2005 10:27 PM
Database, DB2, Oracle
Your DBA is right. Additionally, it be wise to invest about twenty dollars on a small Unix shells book. It will give you details of various switches to those commands: ls, mv, du, grep, more, ps, e.t.c. The kill command can be handy at times. ++ Olu
View Answer
| August 29, 2005 10:27 PM
Database, DB2, Oracle
Printer Problems since relocation and client upgrade
I am sure you have down some research on the web, but I found this site, that may help. http://faq.midrange.com/data/cache/1.html There is a printing folder, but I am not sure if it will have all that you are looking for. Take care
View Answer
| August 26, 2005 11:47 AM
AS/400, Database
I am sure you have down some research on the web, but I found this site, that may help. http://faq.midrange.com/data/cache/1.html There is a printing folder, but I am not sure if it will have all that you are looking for. Take care
View Answer
| August 26, 2005 11:47 AM
AS/400, Database
Securing FTP on an Enterprise wide basis
Perhaps I misread the question, but I think you’re talking about a couple of different things as if they were the same. You want to block all FTP access from inside your enterprise network, simply block TCP ports 20 and 21 outbound on your Internet-facing firewall. As always, your default policy on Internet firewalls should [...]
View Answer
| August 25, 2005 9:45 AM
Application security, Database, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Secure Coding, Security, TCP, VPN, Wireless
Perhaps I misread the question, but I think you’re talking about a couple of different things as if they were the same. You want to block all FTP access from inside your enterprise network, simply block TCP ports 20 and 21 outbound on your Internet-facing firewall. As always, your default policy on Internet firewalls should [...]
View Answer
| August 25, 2005 9:45 AM
Application security, Database, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Secure Coding, Security, TCP, VPN, Wireless
IT Security
Your question is too general for specific answers. Are we referring to physical security, network security. How secure do you want your network to be? Keeping in mind that more security means less accessiblity and ease of use.. The weakest link in any computer/network is the user.. do you for instance, only allow a user [...]
View Answer
| August 25, 2005 6:39 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Certifications, Compliance, configuration, CRM, Current threats, Database, Desktops, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, OS, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Your question is too general for specific answers. Are we referring to physical security, network security. How secure do you want your network to be? Keeping in mind that more security means less accessiblity and ease of use.. The weakest link in any computer/network is the user.. do you for instance, only allow a user [...]
View Answer
| August 25, 2005 6:39 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Certifications, Compliance, configuration, CRM, Current threats, Database, Desktops, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, OS, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Bad logon Event type 529
Have you looked for the process in the registry (usually HKLMSoftwareMicrosoftWindowsCurrent VersionRun or HKCU…)? Any of the big AV websites should give you a description of the manual removal process. Just a question – why does this user have rights to stop services?
View Answer
| August 24, 2005 9:48 AM
Access, Access control, Application security, backdoors, Browsers, Current threats, Database, Desktops, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Patch management, Secure Coding, Security, Servers, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, VPN, Web security, Wireless, worms
Have you looked for the process in the registry (usually HKLMSoftwareMicrosoftWindowsCurrent VersionRun or HKCU…)? Any of the big AV websites should give you a description of the manual removal process. Just a question – why does this user have rights to stop services?
View Answer
| August 24, 2005 9:48 AM
Access, Access control, Application security, backdoors, Browsers, Current threats, Database, Desktops, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Patch management, Secure Coding, Security, Servers, Spyware, SQL Server, SSL/TLS, Trojans, Viruses, VPN, Web security, Wireless, worms
Implementing and configuring VPN Server
I would look into buying a SonicWall router and the necessary licenses. There configurations are very easy to set up and their hardware is very reliable and secure. Adding global VPN clients is very easy as well and the documentation on their website is what I use when setting up the VPNs for our various [...]
View Answer
| August 22, 2005 12:59 AM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
I would look into buying a SonicWall router and the necessary licenses. There configurations are very easy to set up and their hardware is very reliable and secure. Adding global VPN clients is very easy as well and the documentation on their website is what I use when setting up the VPNs for our various [...]
View Answer
| August 22, 2005 12:59 AM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Installing Seperate Internet Connection for Managers
Frankly, installing a separate Internet connection for managers only sounds like you’re trying to please management so that they don’t notice that you have a more serious problem. I’m not sure what you mean by “wireless server room”, but it implies that you are running much of your infrastructure over wireless. This is not good [...]
View Answer
| August 21, 2005 2:23 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Frankly, installing a separate Internet connection for managers only sounds like you’re trying to please management so that they don’t notice that you have a more serious problem. I’m not sure what you mean by “wireless server room”, but it implies that you are running much of your infrastructure over wireless. This is not good [...]
View Answer
| August 21, 2005 2:23 PM
Availability, Bandwidth, Cabling, DataCenter, Desktop management applications, Desktops, Ethernet, FDDI, Frame Relay, H.323, Hardware, IBM, Intel, Interoperability, InterSystems, IPv4, IPv6, LANDesk, Management, Microsoft Systems Management Server, Microsoft Windows, MPLS, NetBIOS, Network protocols, Networking, Online transaction processing, Oracle, OS, Performance management, Ping, Printers, Routers, Security, Servers, SIP, Software, SQL Server, Sybase, TCP, Tech support
Local Admin & passwords
This question can be boiled down to this: Is it costing you enough man-hours in support (because such and such user doesn’t have the right to so and so) to justify giving the users higher rights? For me, this almost always seems to be the case. Unless the user is only supposed to be accessing [...]
View Answer
| August 19, 2005 5:08 PM
Application security, Biometrics, Compliance, configuration, CRM, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, VPN, vulnerability management, Wireless
This question can be boiled down to this: Is it costing you enough man-hours in support (because such and such user doesn’t have the right to so and so) to justify giving the users higher rights? For me, this almost always seems to be the case. Unless the user is only supposed to be accessing [...]
View Answer
| August 19, 2005 5:08 PM
Application security, Biometrics, Compliance, configuration, CRM, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, VPN, vulnerability management, Wireless
Querying GIS Data
You can try something like this: SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection
View Answer
| August 19, 2005 1:40 PM
Data analysis, Database, DB2, Development, Oracle, Software
You can try something like this: SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection
View Answer
| August 19, 2005 1:40 PM
Data analysis, Database, DB2, Development, Oracle, Software
Extracting SAP R3 data in custom DW
The question of “best” has to do with what fits your larger process and Enterpise Integration architecture as well as with the character of your data warehouse refreshes (e.g., monthly?, nightly?, transaction by transaction?. For example, if for you Business Objects is the center of multiple feeds from diverse systems, maybe you should think about [...]
View Answer
| August 18, 2005 9:45 AM
Business Objects, Data warehousing applications, Database, DB2, Development, Microsoft Windows, Oracle, SAP, SQL, SQL Server
The question of “best” has to do with what fits your larger process and Enterpise Integration architecture as well as with the character of your data warehouse refreshes (e.g., monthly?, nightly?, transaction by transaction?. For example, if for you Business Objects is the center of multiple feeds from diverse systems, maybe you should think about [...]
View Answer
| August 18, 2005 9:45 AM
Business Objects, Data warehousing applications, Database, DB2, Development, Microsoft Windows, Oracle, SAP, SQL, SQL Server
Need guidiance from pros already into the game
Well, first off… Congratulations for serving in our Armed Forces. You’ve asked a very broad question, so I’ll give you a broad answer first, and my specifics later. The first thing I can tell you is that very few of us have followed any sort of straight line to get to our respective positions today. [...]
View Answer
| August 16, 2005 11:17 AM
Application security, backdoors, Biometrics, Business/IT alignment, Career development, Certifications, Compliance, configuration, CRM, Current threats, Data analysis, Database, Development, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Firewalls, Forensics, Hacking, Hardware, human factors, i2 Technologies, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Manufacturing applications, Mobile, Network security, Networking, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Software, Spyware, Tech support, Training, Trojans, Viruses, VPN, vulnerability management, Web services, Web Services Standards, Wireless, worms
Well, first off… Congratulations for serving in our Armed Forces. You’ve asked a very broad question, so I’ll give you a broad answer first, and my specifics later. The first thing I can tell you is that very few of us have followed any sort of straight line to get to our respective positions today. [...]
View Answer
| August 16, 2005 11:17 AM
Application security, backdoors, Biometrics, Business/IT alignment, Career development, Certifications, Compliance, configuration, CRM, Current threats, Data analysis, Database, Development, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Firewalls, Forensics, Hacking, Hardware, human factors, i2 Technologies, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Manufacturing applications, Mobile, Network security, Networking, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Software, Spyware, Tech support, Training, Trojans, Viruses, VPN, vulnerability management, Web services, Web Services Standards, Wireless, worms
Synchronization of application servers
What OS? If it’s unix, you might consider rsync
View Answer
| August 16, 2005 8:57 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
What OS? If it’s unix, you might consider rsync
View Answer
| August 16, 2005 8:57 AM
3Com, Access, Active Directory, Apache, AS/400, Availability, Avaya, Bandwidth, Benchmarking, Bind, Cabling, Cisco, Database, DataCenter, DB2, Dell, Desktops, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Exchange, Exchange security, Fault isolation, FDDI, Foundry, Frame Relay, General Directories, Hardware, Hewlett-Packard Application Server, Hubs, IPv4, IPv6, Juniper Networks, LDAP, Linux, Lotus Domino, Lucent, Management, Microsoft Office, Microsoft Windows, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NFS, Nortel, Novell NDS, Oracle, OS, Patch management, Performance management, Ping, Protocol analysis, Remote management, Routers, Security, Servers, SQL, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows, WINS
ASE Trigger
I don’t know much about ASE, but from what I know about programming for the web in general and sql, I think you need to declare that inserted is a variable, and if it isn’t, then rather than calling for all the records from inserted, you need to call the records from the table. I [...]
View Answer
| August 16, 2005 4:55 AM
Database, DB2, Oracle, SQL
I don’t know much about ASE, but from what I know about programming for the web in general and sql, I think you need to declare that inserted is a variable, and if it isn’t, then rather than calling for all the records from inserted, you need to call the records from the table. I [...]
View Answer
| August 16, 2005 4:55 AM
Database, DB2, Oracle, SQL
PowerBuilder Printing Problem
Check to be sure that all your PC’s have the same fonts installed and that they all have the same driver version for the printer.
View Answer
| August 11, 2005 8:18 AM
Database Management Systems, Development, Hardware, Interoperability, Microsoft Windows, Networking, PC/Windows Connectivity, PowerBuilder, Software, Sybase, Tech support, Windows
Check to be sure that all your PC’s have the same fonts installed and that they all have the same driver version for the printer.
View Answer
| August 11, 2005 8:18 AM
Database Management Systems, Development, Hardware, Interoperability, Microsoft Windows, Networking, PC/Windows Connectivity, PowerBuilder, Software, Sybase, Tech support, Windows
Blocking File Transfers from MSN Messenger
MSN Messenger uses FTP to transfer files. Block port 21.
View Answer
| August 11, 2005 6:46 AM
Application security, Compliance, CRM, Database, DataCenter, Desktops, Development, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Networking services, OS, Policies, Protocol analysis, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
MSN Messenger uses FTP to transfer files. Block port 21.
View Answer
| August 11, 2005 6:46 AM
Application security, Compliance, CRM, Database, DataCenter, Desktops, Development, DHCP, Disaster Recovery, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Networking services, OS, Policies, Protocol analysis, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
OWA using SelfSSL and Certificate Services removal
Quick question to start with. Are you making OWA accessible from the Internet, or just on your internal network?
View Answer
| August 5, 2005 2:28 PM
Application security, Certificates, Compliance, configuration, CRM, Database, Desktop security, Disaster Recovery, Encryption, Exchange, Exchange 2003, Instant Messaging, Internet Security Systems, Managed security services, Outlook, Outlook Mobile Access, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, vulnerability management
Quick question to start with. Are you making OWA accessible from the Internet, or just on your internal network?
View Answer
| August 5, 2005 2:28 PM
Application security, Certificates, Compliance, configuration, CRM, Database, Desktop security, Disaster Recovery, Encryption, Exchange, Exchange 2003, Instant Messaging, Internet Security Systems, Managed security services, Outlook, Outlook Mobile Access, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security management, Security products, Security Program Management, vulnerability management
