For tips on a real-world implementation of a data warehouse, I would suggest "Data Warehousing Using the Wal-Mart Model" by Paul Westerman (Morgan Kaufmann Publishers, 2001). Although Wal-Mart used...

Another good book that is just about SQL Server Analysis Services (OLAP) is "SQL Server Developer's Guide to OLAP with Analysis Services" by Mike Gunderloy and Tim Sneath (Sybex, 2001).

...

I passed 228 using the Microsoft Press book "Self-paced Training Kit: Microsoft SQL Server 2000 System Administration" but I wouldn't recommend it. It is essentially a copy of SQL...

SQL Server Reporting Services, which is currently in beta, would be an ideal solution for your web-based reports. Assuming you are on SQL Server 2000, you would need to...

To see just the data and time of when the statistics were last updated, you can use the STATS_DATE() function. The query below will list all the indexes and...

Except for the Database Developer title, the other job titles you listed are defined here:

http://www.dbajobs.com/database_job_titles.htm

What is DB4 ? Is that a clustered DB2 system ?

...

Thanks Andy. Your article was informative and I will definately use the Transcender practice tests again because of your recommendation. Did you like the MS Press book, "MCAD/MCSD...

Members of the sysadmin and serveradmin fixed server roles can stop the services using the SHUTDOWN command from within a query. By default, members of the local Administrators group...

I think you're on the right track there. Inside your Tranform Data Task, you want to create a ActiveX Script Transformation with no source or destination columns.

Inside the Main()...

Here are some links to sites that have free forums and study guides for 70-215:

http://www.examnotes.net/forum34.html

http://boards.cramsession.com/boards/vbd.asp?b=640&pvm=False

http://www.mcsebraindumps.com

Great article but I think there needs to be a sequel, er... I mean Part Two that covers the 1990's. Especially some history on the relationship between Sybase and Microsoft...

quote:

---

You can also send mail from a Transact-SQL batch without the use of SQL Mail, by using CDO for NT Server (CDONTS)...

If you can create stored procedures in the Progress database, I think you can configure the linked server to be read-only.

There are two parameters in the sp_serveroption procedure that might...

If you want a good book covering Analysis Services, take a look at "SQL Server Developer's Guide to OLAP with Analysis Services" from Sybex (2001). The book covers a...

Chris Cubley also wrote an excellent article on this topic that includes the scripts you will need to identify and remove the duplicate records. I tested the scripts on...