(SQLGardner) I have not posted a new blog entry in the last couple months due to the holidays and doing a lot of work travel in January. This will be a short one, but I have seen a lot of customers having issues with this.
Other News
Dependency Injection in ASP.NET MVC – An Introduction
(Sumit Maitra) As Developers we may have come across the term ‘Dependency Injection’ as a design pattern that helps develop maintainable and de-coupled code. DI is also a way to implement the ‘D’ in SOLID principles. (SOLID as stated by Uncle Bob stands for: Single responsibility, Open closed princi
MySQL/QueryScript use case: DELETE all but top N records per group
(Shlomi Noach) Some administrative tasks can be simplified by using common_schema/QueryScript. I’m collecting a bunch of these for documentation. Here’s one for example:
How to call af:query search button programmatically
(Rodrigues, Raphael) I have a simple af:query which I created dragging and drop the All Queryable Properties inside my findAll iterator in DataControl palette. After that, I put a very simple remove button. When I click in the remove button, it calls a method in session bean, which removes the entit
Dynamically Map SQL Resultset to Business Object
(Sam Lombardo) A common issue in our company is working with non-type-safe data. Our DBA writes very efficient stored procedures which often join with related tables to reduce DB calls. Our developers must in turn cycle through the result sets and manually map each column to an appropriate class and
Understanding Database Initializers in Entity Framework Code First
(Bipin Joshi) Entity Framework Code First allows you to create data model classes prior to creating a database. When you run the application for the first time, a database is created for you on the fly based on the classes you created. Database initializers allow you to decide a strategy of database
How to add a button with custom command name and perform an operation?
(SheoNarayan) To add a button for each record in the GridView and perform some custom operation on click of this button, we can follow this approach.
Video: Dan Luksetich, DB2 Expert and IBM Champion, talks about Oracle to DB2 migration and performance
Daniel Luksetich, of YLA Associates and DB2expert.com, talks about Oracle to DB2 migration (and Optim) and the resulting DB2 performance.
Basic scripting tricks for DB2(LUW)
(Ember Crooks) There are a couple of scripting tricks that I always teach when I’m training a new dba. There are some areas where we have to iterate over something that db2 doesn’t provide us with the tools to iterate.
Mainframe code page conversion customization in an IBM z/OS system
(Hong Liang Han, Xiao Lin Zhang and Si Bin Fan) Encoding in mainframes is EBCDIC, and encoding in distributed system is ASCII. Mainframe computers need to communicate with distributed systems that include Microsoft Windows, UNIX, and other platforms.