(Frank Rice) Learn about the scenarios and XML markup that you can use to customize the Ribbon user interface (UI) in the 2007 Microsoft Office release. The Ribbon UI replaces menus, toolbars, and most of the task pane UI in the 2007 release.
Author: SSWUG Research
What is the difference between Oracle, SQL and PL/SQL?
(Lewis R Cunningham) Recently, Sudhat read my Introduction to Basic SQL and had this to say: The article is very interesting. Too Good! And also please describe what is the difference between SQL and Oracle and PL/SQL.
Session Management with MySQL
As the web continues to provide one of the most cost-effective ways for businesses to market and sell their goods & services, we will continue to see the investment in web-based applications rise. An inherent characteristic about the web and one of the most common technical issues businesses face wh
Applications for Real-Time Access
(Ari Kaplan) Database applications for wireless handhelds have an important role for business IT because they can increase productivity and lower costs for an enterprise. Let’s look at an experience I had designing and deploying a wireless application where access was the key.
Design for Performance
(David Beulke) Relational databases and relational set theory hold many performance advantages over other networked and hierarchical databases. Relational set theory and the ability to process multiple rows through one database SQL statement can be very powerful. Unfortunately, I continue to find pe
Q Replication and Consistent Change Data tables
(Sean Byrd) Consistent Change Data (CCD) tables have been a popular type of target table in SQL Replication. By enabling CCD tables as another target option, it is simple for someone familiar with Q Replication to take advantage of this new functionality. So at this point, you might ask, “Why should
Useful SQL Queries to Analyze and Monitor SharePoint Portal Solutions Usage
(Syed Adnan Ahmed) It is a very common requirement in SharePoint Portal Solution to analyze a SharePoint solution in terms of storage capacity and statistics of sites, document libraries, area etc., to monitor the growth of the SharePoint solution and to take prompt action, if any thing goes wrong.
The Future of Perl in PostgreSQL
(Andrew Dunstan) My first article about PL/Perl discussed using triggers written in PL/Perl, and the second showed how to exchange data with the database and running database commands from inside PL/Perl. This final article in the series explores the improvements in PostgreSQL versions 8.0 and 8.1 a
SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
(Hernando Bedoya, Elvis Budimlic, Morten Buur Rasmussen, Peggy Chidester, Fernando Echeveste, Birgitta Hauser, Kang Min Lee and Dave Squires) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network
Overcoming Software Limitations in Multidimensional Reports
(James Catchpole) Most medium to large sized businesses have a reporting solution that provides timely financial information in a user-friendly format for sales people, managers and customers. Usually, the “solution” is a dedicated reporting employee who manually queries source databases for statist