(Paul C Zikopoulos) One of the most frustrating tasks that database administrators (DBAs) have to perform is trying to figure out when one database application’s request is blocking another. Sure, most databases have built-in deadlock detectors and timeouts to help these sorts of issues work themsel
Other News
Achieving High Productivity with Your Linux Cluster
(Tom Quinn) This article provides a comprehensive outline of the factors that need to be considered to achieve the most productivity from your Linux cluster.
Developing .NET Web Services with Beta 2
(Aaron Skonnard) Version 2.0 of the Microsoft .NET Framework makes numerous improvements at various levels in the Web services protocol stack. In addition, better tool support and an increased focus on interoperability make your life easier. In this column I’ll walk you through several of the ma
IBM’s Banking Data Warehouse for Basel II
Basel II initiatives are at the top of all Financial Services’ Providers list. Download this white paper to learn how IBM’s Banking Data Warehouse can help accelerate Basel II initiatives at your company and deliver ROI quickly and consistently. (R)
T-SQL Tiebreakers
(Itzik Ben-Gan) A tiebreaker is a rule used to determine precedence between candidates when there’s a tie. For example, when soccer teams have the same number of points in the league, the one with the higher goal difference takes precedence. A tiebreaker in T-SQL is a rule that determines which
Thinking SQL: Set-based logic can improve query performance
(Robert L. Bogue) You can’t teach an old dog new tricks—at least that’s what the cliché says. Many developers intentionally try to be the “old dog” so they don’t have to learn new tricks. Some developers, even those who have been developing client server, Web-based, and smart client applications
Practical Date/Time examples with PHP and MySQL
(Mauricio Cuenca) This article shows some examples of how to use the date/time features with MySQL and PHP including the UNIX timestamp and the PHP date_diff() function.Some time ago working with dates and times was a pain for me. In several of my projects I had to calculate a person’s age based on
Explore alternatives to Visual Studio .NET
(Tony Patton) Visual Studio .NET is a powerful development tool, yet it’s often overkill or too pricey if you’re in a smaller shop or working on a smaller project. Thankfully, there are a myriad of alternative tools available. This article outlines the pros and cons of these alternatives. (R)
Microsoft CRM Integration: Oracle Database Access from MS CRM
(Boris Makushkin) Today’s article topic is a customization possibility demonstration for a user Web interface of Microsoft CRM. As an example, I’ll use MS CRM integration with ASP.Net application, accessing customer data access when customers are stored in an Oracle 10g database.
Using XML Schemas in BizTalk Server 2004
Schemas are required for most BizTalk Server applications because they are used to process and validate message information. This document covers the basic concepts of XML schemas and explains how they are used in Microsoft BizTalk Server 2004.