(Ted Wennmark) The purpose of this blog-post and next one (Part II) is to see how MySQL Fabric can be used as a HA solution. Reason for this is many users today have the need for HA and automatic failover, but not many users need the sharding functionality, I wanted to focus on creating one HA group
Author: SSWUG Research
Array Support in DB2 11
(Troy Coleman) DB2 11 brings many new SQL processing enhancements that are designed to simplify application coding. One such enhancement is support for arrays. An array is a user-defined data type that consists of an ordered set of elements of a single built-in data type.
Introducing the IBM BLU Acceleration Hub
(John Park) Hemingway once wrote “There is nothing to writing. All you do is sit down at the typerwriter and bleed” — he also wrote — “The best way to find out if you trust someone is to trust them.”
A Distributed Terminology Refresher on DB2 DDF Subsystem Parameter Settings
(Willie Favero) Today’s Fortune 500 companies are embracing distributed techniques to access mainframe data on DB2. Although online transaction processing (OLTP) workloads still dominate DB2’s local processing, more applications, such as data warehousing analytics, run remotely as distributed tasks.
Could not resolve mscorlib for target framework ‘.NETFramework,Version…’
(Ged Mead) I hit this error message this week. The full error message in fact was:
Adding and Removing Objects from a SQL Developer Data Modeler SubView
(Jeff Smith) SubViews are a sub-collection of model objects. They are very useful for breaking up very large designs into smaller, easier to digest pieces. If you need to brush up on the topic a bit, try these posts.
Where does the Exadata storage() predicate come from?
(Tanel Poder) On Exadata (or when setting cell_offload_plan_display = always on non-Exadata) you may see the storage() predicate in addition to the usual access() and filter() predicates in an execution plan:
The ‘rfs writes’ event on a DataGuard standby database
(John Hallas) It is well known that poor performance on the standby server of a DataGuard pair can affect the performance of the primary database. This post shows an example and how to use the view GV$EVENT_HISTOGRAM to track down an issue.
SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info
(Pinal Dave) A very common question which I often receive is –
On Handling Dates in SQL
(Joe Celko) The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical conventions. The handling of dates in TSQL is even more complex because, when SQL Server was Sybase, it was forced by the lack of prevailing standards in SQL to