Adventure Works DW databases INSTALLATION

In SQL Server April 2006 Books Online (BOL)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm

... near the bottom, the following is said ...

To deploy the Adventure Works DW analysis services project

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.

Where do I install/find the "Adventure Works DW database?" I can not find this other database anywhere?

Thanks.

AIM

During product installation make sure you install Samples.

After product is installed go to the Start->Programs->Microsoft SQL Server 2005->Documentation and Tutorials->Samples and run Setup for "Microsoft SQL Server 2005 Samples (English)"

You AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples. There you would also find relational database for it.

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

|||

Hi,

We can also install the default database in another way right from the very beginning. When we are installing the MSAS2005 After selecting the components that we want to install and click on the Advance button. Select "Entire feature will be installed on local hard drive" for the "Books Online and Samples" category.

Your AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples

Please let me know if I am wrong

Thanks

|||

I have been sending forum questions about setting up the Analysis services samples.

I finally figured this out: "Adventure Works DB" database and "AdventureWorksDW" are the same.

In the Analysis Services sample solution "Adventure Works DW," I was recieving Process errors on cubes. I right clicked the solution. I chose properties. I changed the database from Adventure Works DW (that does not exist) AdventureWorksDW. Next, I processed and did not get any errors.

This is from the latest April Samples collection. Maybe someone can tell the people at Microsoft to make this fix.

AIMDBA

sql

Adventure Works DW databases INSTALLATION

In SQL Server April 2006 Books Online (BOL)

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm

... near the bottom, the following is said ...

To deploy the Adventure Works DW analysis services project

1. Make sure that the AdventureWorksDW and Adventure Works DW databases have been installed.

Where do I install/find the "Adventure Works DW database?" I can not find this other database anywhere?

Thanks.

AIM

During product installation make sure you install Samples.

After product is installed go to the Start->Programs->Microsoft SQL Server 2005->Documentation and Tutorials->Samples and run Setup for "Microsoft SQL Server 2005 Samples (English)"

You AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples. There you would also find relational database for it.

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

|||

Hi,

We can also install the default database in another way right from the very beginning. When we are installing the MSAS2005 After selecting the components that we want to install and click on the Advance button. Select "Entire feature will be installed on local hard drive" for the "Books Online and Samples" category.

Your AdventureWorksDW Analysis Services sample project should be installed into C:\Program Files\Microsoft SQL Server\90\Tools\Samples

Please let me know if I am wrong

Thanks

|||

I have been sending forum questions about setting up the Analysis services samples.

I finally figured this out: "Adventure Works DB" database and "AdventureWorksDW" are the same.

In the Analysis Services sample solution "Adventure Works DW," I was recieving Process errors on cubes. I right clicked the solution. I chose properties. I changed the database from Adventure Works DW (that does not exist) AdventureWorksDW. Next, I processed and did not get any errors.

This is from the latest April Samples collection. Maybe someone can tell the people at Microsoft to make this fix.

AIMDBA

Advanced programming examples ?

Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_leftThe following books have some great stored procedures and complex queries:
The Guru's guide to Transact-SQL
http://vyaskn.tripod.com/gurus_guid...ransact_sql.htm
Transact-SQL Cookbook
http://vyaskn.tripod.com/transact-sql_cookbook.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
Can anyone reccomend a book or online tutorials that shows quite
advanced SQL examples.
Most the sites and books I have seen for SQL only give small examples
from the pubs database designed for a few concurrent users. This is
fine for learning but what about real systems with 50+ concurrent users
and millions of records.
I'm looking for best practices and some examples showing heavy duty
stored procedures for high volume batch updates and inserts, triggers
for audit trails, best practice for transactions, efficient crosstab
queries etc.
Can anyone reccomend a website of book for this for SQL 2000.
Thanks
hals_left|||Thanks - the gurus guide looks exactly what im after|||Another good book for how to write efficient queries is:
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
by Ken England
<cc900630@.ntu.ac.uk> wrote in message
news:1117094001.602864.285150@.f14g2000cwb.googlegroups.com...
> Can anyone reccomend a book or online tutorials that shows quite
> advanced SQL examples.
> Most the sites and books I have seen for SQL only give small examples
> from the pubs database designed for a few concurrent users. This is
> fine for learning but what about real systems with 50+ concurrent users
> and millions of records.
> I'm looking for best practices and some examples showing heavy duty
> stored procedures for high volume batch updates and inserts, triggers
> for audit trails, best practice for transactions, efficient crosstab
> queries etc.
> Can anyone reccomend a website of book for this for SQL 2000.
> Thanks
> hals_left
>

Administration Of Reporting Services

Books online talk about a report manager page to monitor and administrator running job, subscriptions etc...

But I use Reporting Servcies in sharepoint administration mode? Where do I go to see something similiar?

Thanks

Try putting the url below into an Internet Explorer address bar and click on go. It should pull up Report Manager for you.

For default SQL Server instances use this:

http://localhost/reports/Pages/Folder.aspx <-- substitute your web server name for localhost

For named SQL Server instances use this:

http://localhost/reports$InstanceName/Pages/Folder.aspx <-- substitued your web server name for localhost and your SQL Server instance name for InstanceName

|||

This do not work becuase as soon as you run in sharepoint integrated mode, you loose the report manager functionality. Actually, an error is returned if you try to navigate to that page.

Frank