Building Development Box for 2005

I'm planning on building a new desktop box for developing apps with VS 2005
and SQL Server 2005.
Would it make sense to have two SATA drives, say C: and D: and install SQL
Server on D?
What would you recommend would be a reasonably good configuration - RAM,
CPU, video, HDs, etc considering a budget of about $2000, NOT $5000.
Thanks.You should be able to buy something cheaper than $2000, i would think.
Not much video is necessary so pretty much anything on board would do
the job.
A gig of ram - or more.
Any old fairly fast HD would do...
Plus an external drive to back up to.
You might aklso want to think about raid so you minimise your risk of
losing anything.
Only having the one cevelopment PC is a risk if you're working at home
or in an office where you can't use someone else's PC.
I'll probably be buying a 2nd (cheap) pc for my home office.
You can then back up from one to the other and if you mess one up the
other is still ok.
Oh.
And a router firewall. These are cheap now.

building cube using AMO

hi,
i am developing an application which enables the user to create a cube on the fly. I know that i can use AMO to create a Analysis Services 2005 cube.

but my question is :

Is it possible to use AMO to create a Analysis Services 2000 cube ?

Cheers

Anil

The answer to your question is: No, you cannot use AMO to create cubes in Analysis Services 2000. There are too many differences betwee AS 2000 and AS2005. Analysis Services in version 2005 has been rebuilt almost from the groud up. The techologies and protocols used in AS2005 are new.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am in the process of converting a DSO and SQLServer 2000 process which programmatically creates data sources (now DS views), dimensions, and cubes to AMO and SQL Server 2005, and I've been struggling. Can anyone suggest a good book or documentation source which clearly describes the new AS object model and gives comprehesive, well explained AMO examples (preferably in VB)?

Thanks in advance.

|||how can we use AMO to build cubes on the fly?|||

Thanks for your help edward.

Cheers
Anil

|||

I suggest you guys start a new thread.

Just shorly:

To learn AMO it often better to take a look at number of AMO samples provided with SQL Server 2005 installation.

There is already abundance of information you can search for with people posting on how to use AMO.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Building an application on multiple data sources

ASP.NET on SQL Server

I've been asked to quote for developing a system to expose data on a
web application. Most of the data will come from SQL Server DBs
located on a single box. However, some of the data will be sourced
from ORACLE which is located on a different box. It may be necessary
to create VIEWS and Stored Procedures joining these DBs

Does anyone have any pointers, clues, hints, tips or pitfalls that I
might consider while making my proposal? What sort of extra
contingency should I allow for the connection to ORACLE? Should I do
all the data retrieval on the DB server, or should I do it on the Web
server?

Any thoughts would be appreciated.

Thanks

William BalmerWilliam wrote:

Quote:

Originally Posted by

ASP.NET on SQL Server
>
I've been asked to quote for developing a system to expose data on a
web application. Most of the data will come from SQL Server DBs
located on a single box. However, some of the data will be sourced
from ORACLE which is located on a different box. It may be necessary
to create VIEWS and Stored Procedures joining these DBs
>
Does anyone have any pointers, clues, hints, tips or pitfalls that I
might consider while making my proposal? What sort of extra
contingency should I allow for the connection to ORACLE? Should I do
all the data retrieval on the DB server, or should I do it on the Web
server?

Look into the Linked Server features of SQL server. You can link to the
Oracle db & run queries against the Oracle db thru SQL server. This may
reduce the maintenance - you'll only be writing in SQL Server syntax, or
calling SQL Server stored procedures that query the Oracle db.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)|||"Linked Server" can be one way to do this. However general network
latency and throughput restrictions due to bandwidth limitations or
network traffic, etc. can completely kill joins across the wire.

Also, be prepared to write views on the Oracle box to convert Oracle
data types to be more compatible with Sql Servers needs even using
linked servers.

Another option to consider it to "replicate" the data from the Oracle
box onto a Sql Server box, avoiding the need for joins across the wire.
This is the option I had to take to get acceptable performance for one
job I did.

William wrote:

Quote:

Originally Posted by

ASP.NET on SQL Server
>
I've been asked to quote for developing a system to expose data on a
web application. Most of the data will come from SQL Server DBs
located on a single box. However, some of the data will be sourced
from ORACLE which is located on a different box. It may be necessary
to create VIEWS and Stored Procedures joining these DBs
>
Does anyone have any pointers, clues, hints, tips or pitfalls that I
might consider while making my proposal? What sort of extra
contingency should I allow for the connection to ORACLE? Should I do
all the data retrieval on the DB server, or should I do it on the Web
server?
>
Any thoughts would be appreciated.
>
Thanks
>
William Balmer

Build Query dialog for OLEDB Source Editor

Can i extend the "Query Builder" dialog of OLEDB Source Editor for developing custom source component?

No. None of the MS component/task UI 's can be inherited or extended, you will have to write your own.