When you use merge replication that uses a custom resolver, the merge agent fails intermittently after you install Microsoft SQL Server 2000 Service Pack 4. When this problem occurs, you receive a message that resembles the following in the merge agent history log: Processing article ‘
Other News
Updated procedure for creating MySQL FEDERATED tables
(Roland Bouman) Three months ago, I wrote about a procedure to create MySQL FEDERATED tables.
Oracle Offers $3.3B For BI Power Hyperion
(Clint Boulton) Oracle agreed to buy Hyperion Solutions Corporation for $52 a share in cash a $3.3 billion deal that will make Oracle a leader in the lucrative business intelligence (BI) software space.
Introducing JSON
(Bilal Haidar) You have always used the Asynchronous JavaScript and XML (AJAX) to allow a web application to send asynchronous requests from the client browser to the server to retrieve some data and then let the client browser running your application receive a server response again in an asynchron
Asking the Right Question: Penetration Testing vs. Vulnerability Analysis Tools, Which Is Best?
(Dennis Hurst) Over the past several years I have heard people asking the question “should I use vulnerability analysis tools to assess my web based applications or should I look to penetration testing?” I think we, as an industry, may be asking the wrong question. First, let’s look at how the we
Notes from an Upgrade to SQL Server 2005
(graz) I recently worked with a client to upgrade their main database server from SQL Server 2000 to SQL Server 2005. Along the way I learned a few things and thought I’d share them. This article is a random collection of my "Thoughts from an Upgrade."
DB2 9 Fundamentals exam 730 prep, Part 6: Data concurrency
(Roger E. Sanders) This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 to maintain consistency in both single and multi-user database environments. This is the sixth in a series of seven tutorials to help you prepare for the DB2 9 for Li
How to subtract in SQL over samples that wrap
(Xaprb) This article explains how to do subtraction in SQL over samples that wrap back to zero when they exceed a boundary.
Serving SQL XML through a WebService (SQL2005)
(Russ Quinn) I recently needed to create a feed for a customer from some data held within SQL Server so looked around for the best (and quickest) way to do this. Knowing that I use SQL 2005 and that XML was an intregal part of it, I looked at ways to leverage this.
Dynamic SQL and Performance
(Craig Mullins) The performance of dynamic SQL is one of the most widely debated DB2 issues. Some shops try to avoid it, but in this day and age of ERP/CRM systems, Java/JDBC programming, and web applications, all of which heavily rely on dynamic SQL, its use is becoming more ubiquitous.