(Bob Watkins) As I continue to teach Oracle 9i, I find more database administrators (DBAs) running current versions of the software but still living within the limitations of older versions. Here are five more things that it’s time to unlearn about the Oracle database.
Author: SSWUG Research
.NET XML Best Practices: Choosing an XML API
(Aaron Skonnard) As someone who has spent the past several years learning and using the various XML APIs available throughout the industry, I can honestly say that the .NET implementations are the best I’ve seen in terms of productivity, efficiency, and extensibility.
Documentation Search with DB2 Information Center
In addition to the product manuals for DB2, the DB2 Information Center gives you searchable access to DB2 information. This technote describes how to do it.
Restore multiple DTS packages
(Muthusamy Anantha Kumar) This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box. When many DTS packages reside as structured storage files, it can be tiresome
Using Triggers In MS SQL Server
(David) Designing a database for a large-scale web application is a monstrous task to say the least. It can however, be made easier by taking full advantage of the many tools, utilities and built-in objects that come with a Relational Database Management System (RDBMS), such as Microsoft SQL Server
Beyond the Hype: Succeeding With SOA Through Patterns
(Mark M. Davydov) There’s little doubt that component reuse and increased flexibility are major objectives flowing out of the popularity of service-oriented architecture (SOA). Companies of all kinds and sizes are focused on reducing costs as well as business risk; they’re improving the delivery
ASP.NET Caching: Techniques and Best Practices
(Steven A. Smith) ASP.NET provides three primary forms of caching: page level output caching, user control level output caching (or fragment caching), and the Cache API. Output caching and fragment caching have the advantage of being incredibly simple to implement, and are sufficient in many cases.
ADO.NET – A Data Access Layer
(Patryk Nowakowski) With the release of ADO .NET Microsoft has fundamentally changed the way of database applications development. The new version of ADO introduced with .NET Framework is extremely flexible and gives developers a wide variety of tools for handling common database programming tasks.
SQL Server 2000 Report Pack for Microsoft CRM
The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new report
IMS Technical Conference
The IMS Technical Conference has been rescheduled to November 1-4, 2004 at the same hotel – the Hilton in the Walt Disney World Resort. The IMS Technical Conference is where you can gain technical skills that can help expand the capabilities of your enterprise. If you want to integrate your mis