(Jayaram Krishnaswamy) XML integration with the Microsoft .Net Framework 2.0 provides the XMLDocument class for working with XML. Loading an XML document, a task needed in many web applications, can be accomplished using several forms of the Load() method. The article introduces you to several of th
Author: SSWUG Research
Data Warehouse Design in the Real World, Part 1
(William McKnight and Mike Cross) There is a notion that all of an organization’s data, both current and historical, needs to be in the enterprise data warehouse, regardless of its current or future necessity. In today’s world of exploding data, limited resources and viable architectural alternative
Looking at the WCF Windows Communication Foundation
(Jayant Kulkarni) To make your life as a developer easy, Microsoft continuously brings new technologies to the market. Sometimes, these technologies are similar to existing technologies, and at other times large enhancements are made in the current technologies. As a result, at times you see the pro
Enumerating projects in a Visual Studio solution
(Serge van den Oever) People writing add-ins for Visual studio probably have come across the nightmare of the Visual studio object model to go through the projects within a solution. I had to get the list of projects in a solution, and for each solution its output path in the current configuration.
Setting up Db2 v9 as a Coldfusion Datasource
(Victor Rubba) In the last few weeks I’ve had the opportunity to get to know Coldfusion just a little bit better. One of the first challenges I faced is getting CF talking to Db2, so I could take advantage of the CF Extensions for Flexbuilder and that funky Wizard. To be precise I used ColdFusion MX
Oracle moves a step closer to Fusion
(Arif Mohamed) The launch of Oracle E-Business Suite 12 last month is a major step towards Oracle’s first fully standards-based, service oriented architecture (SOA) suite, Fusion Applications due in 2008.
Understanding the Falcon Transaction Storage Engine – Part 2
(Robin Schumacher) In Part 1 of this article series, we looked at how the Falcon transactional storage engine was architected and how it compared to some of the other MySQL storage engines. In this article, I’ll focus on how Falcon performs transaction management, including some special points on wh
Running totals in SQL Server queries
(Arthur Fuller) You’re tasked with creating a SQL Server query containing running totals based on the moment of the event. The classic example is a bank account.
An Overview of Cryptographic Systems and Encrypting Database Data
(Erich Peterson and Siqing Li) As the attacks in which hackers use become more and more sophisticated, and the programs in which they attack become increasingly complex, encryption is becoming the last line of defense in database management system (DBMS) security. Since Microsoft announced their Tru
Oracle RAC Administration – Part 15: Connection Load Balancing and FAN
(Tarry Singh) In our last article, we looked at the service architecture. We will continue our quest to understand the workload characteristics and the load balancing connections in our Virtualized RAC.