(Sanders Kaufman, Jr.) If you’re a Microsoft programmer, you have probably invested quite a lot in the transition from Windows NT/SQL Server 7 to Windows 2000/SQL Server 2000. The transition to Longhorn/Yukon is going to require a similar investment. Enhancements to SQL Server (Yukon) will include m
Other News
Build a PL/SQL Web Service
(Jason Price) As we’ve all learned by now, the web services model has proven to be an efficient way to connect applications. Web services protocols such as XML, the de facto standard for information interchange; SOAP (Simple Object Access Protocol), which allows you to exchange XML documents in a di
Tapping RSS with Shell Scripts
(Dave Taylor) If you’re like me, you want to keep up with the latest news and information. Shell scripts help me do just that. In this article I’ll show you how I wrote a shell script that watches the news at Slashdot.org and automatically shows me the latest story headlines every time I launch a Te
Using INSTEAD OF triggers
(Alexander Kuznetsov) First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful when you need to modify the database structure without changing the applications running against the changed database. In other words, you may use INSTEAD OF triggers and views to isolate applications from ch
How to use XML in connected and disconnected ADO.NET applications in Visual C++ .NET 2003
XML is a fundamental part of Microsoft ADO.NET and XML Web Services. This article describes how to use XML in connected and disconnected ADO.NET applications: –Connected ADO.NET applications can query Microsoft SQL Server to return an XML result and then use the XmlReader class to iterate throu
Independence Day
(Andrew Ward) DB2 for z/OS v.8 provides a host of partitioning changes that bring better query performance, more efficient use of utilities, and other benefits of true physical partition independence.
Oracle Backup and Recovery
Backup and recovery is one of the most important aspects of database administration. If a database crashed and there was no way to recover it, the devastating results to a business could include lost data, lost revenue and customer dissatisfaction. Whether companies operate a single database or mult
HOW TO: Program the SQL Snapshot and SQL Distribution Control by Using Visual Basic .NET
You can use the SQL Server 2000 Replication ActiveX controls to embed replication functionality inside custom applications. This article describes how to program the SQL Snapshot and SQL Distribution controls by using Microsoft Visual Basic .NET.
Reporting Services Part I: Overview, Architecture and Installation
(James Luetkehoelter) So it’s here. Finally. For those of you who haven’t had a chance to work with the beta, it’s probably a good idea to download the evaluation version and start. This add-on should be widely adopted in a relatively short time. It doesn’t matter if you’re primarily a developer or
Get the Next
(Marco Gilbert) Here is a function to get the next “D” day in Oracle Database.