(Shu Fang Rui) From when to choose mobile Web services to the overall design guidelines to the value types to use in mobile Web services, this article addresses many of the design considerations you need to ponder when developing Web services for mobile devices. It also covers many of the best pract
Author: SSWUG Research
Oracle’s identity solution
(Eliot Beer) Oracle has released a new package — Oracle Identity and Access Management Suite — to prevent unauthorised users accessing sensitive data on enterprise systems.
Comparing Microsoft SQL Server Replication and DataXtend RE Replication for Mobile and Distributed Applications
If you are considering Microsoft replication capabilities you need to understand how these capabilities compare to DataXtend RE. This white paper discusses the differences in SQL Server and DataXtend RE replication capabilities across several areas and also reviews the challenges of supporting multi
How To Receive Data from a Single Table
(Bryan Sylverson) To help you learn to code SELECT statements, this chapter starts by presenting its basic syntax. Next, it presents several examples that will give you an idea of what you can do with this statement. Then, the rest of this chapter will teach you the details of coding this statement.
Manage, Don’t Tune
(Sanjeev, Saurabhi Singh and Siddharth Singh) Over years of performance tuning endeavors, we’ve encountered many performance myths, ideologies, and traditional approaches to working with relational databases. We believe that the need of the hour is not to tune for performance, but to manage applicat
Using MySQL – Data and Structures
(Keith Brown) A common problem when learning how to the MySQL Command Line Client is getting the syntax exactly right. There are several conventions which are used throughout the MySQL virtual workshops when displaying commands that you will have to type.
Implement an advanced physical database with SQL Server 2000
(Thomas Moore and Ed Tittel) Learn about schema binding, data partitioning, and other aspects of advanced physical database implementation. This information, including practice questions, will help you prepare for the CAD/MCSE/MCDBA 70-229 certification exam. (pdf)
Building COM Servers in .NET
(Lim Bio Liong) COM/.NET interop is a well-known, well-documented and well-loved technology. It serves to help us bridge existing COM-based systems with .NET components, allowing us to leverage the wealth of functionality available through the use of the .NET class libraries. On the flip side, COM/.
Properties, Getting and Setting Them Dynamically
In this code snippet we have a custom object that contains a method called GetProperties. The purpose of this method is so the object can return an arraylist of all the named properties it contains. Again you could use this to populate a drop down which then adds fields to be reported on or calculat
.NET Stored Proceedures: Reading Excel Files or Transferring SQL Server Tables into Oracle Tables
(Jagadish Chaterjee) In this article, I shall introduce you to developing a .NET based CLR stored procedure which can read a simple Excel file and transfer that information into an Oracle database using Visual Studio.NET. Once we have completed the stored procedure with the Excel file, we will furth