(Xaprb) One of the enhancements I added to MySQL Archiver in the recent release was listed innocently in the changelog as “Destination plugins can now rewrite the INSERT statement.” Not very exciting or informative, huh? Keep reading.
Other News
Oracle BI EE 10.1.3.3./2 – Understanding Todate and AGO – Achieving YTD, QTD and MTD
(Venkatakrishnan J) Though I had known about the existence of repository functions Ago and TODate, i had never used them before especially in the context of achieving YTD, QTD and MTD. So, i thought i would give it a try and see how it works and of course find out the possible use cases of using the
ADF – Implement a ‘Delete this record’ icon (action) in an ADF Table
(Lucas Jellema) As I may have mentioned previously on this blog, I am currently involved in a somewhat challenging ADF project. We are using JDeveloper 10.1.3.3 and JHeadstart 10.1.3.2 for the development of a hosted web application with over 100 customers with on average two dozen users. One of the
Manipulating Query Strings
(Jim Mischel) As you probably know, a URI’s query string is usually made up of key-value pairs. For example, a session identifier might be defined as “sessid=237”. Individual parameters in the query string are separated by ampersand characters. So if you had a session id and a user name the query st
Your First Server Control
(Bipin Joshi) Even though ASP.NET provides you with plethora of server controls, sooner or later you require something that doesn’t ship out of the box. Custom server controls is the way to go in such cases. Custom server controls provide much more control on the overall control creation process tha
Remember a form’s position between uses in VB.NET
(Irina Medvinskaya) There are times when it’s handy for developers to be able to remember where a form was located the last time the application was used. In this quick VB.NET tip, I’ll show you a way of using Application Settings to store and use the last location of the form.
ViewState in ASP.NET 2.0
One of the most interesting features of ASP.NET 2.0 is the open way it allows the programmer to manipulate a control’s viewstate. The viewstate should be the first choice to save data to access across postbacks. If the information is to be shared across different controls, it can be placed in the vi
Aggregating Correlated Sub-Queries
(Jeff Smith) Every now and then you may attempt to calculate an aggregate function — such as SUM() — on a correlated subquery, only to encounter the following error: Msg 130, Level 15, State 1, Line 24 Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
SQL Server 2005 Express Edition – Part 9 – Managing User Instances
(Marcin Policht) In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we have described its unique functionality that allows you to distribute and implement single-user databases (typically with applications they support) without the dependency of having administra
From DevConnections/SQL Connections – Final Thoughts
Featured Article(s) One of the common problems, mostly misunderstood! (Vadivel Mohanakrishnan) This article explains the power of ‘EXECUTE’ keyword in SQL Server. I would explain a common issue which to my knowledge is mostly misunderstood by most of the folks (At least whom i have met so far :)). The target audience for this article are: Basic to Intermediate level […]