Have you taken a shot at the Intel Open Port IT Scavenger Hunt?
If you’re answer is no then what are you waiting for? Get in the hunt! You could win… GRAND PRIZE WINNER: Dell Precision T7500 Tower Workstation FIRST RUNNER UP: $100 Amazon.com Gift Card SECOND RUNNER UP: $50 Amazon.com Gift Card THIRD RUNNER UP: $25 Amazon.com Gift Card IT Knowledge Exchange members receive 200 Knowledge Points [...]

Answer Question   |  June 4, 2010  2:40 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP

test management tool
I’m in the process of researching test management tools and was wondering if anyone has any insight to what worksfor them and what doesn’t. Also any information on free vs purchasing. Soem features I’m looking for are: user story documentation, test case documentation, defect capture and process, test execution, dashboard – integration w/Sharepoint, SQL backend, [...]

Answer Question   |  April 13, 2010  8:29 PM
Defect Tracking, Microsoft SharePoint, SQL Server, Test management tools

Protecting Oracle report source
Is there a way to wrap the SQL in an Orale report, or another way to protect the report source?

Answer Question   |  April 13, 2010  2:27 PM
Oracle Reports, SQL Server

Policy Management – SQL Server 2008
I have installed SQL Server 2008 Developers Edition on Laptop witrh XP. All installed ok but noted that under Management section there is no policy management. Is this a separate option during the installation or not included in the Developers 2008 edition of MS SQL Studio?

Answer Question   |  April 13, 2010  11:09 AM
Policy Management, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 performance, SQL Server 2008 Policy Management, Windows XP

16 node failover clustering in SQL Server 2008
How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

Answer Question   |  April 13, 2010  9:31 AM
Failover Clustering nodes, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 performance

Migrating DTS packages that use mainframes source to SSIS
I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

Answer Question   |  April 12, 2010  6:26 AM
AS400/DB2 source, DTS Migration, DTS package, DTS packages, SQL Server Integration Services, SSIS, SSIS 2005

Please explain SQL Ingestion with a example?
Please explain SQL Ingestion with a example?

Answer Question   |  April 12, 2010  7:21 AM
SQL Server integration/interoperability, SQL Server security

SQL server 2000 sp3 database remote access
hi i want to access a sql server 2000 sp3 database in remote system where no sql server 2000 is installed. can anyone help me for this?

Answer Question   |  May 6, 2010  6:27 PM
Remote SQL Server, SQL Server 2000 SP3, SQL Server database

External Table / SQL Loader
Hi, We are using this new sqlloader for a month nowmand it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge error KUP-04001: error opening file [...]

Answer Question   |  March 14, 2012  2:50 PM
PL/SQL, SQL Loader, SQL Server

When does SQL performance start being affected by the size?
When does SQL performance start being affected by the size?  We are running SQL 2005 64bit on Windows 2003 Enterprise 64 bit server.  The database is over 1 tb.  When does MS SQL start to degrade with database size? 

Answer Question   |  April 12, 2010  2:17 PM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 (64-bit), SQL Server 2005 Enterprise Manager

bulk update query using sql server
Hi , We need a way using sql server  for updating more than one rows at a time . Thanks , Pramod.  

Answer Question   |  April 13, 2010  8:01 AM
SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 Database

Oracle 10g versus Microsoft SQL Server 2008
Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

Answer Question   |  April 9, 2010  5:58 AM
Oracle 10g, Oracle 10g administration, Oracle versus Microsoft SQL, SQL Server, SQL Server 2008, SQL Server 2008 administration

Data archiving to additional server
We have two identical SQL Server 2005 databases. We need to archive data to another server over a network. What would be the best way to accomplish this? This is primarily required because data needs to be archived for at least five years. We don’t need the archive server for backup purposes, just for archiving [...]

Answer Question   |  April 12, 2010  6:15 PM
Data archiving, SQL Server 2005

Retrieving records from main database and logs database
Our system has one main database (jadeappdbase) but the system logs (logs per transaction/process) are stored on a separate database on a monthly basis (a specific database is created every start of the month to hold all the logs for the said month). How will I get certain records from the databases, such that the [...]

Answer Question   |  April 13, 2010  4:04 PM
SQL Server

Failed ODBC USER DSN connection to SQL Server 2005
I developed a project in VB.net with SQL Server as the backend using ODBC Data source. I converted the DB to SQL Server 2005 and tried to change the ODBC Data source connection with a SQL Server native client. The ODBC USER DSN connection is not obtaining the SQL Server 2005 database I created. How [...]

Answer Question   |  January 20, 2012  4:00 PM
SQL Server 2005, VB.NET

Conducting a performancee baseline comparison
I was reading this 2-part article on performance baselines. I would like to know how someone actually performs the comparison between the performance on the system with the baseline? How do you use SQL Server Profiler and PerfMon to do the comparison?

Answer Question   |  April 8, 2010  3:43 PM
SQL Server Performance Monitoring, SQL Server Profiler

SQL Server user name issue
We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. – aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name [...]

Answer Question   |  April 9, 2010  3:38 PM
SQL Server 2000, SQL Server database, SQL Server User Accounts

Replicating a partitioned table to a secondary server
I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is done [...]

Answer Question   |  September 16, 2010  3:31 PM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning

Retrieving data tables without backup SQL
If I truncate a table without the backup of it, how do I retrieve the table data?

Answer Question   |  April 9, 2010  3:23 PM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables

View a concise list of all Job Schedules SQL Server 2000
I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can’t be sure. The number jobs I have makes this an onerous task. Is there a way to query the database [...]

Answer Question   |  April 8, 2010  11:35 AM
SQL job scheduler, SQL Server 2000