(Jim Mischel) Extension methods are a very clever bit of syntactic sleight-of-hand, and can be very useful in some situations. The LINQ standard query operators that add query functionality to the existing IEnumerable and IEnumerable(T) types are an excellent example of extension methods used well.
Other News
MySQL Proxy recipes: returning a dataset
(Giuseppe Maxia) How do you return a dataset using MySQL Proxy? This being a common task, as many that we will see in these pages, it is worth implementing with a function.
Oracle BI EE 10.1.3.3/2 – Choosing Multiple Columns in a Column Selector – Varying Multiple Columns in a Report
(Venkatakrishnan J) I received a very interesting question yesterday with regard to Column Selectors. As you would already be knowing, Column Selector allows the end users to vary the columns in a report. But there is no out of the box way to choose more than 1 column simultaneously. To be more prec
SQL Server Injection, Warehousing for Performance
New SQL Server Show Posted The weekly SQL Server show has been posted – we look at injection protection and recovery today, along with server protections, data warehousing for the rest of us, events, tips, trick, news and more. [Watch the show here] Featured Article(s) Oracle 2-Day DBA in x Days Post 4; Getting Enterprise Manager (dbconsole) to work It […]
Automatic form layouts with the TreeView
(Pavan Podila) Over the past couple of days I have been working on an application that automatically generates a Form layout from an XML file. The XML file represents a form with a bunch of parameters. The form can also contain parameter groups, which can encapsulate a set of parameters.
Planning a Semantic Web site
(Rob Crowther) The Semantic Web brings with it the opportunities for users to get smarter search results, and for site owners to get more targeted traffic as users find what they really want. But these benefits don’t just magically appear. This article leads you through the aspects of both informati
Discarding the Output of a Select Statement
(David Aldridge) I’ve wondered before about a convenient way to tackle a particular problem — you want to run a select for a big bunch of rows, maybe for measuring wait events for a tricky query, but you want to discard the output so you don’t incur the network traffic and waits to the client. You c
How To Identify the Database Links of a Failed Refresh Job
(Alex Gorbachev) From time to time, we get DBMS_JOB failures for failed refreshes that happen due to broken database links.
Need a DB2 for LUW DBA? Check out this one from Toronto
(Robert Catterall) The DBA I have in mind is DB2 itself – Version 9.5 for Linux, UNIX, and Windows, to be specific (and for those of you who don’t know, IBM’s Toronto Lab is the home of DB2 for LUW).
Role Based Forms Authentication in ASP.NET 2.0
(Satheesh Babu) Any ASP.NET site we develop will always have an authentication module unless and until there is nothing private on the site or something we explicitly know as being unnecessary. For instance, a simple public content site will not require an authentication module. Depending on the nat