(Alex Papadimoulis) In most installations, SQL Server acts as the bottom layer in a standard application stack (user interface, middle tier, and database). Users rarely know what type of database they’re using, let alone access and use it directly. For this reason, database security configuration is
Other News
Introducing DB2 Viper, Part 1: Data compression in DB2 Viper
(Rav Ahuja) Disk storage systems can often be the most expensive components of a database solution. For large warehouses or databases with huge volumes of data, the cost of the storage subsystem can easily exceed the combined cost of the hardware server and the data server software. Therefore, even
Oracle 10G Development: Oracle-MS SQL Server Integration Tips
(Boris Makushkin) Two Worlds, two different ideologies, two constant rivals – is it possible to give more precise description for two RDBMS World giants – Oracle Database and MS SQL Server? Mountains of TPC tests, proving superiority of one or the other side. Legions of supporters for one product
Oracle: Deleting Duplicate Rows Efficiently
(Tim Procter) If you’ve made the mistake of forgetting a primary key on your table, it can be frustrating to find a way to delete all of the duplicate rows without deleting the initial instances.
Elements and attributes: modeling relational data in XML, part 1
(Kevin Williams) This article is the first in a series that looks at the steps involved in modeling relational data in XML. We look at the three major components of a relational database—tables, columns, and the key relationships among them—and see how to best model each in XML.
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
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
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
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
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