Newest Database Articles Performance Improvement: Understanding By Robert Bogue - Published 06/29/2009 The results you get out of any performance prediction exercise are bound to be wrong. The goal is to make them as least wrong as possible. Rob Bogue will help you understand how to avoid getting them too wrong.
Using SQL Server 2008 Change Data By Jani Järvinen - Published 04/14/2009 In many business applications, it is crucial to know how data has changed over time. For developers, this is not a new problem; many different solutions have been created to log changes. But creating a log is time-consuming. Read on to learn how SQL Server 2008 can help you save time and work more effectively.
Highlighted Database Tutorials Using More Advanced JDBC Features By Matt Weisfeld -
Expand your basic knowledge of connecting to a database from a Java application using JDBC. Discover how to use just about any database application you may want. In this example its a Microsoft Access database.
Sample Chapter: Efficient PL/SQL By Beck, Kallman, Katz, Knox, and McDonald -
When used intelligently, PL/SQL can build applications that perform well, are resilient to change over time, and scale to large user populations.
Introductory Transact-SQL By Addison Wesley -
If you are new to SQL Server don't miss this excerpt. Learn the fundamentals of Transact-SQL with Ken Henderson!
Review the architecture of Perl DBI (The Perl Database Interface Module), what DBI provides to interact with databases, then cover simple tasks such as connecting and disconnecting from databases. Finally, we'll discuss the important topic of error handling and describe some of the DBI's utility methods and functions.