(Alejandro Gervasio) This is the first part of a three-part series that covers separating logic from presentation in PHP applications. In this article you will learn to develop a template system that is advanced enough to meet the requirements of a majority of applications.
Author: SSWUG Research
MySQL CEO offers mixed view of Oracle
(Stephen Shankland) In an illustration of just how rapidly change is sweeping the database market, MySQL Chief Executive Martin Mickos named Oracle as a partner of the year just minutes after effectively calling one of its products “crippleware.”
Except Operator in SQL Server 2005
(Muthusamy Anantha Kumar) Microsoft introduced the EXCEPT operator in SQL Server 2005, which returns all of the distinct rows from the left side of the EXCEPT operator. It also removes all of the rows from the result set that match the rows that are on the right side of the EXCEPT operator.
Tour de SQL: Part I, Versions
(Eric Johnson) This July 1, the world’s best bicyclists will gather in northeastern France to kick off the planet’s most grueling event: the Tour de France, a 20-stage race covering more than 2,100 miles. The cyclists will zip through wheat fields, bounce over cobblestone streets and power up mounta
Working with VARRAYs in Oracle Part I
(James F. Koopmann) This is the first in a three part series that will take you through the process of creating VARRAYs and dealing with them in Oracle tables.
Working with MagicAJAX
(Mohammad Azam) In this article, we will look at the MagicAJAX Library which helps make the client side postback calls and provides a smoother user experience. The article will cover the development of a small application that is used to add and view user specific tasks.
Build and Deploy a .NET COM Assembly
(Phil Wilson) In this article I’ll build a .NET COM assembly following the recommended best practices, and show you how to deploy it with a Visual Studio Setup & Deployment Project. I’ll also show you two types of client for the COM object (early binding and late binding) and discuss the advantages
Using SQL Server Profiler with Analysis Services
(Jeremy Kadlec) Analysis Services was originally introduced with SQL Server 7.0 as the core backend technology for Microsoft’s business intelligence offering. Since the original release, the overall business intelligence offering has improved immensely for both the presentation and processing layers
IBM DB2 ‘Viper’ revs XML engine
(Sean McCown) Code-named “Viper” and due for release in early summer, will be more worthy of its “Universal Database” tagline than previous versions. Not only does Viper contain an extensive list of enhancements that cover everything from security and development to storage and administration, but t
How to serialize a CTreeCtrl in XML
(Andreas Loeffler) A while ago I had to come up with a solution on how to serialize a CTreeCtrl – or a derived class from it – with XML, e.g. loading and saving its content in a XML file without destroying the tree structure of the items.