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?
Author: SSWUG Research
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
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.
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
Setting up Merge replication: step by step guide
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
Oracle Guide Aims to Clear up Policies
By Matt Hicks – Oracle Corp. on Tuesday will release a promised pricing and licensing guide that company officials hope will help clear up customer confusion of its policies. The guide, called the Oracle Software Investment Guide, offers about 40 pages of details on licensing and pricing poli
OASIS Forms Technical Committee To Tackle UDDI
By Richard Karpinski – The OASIS standards group this week launched a new technical committee to oversee the development of UDDI, the registry and lookup technology in the Web services software "stack."
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.
Separating Elements
By Itzik Ben-Gan – User-defined functions can help when you have to work with denormalized data, but don’t worry if you don’t have SQL Server 2000. You can also create a SQL Server 7.0 solution to this headache.