(Nicholas Chase) The need to transform XML is so common that Extensible Stylesheet Language Transformations (XSLT) is considered one of the basic XML specifications. This tutorial explains how to create XSLT stylesheets. It also covers the basics of XPath, which enables you to select specific parts
Other News
The Trial-and-Error Method for Data Architecture
(Rick Sherman) As a coach of my sons’ soccer teams, I’ve noticed something that occasionally holds back the ambitious players. Rather than focusing on basics, such as learning good ball control, they are seduced by the lure of scoring. But without good basic skills, they don’t have the ability to sc
Handling Database Writes in Data Access Layer Management
(Paul Kimmel) My first article on this topic demonstrated database reads-to-entities. Reads are relatively easy. Just read one or more result sets and build objects; you don’t need transactions. This article demonstrates database writes. The write part of managing a data access layer (DAL) is where
The .Net Developer And SQL Server: Know Your Locks
(George P. Alexander, Jr.) In my last post on what we .Net developers would need to know regarding SQL Server, we had a look at how locking comes into the picture with respect to performance in our application. We understood why Locks are necessary: basically to maintain data concurrency. ie, while
Review: Oracle Performance Tuning for 10gR2, Second Edition
(Steve Callan) Within Oracle, performance tuning (sometimes referred to as performance and tuning) is by far one of the hardest subject areas to master. There are no shortcuts to being good at tuning an Oracle database, but there certainly are a lot of tools and advice covering the specifics of how,
Using Fuzzy Lookup Transformations in SQL Server Integration Services
(Michael K. Campbell) Left unchecked, poor data integrity costs businesses billions of dollars each year by negatively impacting business intelligence and decision support systems. Poor data integrity can also wreak havoc with inventory and contract management applications – to say nothing of all of
New Index Locking Granularity in SQL Server 2005 Gives You More Options
(Brad M. McGehee) While most DBAs are familiar with how locking works with tables, few DBAs are familiar with how SQL Server 2005 applies locking to indexes. That’s right, indexes, just like tables, are subject to locking. And as most DBAs already know, inappropriate locking (in tables or indexes) c
Performance Impact of Querying SQL Server 2005 Scheduler-Related DMV’s
(Linchi Shea) In their excellent whitepaper "How to Diagnose and Correct Errors 17883, 17884, 17887, and 17888", Bob Dorr and Sameer Tejani put forward the following warning regarding querying about the activity of the SQL Server 2005 schedulers: "Warning: These dynamic management views (DMVs) ar
Interoperability between WCF and Oracle Application Server – Part1
(John Charles Olamendy) This article is part of series intended to show how to use Web Services related technologies to interoperate applications running in different platforms, in this case, the most common scenario between Microsoft.NET and Oracle AS platforms.
Building Office Open XML Files
(Ted Pattison) Welcome to Office Space, a new column devoted to developing with and for the Microsoft Office system. In this column, I will be exploring how you can extend and customize Microsoft Office system applications and file formats. With the 2007 Microsoft Office system, Microsoft has introd