by Michael Fitzgerald – Working with XML Schema is like driving a limousine. It’s true that it has some nice appointments (datatypes come to mind), but the wheelbase is a bit on the long side, making it difficult to turn corners easily, and I am inclined to let somebody else do the driving for me. U
Community
Interpreting Wait Events to Boost System Performance
By Roger Schrag – People seem to have an insatiable appetite for speed. No matter how fast an application runs, users always seem to want it to run faster. Since everybody looks to the database administrator when system performance or scalability is in question, it’s no wonder DBAs are always lookin
SQL Server Quantitative Performance Analysis
by Joe Chang – SQL Server employs a set of formulas to assess the cost of an execution plan for a query based on the type of operations involved, and the number of rows and pages involved. By examining the SQL Server execution plan cost formulas, we can understand why a specific execution plan is ch
Keep your SQL Server database free from design flaws with SSW SQL Auditor.
Maintaining quality code across a large team is difficult. Even when standards are in place developers can make mistakes that will slip through QA. SSW SQL Auditor, built in VB .NET, allows a developer to set SQL Server design rules and then check the database for code or design elements that ignore
Top Ten Tips: Accessing SQL Through ADO and ASP
By J. D. Meier – Using SQL and ADO to provide data for your Web application can seem daunting, but these ten tips can noticeably improve your results.
Upgraded Onyx CRM adds Web services, Oracle ties
By Matt Hines – CRM veteran Onyx Software Corp. is betting on new functionality around emerging Web services and links to Oracle Corp. database technology to help drive its fourth generation of enterprise applications deeper into the middle market.
Handling large data files efficiently with Java
By Serguei Eremenko – Java provides a simple standardized API for reading and writing to and from external resources such as files, databases, and sockets. But even though the Java I/O API covers a wide spectrum of applications’ demands, correct usage of it is not as simple as it may seem. Inefficie
Creating a link for connecting two databases
By Shailesh Yagnik – Suppose you want to query both a remote and a local database. To do this, you need to create a database link so that users can get the results from two databases in one SQL query from the SQL prompt.
Oracle patches two holes in 9i database
By Sam Costello – Oracle Corp. released patches for two security holes in its 9i database last week that could have allowed an attacker to take over or run code on affected systems.
Flaw Puts SQL Servers at Risk
By Dennis Fisher – A Russian security researcher claims he has discovered a flaw in Microsoft Corp.’s SQL Server 2000 which gives an attacker the ability to either crash the server or execute malicious code on the machine.Microsoft is aware of the advisory and is investigating the issue, the