(Arthur Fuller and Stephen Giles) Microsoft SQL Server 2005 contains a number of major new features, but the feature that we like the most is the SQL Server Management Studio. This tool is leaps and bounds beyond what was available in earlier versions of SQL Server. Here is a list of the 10 things t
Other News
Securing your web application against dangerous request
(Abey George) While programming with web applications it is common to split the task to different pages. Most of the times we will have to pass parameters to other pages using query string and sometimes it is the only viable method to accomplish certain tasks. You can pass values to other pages usi
FIX: You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000
When you try to delete records by running a Delete Transact-SQL statement in Microsoft SQL Server 2000, you receive the following error message: Server: Msg 601, Level 12, State 6, Procedure testprocess, Line 7 Could not continue scan with NOLOCK due to data movement.
Data Warehouse Design Review Checklist (Sample Chapter)
W.H. Inmon) One of the most effective techniques for ensuring quality in the operational environment is the design review. Through a design review, errors can be detected and resolved prior to coding. The cost benefit of identifying errors early in the development life cycle is enormous. (R)
Deriving Order from Chaos: Creating an Information Integration Strategy
(Dennis Cahill) Disconnected departmental knowledge systems make it difficult for employees to find the information they need to make critical decisions. Marketing portals, CRM (customer relationship management) systems, financial tracking systems and collaboration solutions are important tools, yet
Generating a JSF Data Table
(Deepak Vohra) Oracle JDeveloper supports the JavaServer Faces (JSF) standard for building Web-based user interfaces (UIs). Oracle JDeveloper 10g Release 3 (10.1.3) bundles the reference implementation of JSF v1.1, including both the JSF HTML and JSF Core tag libraries. The JSF HTML tag libraries pr
Force SQL Error Log Switch :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 only Description:
Writing MySQL Programs Using C (Sample Chapter)
(Paul Dubois) MYSQL provides a client library written in the C programming language that you can use to write client programs that access MySQL databases. This library defines an application programming interface that includes the following facilities: –Connection management routines that establ
Making Mistakes with XML
(Sean Kelly) Since the first publication of the XML 1.0 Recommendation in 1998, hundreds of applications, data models, document formats, tools, specifications, libraries, references, tutorials, books, papers, excitement, enthusiasm, and energy have exploded onto the scene, making this relatively sim
Mixed Reaction to Oracle Fusion from J.D. Edwards Users
(Alex Woodie) Users of the J.D. Edwards ERP systems are offering differing views on how Oracle’s Fusion application and integration strategy will effect their long-term plans. The software giant says its half-way to completing Fusion, a new suite of Java-based ERP applications that are due to be rol