(Diego Dagum) Javadoc is a standard tool that generates API documentation from its Java source code. It scans the sources to search for comments in a specific enhanced syntax. By commenting code this way, developers keep the API documentation updated.
Author: SSWUG Research
SharePoint: Easy Row Level Security
(Scott Shearer) Once I deploy a solution, I want the Site Owners and SCAs to be able to easily maintain the solution I have provided. I have devised a simple and easy to maintain method of setting security on each row of data when it is entered and changed.
Zigzag join enablement for DB2 star schema queries
(Lee Jung Chu and Sudhir Singh) IBM DB2 10.1 Linux, UNIX, and Windows introduces a new join method called zigzag join. Zigzag join improves consistency in performance as well as reduces the execution time of queries in data warehouse or data mart environments with large volumes of potentially partit
Text Manipulation Using Canvas in HTML5
(Ashwani Tyagi) This article describes various text manipulation techniques such as Text Metrics,Text Baseline and Text Alignment in HTML5.
IBM Enterprise-Class RDBMS Gets Even Better
(Joseph Veleeparambil and Shawn Moe) Two years after its hugely successful release of IBM Informix 11.7, IBM continues to deliver significant new versions of the Informix data server. Building on 11.7, the Informix 12.1 release focuses on its core online transaction processing (OLTP) strengths of hi
A Journey from OLTP to OLAP
(Franco Lopes) In this first Part of the series I will discuss the OLTP and OLAP and the transition from OLTP to OLAP in pursuit performance improvements as well as the benefits of the each technology.
New Query Optimizer Features in MySQL 5.6
(Rob Gravelle) One of MySQL 5.6’s many optimizations apply to the processing of queries that contain subqueries. These involve transforming a subquery into a semi-join operation, and then treating it like just another join operation for evaluation.
And the real-time statistics discussion continues with index last update
(Willie Favero) I’m still talking about real-time statistics. This is what is referred to as the trickle affect. Periodically I keep discussing another little piece of real-time statistics. This stuff is important… it’s useful… and in my opinion it’s pretty interesting…. Every time I reread one of m
Altering Text Columns: Only a Metadata Change?
(Michael J. Swart) Say you want to change the type of a text column using the ALTER TABLE … ALTER COLUMN syntax. It is valuable to know how much work SQL Server will have to do to fulfill your request.
Making your existing ASP.NET MVC Web Site Mobile Friendly
(Suprotim Agarwal) If you already have an existing ASP.NET MVC Site and you would like to add seamless transition between Mobile and Non-Mobile views, you can easily accomplish it with the help of the built in Mvc.Mobile package.