(Brian Mains) As a developer, the .NET framework and Visual Studio presents many choices for choosing the right architecture, from placing the data access code directly in the UI through datasets and data source controls, to creating a data access layer that talks to the database, all the way to cre
Other News
An Error Message Control
(Jonathan Wood) With desktop applications, you can throw up a message box to alert the user any time an error is detected. However, web applications don’t directly support message boxes. Instead, the page being served should be modified to include information about the error. Ideally, you can do thi
Using Word to Create Master-Detail Reports for LightSwitch (or Silverlight)
(Beth Massi) A while back a posted how to use Word to create simple reports for LightSwitch by passing in an entity (like Customer) and using Word Content Controls to lay out content in a template and bind them to XML inside the document. If you missed it: Using Microsoft Word to Create Reports For
Oracle SQL Plan Management – Part 2
(Advait Deo) In SPM part 1 we saw information about SPM and how to automatically capture the baseline.
Transitive Closure – Outer Joins
(Randolf Geist) The Cost Based Optimizer (CBO) supports since at least Oracle 9i the automatic generation of additional predicates based on transitive closure.
Committing over a Select For Update
(Dominic Brooks) I’ve read a couple of articles recently reflecting on changes and bugs roughly in and around read consistency in recent versions.
Creating a Custom ASP.NET MVC Project Template
(Phil Haack) When you create a new ASP.NET MVC 3 project, the new project wizard dialog contains several options for different MVC project templates:
The DB2Night Show #54: DB2 LUW Data Movement Utilities & Oracle Comparisons
(Scott Hayes) Our special guest, Burt Vialpando, IBM, never disappoints us! 100% of our studio audience indicated that they learned something from today’s show! Burt covered several ways to move data in DB2 LUW (for example, db2move, db2relocatedb, export, import, load, and others) and then compared
Migrating Oracle to SQL Server using SSMA – Error O2SS0343 FORALL statement with SAVE EXCEPTION clause is not supported
(Bill Ramos and Mayank Bhanawat) This blog post describes why SQL Server Migration Assistant (SSMA) for Oracle doesn’t support the SAVE EXCEPTION clause in the FORALL statement. Exception handling is a programming language construct or mechanism designed to handle the occurrence of exceptions, speci
Mainframe Specialty Processors
(Craig Mullins) Anyone who uses an IBM z Series mainframe has probably heard about zIIPs and zAAPs and other specialty processors. But maybe you haven’t yet done any real investigation into what they are, what they do, and why they exist.