(Muthusamy Anantha Kumar) In Part I and Part II of this series, we saw how to install the SQL Server 2005 Data Service component. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services and SQL Server Analysis Services on a host machine using an .ini
Author: SSWUG Research
Sizing up Oracle’s open source tactics
(Mark Brunelli) Oracle’s recent maneuvers in the open source software market are all about the upsell, according to one IT industry analyst. (R)
The changing face of Oracle
(Angela Eager) Oracle has in recent times not so much been throwing off the old to bring in the new, as hanging onto the old while adding the new. It has considerably changed the shape of its business and is now presenting a new face to the world.
Diagnosing SQL Server performance issues using sp_lock
(Tim Chapman) A common misconception among IT pros is that "locks are bad," and you must do everything possible to ensure database locking doesn’t prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use o
SQL Server clustering best practices
(Hilary Cotter and Geoff Hiten) SQL Server clustering is a high-availability technology for SQL Server instances. It involves the sharing of server resources between one or more nodes (or servers), which have one or more shared disks grouped into logical units called resource groups. A resource grou
Enabling flexible distributed business processes with SOA – an illustration
(Krishnendu Kunti and Bijoy Majumdar) Service-oriented architectures holds the promise to radically change business processes by replacing tightly coupled proprietary interfaces and data formats with standards-based reusable business interfaces. Conventional business processes and roles tend to be d
Seven Steps to XML Mastery, Step 4: Parsing and Processing XML (Part 2 of 2)
(Frank Coyle) In part 1 of step 4, we looked at SAX and DOM parsers and found that SAX provided a simple way to extract data from streaming XML without incurring the high memory cost of building a DOM tree in memory. Another dimension of SAX is its ability to link handlers to create SAX filter chain
Microsoft’s Open XML Project Deemed a Short-Term Fix
(Peter Galli) Microsoft’s move to set up an open-source project that will allow translation between its Office Open XML format and the OpenDocument Format is a welcome first step, but not a long-term solution to the problem, industry players said.
Oracle JDeveloper 10g Handbook: Build Java 2 Platform, Enterprise Edition (J2EE) Applications
(Avram Roy-Faderman, Peter Koletzke, and Paul Dorsey) Java client applications are standalone programs that run in a Java Virtual Machine (JVM) on the Client Tier. The user interface portion is usually written using Sun’s Swing components and other third-party components (for example, for graphs a
Tutorial: Changing the Visibility of Objects in Reporting Services
(Brian Knight) In the last tutorial in this series of Reporting Services tutorials we added conditional formatting to the report. Now that we’ve created our first report and have added a bit of flare to it, let’s go ahead and make it even cleaner. In this very quick demonstration, we’ll go ahead and