By Douglas Seward – We recently had a problem with SQL Server 7 bombing out when trying to process a view of our DB2 table where some of the date fields were initialized with the value ‘0001-01-01’. In SQL Server the earliest date recognized is 1753-01-01, so it could not process date fields with th
Author: SSWUG Research
The comparison of SQL Server 6.5 with SQL Server 7.0
by: Sergey Vartanyan – In this article, Sergey Vartanyan shows you the core differences between SQL Server 6.5 and 7.0.
SQL Server 2000 Enterprise Edition Benefits
SQL Server 2000 Enterprise Edition offers several unique features, including the ability to access more than 2GB of memory, support for failover clustering, and distributed partitioned views (aka federated database servers). However, even if you don’t need any of these features, some performance opt
Setting Up Full Text Search: A Step-by-step Guide
Alexander Chigrik explains SQL Server full-text search concepts in extensive detail, complete with a step-by-step example for getting up and running with a full-text search index.
Office 11 Snubs Windows 9x, Me
By Peter Galli – Microsoft Corp. has told beta testers of Office 11, its next-version Office desktop productivity suite, that the product will only work with the Windows 2000 operating system with Service Pack 3 installed, Windows XP and later desktop releases.
INF: Common SQL Mail Problems
This article uses a question and answer format to identify common problems you may encounter when you work with SQL Mail and provides you with some tips on how to correct or troubleshoot these problems. The vast majority of SQL Mail related problems are due to an improper configuration.
DoS Bug Found in Oracle9i App Server
By Ryan Naraine – Security consultants @stake has detected a potential vulnerability in the Oracle9i Application Server that could lead to Denial of Service (DoS) scenarios.
Xpath1() scheme published as an IEFT Internet-Draft
Simon St.Laurent has announced an IETF Internet-Draft defining a XPath based scheme to be used in the XPointer framework that is simpler than the xpointer() scheme and more powerful than the shorthand or element() scheme.
XML Files: WebMethod Validation, SOAP Validation, XmlSerializer, One-way Operations, and More
By Aaron Skonnard – Is it possible to turn on validation in ASP.NET WebMethods? WebMethods don’t seem to validate the request message against the implied XML Schema.
HOW TO: Apply an XSL Transformation from an XML Document to an XML Document by Using Visual Basic .NET
This article illustrates how to apply an Extensible Stylesheet Language (XSL) Transformation (XSLT) to an Extensible Markup Language (XML) document using the XslTransform class to create a new XML document. XSL is an XML-based language that is designed to transform one XML document into another XML