(Anant Jhingran) First, as I have said, I want to thank Curt Monash for this term — I had been using the term “schema variance” but I will move to poly-structure, or at least promote it the way to talk about it. Curt has an excellent blog on it here.
Other News
HOWTO: Convert from W3C XML DateTime format to Oracle Timezone
(Marco Gralike) Most XML datetime information is represented like the following:
A Quick SQL Trick: Find The Number of Commas
(Craig Mullins) Today’s blog post is a short one. I was recently asked how to return a count of specific characters in a text string column. For example, given a text string, return a count of the number of commas in the string.
Understanding SQL Server Service Broker Authentication
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applications
The ‘Balanced Data Distributor’ for SSIS
(Len Wyatt) There is a new transform component available for SQL Server Integration Services. It’s called the Balanced Data Distributor (BDD) and the download is available here. The BDD provides an easy way to amp up your usage of multi-processor and multi-core servers by introducing parallelism i
Why we link …
(Michael Hausenblas) The incentives to put structured data on the Web seem to slowly seep in, but why does it make sense to link your data to other data? Why to invest time and resources to offer 5 star data?
Projecting Indexes with LINQ
All sequences have a notional order that can be expressed using index values in a similar manner to the indexes of an array. When projecting sequences using LINQ’s Select and SelectMany operators, this index value can be included in the projection.
SSIS: Custom Logging Using Event Handlers and SQL Server Job Scheduling
(Vishal) Generally we use the logging provided by SQL Server Integration Services (SSIS) in a database that contains metadata about SSIS packages. This allows us to easily have a corporate standard for what actions are logged and takes advantage of the work Microsoft did to create the logging system
Export/Import an Oracle database with date range without constraint issues
(Sekhar) While exporting/importing a huge Oracle database with a certain date range, we may come across dangling records. That means a child table that has missing parent keys. In this article, steps are given to ensure safe export/import without any database constraint issues.
How to Add Text Over an Image
(Ged Mead) Some time ago, I wrote an item that described how to add text on top of an image in Windows Forms. Basically, this involved using the DrawString method of the System Drawing Graphics class. It wasn’t particularly difficult, but still took a bit of work.