(John Papa) Model-View-ViewModel, data binding and separation of concerns are just some of the reasons that Knockout.js, which I introduced in a recent column (“2 Great JavaScript Data-Binding Libraries,” February 2012), has become a popular data-binding library in the Web community.
Other News
Oracle Within Group
(Michael McLaughlin) Somebody asked me for a useful example of Oracle 11gR2Œs new analytical LISTAGG function that uses a WITHIN GROUP syntax.
Reasons to Conduct an out-of-place upgrade for Oracle BI 11.1.1.x
(Christian Screen) I received a comment on one of the last post regarding upgrading a Oracle BI 11.1.1.6 from 11.1.1.5 and why I recommended doing a out-of-place upgrade, i.e. deinstall and re-install of the updated version, versus using a patch of 11.1.1.6 over 11.1.1.5. So on a plane ride a few w
MULTISET experiments
(Eter Pani) Recently I was asked to make some investigation about the PL/SQL procedure running slowly. PL/SQL procedure does not contain any SQL or complicate math operation but for some reasons have unexpected delays in processing. After small investigation I localize the problematic statement as c
List MySQL Indexes With INFORMATION_SCHEMA
(Aaron Brown) Have you ever wanted to get a list of indexes and their columns for all tables in a MySQL database without having to iterate over SHOW INDEXES FROM ‘[table]‘? Here are a couple ways…
DB2 Advanced Enterprise Server Edition (AESE) Webcast Recording and Presentation
(Frank Fillmore) The recording of the April 5, 2012 webinar “DB2 AESE – Why You Should Consider It” is located here.
APAR Friday: Two APARs that deal with the cost of doing work on DB2 and one utility fix
(Willie Favero) First one; a DB2 supplied stored procedure could flood your dynamic statement cache with SQL. If you rely on the statement cache to minimize dynamic bind times, this one could be a biggie… after all, the statement cache is a wrap around buffer. When all the space is used up, it j
Manage, query SQL Azure Federations using T-SQL
(Roger Jennings) SQL Azure Federations is Microsoft’s new cloud-based scalability feature. It enhances traditional partitioning by enabling database administrators (DBAs) and developers to use their Transact-SQL (T-SQL) management skills with “big data” and the new fan-out query tool to emulate MapR
SharePoint List From SQL Server Table (External Content Type with SharePoint Designer)
(priyankasrivas) Many time we need to show custom data in a SharePoint list and you do not have an option to store data in SharePoint list .In most of the cases your data source can be used in some other legacy system and you have centralized data in SQL server table. Now challenge is to integrate
SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file
(Pinal Dave) I am writing this blog post right after I resolve this error for one of the system. Recently one of the my friend who is expert in infrastructure as well private cloud was working on SQL Server installation.