By Wylie Wong – Oracle announced it has purchased WebGain’s TopLink, a tool that speeds the building of software by connecting Java software code with databases. As part of the deal, about 90 WebGain employees who develop, sell and support the TopLink product will now become Oracle employees, an Ora
Author: SSWUG Research
SQL Case Statement Finds Segments Nearing Maximum Extents
(Richard Hibling) Quickly identify segments nearing their maximum extents using the *new* SQL case statement.
Overview of SQL Server security model and security best practices
By Vyas Kondreddi – This article discusses the security model of Microsoft SQL Server 7.0/2000 and security best practices to help you secure your data. Special thanks to my friend Divya Kalra for her valuable input and content review.
The database socket is deserializing: How to tell if your developers are lying to you
By Shelley Doll – A nontechnical development manager puts a huge amount of trust in his or her team. When the team misses a deadline, or functionality doesn’t work as expected, it can be hard to know why if you don’t understand the lingo. How can you tell if your trust is being taken advantage of, w
The Shape of T-SQL
By Itzik Ben-Gan – Next time someone tells you to think outside the box, try this rectangular technique.
Web-Based Enterprise Manager
Web-based SQL Server 2000 Enterprise Manager. Create, add, edit, delete, and administer all aspects of your SQL Server databases online. Creates completes ASP Insert and Update codes for your tables. Builds Stored Procedure Search Engine automatically.
Editing XML Data Using XUpdate and HTML Forms
by Chimezie Ogbuji – In this article I will discuss how XUpdate can be used in conjunction with XSLT to write tools for authors of web-based applications that will automatically generate HTML forms for editing various kinds of data. Forms are the primary means that web-based applications collect inf
Two Oracle Flaws Put Machines at Risk
By Dennis Fisher – Security researchers have found two serious buffer overruns in Oracle Corp. products, both of which give an attacker complete control of a vulnerable machine.One flaw affects Windows machines running any version of Oracle9i, while the other affects any machine running the
Government seeks accord on XML
By Margaret Kane – The federal government isn’t known as a pioneering early adopter. But growing support within U.S. agencies for the popular XML data exchange format has raised concerns that, for once, things might be moving too fast.
W3C: Put XML to the test
By Paul Festa – The World Wide Web Consortium (W3C) on Wednesday launched the XML Conformance Test Suite. Offered free of charge, the suite consists of 2000 files, each of which tests for a specific feature or combination of features in the second edition of the W3C’s published XML 1.0 recommendatio