Data Mirror Resource

Are there any good resources for data mirror in SQL 2005 SP1?

I tried to search on microsoft.com, there is an article, but it is outdated, it only described data mirror in SQL 2005 RTM.

appreciate any links or input.

Owen

What do you want to know?

There's:

Functionality:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Best Practice:

http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/DBM_Best_Pract.doc

Alerts:

http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx

Couple of webcasts:

Kimberly's

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032290565&EventCategory=5&culture=en-US&CountryCode=US

Mine:

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032290576&EventCategory=5&culture=en-US&CountryCode=US

A FAQ:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx

Thanks,

Mark

data mining and SS05

I've seen a couple of article on creating and scoring some mining models -- very cool stuff. Is the only way I can do this from an OLAP cube? Can I create, train, and score a model just from relational data?

Thanks!

You can create models directly from cubes using the wizard. Scoring models can be done using an MDX input to a prediction join statement e.g.

SELECT Predict(MyColumn) FROM MyModel
PREDICTION JOIN
<MDX Statement>
ON <bindings>

|||

The data mining functionality in SQL Server 2005 Analysis Services is not restricted to source data in OLAP cubes - you can create, train and query (score) mining models based directly on data in any relational data source. You can find more information, including tutorials at http://www.sqlserverdatamining.com.