(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved the effectiveness and speed of materialized view refreshes, something that is becoming especially important in increasingly complex data warehouses and data mart environments. This article – the first in a series – demonstrates several new f
Author: SSWUG Research
New Open-Source Database Touts Oracle Compatibility
(Charles Babcock) An open source competitor is zeroing in on Oracle’s customer base—and it’s not the popular and well known MySQL open source database. It’s a relative newcomer called EnterpriseDB Advanced Server.
Seriously Customizing JDeveloper
(Brian Duff) If you’re a long time JDeveloper user, you may recall the old version of the extension preferences page. It gave you the ultimate in low level control over which features were enabled in the product – you could switch off anything, and get a startup and memory footprint boost as a resul
FIX: The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4
A computer that is running the Microsoft SQL Server 2000 SP4 may unexpectedly end the SQL Server process and you may receive the following message in the SQL Server log: spid4 SqlSecurityHandler is invoked. Server is terminating.
SQL & XQuery tutorial for IBM DB2, Part 4: Data analysis
(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes how to write queries that require basic data analysis. Many of the queries contain sequential calculations, or calculations that operate on an ordered set of rows–queries frequently encountered during business analysis. On-Line
DB2 Developer Workbench, Part 1: Developer Workbench concepts and basic tasks
(Debra R. Eaton) The IBM DB2 Developer Workbench (DWB) gives DB2 9 database developers the ability to develop database application objects that access data. DWB is based on Eclipse technology, which replaces the Swing-based DB2 V8 Development Center. Get an introduction to the Eclipse User Interface
Inside IBM DB2 Viper
(Sean McCown) IBM’s newly released DB2 9.1 (previously code-named “Viper”) sheds many of the limitations of DB2 8, boosting performance, scalability, and security. But one feature in particular, the hybrid XML/relational engine, gives this Big Blue serpent its distinctive shape. For customers plungi
TechTip: SQL Server 2005 Linked Servers and Synonyms
(Michael Sansoterra) Most SQL Server developers know the benefits that linked servers provide. Available since SQL Server 7.0, linked servers can use almost any ODBC or OLE DB data source to provide read/write connectivity to remote database objects. This provides developers with a powerful, easy-to
A Functional Look at Report Builder Client in SQL Server 2005
(Dipal Choksi) In this article we will take a look at the functionality provided by the Report Builder Client. The Report Builder Client is a “self-service” tool to provide capability for building ad-hoc reports by business users, with automatic interactive drilldown capabilities.
How to use Stored Procedure in VB 6.0
(Sujith C Jose) This is a simple article which describes how to use a Stored Procedure in Visual Basic 6.0 using the Microsoft ActiveX Data Objects(ADO).