Transactional replication for Oracle Publishers is built on the Microsoft SQL Server transactional replication publishing architecture, but the process of tracking changes at the Publisher and delivering them to the Distributor is significantly different from standard transactional replication. Desp
Author: SSWUG Research
Oracle 10g Free Training – Sequences
In this tutorial you will learn about Sequences, Creating Sequences, Altering Sequences, Using Sequences and Dropping Sequences.
Performance monitoring with Enterprise Workload Manager
(CheKim Chhuor) Today, multi-tier Web applications and clusters are very common in IT environments. System administrators need to know how their Web applications are performing to satisfy established business goals or service level agreements (SLA). There are several tools to let you monitor systems
Leverage your PostgreSQL V8.1 skills to learn DB2, Version 8.2
(Ted J. Wasserman) There has never been a better time to consider switching over to DB2. With the recent announcement of DB2 Universal Database (UDB) Express-C Edition V8.2, a fully functional, free version of DB2 for Linux, Unix, and Windows platforms (32-bit and 64-bit), more and more developers w
Creating a Simple SQL Server 2005 Notification Application: Stock Quotes
(Shyam Pather) In this chapter, you’ll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross
DSNTIAD – The Dynamic SQL Update Program
(Craig S Mullins) In my last blog entry I posted about DSNTEP2, the batch SQL program. But there is another batch SQL program named DSNTIAD that is less widely-known and used.
Storing Session State in a SQL Server Database
(Bipin Joshi) HTTP is a stateless protocol. To allow users save to state information across requests, ASP.NET provides Session storage. The session variables are stored on per-user basis. In ASP classic, you can store session variables only in the Web server’s memory. However, this approach proves t
Set Functions: The DrillUpLevel() Function
(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our sub-series, stating that it comprises an analytical
Quick Debugger Visualizers in Visual Studio 2005
(Mike Gunderloy) Debugging in Visual Studio is a wonderful thing. You can use the tools built into the debugger to drill into the values of objects and their member variables easily. But even wonderful things can be improved, and that’s exactly what Microsoft has done with the introduction of debugg
Developing a Data Access Layer for Sybase using ADO.NET: Working With Stored Procedures
(Jagadish Chaterjee) This article is third and last in a series focusing on developing a simple DAL (Data Access Layer) for any database using ADO.NET. In this series, we consider Sybase as the database of choice for developing the DAL.