(Graham) In a database such as MySQL, data is divided into a series of tables (the “why” is beyond what I’m writing today) which are then connected together in SELECT commands to generate the output required. I find when I’m running MySQL training, people often get confused between all the join flav
Author: SSWUG Research
Why DB2 for z/OS data sharing should be in your life…
Attend “Why DB2 for z/OS data sharing should be in your life…” This is a teleconference packed with important information for anyone considering the implementation of data sharing in their DB2 for z/OS environment. (pdf, R)
Using SharePoint’s SPView Class and CAML as a Query Language
(Michael Peterson) If you’ve been working to customize SharePoint, you’ve probably at least heard the term “CAML,” which stands for Collaborative Application Markup Language. CAML is the XML-based language that Microsoft uses to build and customize SharePoint sites. Many of SharePoint’s .site defini
.NET Tip: Create a Class with Overloaded Constructors
(Eric Smith) When I create a class, I often define a constructor to ensure that the object is initially populated with all the information it needs to operate properly. As an example, one of my databound objects can take a database connection or both a database connection and an object representing
Performing Basic Tasks with MySQL 4.1 and Above, using mysqli with PHP 5
(Alejandro Gervasio) For anyone who has spent a few weeks working with PHP 5, the plethora of cool improvements and new features added to this incarnation of the language has brought a new, more powerful level for developing and deploying Web applications. These include the implementation of excepti
Can a foreign key also be used as the primary key in the same table?
(Rudy Limeback) Can a foreign key also be used as the primary key in the same table? (R)
Pros and cons of using merge replication for high availability in SQL Server 2000
(Michelle Gutzait) If you have deployed merge replication even once, you know it can cause a lot of headaches within the planning phase, during deployment and even after it is set up. According to Microsoft SQL Server Books Online: “Merge replication is the process of distributing data from Publishe
Table Spaces and Locking Levels, Part 2
(Bonnie Baker) Back in Quarter 1 of 2005, I wrote about the types of table spaces in DB2 for z/OS, and promised to continue that column with two additional articles: one on how locking is handled in these table spaces and the other on topics such as timeouts vs. deadlocks, lock escalation vs. lock u
Making the Most of JDBC with WebRowSet
(Sharad Acharya) Any real-world, enterprise-scale application requires access to some sort of persistent storage. The Relational Database Management System (RDBMS) is the most widely-used persistence storage mechanism that supports SQL for data query and update. Java DataBase Connectivity (JDBC) is
DB2 Data Warehouse OLAP Services, Part 1: Starting out with OLAP services
(Leon Gong and Donna Venditti) Online Analytical Processing (OLAP) is a popular and powerful data analytical method. It explores the complex data structure and presents the information in an elegant easy-to-understand fashion. IBM DB2 Data Warehouse Edition (DWE) provides a set of comprehensive OLAP