If you are running SQL Server 6.5, don't make the most common mistake made by DBAs, and that is to accept the default Memory setting, which is either 8MB or 16MB, depending on how much RAM the physical server has. This number tells SQL Server how much RAM is can use out of the available RAM on N
Author: SSWUG Research
DTS Grows Up
By Brian Knight – Since its introduction in SQL Server 7.0, Data Transformation Services (DTS) has helped many SQL Server professionals migrate data from OLE DB-compliant data sources to any compliant destination. But in SQL Server 2000, DTS has really grown up. If you've used DTS in SQL Server
Mapping DTDs to Databases
By Ronald Bourret – A common question in the XML community is how to map XML to databases. This article discusses two mappings: a table-based mapping and an object-relational (object-based) mapping. Both mappings model the data in XML documents rather than the documents themselves. This makes the ma
Bleeding edge XML at XTech 2001
Here's your chance to share ideas and code with the best XML developers at the O'Reilly Open Source Convention this summer. Proposals are invited for 30-minute talks covering the very latest developments in XML technology and open source software. These program slots have been lef
XML Schema Taking Root
by Demir Barlas, Line56 – After two years of research and development, the World Wide Web Consortium (W3C) recommended the adoption of XML Schema, its pet specification of the XML protocol. A W3C release laid out up some of the technical and practical advantages of XML Schema. Of particul
SQL Server 7.0 and 2000 Clustering Resources
by Brad M. McGehee – If you have read many of the articles I have written on this website, you will have learned in the past that I have used SQL Server log shipping as the main way to help ensure high availability of my company's SQL Servers. While log shipping has many benefits, there are seve
WWW10: IBM Readies Web Services Workflow Proposal
By Stephen Lawson – IBM in the next few weeks will unveil Web Services Flow Language (WSFL), a proposal for how to define workflows for Web services, the company's director of e-business standards strategy said on Thursday at the 10th International World Wide Web Conference (WWW10) here. Rob
Protecting the Middle
by Xenos J. Sroka – One constant in this high-tech age is that nothing stays constant. Things change all the time, whether it's stock prices, Florida vote tallies, or even code. On more than one occasion, programmers have had to adjust the parameters of the stored procedures nestled in their
Daring to Do Less with XML
by Michael Champion – Many observers have noted that the basic simplicity of XML is a fundamental reason for its rapid acceptance in electronic business. The original XML specification can be printed on about 40 pages, compared to the more than 400-page SGML specification from which it is derived. T
Answers from Microsoft
Richard Waymire tells readers how to append extra characters to a fixed-character column, how to troubleshoot fluctuations in backup tape speed, and more.