(Gregory A. Larsen) In my article last month, I wrote about different methods you could use to identify the state of a SQL Server Agent job. One of the methods I discussed was using the undocumented extended stored procedure (XP) “xp_sqlagent_enum_jobs.” In this article, I will show you how to u
Other News
Encrypting Critical Data in Oracle Databases with Ingrian Networks
As the incidence and severity of security breaches continues to grow, it is increasingly incumbent upon organizations to begin encrypting data inside the enterprise. Ingrian’s breakthrough solutions make it practical to encrypt critical data, and ensure it’s secured throughout an organization. With
Recover from import errors in Oracle
(Scott Stephens) When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus.
Configure DIME with WSE 2.0
(Nirosh) SOAP messages are not the best way to send large binary files. As the Web Services emerge, people look for Web services to have more and more functionality. Result was the introduction of Web Services Enhancement (WSE) 2.0. The Web Services Enhancements for Microsoft .NET (WSE) supports
A Brief Look at Mod_Python
(Peyton McCullough) Python’s Apache interpreter is available as an Apache module, mod_python. This module reduces the time it takes to deliver a given page to a client. It is also capable of a great deal more, including interacting with Apache itself in various powerful ways. This article gives you
Five Reasons for Using an O/R Mapping Tool…
(Iqbal Khan) So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really i
Working with Windows Forms Configuration Files in .NET 2.0 and Visual Studio 2005
(Guy Rish) Among the many new features in the forthcoming .NET 2.0 are the revamped System.Configuration namespace and the Visual Studio 2005 configuration editor. The new classes raise configuration for both desktop and Web applications to a new level of sophistication compared to prior implementat
MySQL Query Optimization (Sample Chapter)
(Paul DuBois) Database management systems implement abstract concepts but do so on real hardware bound by real physical constraints. As a result, queries take time—sometimes an annoyingly long time. Find out how to minimize your wait in this sample chapter.
Manage Localization of .NET Apps
(Liewen Huang) Suppose a salesperson on the other side of the world says he needs your enterprise application to support another culture by tomorrow morning so he can demonstrate it to prospective customers in a potentially large market. Whether you respond “No way” or “No problem” depends on how yo
DB2 System Performance Metrics
(Joel Goldstein) DB2 is a complex database management system, that has a major impact upon your overall processing environment. Installations are constantly looking for ways to measure, analyze, and control its resource consumption. This presentation assumes that the reader has a basic understan