(Muthusamy Anantha Kumar) In the typical IT department, an un-avoidable task is to monitor the disk space on all drives on certain servers. In addition, the methods presented here will help in monitoring the growth of files. In this article, I am going to discuss three different ways to monitor disk
Other News
Mapping files into SOAP requests, Part 2
(Benoit Marchal) In 2001, I demonstrated to one of my skeptical clients that a Web service can be easy to deploy in the field. My goal was to replace most of my client’s administrative paperwork with a Web service, thereby “fastening” their supply chain. The acid test was to deploy the Web service t
XML, T-SQL, and the CLR Create a New World of Database Programming
(Eric Brown) The next version of SQL Server, code-named “Yukon,” includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined f
SQL Server 2000 DTS Part 7 – DTS Designer Tasks: the ActiveX Script task
(Marcin Policht) If you have been following our series of articles discussing SQL Server DTS technology, you probably have noticed frequent references to ActiveX-based scripting. While scripting is not very popular among database administrators, its potentials are worth exploring, especially sin
Serialize Objects to XML in .NET
(Dan Wahlin) The .NET platform provides the ability to save the state of an object using serialization techniques. If you’re not familiar with serialization, it’s a way to persist object data to another form such as binary or XML data. In this article, I’ll provide an overview of how to use XML Seri
Basics of C2 Auditing
(Dinesh Asanka) What ever the system that we are taking about, whether it is an ERP system or CRM tool or any database system auditing has become essential part of that system.. Auditing will allow you to: –Detect the misuse and prevent it being happened again. –Take legal actions against t
It All Depends on the CONTEXT: Using the SYS_CONTEXT Function
(Jim Czuprynski) During a recent code review of our production databases’ stored procedures and packages, I took the time to convert the objects from the deprecated (but still serviceable) USERENV function to its Oracle 9i replacement, SYS_CONTEXT. The conversion was relatively painless, of course,
DB2 Data Bound ASP.NET Form using VS.NET
(Abdul Al-Azzawe) With the release of DB2 V8.1.3, you can now quickly build data bound ASP.NET WebForms using the same drag-and-drop and design-time manipulation features you are accustomed to when building WinForm applications. In this simple DeptEmployees application, we will walk you through t
Asked and Answered
(Robert Catterall) I read your column “Time to Reconsider SMS,” and I agree with you regarding the advantage of defining DB2 user tablespaces under the control of the Storage Management System (SMS). But what about the DB2 Catalog and directory? Can you also define DB2 catalog and directory data set
If Oracle RAC Crashed Orbitz, Can We Trust 10g?
(Lisa Vaas) A few months back, the travel site Orbitz was grounded for a full day due to a technology snarl that it blamed on Oracle’s RAC (Real Application Clusters) technology. Considering that RAC is a cornerstone component of Oracle’s much-heralded and almost-here Oracle Database 10g and the who