In his 20th annual COMDEX Las Vegas keynote address, Microsoft Corp. chairman and chief software architect Bill Gates outlined the company’s vision for Seamless Computing, a framework for software innovation that addresses the fundamental issues computer users face today, unlocks the value of comput
Author: SSWUG Research
Create table in Oracle
Back to the basics: Everything you always wanted to know about the syntax and options you can use when creating a table in Oracle.
Replication Agents
A Replication Agent is a Replication Server client that retrieves information from the transaction log for a primary database and formats it for the primary Replication Server. Replication Agent detects changes to primary data and, using Log Transfer Language (LTL), which is a subset of Replicat
Database Recovery Using Redirected Incremental Restore
(Roman B. Melnyk) Suppose your database server is destroyed by fire. Luckily, you have a good backup strategy in place. This strategy includes remote storage of backup images and recovery logs. The set of backup images that you have at your disposal includes full database backup, online incremental
Comparing Business Intelligence Platforms
(Thierry D’Hers and Stacy Vickery) This white paper compares the features of Microsoft® SQL Server™ 2000 Analysis Services, IBM DB2 OLAP Server 8.1, and Hyperion Essbase 6.5. As you’ll learn, Analysis Services has functionality that compares favorably against other offerings such as IBM DB2 OLAP Se
XML Capabilities – FOR XML Clause
With the release of SQL Server 2000, a lot more support and functionality for XML was included in the product. In this article we would target at some of the out of the box functionality that SQL Server 2000 offers us to convert our relational data as XML formatted data. Not wasting much of the time
Longhorn for Developers – A Brief Introduction
(Mahesh Chand) Before we look at Longhorn programming model, let’s take a quick look at current programming model in Windows. In Windows, we can write two types of applications – Windows based or Web based. In .NET, usually we use Windows Forms to write Windows applications and Web Forms (ASP.NET)
Put Your Sensitive DB2 Data Under Lock and Key
(Kulvir Singh Bhogal) Hackers are trying to find some way to get into your database. If you think they’re not, you’re just deluding yourself. The news stories about compromised credit card numbers are proof that the best way to lose face with your customers is to let a hacker steal their sensitive d
Get Oracle stored procedures to work in ADO.NET
With the recent release of the .NET Managed Provider For Oracle, .NET developers finally have a high-performance way to access Oracle data using ADO.NET. In a previous article, it was discussed how to connect to and execute SQL statements against Oracle databases using the Oracle managed provider. N
Identity Management in Oracle 10g
(Fred Sandsmark) Who are you? It’s a question Oracle users are constantly asked by dozens of login screens every day. “The most important thing in any security consideration is the concept of who—the identity,” says Uppili Srinivasan, director of Oracle’s Identity Management and Security Products. I