(Chris Bennett) ASP.NET MVC (Model-View-Controller) provides a light-weight framework with a lot of flexibility over the base ASP.NET framework. Unfortunately, this means we lose most of the high-level control structure provided by ASP.NET. This isn’t necessarily a bad thing when you consider where
Other News
Interaction Between Baselines and SQL Profiles
(Kerry Osborne) In a previous post (GATHER_PLAN_STATISTICS) I mentioned that SQL Profiles and Baselines can both be applied to a single statement. In this case, it appears that the hints are merged. The Notes section of the XPLAN output shows that both the Baseline and the Profile are in effect. I w
ADF 11g : How to control where a new row is inserted
(Luc Bors) On the JDeveloper forum a question was asked how to insert a new row in an ADF table after the selected row. Default behavior is insertion before the current row. In this short post I describe how to achieve this.
Something Interesting about the 11g Client
(Jeff Hunter) If you’re just beginning to implement Oracle 11g, you need to be aware of the Automatic Diagnostic Repository (ADR). It has nothing to do with AWR, ADDM, ASM, ASSM, or any of the other acronyms Oracle has come up with over the last two releases.
Analytics Corner with James Taylor (Video)
(Adam Gartenberg) “How do you embed analytics so the data you have informs every interaction you have with customers?”
Understanding IBM DB2 DB2SET
(Rebecca Bond) Despite the fact that db2set has been around for a while, it seems that db2set is not always well understood. According to IBM’s documentation, the IBM DB2 Profile Registry command (db2set) allows for centralized control of environmental variables. Read on to learn more…
Best Practices in .NET XML Serialization of Complex Classes
(Zoran Horvat) This article will show you XML serialization, so simply added in code, is not a magical stick. Serialization must be planned in full detail when working with complex classes, rather than expected to work by itself. Loss of planning work leads to redesign work later on, when maintainin
Integrate Google Spreadsheets data with PHP, Part 1
(Vikram Vaswani) Google Spreadsheets is a well-known cloud-based spreadsheet application. Web application developers are able to access and search data from online spreadsheets through the Google Spreadsheets Data API. This article introduces the Google Spreadsheets Data API and demonstrates it in t
Monitoring in DB2 9.7, Part 2: Relational access to XML event monitor data in DB2 9.7
(Scott Walkty) Learn how you can get relational access to the subset of monitor data that is captured in the form of an XML document by an activity or statistics event monitor in IBM DB2 for Linux, UNIX, and Windows Version 9.7 (DB2).
Running a SSIS Package from SQL Server Agent Using a Proxy Account
(Arshad Ali) Recently when I created a SQL Server Agent job to execute a SSIS package, it failed with the message “Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.”. What is this exception about? What causes it and how do I resolve it?