Oracle Database 10g comes with a number of new features such as new features in flashback, Data Guard and transaction recovery monitoring. Also covered here are RMAN improvements and general database recovery improvements.
Author: SSWUG Research
Securing Web services: Using XML signatures
(Jeffrey Vagle) An important consideration in the creation, deployment, and use of Web services is the message itself. Since Web services rely on the transmission and receipt of SOAP messages, the ability to verify the integrity and authenticity of these messages should have a rather high priority a
Converting Oracle SQL to DB2
(Craig Mullins) I am new to DB2. We are migrating an Oracle database to DB2. In this conversion, I have to convert Oracle SQL to DB2 SQL. (R)
Back to School with Database Encryption 101
(Lisa Vaas) Opinion: To fend off criminal manhandling of valuable data, database encryption should be one tool in an enterprise’s arsenal. Database security vulnerability is finally getting a level of attention approaching that which has long been targeted at networks, which is both a good th
Taking Abstraction One Step Further
(James Holmes) One of the hottest new concepts in programming today is aspect-oriented programming (AOP). Once used primarily in academia and research-and-development organizations, AOP today is making inroads into mainstream development. Using AOP is an evolutionary way of developing software that
Lotus Workplace Web Content Management and Content Manager Working Together
(Wei-Dong Zhu) In this IBM Redbook, we explore how we can put both IBM Lotus Workplace Web Content Management (LWWCM) V2.0 Java Edition and IBM DB2 Content Manager (Content Manager) V8 products at work together. We provide overviews of LWWCM and Content Manager products, discuss why and when we m
Islands and Gaps in Sequential Numbers
(Alexander Kozak) SQL Server developers often use either the IDENTITY column or the MAX() function (for example, MAX(id) + 1) to create unique identifiers for a table. I personally like the identities. In my opinion, they’re convenient and flexible. One of the things that I don’t like about them, th
Hosting .NET Within SQL Server 2005 Express
(Philip Miseldine) One of the biggest strengths of SQL Server is its powerful support for the definition of logic inside the database through stored procedures, user-functions, and triggers. This allows developers to create well-recognised and adaptable interfaces from their business logic layers to
FIX: You may receive a 547 error message when you try to update an instance and application databases of SQL Server 2000 Notification Services by using the NSControl Update command
When you use the NSControl Update command to try to update an instance of Microsoft SQL Server 2000 Notification Services and the application databases for an existing instance of Notification Services, the update operations may not be completed successfully.
Monitoring Oracle processes in Windows NT
(Ravinder Bhalla) It’s much easier to monitor CPU usage in a Unix environment for each individual Oracle process (i.e., PMON, SMON, DBWR) as compared to NT. In NT, there is only a single process (i.e., oracle.exe). In order to get the status of individual threads of Oracle processs in a Windows envi