We often add columns to replicated tables. How can we add a column without having to reinitialize the entire publication?
Author: SSWUG Research
Eyes Slammed Open
The havoc wreaked by the SQL Slammer, or Sapphire, worm starkly illustrated the vulnerability of Internet-accessible database servers. Fortunately, the worm didn’t compromise any stored data. However, it exploited a flaw in Microsoft’s SQL Server to propagate itself and consequently (according to pu
Oracle Updates Data Warehouse Tools
By Barbara Darrow – The newly updated Oracle9i Warehouse Builder tool claims to break down the walls between silos of corporate information. Version 9.0.4 can extract data from IBM’s DB2, Sybase, Microsoft SQL Server and Oracle’s homegrown database, said John Magee, vice president of product
XML Watch: WBXML and basic SyncML server requirements
In the second installment of his quest to make his data available wherever and whenever he wants by using SyncML, Edd Dumbill encounters Wireless Binary XML (WBXML) and examines the minimum functionality required for a SyncML server.
XPath Tutorial
XPath is described in XPath 1.0 standard. In this tutorial selected XPath features are demonstrated on many examples.
Microsoft BizTalk Server 2002 Part 1
By Hitesh Seth – Microsoft BizTalk Server 2002 provides an out-of-box solution for integrating internal systems and external business partners. BizTalk Server 2002 is its second generation, succeeding BizTalk Server 2000. It is built on top of a core Microsoft Windows 2000-centric infrastructure run
Build a Web Services-Based Interface
by Enrique Castro – Here’s a collaborative solution that employs Microsoft Excel spreadsheets in a simple, Web-based, peer-to-peer publish/subscribe service.
How to Restrict the Inner Table of an ANSI Outer Join
SQL Server 6.5 and later support the ANSI-style join syntax for cross, inner, and outer joins. Restricting the inner table of an ANSI-style outer join may appear to return results that differ from those returned using the Transact-SQL-style outer join syntax. This article discusses the situation in
Use eVB and ADOXCE to build an Enterprise Manager for MS SQL Server for CE
For anyone familiar with using SQL Server on the Desktop, and now looking to use SSCE, one tool that will be missed right away is Enterprise Manager. Tim Chaffee of Object Design Works has written this excellent and pioneering article covering some of the aspects of managing a database on the CE dev
Certifying: DBA Fundamentals II
By Jim DiIanni – This column includes a discussion of topics you will likely encounter on the Oracle9i DBA Fundamentals II exam. The Oracle9i DBA Fundamentals II exam is one of two that you must take to achieve the Oracle Certified Professional (OCP) level of certification. In this column, I’ll disc