(Eric Vogel) The Chain of Responsibility Pattern is a common Object-Oriented Programming (OOP) design pattern that decouples the sender of a request from the receiver by allowing one or many handler objects to handle the request. One handler may pass on the request to the next until an object in the
Author: SSWUG Research
Understanding the SQL Server HASHBYTES hashing algorithms
(K. Brian Kelley) I’m trying to use the HASHBYTES() function and I see there is an assortment of hashing algorithms available. What is the difference between each one?
InfoSphere MDM for master data governance with MDM workflow
(Jay Limburn, Trey Anderson and Harsha Kapre) This article explains the important role that master data management (MDM) workflow plays when considering master data governance within an MDM implementation.
MVC Complex Model Postback: Bind Field to JSON string
(m_kramar) In my scenario, model had both simple fields directly bindable to input controls, and an array of complex objects that was constructed using fancy JavaScript. I had to submit the whole model using one form postback (no AJAX).
ERROR: could not access file ‘$libdir/plpython2’ – ERROR: could not access file ‘$libdir/plpython3’
(Raghavendra Rao) Above error described on PG mailing as it failes to CREATE LANGUAGE plpython2u/plpython3u on PG9.3Beta.
SQL Query for Determining SharePoint ACL Sizes
(Damon Armstrong) When a SharePoint Access Control List (ACL) size exceeds more than 64kb for a particular URL, the contents under that URL become unsearchable due to limitations in the SharePoint search engine. The error most often seen is The Parameter is Incorrect which really helps to pinpoint
Improving SSRS Query-based Report Performance by not Using Display Methods – Part 3
(yxjin) This post is about Query based reports in Ax2012. Ax2012 supports table display method in query based reports. It is convenient to use. For example, the query for VendDueReportDetail is on VendTable and looks like this in VS designer:
Gathering CBO Statistics in Oracle Applications
(Carlos Sierra) When we refer to Oracle Applications we usually think E-Business (EBS), but there are other large Oracle Applications that requires some special consideration when it comes to CBO Statistics gathering: Siebel and People Soft (PSFT). There are some others, but I would say EBS, Siebel
List tables that stats job doesn’t finish
(Bobby Durrett) We are running the Oracle delivered automatic optimizer stats job on some of our 11.2 Oracle databases and the job is not completing for some of our tables. But, the list of these tables is buried in a trace file on the database server on some random RAC node.
Reporting Enhancements for Oracle SQL Developer v4
(Jeff Smith) This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available via the