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
Visual Basic and SQL database design
As others have suggested, the table needs to be broken up and normalized. In a salary application, I venture to state that about 70% to 80% of data is static month to month. Consequently your monthly replication of 27000 of rows (with 37 columns) is a not good design. You really need to take a [...]
View Answer
| September 13, 2011 7:18 PM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
As others have suggested, the table needs to be broken up and normalized. In a salary application, I venture to state that about 70% to 80% of data is static month to month. Consequently your monthly replication of 27000 of rows (with 37 columns) is a not good design. You really need to take a [...]
View Answer
| September 13, 2011 7:18 PM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
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
SQL Server Help
Dynamic SQL is the only way that you’ll be able to do this. The code you have looks fine to me. [kccrosser] There are a couple of key things to do to speed this up – a LOT. 1. eliminate those “select top 1 …” queries. Those are causing a table scan and sort, where [...]
View Answer
| September 10, 2011 1:03 AM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
Dynamic SQL is the only way that you’ll be able to do this. The code you have looks fine to me. [kccrosser] There are a couple of key things to do to speed this up – a LOT. 1. eliminate those “select top 1 …” queries. Those are causing a table scan and sort, where [...]
View Answer
| September 10, 2011 1:03 AM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
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
Access 2007 database errors when using Access 2010
check out http://msmvps.com/blogs/access/archive/2008/04/23/the-expression-on-click-you-entered.aspx and see if that helps.
View Answer
| September 9, 2011 12:39 AM
Access 2007, Access 2010, Access Database
check out http://msmvps.com/blogs/access/archive/2008/04/23/the-expression-on-click-you-entered.aspx and see if that helps.
View Answer
| September 9, 2011 12:39 AM
Access 2007, Access 2010, Access Database
MS Access 2007 Date Query Question
you may need to play with the format a bit but under the criteria for query of that field give this a shot and adjust as need: >DateAdd(“m”,-52,[Enter date. I.E. June 2011]) My test field was defined as ‘Date/Time’ with a format of ‘Medium Date’
View Answer
| September 3, 2011 2:39 AM
Access Database, Access Database Format, Access query
you may need to play with the format a bit but under the criteria for query of that field give this a shot and adjust as need: >DateAdd(“m”,-52,[Enter date. I.E. June 2011]) My test field was defined as ‘Date/Time’ with a format of ‘Medium Date’
View Answer
| September 3, 2011 2:39 AM
Access Database, Access Database Format, Access query
select parent where more than one child
Queries like this can get tricky depending on your table design. If your table looks like this: <pre>CREATE TABLE MyTable (ParentId INT, ParentSequence INT, /*A number which is unique per parent*/ Value INT)</pre> You can do something like this <pre>SELECT * FROM ParentTable WHERE EXISTS (SELECT * FROM MyTable WHERE MyTable.ParentId = ParentTable.ParentId AND ParentSequence [...]
View Answer
| September 2, 2011 4:18 AM
SELECT statement, SQL, SQL queries
Queries like this can get tricky depending on your table design. If your table looks like this: <pre>CREATE TABLE MyTable (ParentId INT, ParentSequence INT, /*A number which is unique per parent*/ Value INT)</pre> You can do something like this <pre>SELECT * FROM ParentTable WHERE EXISTS (SELECT * FROM MyTable WHERE MyTable.ParentId = ParentTable.ParentId AND ParentSequence [...]
View Answer
| September 2, 2011 4:18 AM
SELECT statement, SQL, SQL queries
sql query
The question is not clear enough, and much more details are needed. What database ? What do you mean by “doesn’t respond” ? What tool are you running the query on ? Are you running the query from an application ? if so, what programming language ? Can you post your code ? and what [...]
View Answer
| September 2, 2011 3:58 AM
SQL queries, SQL Query
The question is not clear enough, and much more details are needed. What database ? What do you mean by “doesn’t respond” ? What tool are you running the query on ? Are you running the query from an application ? if so, what programming language ? Can you post your code ? and what [...]
View Answer
| September 2, 2011 3:58 AM
SQL queries, SQL Query
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
SQL Injection in my network
Fixing SQL Injection requires that you verify all values which your web application is sending to your database. Fixing the data requires that you go through all the data removing the changes that an attacker puts into the data. I talk about this in my book “<a href=”http://securingsqlserver.com/”>Securing SQL Server</a>”.
View Answer
| August 16, 2011 7:58 PM
SQL injection, SQL Injection Validation, SQL Security, SQL Server security
Fixing SQL Injection requires that you verify all values which your web application is sending to your database. Fixing the data requires that you go through all the data removing the changes that an attacker puts into the data. I talk about this in my book “<a href=”http://securingsqlserver.com/”>Securing SQL Server</a>”.
View Answer
| August 16, 2011 7:58 PM
SQL injection, SQL Injection Validation, SQL Security, SQL Server security
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
Access 2007 creating a menu
Answer by Randym: Click the Office button at the top left and select Access Options on the bottom. Go to Current Database and uncheck Display Navigation Pane.
View Answer
| August 12, 2011 7:07 PM
Access 2007, Access 2007 forms, Access 2007 functions
Answer by Randym: Click the Office button at the top left and select Access Options on the bottom. Go to Current Database and uncheck Display Navigation Pane.
View Answer
| August 12, 2011 7:07 PM
Access 2007, Access 2007 forms, Access 2007 functions
Link SQL Server 2008 to AS400
Can you elaborate on the issues from V5R4? What issue? Any idea on causes?
View Answer
| August 10, 2011 2:35 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
Can you elaborate on the issues from V5R4? What issue? Any idea on causes?
View Answer
| August 10, 2011 2:35 PM
AS/400 SQL, ODBC, SQL 2008, SQL Server 2008
Connecting to SQL Database
Hello NewnanIT, To be able to help you, you need to provide some detail about your issue. Can you please tell us why you can’t access you database or SQL Server Management Studio? Is this a login related problem? Bad user name or password? You can’t log on locally to that server? Please post back [...]
View Answer
| August 9, 2011 10:42 PM
Database management, SQL 2005, SQL 2005 Database, SQL Database, Windows Server 2008
Hello NewnanIT, To be able to help you, you need to provide some detail about your issue. Can you please tell us why you can’t access you database or SQL Server Management Studio? Is this a login related problem? Bad user name or password? You can’t log on locally to that server? Please post back [...]
View Answer
| August 9, 2011 10:42 PM
Database management, SQL 2005, SQL 2005 Database, SQL Database, Windows Server 2008
Display date in Oracle Toad
Why not to use the Months_Between function: Firstly you should visit <a href=”http://www.sql-performance-tuning.com/oracle-sql-functions/”>this</a> website, where you will find complete list of Oracle sql functions and <a href=”http://www.sql-performance-tuning.com/oracle-date-format/”>this</a> website where you will find complete list of Oracle date format elements. This should also help you for your future work. <b>SQL function MONTHS_BETWEEN</b> The MONTHS_BETWEEN function calculates [...]
View Answer
| August 9, 2011 7:11 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler
Why not to use the Months_Between function: Firstly you should visit <a href=”http://www.sql-performance-tuning.com/oracle-sql-functions/”>this</a> website, where you will find complete list of Oracle sql functions and <a href=”http://www.sql-performance-tuning.com/oracle-date-format/”>this</a> website where you will find complete list of Oracle date format elements. This should also help you for your future work. <b>SQL function MONTHS_BETWEEN</b> The MONTHS_BETWEEN function calculates [...]
View Answer
| August 9, 2011 7:11 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler
Open / Convert MS-Access x64 file into MS-Access x32
Just open the Access database. The Database file shouldn’t care if the application which is using it is x86 or x64.
View Answer
| August 3, 2011 6:19 PM
32- versus 64-bit Windows OSes, 64-bit (x64), Access, Database software
Just open the Access database. The Database file shouldn’t care if the application which is using it is x86 or x64.
View Answer
| August 3, 2011 6:19 PM
32- versus 64-bit Windows OSes, 64-bit (x64), Access, Database software
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
