By Joris Evers – MICROSOFT POSTED A cumulative patch for its SQL Server 7.0 and 2000 database software late Wednesday, also patching four new vulnerabilities.Also affected are Microsoft Data Engine (MSDE) 1.0 and MSDE 2000, products often used with SQL Server, Microsoft said in security bull
Author: SSWUG Research
True DBA blooper #3: Wildcard runs wild
By Sara Cushman – Sometimes a simple plan to save time can really backfire. In Oracle DBA Ron Horjus’ case, a mistake he made while implementing a new file path naming standard was so memorable, and miserable, that the details are vivid more than a decade later. At the start, Horjus simply intended
Changing Times
By Itzik Ben-Gan – With many calendars in use and varying ways of expressing times and dates around the world, keeping everything straight in your calculations could be a nightmare—but it doesn’t have to be.
XML to Drive Office Update
By Peter Galli – The next version of Microsoft Corp.’s Office productivity suite will come with XML support baked into Word, allowing users to, among other things, more effectively mine their data.
Web-developer’s perspective on power of “Well-Formed Web”
Joe Gregorio describes how adding XML to the Web might be enough to open some powerful new possibilities.
Roots of the REST/SOAP Debate
By Paul Prescod – What problem are web services trying to solve? It sounds like it should be an easy question to answer but web services are seldom described in terms of their problem domain. The general gist of most definitions seems to be “Web Services allow programs written in different languages
DB2 replication to SQL Server 2000
Answered by Michael Hotek – I neet to get a DB2 Database replicated to SQL Server 2000. I have an OLE Connection and Data Bindings. But even though I have set up a pull subscription through SQLDMO, I can’t seem to get it working.
Index Range Scan for “ename like ‘%EIL'”
by Vadim Tropashko – Description: An index range scan is routinely used when querying a name by a name prefix. It is also not unusual to query by a postfix:
Introduction to SQL Server 2000 Analysis Services: Parent-Child Dimensions
The fourth article in the advanced SQL series ‘Introduction to MS SQL Server 2000 Analysis Services’ examines another special type of dimension, the Parent-Child dimension, and explores the attributes that make it different from a regular dimension. The article also discusses the considerations that
Class Loading in J2EE and Oracle9iAS Environments
By Bryan Atsatt and Debu Panda – This article looks at how class loading works, both in a standard J2SE environment and in more-complex J2EE environments such as OC4J.