(Arthur Fuller) A long time ago, I learned (the hard way) that you must anticipate the worst when working with SQL Server. In order to protect your software from someone with malicious intent—this could wind up being a disgruntled employee, a criminal with monetary intent, or a competitor wanting yo
Author: SSWUG Research
Log shipping in SQL Server 2000 can provide for automatic failover
(Michelle Gutzait) When it’s necessary to have disaster recovery or high availability architecture at the database level, you have a few options for implementing it, such as: –Windows clustering –Disk mirroring –- mirroring in the physical disk -level, such as RAID –Data replication –D
Introduction to XForms, Part 3: Using actions and events
(Chris Herborth) XForms is the next generation of Web-based data processing. It replaces traditional HTML forms with an XML data model and presentation elements. In this three-part series, you’ll be introduced to XForms and its capabilities, including the basic XForms model and form, the various typ
Importing a CSV Text File into Oracle 10G XE
(Jayaram Krishnaswamy) If you need to deal with legacy data by moving it to more recent databases, this article might help. It will show you how to move data from an MS Excel file into an Oracle 10G XE table.
Changing XSL StyleSheets on the FLY in C# and ASP.NET
(Mike Gold) This article shows you how you can use alter XSL in memory to transform XML data into HTML with different results.
STMM Part 4 – STMM and DPF
(Chris Eaton) In the past 3 postings I wrote about how to set up STMM and how it works to share memory between databases and within databases. Now for a bit of a more advanced topic which is how does STMM work when you are using Database Partitioning Feature (DPF). DPF allows you to distribute data
Oracle overhauls Sleepycat’s original Berkeley DB
(Mark Brunelli) Oracle unveiled a new version of Berkeley DB, the lightweight, non-relational and embeddable database management system (DBMS) that the firm acquired when it purchased open source stalwart Sleepycat Software Inc. back in February. (R)
Managing Information Overload
(David Baum) Jim Murphy, a research director at AMR Research covering content management, portals, collaboration, and search-and-retrieval technology, talked to Oracle Magazine about managing structured and unstructured information cohesively.
Generating PDF reports programmatically using SQL Server Reporting Services 2005, in C#
(Sivakumar Mahalingam) SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This article explains a way to create PDF reports programmatically using web services exposed by SQL Server Reporting Services 2005 in C#.
Make the Right Decision with Our Side-by-Side Comparison of Spring and EJB 3.0, Part 2
(Rod Coffin) This is the second article in a two-part series comparing Spring and EJB 3.0. The first article looked at how each technology addresses persistence, transaction management, and state. In this article I’ll continue the analysis by looking into other characteristics such as messaging, rem