(James F. Koopmann) This week I am looking at a product called Bind ImpactExpert by NEON Enterprise Software, Inc. NEON Enterprise Software, Inc. Monday I took a look their Webinar and Wednesday I took a look at their on-line demo. Since this is a z/OS product it was hard for me to physically test t
Other News
Back up and restore PostgreSQL databases
Ever accidentally deleted a database table, or had the disk with your live database crash? If so, you know all too well that sinking feeling you get when you realize that weeks of hard work just vanished into nothingness.
SQL Server 2005 XQuery and XML-DML – Part 2
(Alex Homer) This is the second in a series of three articles that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and query XML d
Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
(Jay Nathan) Data cleansing is an important task for data warehouse specialists, database administrators, and developers alike. Deduplication, validation, and householding techniques can be applied whether you are populating data warehouse dimensions, integrating new data into an existing transactio
Pragmatic Guidelines: Diagrams That Work (Sample Chapter)
(Martin L. Shoemaker) In the last chapter, we spent a long time working through the process of Five-Step UML, and looking at all of the new UML notation which that entailed. But in this chapter, we’re going to take a quick break from learning all the formal rules and all the step-by-step instruction
Service-Oriented Java Business Integration
(Frank Sommers) Java Business Integration (JSR 208) defines container services that enable system integration via Web service technologies and XML message exchanges. In this interview, JBI Spec Lead Ron Ten-Hove discusses how JBI will impact enterprise Java developers.
Streamlining Your Data Access Layer with Helper Methods
(Scott Mitchell) A well-architected ASP.NET application provides definitive boundaries between the application’s presentation logic, business logic, and data access code. That is, your ASP.NET web pages should consist solely of markup and logic for displaying data – the specific business rules and c
Simplify your Web page and form development with these 10 PEAR classes
One of the staples of Web site development is the manipulation of Web pages based on user interaction and the retrieval of user data using Web forms. While these functions can certainly be hand coded, there is another way. The PHP Extension and Application Repository (PEAR) contains hundreds of
FREETEXT Searches with SQL Server and ADO.NET
(Paul Kimmel) Data is king. Companies such as Google and eBay are based primarily on the value of their data. (In Google’s case, the data is actually indexes of data.) Providing access to data often is either mission critical to a company or the company’s raison d’être.
Undocumented stored procedure: View SQL Server 2000 raw data
(Serdar Yegulalp) SQL Server stores data in “pages” or allocation units of approximately 8,000 bytes. If you want to see the raw data in a given database page and interpret the information produced, you can dump that data to the console (or to the SQL Server log) using the undocumented DBCC PAGE com