(Greg Robidoux) Failing over to another system in a disaster recovery situation is the last thing you want to do. Although you won’t have to do this often, you may need to eventually — and it’s better to be prepared than not. (R)
Author: SSWUG Research
Serious scaling for open source databases
(Dana Blankenhorn) One of the biggest problems for those who want open source databasing is scaling.
Exception Handling in SQL Server 2000 and 2005
(Jagadish Chaterjee) This article mainly discusses and compares the features of exception handling in Microsoft SQL Server 2000 with the same features in SQL Server 2005.
Create, Export & Encrypt Connection String on Server and Dev Machine with ASP.Net 2.0
(Steve Schofield) This article covers some basic steps and commands to encrypt your connection string and other items in a configuration file using ASP.NET 2.0. Microsoft has made it easier to have a portable key that encrypts certain sections in a web.config that are normally clear text. I have not
Finding and Setting SQL*Plus Settings
(Steve Callan) SQL*Plus offers several handy features you can use to control your SQL*Plus session. The SHOW command works the same in both UNIX and Windows environments, and SHOW ALL can be used to display the settings or values of nearly 70 items. Instead of just showing these settings, SQL*Plus o
Implementing Active Directory Services in ASP.NET 2.0
(Peter Nichols) The advent of ASP.NET 2.0 and Visual Studio 2005 Express has kicked the door wide open for creating integrated applications. Many of the security tasks required for an applications authentication and authorization mechanisms to be hooked into Active Directory have been dramatically s
Domain Objects Caching Pattern for .NET
(Iqbal M. Khan) Caching greatly improves application performance because it reduces expensive trips to the database. But, if you want to use caching in your application, you must decide what to cache and where to put your caching code. The answer is simple. Cache your domain objects and put caching
ASP.NET Tip: Create a Smart Property to Instantiate Your Objects
(Eric Smith) When I’m writing Web applications, I may need to use lots of objects at various times while the application is running, but I generally don’t always need all of them. Each object that gets instantiated takes system memory, and I try to keep my applications as small as possible for the b
Seven Steps to XML Mastery, Step 3: Transform with XSLT (Part 1 of 2)
(Frank Coyle) In the previous articles along our path to XML mastery, we looked at some XML basics and explored how to separate content from display. At ZwiftBooks, where you’ve been hired to prepare the way for dynamic web content generation, your strategy revolved around using a limited subset of
An Introduction to BPEL
(Kumar Raj Moorthy) Business Process Execution Language (BPEL) is a XML-based language used to define enterprise business processes within Web services. Every company has its unique way of defining its business process flow. The key objective of BPEL is to standardize the format of business process