(Hmanjarawala) This article describes use of IEnumerable interface for Collection types.
Other News
ODI 11g – Oracle Multi Table Insert
(David Allan) With the IKM Oracle Multi Table Insert you can generate Oracle specific DML for inserting into multiple target tables from a single query result – without reprocessing the query or staging its result.
Exposing the Oracle Alert Log to SQL
(Neil Chandler) I’ve been spending some time working in Apex recently, building a small app to draw together the monitoring of application and infrastructure components into a single easy-to-visualise tool. As part of that, I wanted to be able to read and report on the alert log.
SharePoint: Create a Document Dashboard with Dynamic Related Items
(Benjamin Niaulin) I would like to see Related Tasks, Related Discussions and any other related items for Each document that I have in my document library. And if I click on Add New Task while I am working with a Document, I want the task to associate itself to that document automatically.
MySQL REGEXP Error
(Michael McLaughlin) While working through prepared statements in MySQL, there was an interesting regular expression question raised. A student wanted to know how to address the following error message:
IBM Cognos Proven Practices: Use Case: Diagnosing a Server Startup Issue with the IBM Cognos Diagnostic Tool
A client calls IBM Cognos support and indicates one of their IBM Cognos BI servers in a multi-server environment will not start. The support analysts leverages the IBM Cognos BI Diagnostic Tool to gather information to solve the case.
ColdFusion 10 – Native WebSocket Filtering And Channel Listeners Are Mutually Exclusive
(Ben Nadel) In the ColdFusion 10 documentation regarding WebSockets, both the publish and subscribe functions mention that special data parameters can be used to filter incoming and outgoing messages. In my previous blog post, I looked at using the WebSocket application pseudo-events as a means to e
Auditing sysadmin on multiple servers using PowerShell
(K. Brian Kelley) I have a requirement to periodically audit for members of the sysadmin role across all my servers. I’d like to automate this and I’ve heard PowerShell is a good match. In order to feed a downstream governance application, I’d like to simply output the members into text files. How c
Modern Documentation for a Non-Waterfall LifeCycle
$$SWYNK$$ Featured Article(s) Troubleshooting problems with SQL Server 2008 R2 alerts In this article, Alexander Chigrik explains some problems you can have with SQL Server 2008 R2 alerts. He also tells how you can resolve these problems. Featured White Paper(s) Demystify Tempdb Performance and Management In this white paper, Robert L Davis demystifies the best practices that work some of […]
Modern Documentation
Featured White Paper(s) Encryption & Key Management for Microsoft SQL Server 2008 Written by Townsend Security Simplify encryption and key management on … (read more) Featured Script convert_ident_to_guid.sql Script to find all ident columns in db, find out if they are in an index, (if so)drop the index, recreate the ident as guid, … (read more) Modern Documentation We had […]