(Marcus Whitney) When you have publicly available forms on the Web, you are always prone to attack by people who want to use your application for their own purposes. Forums, polls, guestbooks, and blogs are the popular places for robots to try to generate inauthentic posts on your site. Many sites,
Other News
The SQL Server 2005 Paradigm Shift
(Stephen Swoyer) Skeptics who question Microsoft’s decision to integrate its .NET CLR with SQL Server 2005 tend to use the language of doomsayers such as Jeremiah or Cassandra to make their points. They believe in-process CLR is an insanely bad idea that could jeopardize the scalability and reliabil
IBM Has Some Tall RFID Plans
IBM is ramping up its efforts to compete in the emerging market for products that communicate environmental data to I.T. systems for analysis — which Big Blue says could represent a $20 billion opportunity by 2007.
Building an Enterprise Service Bus to Support Service Oriented Architecture
(Joseph Poozhikunnel) The intent of this article is to define an Enterprise Service Bus (ESB) that can be created to support any Service Oriented Architecture (SOA) adopted by an organization. The type of ESB required could vary as there is no “one size fit all” available. Therefore this article def
IBM Informix Dynamic Server Enterprise Replication templates
(Pravin Kedia) Introducing IBM Informix Dynamic Server, Version 10.0, Enterprise Replication templates. Learn how to use templates to administer a large number of Enterprise Replication nodes and tables. The template feature is not currently available in the replication products of competitors.
Letting Java in on SQL Server Notifications
(Laurence Moroney) Starting with SQL Server 2000, Microsoft added the concept of notification services to their flagship database engine. SQL Server Notification Services lets you generate and send notifications whenever some criterion is met. Generally, you use notifications to alert or update data
Get Ready for the Process Warehouse
(Guy Creese) Data warehouses have now been with us for over a decade and will be with us for many years to come. However, with virtually all business data now created electronically and the price of storage dropping like a rock, a new type of business intelligence repository is starting to appear –
Executing SQL Statements in VBA Code
(Danny Lesandrini) There are a number of ways to execute a SQL Data Manipulation Language (DML) statement from Microsoft Access, besides the obvious process of creating an Action Query and double-clicking its icon. Understanding your options with respect to executing SQL will make your code cleaner,
Say goodbye to system tables in SQL Server 2005
(Adam Machanic) Microsoft SQL Server DBAs, think fast! Without using any documentation, write a query that pulls a list of indexes from the SQL Server 2000 system tables, enumerating each index’s columns and whether the columns are sorted ascending or descending. You have two minutes. Go! (R)
Using a Property to store an Array
(legalAlien) I found I had a need to store simple arrays in properties for easy retrieval throughout an application such that they may be set in formA, displayed in formB or reportA, further changed by formC and then viewed again in formA or formB or reportA or reportB. This is not the only solu