DB question(s) that I have never heard a direct answer for
In designing a database for use where I work, I ran smack-dab into a few old questions I have always had relating to relational databases.  I say “old” questions because I developed them a long time prior.  However, I think the answers are entirely relevant today (obviously, otherwise I wouldn’t have run into them again). [...]

Answer Question   |  September 24, 2009  10:03 PM
Database, Database design

How to create a virtual shared disk on for a cluster setup?
How to create a virtual shared disk on for a cluster setup? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 15, 2009  9:21 PM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27, Virtual Disk

Oracle ODBC Windows Server 2003 scheduling issue
I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems like the [...]

Answer Question   |  September 14, 2009  3:45 PM
ODBC, Oracle Database, Windows Server, Windows Server 2003

PeopleSoft Index Peformance
Should a PeopleSoft table that has only 1 field in it have that field also defined as a key?

Answer Question   |  September 11, 2009  5:58 PM
Index Performance, Oracle PeopleSoft, PeopleSoft

Controlling tempdb Growth
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of [...]

Answer Question   |  September 11, 2009  2:22 PM
SQL Server, SQL Server 2005, TempDB

Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?
Do you have any idea approximately when MS & Marathon will have the capability of clustering completed? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 11, 2009  1:46 PM
Clustering, Microsoft virtualization, Microsoft Virtualization Chat 8/27

Community Update: The IT Blog Top 10 for Sept. 10, 2009
As part of a new feature on the Community Blog, each week we’ll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an [...]

Answer Question   |  September 10, 2009  3:28 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Error copying indexes in DTS package
I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a [...]

Answer Question   |  September 10, 2009  2:18 PM
DTS, Indexes

odbc error while generating crystal reports
Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?

Answer Question   |  September 10, 2009  10:28 AM
Crystal Reports, Crystal Reports 8.5, ODBC, ODBC Errors

How to connect Forms 6i with MS Access
Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah

Answer Question   |  January 2, 2011  9:56 AM
Microsoft Access, Oracle 6i, Oracle Forms, Oracle Forms 6i

What does it mean by related data in a database?
What does it mean by related data in a database?

Answer Question   |  September 9, 2009  5:22 AM
Database, Relational databases

Flat file
How to copy records from a file to flat file in RPG III

Answer Question   |  September 9, 2009  11:33 AM
Flat files, RPG, RPG Flat Files, RPG III

Advantages and disadvantages of MySQL 5.0
Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

Answer Question   |  December 7, 2010  1:05 PM
Database design, MySQL, MySQL 5.0

Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ;  qrydate.Active := false ;  qrydate.SQL.Text := ‘ select * from datum where datum < 1994/02/05′ ; qrydate.Active := true;  in she shown [...]

Answer Question   |  August 31, 2009  8:48 PM
Access 2000, Access Database, Delphi 7, Microsoft Access, SQL

MySQL 5.0 advantages and disadvantages
what is the advantage and disadvantage of mysql 5.0?

Answer Question   |  August 31, 2009  5:53 AM
MySQL, MySQL 5.0

Write Recordset to MSAccess(mdb) using VB6.0
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance.

Answer Question   |  August 28, 2009  2:51 PM
Microsoft Access, Visual Basic, Visual Basic 6

MySQL vs. Oracle
what is the major two comparison of mysql5.0 and oracle 10g?

Answer Question   |  September 1, 2009  8:36 AM
MySQL, MySQL 5.0, MySQL vs. Oracle, Oracle 10g

Migrating C code db acess from sybase to sql server 2005 – newbie
I have to change the db access from a sybase to a sql server 2005 in a c program (i have to keep the C code) I have read lots of technical articles but i’m a bit confused … with ODBC and the use of sqlcli.h i write a simple C code that access the [...]

Answer Question   |  August 25, 2009  7:49 AM
C programming, ODBC, SQL Server 2005, Sybase

Function to find greatest numeric value across different fields
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

Answer Question   |  August 25, 2009  2:52 AM
Oracle SQL, WinSQL, WINSQL Numeric Function

Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way to ”capture the SQL Server logged in user name” in the Access code?  Probably in [...]

Answer Question   |  August 27, 2009  11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security