(Jamie Thomson) A common requirement when building a data warehouse is to be able to get all rows from a staging table where the business key is not in the dimension table. For example, I may want to get all rows from my STG_DATE table where the DateID is not in DIM_DATE.DateID.
Other News
Replicating Stored Procedure Execution
(Muthusamy Anantha Kumar) In OLTP environments, you often find batch jobs that move historical data to archive tables. In addition, there are often some batch jobs that purge historical data from the OLTP tables. These types of jobs can perform a lot of transactions and create additional overhea
XML 2004: After Declaring Victory, What’s Next?
(Kendall Grant Clark) This week I’m attending XML 2004 Conference and Exhibition, organized by IDEAlliance, at the Marriott Wardman Park Hotel in Washington, DC. Titled “XML: From Syntax to Solutions,” North America’s premiere XML conference is moving in the same direction as XML.com and XTech 2005.
Running .NET on Linux with DotGNU
(David McAmis) Who said .NET only runs on Windows? In this article we take a look at DotGNU and how you can get .NET applications running on Linux and other flavours of Unix.
Lookup Table Madness
(Don Peterson) Over the years I have had a number of “discussions” about the practice of creating generalized “lookup” tables for storing multiple code types in a single table. I won’t keep you in suspense about my view of this practice; the idea stems from a failure to learn and appreciate the f
SQL MAIL Using POP3 and SMTP
(Gregory Larsen) How many times have you had problems sending SQL MAIL or SQL Agent Mail from SQL Server because the Exchange server was taken down or not working? Have you ever tried to connect up SQL Mail and/or SQL Agent mail to Exchange through a firewall or across domains, only to find out that
In Wake of Training Scam, Oracle Says Buyers Should Beware
(Lisa Vaas) Following recent news about an Oracle training provider who allegedly scammed his customers, Oracle training experts had unanimous advice for consumers: Be a smart shopper.
An Introduction to the Web Services Architecture and Its Specifications
(Luis Felipe Cabrera, Christopher Kurt and Don Box) This introduction to the Web services architecture describes the design principles underlying the architecture and foundational technologies for Web services. Features are described and linked to the specifications that formally define them. Th
Making Your SQL Server Apps Highly Available: First, Do The Assessment (Sample Chapter)
(Paul Bertucci) Want your SQL Server apps to stand up to industrial use? In this sample book chapter, you’ll learn a rather formal approach to assessing and choosing a high availability solution. As you’ll learn, the key to success is doing as complete a job as you can on the assessment and usin
WebSphere for z/OS V5 Connectivity Handbook
(Tamas Vilaghy, Robert Cronin, Hidenori Fujioka, Mitch Johnson, Wilbert Kho, Rajesh P Ramachandran, Allen Schmutzler and Claus Schroeder-Hansen) This IBM WhitepaperRedpaper Redbook helps you install, tailor, and configure adapters and the Java 2 Platform, Enterprise Edition (J2EE) Connector Architec