Archive for April 8th, 2005

Step by Step: Program Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework April 8th, 2005

Vinod Kumar

In this exercise, you will use the .NET Compact Framework and SQL Server CE to configure merge replication, build an application user interface, subscribe to a SQL Server publication, modify and synchronize data, and resolve conflicts.

Read the 50 page MSDN article on the same.

Continue reading...


 

XML Indexing Part 1: XML IDs, XSLT Keys and IndexingXPathNavigator April 8th, 2005

Vinod Kumar

This two-part article discusses various aspects of indexing XML data. The first part examines indexing of standalone XML documents, a native XML concept of IDs, XSLT keys, and introduces the IndexingXPathNavigator class, which enables indexing for any IXPathNavigable in-memory XML store, such as XmlDocument, XpathDocument, or XmlDataDocument classes. The next part will be focused on new XML indexing features introduced in the Microsoft SQL Server 2005.

Read this part on MSDN.

Continue reading...


 

SQL Server Data Mining Programmability April 8th, 2005

Vinod Kumar

Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios

Read it from MSDN.

Continue reading...


 

.NET in the Real World: The CLR Enters the Relational Stage April 8th, 2005

Vinod Kumar

Here goes some more info on the topic. Seems to be a hot topic since it was first introduced. “This article describes the CLR integration into the SQL Server 2005 Database Engine in detail and provides some background for answering two integration-related questions”

Read it from MSDN.

Continue reading...