(Uwe Hesse) An exciting feature of 12c is Automatic Data Optimization (ADO). It can automate Compression Tiering and Storage Tiering. The documentation mentions that Storage Tiering can be based on a customized function, but there is no example for it. Therefore this posting.
Author: SSWUG Research
DB2 for z/OS: Monitoring Prefetch Read Activity
(Robert Catterall) Not long ago, a colleague sent to me some DB2 for z/OS buffer pool activity data that a DB2-using organization had sent to him. The DB2 people at this site were alarmed by some of the prefetch-related numbers in the data, and they had requested a review of the information.
Web API With AJAX: Understand AcceptVerb Attribute in Web API
(Sourav Kayal) This article explains the “AcceptVerb” attribute of the Web API. AcceptVerb is one attribute of the Web API actions. We can use it to allow a specific HTTP verb in a Web API action.
Data and the C Programming Language
(Stephen Prata) This chapter explores the two great families of data types: integer and floating point. C offers several varieties of these types. This chapter tells you what the types are, how to declare them, and how and when to use them. Also, you discover the differences between constants and va
mysql.user
(Dave Stokes) Every MySQL DBA has at least peeked at a mysql.user table. But with the latest versions come some changes that many may have not noticed. The last three of the forty three columns — plugin, authentication_string, and password_expired — fields deserve a closer look.
SQL Server default settings that you might want to change
(John Daskalakis) One very common complaint I receive from SQL Server administrators is:
12c Adaptive Optimization – Part 2 – Hints
(Kerry Osborne) This is the second post on follow up questions from the Redgate webinar I did on 12c Adaptive Optimization. The first post is here: 12c Adaptive Optimization – Part 1. Since there were several comments and questions about hints and how they interact with Adaptive Plans, I decided to
Best Practices For Optimizing DB2 Performance
DB2 performance tuning and optimization is a complex issue comprising multiple sub-disciplines and levels of expertise. Mastering all of the nuances can take an entire career. Deploying standard best practices can minimize the effort to achieve efficient DB2 applications and databases. (R)
jQuery Paging Fast and Easy
(ronak-webdeveloper) jQuery is the powerful JavaScript library nowadays. jQuery is a cross-browser JavaScript library designed to simplify client-side scripting of HTML.
GeoLocation with VB and Windows 8 /8.1
(Hannes Du Preez) This has to be my favorite feature in Windows 8.x. OK, I’ve probably said that many a time. With so many developers wondering why exactly there were five-thousand plus new APIs introduced in Windows 8.x, it is hard to resist the temptation of looking into them.