If you are looking to combine the technical with the mangerial and business side of the eq then think about BI. BI is where the new money is IMHO and...

If you want more in-depth knowledge of database systems separate from any one product, take a look at the graduate certificate program from the University of Maryland University College in...

Yes SQL Server will work for the project, so would Oracle, Sybase, and DB2. Depending on the requirements you may also use MySQL, or PostgreSQL but would run into some additional...

Could you expand more on your question? Are you asking for the prerequisites for installing 2005 on a new box or are you asking about migrating databases from sql 2000...

ETL: Extract, Transform, Load

Also thought of as get the data, clean the data, and load the data.

Create a new user that is a member of the olapadmin group and in the DTS package in the Microsoft OLE DB connection when you are in the DTS design view change...

To sum up your options:

“One is a timestamp column in the SQL table. I need...

The Mac OS is not suited to a business environment for one critical issue, it has a thread ability problem. In Lmbench 3.0 measurements of OS...

If this is an XML Bulk upload then make sure that the agent running the bulk load is a memeber of the bulkadmin fixed server role in SQL Server.

Also are...

I have to agree with a previous poster. You are much better off not using Identity as a PK (ever). It is a meaningless PK because it does not enforce...

Let us be realistic please. If you need a complex ETL tool, you are not considering SQL2005. Seriously, individuals that need a complex ETL tool...

The book I use for teaching includes indepth set theory approach to SQL and relational systems and relational algebra. THis may be too academic a book for what you are...

You should be able to execute the .bat file from DTS using the Execute Process Task object in the DTS Task area of the DTS designer window. If you tried...

I agree with Tinker. The slowest part of any database is the disk subsystem and I/O contention will kill performance. Is the contractor also recommending going with separate physical arrays...

Thanks for all your help. It definately put me on the right road.

I went with:

Declare @cmd varchar(100), @path varchar(50), @path2 varchar(50)

SET @path = (Select column from table where condition = 'condition')

SET...