(Alejandro Gervasio) Welcome to the concluding part of the series “Using SQLite with PHP 5.” As you’ll possibly know, PHP 5 comes equipped with a fully-featured RDBMS called SQLite that definitely can make your life as a PHP developer much easier. It’s particularly helpful if you want to get rid of
Author: SSWUG Research
Medians, ROW_NUMBERs, and performance
(Adam Machanic) A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even better way to attack the probl
CreateXMLDB – Create an XML Database and Associated C# Class to Access it
(Jeff Gaines) I have been planning to convert my MS Access files to XML for some time, but had put it off because it is a tedious task.
Accessing the IBM WebSphere Service Registry and Repository using JAX-RPC
(John Colgrave) The IBM WebSphere Service Registry and Repository (hereafter referred to as Service Registry) includes a Java client which supports accessing the Service Registry using either SOAP/HTTP or RMI/IIOP, with a programming model based on Service Data Objects (SDO) 2.0. The SOAP API that t
Meet DependencyObject and DependencyProperty, the .NET Data-Binding Boosters
(Chad Campbell) With the introduction of the .NET 3.0 Framework, Microsoft made the DependencyObject and the DependencyProperty fundamental concepts, placing them at the forefront of development. Using these two items in conjunction enables .NET developers to expose some of the powerful features of
Primary Key Order Does Matter!
(Partha Dutta) There have been a few posts on PlanetMySQL regarding primary keys and the importance of choosing the right one. This is even more important when the table uses InnoDB. You’ve read different posts of why it is so important. Now, I’m all about benchmarks and showing the details. So I’ll
Understanding SQL Server’s sysobjects table
(Arthur Fuller) Everything about your SQL Server database is stored in its system tables. I doubt that you spend a lot of time inspecting the system tables since you are too busy with your user tables. However, you may need to do something unusual once in a while, such as list all the triggers in yo
Searching Open XML documents
(Doug Mahugh) Searching documents for text strings is a common task in many type of applications. And there are many possible variations on this simple concept: whether to search the body of the document or its metadata, whether to restrict your search to specific document types or document sections
Using SQL Developer to Learn Oracle
(Steve Callan) GUI interfaces into Oracle are becoming more and more common, and aside from the heavyweight TOAD, other products include SQL Developer, SQL Manager 2007 and SQL Edge. Inside of Oracle’s (free) SQL Developer 1.1 product is a tutorial, which includes a little bit about a lot of things
Introducing IBM Workplace Web Content Management in WebSphere Portal V6
(Sven Viehweger) IBM Workplace Web Content Management is a key component in IBM WebSphere Portal Version 6. You can use it to manage corporate content from the creation of the first draft to the final Web presentation. You can also use it to design your Web site. Because Web Content Management separ