by Rich Salz – Unlike today's Web, web services can be viewed as a set of programs interacting cross a network with no explicit human interaction involved during the transaction. In order for programs to exchange data, it's necessary to define strictly the communications protocol, the data t
Author: SSWUG Research
By Wylie Wong – Oracle, looking to regain market share lost to its rivals, is set to launch a new version of its flagship database software. The software maker said it plans to ship a new release of its 9i database later this week or early next week. Topping the list of new features in the re
By John Zipperer – When Mark Jarvis, senior vice president and chief marketing officer for Oracle Corp., came to speak at the Streaming Media West event (which was collocated with Internet World Spring 2002) on April 26, he came not to speak about his company’s databases or enterprise applications.
I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform
By Brian Moran – Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003.
by Brad M. McGehee – Over the last five years that I have been a SQL Server DBA, I have put together a mental checklist that I use when it comes to performance tuning SQL Servers. I use this checklist as a guide when I perform a “performance audit” a (new to me) SQL Server for the first time. I […]
By Alorie Gilbert – A California legislator accused Oracle and its business partner Logicon of being “part and parcel of defrauding the state of California” after he reviewed an e-mail exchange between the two companies that discussed how to handle Oracle’s pending $95 million software contract with
Since it’s introduction in ADO 2.0, data shaping has remained largely on the fringes of Visual Basic arcanum. Relegated to the back pages of musty manuals, you may have overlooked this useful aspect of ADO. If you’re not familiar with data-shaping, in essence, it lets you create recordsets within
By Wylie Wong – The software maker said it plans to ship a new release of its 9i database later this week or early next week. Topping the list of new features in the release is more fluency in XML (Extensible Markup Language), a Web standard for exchanging information that is a cornerstone of Web se
by Walter Myers III and David Byres – The best cure is prevention. That’s why user authentication is the cornerstone of any software security system. And it seems easy: You can authenticate users with SQL Server’s own security mechanism, typically by passing a set of security credentials in ADO code