By David Berlind – Like many pundits of handheld computing, Landry believes in the mobile mantra that “synch is everything.” In that context, “synch” refers to the solid, reliable, and accurate synchronization of desktop- and server-bound data to handheld devices. “The problem” Landry says, ”
Author: SSWUG Research
Read Microsoft Security Bulletin MS02-040
An unchecked buffer in MDAC leaves SQL Server systems vulnerable to a buffer overrun attack. The latest security patch to MDAC fixes this problem for MDAC 2.5, 2.6, and 2.7.
Not My Type: Sizing Up W3C XML Schema Primitives
by Amelia Lewis – Since the application of XML to data representation first gained public visibility, there has been a movement to enhance its type system beyond that originally provided by DTD. Several attempts were made (SOX, XML Data and XML Data Reduced, Datatypes for DTDs, and others) before th
Mozilla’s Potpourri of Rendered XML
by Nigel McFarlane – HTML and XHTML are no longer the only game in town—Mozilla has direct support for other XML languages, such as MathML (mathematical equations) and SVG (two dimensional vector diagrams). Learn about Mozilla’s fresh approach for rendering Web page content onto the screen. Be sure
Java XML Pack Summer 02 Release
The latest release of the Java XML Pack, Summer 02, includes the Java API for XML Messaging (JAXM) v1.1, the Java API for XML Processing (JAXP) v1.2, the Java API for XML Registries (JAXR) v1.0_01, Java API for XML-based RPC (JAX-RPC) v1.0, and the SOAP with Attachments API for Java (SAAJ) v1.1.
Remove the Duplicate Rows from a Table
by Madan Patil – This script will remove duplicate rows. Even if you suppose one record is duplicated more than 2 times, the script will keep only one record and delete the others.The advantage of this script is that if you have loaded data from SQL*LOADER or from other databases or data imp
A Comparison of SQL Server 7.0 with SQL Server 2000
by Sergey Vartanyan – Are you still using SQL Server 7.0 and considering upgrading to SQL Server 2000? If so, this article may help.
Decrypt encrypted stored procedures
(Joseph Gama & ShoeBoy) This code presents a stored procedure called sp_decrypt_sp that is used to decrypt T-SQL stored procedure compiled with the ENCRYPTION option. (R)
Project management: A simple plan
By Ellen O’Brien – Why do so many data warehousing projects fail? Michael Corey says it’s because so many project managers lack clarity, and a commitment from the top. And he ought to know. Corey, a relational database expert, is the founder of Ntirety Technologies, an IT consulting agency, and is t
Migrating Sybase Databases to SQL Server 2000
This white paper on the Microsoft TechNet site provides a detailed explanation of the migration process and explores the improved database functionality of SQL Server.