(Nigel Rivett) A common requirement is to process files from an FTP directory. Often this is done by processing every file in the directory and moving each file to an archive directory after processing. Therefore, on the next run, the “live” directory will only contain unprocessed files and the “arc
Other News
SQL Server 2005 Command Line Tool ‘SQLCMD’ – Part I
(Muthusamy Anantha Kumar) Microsoft shipped the SQL Server 2005 command line tool “SQLCMD” along with SQL Server. This SQLCMD replaces the old ISQL command line utility and the OSQL utility. This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
Performance Impact of Enabling Page Checksum and Default Trace
(Linchi Shea) “Should I keep the database page checksum and the default trace enabled on SQL Server 2005?” That is a frequently-asked best practice question. Out of box, these two options are enabled. Although you can argue about the pros and cons of enabling or turning off these options, it is most
A Successful Enterprise Data Warehouse? The Four Biggest Reasons for Failure
(Ad Stam) Many large organizations are preparing or executing projects with the aim to improve business intelligence (BI) delivery by implementing a data warehouse on an enterprise scale. However, in practice, it proves to be very difficult to bring such ambitious projects to a successful implementa
Show 51: Database, managing user expectations, 60 second tip of the day and more.
Pro-Center Video Programming for IT Professionals
Inherent AJAX Security with Java and JSF
(Stephen Maryka) With the popular adoption of AJAX techniques mushrooming on the web today, real-life security issues were sure to follow, as illustrated by the Yamanner and MySpace worms. The debate over AJAX security now rages, with widely differing opinions. Just google “AJAX security” and you wi
Making XML in a Rails App
(Deepak Vohra) Ruby on Rails is a database-based web framework. An XML document may be created and parsed with Ruby on Rails. Rails provides a Ruby library called Builder to generate XML markup. The Builder package contains class Builder::XmlMarkup to generate an XML document. In this article, we wi
z/OS Version 1 Release 8 RACF Implementation
(Paul Rogers, Rogerio E. M. Camargo, Gillian Gainsford and Rita Pleus) This release of RACF in z/OS V1.8 continues to deliver industry leadership for security. Improvements that are all intended to help deliver the kind of security-rich environment that has made z/OS an industry leader includes the
A Security Overview of Microsoft Visual Studio 2005 Team Edition for Database Professionals
(Richard Waymire) Microsoft Visual Studio 2005 Team Edition for Database Professionals (DB Pro) is the most recent addition to the Microsoft Visual Studio Team Suite of products. The mission of this product is to bring developers of database application code (Transact-SQL for Microsoft SQL Server 20
Getting Started with .NET Programming
(Julia Lerman) Ready to get started with .NET programming? There are two important aspects you’ll need to know. The first is a basic understanding of what the .NET Framework is. The second is where to find great resources. In this article, I simplify the process of getting started with .NET.