(Wei-Meng Lee) With Visual Studio 2005, developing Windows Forms applications has never been easier. In the user interface area, Microsoft has provided much of the needed functionality in the form of Windows Forms controls, such as the familiar Button and TextBox controls. Using the controls greatly
Author: SSWUG Research
Where covering indexes rock
(Domas Mituzas) One of MySQL features I usually like to exploit is covering index. Simply, if all fields required for a query are contained in an index, there’s no need to access table row somewhere else. In MyISAM that would mean not going to MYD file. Inside InnoDB data is clustered together with
RAID as your line of defense in SQL Server
(Greg Robidoux) As hardware becomes more and more advanced there are several safeguards that companies employ to ensure their systems stay online. This includes: multiple power supplies, multiple network cards, multiple processors, multiple controllers, hot swap memory, hot swap disks, hot swap proc
Integration’s The Rub For New Oracle BI
(Clint Boulton) One of Oracle’s biggest challenges these days is integrating the new products from its numerous acquisitions with its existing software.
Way to migrate large database other than export/import
(Maria Anderson) there any other way apart from using export/import for migrating the database between different platforms? Export/import is taking more time for TB databases. (R)
XSLT 2.0
We are pleased to note that XSLT 2.0 and XPath 2.0 are now W3C Recommendations. Microsoft contributed thousands of person-hours to the W3C efforts that developed these standards and is committed assist with the further development of XML standards at W3C.
Look inside ASM disk groups with Oracle 10gR2’s ASMCMD
(Bob Watkins) In 10g, Oracle introduced a new kind of storage for its database product. Automatic Storage Management (ASM) is a logical volume manager that takes physical disk partitions and manages their contents in a way that efficiently supports the files needed to create an Oracle database.
Transfer and store data from an XML document in a relational database
(Edmond Woychowsky) Between AJAX, Web services and just plain XML there is a plethora of information going to and fro. Yes, XML really makes it easy to move data from here to there and from there to here. While this is really great it totally ignores the fact that eventually the data needs to be sto
Using Crystal Reports for Visual Studio 2005 to Build Reports from DB2 9 – Part A
(Paul Zikopoulos) In this article, I want to show you how you can create a very slick cross tab report using Crystal Reports for Visual Studio 2005 to generate a report from an IBM DB2 9 data server.
Performance Monitoring and Best Practices for WebSphere on z/OS
(Alex Louwe Kooijmans, Tony Cox, Ruud Huisman, Magdalena Matysiewicz, Koelli Mungee, Brian Paskin, Martina Scmidt, Thomas Schulze and Brian Paskin) Implementing a WebSphere Application Server environment on z/OS and deploying applications to it in a manner that delivers the best performance is not a