(Umachandar) SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot.
Other News
A flexible data integration architecture using WebSphere DataStage and WebSphere Federation Server
(Simon Harris and Susanne Englert) Combine WebSphere DataStage and WebSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of WebSphere Federation Server as a “data pre-processor” for DataStage, and demonstrates si
UDM in SQL Server 2005: Linking Relational and Multidimensional Databases
(Alexander Berger, Py Bateman, Irina Gorbach and Edward Melomed) The Unified Dimensional Model (UDM) of Microsoft SQL Server Analysis Services 2005 makes it possible for you to set up your system so that different types of client applications can access data from both the relational and the multidim
SqlCredit – Part 3: Schema/Proc Updates and Automated Unit Testing
(Rob Garrison) In this month’s installment, we will discuss updates based on feedback from part 2 as well as introduce automated unit testing.
How to find the max row per group in SQL without subqueries
(Xaprb) A while ago I wrote about how to select the first, minimum, maximum or least row per group in SQL. This article shows how to solve this problem without subqueries.
Hosting and Consuming WCF Services
(Chris Peiris and Dennis Mulder) This article discusses Windows Communication Foundation (WCF) hosting options and consuming WCF services. The traditional ASMX Web services were hosted only on Microsoft Internet Information Services (IIS). The hosting options for WCF services are significantly enhan
Pulling the Back-Room Data Warehouse onto Center Stage with RFID
(Harikrishna S. Aravapalli) Imagine a world where people, machines, products, buildings, computers, food, transport systems and more are all interconnected into a web of objects. The information about them is being captured, processed and analyzed in an event-based environment by an all-powerful, ce
Calling unmanaged function from within managed code
(Abey George Peter) Have you ever tried to called an unmanaged function (eg: MessageBox function inside the User32.dll ) with in a managed code? Let’s try to do that.
Use logon triggers to initialize user sessions in Oracle
(Bob Watkins) You may be aware of the old USERENV function, which returned session values such as the user’s session_id, language, and whether the user had DBA privileges. Although USERENV still exists for legacy reasons, it was superseded by a new function in Oracle 8i, SYS_CONTEXT.
Oracle extent allocation: AUTOALLOCATE vs. UNIFORM
(David) Starting with Oracle 9i, DBAs can now create locally managed tablespaces.