In this article, Alexander Chigrik defines some general SQL Server replication topics,including replication topologies, replication types, and replication agents; and alsodiscusses Merge replication. He then illustrates these concepts with a step-by-stepguide to setting up a Merge replication proces
Other News
Microsoft SQL Server 2000 Unleashed
If you can only afford one book on SQL Server 2000, this is the book to own. I have been a fan of the previous two editions (for 6.5 and 7.0), and the editions keep getting better. The best way to describe this book is as an encyclopedia of SQL Server 2000. Virtually every topic is covered, and most
Complex updates using the Case statement
(Neil Boyle) One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
Swingtide Debuts, Aims To Ensure XML ‘Quality Of Business’
By Richard Karpinski – Swingtide, a startup with deep roots in Web services, launched this week and will deliver later this year a platform for helping enterprises make better use of XML-based Web services.Led by Jack Serfass and David Sweet, co-founders of directory and Web services vendor
Attachments
by Rich Salz – You know the old saying, that a picture is worth a thousand words? There’s an awful lot of binary data out there, and XML is not going to replace it all or even a significant percentage. After all, what’s the benefit to xmlifying things like MPEG’s or program executables?
Stored procedure to export/import images to SQL Server
(Eli Leiba) This stored procedure serves as an interface to the TextCopy utility that exports and imports images and documnets to SQL Server. (R)
Performance Study of Microsoft Data Mining Algorithms White Paper
Data mining is quickly becoming a widely used analytical technique in today’s e-business environment. Learn about the two data mining algorithms included in SQL Server 2000 Analysis Services: Microsoft Decision Trees (MDT) and Microsoft Clustering.
Serve Business Graphics from Any XML Source
by Laurence Moroney – Defining data in XML and parsing it in XPath gives you considerable flexibility in presenting business data graphically. Learn how to write a chart server that creates dynamic business graphics from any XML source—in either Java or VB.NET.
Software Testing Tool Vendors Unprepared for Web Services
While many software testing tool vendors provide rudimentary Web Services testing, very few vendors have presented plans for providing tools that will help companies test standards-based Service-oriented architectures, according to a report released today by ZapThink, LLC, an XML-focused industry an
Learn the basics of object-relational data binding using Castor
A growing number of enterprise projects today call for a reliable method of binding Java objects to relational data — and doing so across a multitude of relational databases. Unfortunately (as many of us have learned the hard way) in-house solutions are painful to build and even harder to maintain