(Bob Beauchemin) Learn how to use the new notification technologies in ADO.NET 2.0 and SQL Server 2005 to handle ad-hoc data refreshes.
Other News
Meet the Experts: Why IBM is open sourcing Cloudscape as Derby
(Jon Prial) At LinuxWorld in San Francisco, IBM announced that it was releasing Cloudscape, a fully relational Java database as open source to the Apache Software Foundation, which has established it as an incubator project under the name “Derby.” This is the latest in a long series of commitmen
MSDE With SQL Web Data Administrator : Authorization
(Scott) In our previous article we examined authentication with MSDE. In this article we will take a close look at authorization. Specifically, we will see how to use and manage database roles, and how to grant, revoke, and deny permissions to database objects and statements. If you need to inst
The XML Litmus Test
(Dare Obasanjo) This article provides some simple guidelines for determining when XML is the appropriate technology to use in a software application or architecture design.
Operating DB2 DataPropagator
This chapter describes how to operate the Capture and Apply programs generally. This chapter also describes regular database maintenance, monitoring replication, handling gaps, and modifying your replication configuration.
eServer i5 and DB2: Business Intelligence Concepts
Business Intelligence (BI) is a popular and powerful concept of applying a set of technologies to turn data into meaningful information. With Business Intelligence Applications, large amounts of data originating in many different formats (spreadsheets, relational databases, web logs) can be consoli
A Baker’s Dozen: Thirteen Things You Should Know Before Porting Your Visual C++ .NET Programs to Visual Studio 2005
(Stanley B. Lippman) This article discusses issues that developers should be aware of when porting applications to Microsoft Visual Studio 2005.
Using Oracle’s Redefinition Package for Performing Online Reorganizations
(Tom Szekely, Gil Candia and Danny Pham) This paper discusses the use of Oracle’s Redefinition Package to perform online reorganizations in Oracle 9i and 10G databases. The paper describes the redefinition process, the commands used to perform the redefinition online, and certain limitations an
Multiple Active Result Sets (MARS) in SQL Server 2005
(Christian Kleinerman) All Microsoft SQL Server data access application programming interfaces (APIs) provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most on
Delegates vs. Interfaces in .NET
(Jon Shemitz) When you write .NET code that takes callback parameters, your first instinct may be to use delegates, but it may not occur to you that you can use an interface instead. Learn why and when an interface may be a better answer.