(Beth) As an IBM employee it’s embarrassing to admit I’ve never administered a DB2 database before. I did test one briefly last fall, attempting to load large XML SAP iDocs into DB2 or Oracle (turned out the xml was too large for either engine).
Author: SSWUG Research
Aggregating SHOW STATUS Output
(Mark Leith) When I first joined MySQL one of the things that was evident was the Support Engineers spent quite some time with customers issues that were focused on performance tuning. Performance tuning issues generally start with a engineer requesting a bunch of information from the customer such
JDeveloper 11 – Declarative Calculated Fields
(Grant Ronald) One of the features I’ve been pushing for in JDeveloper (that we got way back in Forms 5) was the ability to have declarative calculated fields. JDeveloper 11 (the technology preview is available on OTN) has this feature and it works pretty well (although just found one bug)…
CLR architecture
The .NET Framework CLR is very tightly integrated with the SQL Server 2005 database engine. In fact, the SQL Server database engine hosts the CLR. This tight level of integration gives SQL Server 2005 several distinct advantages over the .NET integration that’s provided by DB2 and Oracle. You can se
Choose the Right Web Services Security Solution
(Hyder Alkasimi) Web services are designed to expose business functionality in an interoperable and loosely coupled manner. While they have the potential to reap the benefits of an SOA infrastructure, they also introduce the risk of unauthorized access to your business assets. Therefore, it is impor
CodeSnip: How to Group Data in the GridView Control
(Sushila Bowalekar Patel) It is a very common requirement to Group the data based on particular column or cell data.
SOA management and composite apps key for IBM Tivoli
(Rich Seeley) At IBM’s Impact 2007 conference this week, Al Zollar, general manager of IBM Tivoli, stressed the need to automate management to make sure Web services work in an SOA environment. (R)
(64) SelectViews – Business Intelligence, VS Database Pro Edition, DBA Role Changes and more
Video Programming for IT Professionals
Getting PHP to Talk to MySQL
(Michele Davis and Jon Phillips) In this first part of a three-part series. you will begin learning how to use PHP to display and modify data from a MySQL database.
Taking the Guesswork out of SQL Server Performance Profiling Part 2
(Mario Broodbakker) In the previous article, Dude, where’s my time, I described a method, based on use of SQL Server wait events, for measuring response time and pinpointing the main bottlenecks in your SQL Server applications.