(Sveta Smirnova) As author of MySQL JSON functions I am also interested in how development goes in another parties. JSON functions and operators in PostgreSQL, indeed, have great features. Some of them, such as operators, I can not do using UDF functions only. But lets see how these functions are in
Author: SSWUG Research
Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform
(Chuck Ballard, Jason Arnold, Rich Briddell, Heverson Campelo, Cecile Madsen, Jayanti Mahapatra and Eduardo Pingarilho) With ever-increasing workloads on production systems from transaction, batch, online query and reporting applications, the challenges of high availability and workload balancing ar
SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server
(Pinal Dave) Probably, everyone who writes SQL code has used INSERT statement, which alongside SELECT, UPDATE and DELETE, is a part of a basic operations’ set for data manipulation.
WPF Information Controls Class Hierarchy
(Richard Carr) The forty-sixth part of the Windows Presentation Foundation Fundamentals tutorial looks at the classes that support the WPF information controls. This article includes the inheritance hierarchy of all of the WPF controls seen so far.
Looking at ASP.NET MVC 5.1 and Web API 2.1 – Part 2 – Attribute Routing with Custom Constraints
(Jon Galloway) I’m continuing a series looking at some of the new features in ASP.NET MVC 5.1 and Web API 2.1. Part 1 (Overview and Enums) explained how to update your NuGet packages in an ASP.NET MVC application, so I won’t rehash that here.
DB2 10 (and beyond) for z/OS: Being Smart About More RELEASE(DEALLOCATE)
(Robert Catterall) By now, a lot of you probably know that a really important action to take, once your DB2 subsystem is at the Version 10 (conversion mode) level, is to rebind your plans and packages. Taking this action delivers several benefits:
Extending System.Web.Optimization
(Dean Hume) The ASP.NET framework is packed with loads of great features and with each release it seems to get better and better. One of my favourite features is the bundling and minification classes that optimize JavaScript and CSS files in a website to reduce file size and improve page performance
APAR Friday: Apply a PTF, get improved performance
(Willie Favero) Today’s fix is a pretty straight forward one. You all know how fast log apply helps improve recovery times for a table space, right?
Do AWR Reports Show the Whole Picture?
(Maris Elsins) AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the AWR report.
Comparing Columns In Power Query
(Chris Webb) A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a question came up in the comments about how you might go about comparing values in columns rather than whole tables. Of course this prompted me to investigate how different types of compari