(Alex Fatkulin) I wrote this post because I feel there is a great need for it. The number of people struggling with unstable query plans due to bind peeking in Oracle 10G is enormous, to say the least. More than that, solutions like disabling bind variable peeking are driving us away from understand
Other News
.NET Debugging Demos Lab 6: Memory Leak – Review
(Tess Fernandez) Since it took me so long to get Lab 6 out the door i’ll post the review right away… After this we only have one memory leak lab to go before you have gone through the whole lab set.
Dealing with NULLs
(Arjen Lentz) I frequently see a question fly past on why an expression like WHERE col = NULL does not come up with the desired result, even though it superficially looks perfectly sane. To address this, we can recap some high school maths, and at the same time finally find out that some things lear
LINQ to XML
(Mark Nischalke) Working with XML using Microsoft’s .NET Framework in version 2.0 and below is a cumbersome task. The API available follows the W3C DOM model and is document-centric. Everything begins with the document; you can’t create elements without having a document, even a fragment of XML, is
Using the script task to dynamically build SSIS package variables
(Hal Hayes) One of the advantages of using SSIS is the ability to dynamically create tasks that can take different elements and manipulate them in code instead of having to hard code the package to do only one task. In a previous tip we looked at how to use expressions to dynamically build an output
SOA is a Means – Not an End in Itself
(Robert Catterall) Here’s a news flash for you: SOA is sometimes oversold. Hard to believe, I know, but it’s true.
REST in PostgreSQL Part 2 A – The REST Server service with ASP.NET
(Leo Hsu and Regina Obe) Download the npgsql 1.01 driver from pgfoundary – http://pgfoundry.org/projects/npgsql. For ASP.NET 2.0 you’ll want – Npgsql1.0.1-bin-ms2.0.zip and for Mono.NET you’ll want Npgsql1.0.1-bin-mono-2.0.zip. Unzip and place the files in bin folder of your web app project.
MySQL Error Message Nonsenses
(Peter Zaitsev) What MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives you information about tokens near by but little details:
Binding a generic collection to a DataGridView via Visual Basic 2008 code
(Alessandro Del Sole) This is a typical article which raises from a practical situation. I needed to bind a DataGridView to a generic collection of custom classes, in an application written in Visual Basic 2008. The objective to reach is that, whenever editing, adding or deleting items from the Data
Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps
(Paul S. Randal) Well this one is well overdue and I’m in the middle of writing a class where I want to reference this blog post – so I suppose I’d better write it!! This is an updated post from my old Storage Engine blog that now covers DIFF and ML map pages.