(Willie Favero) DB2’s subsystem parameters (AKA DSNZPARM) just seem to be one of my favorite topics. I can’t stop writing stuff about them. It’s kind of amazing how so much can discuss about a bunch of parameters that can be listed on a mere 10 pages in the DB2 10 Installation and Migration Guide.
Author: SSWUG Research
5 Reasons Why DB2 Is Still the Best Big Data Solution
(Dave Beulke) The race is on among all the vendors to lock your new Big Data project in to their architecture, platform, and support contracts. All the open source Hadoop derivatives have boiled down to the leaders of Cloudera Impala, Teradata SQL-H, EMC Pivotal (formerly GreenPlum) MongoDB, and on
Modular AngularJS NuGet Packages
(John Papa) Now serving smaller bite sized AngularJS NuGet packages! AngularJS 1.2 shifted to a more modular approach where the core AngularJS features are in angular.js while other functionality such as routing, animation, and resource are located in their own separate files. Each file hosts a modu
Create Your Own jQuery Slideshow Plugin
(Puneet Gupta) jQuery is the most popular of the JavaScript libraries, and its popularity continues to grow. Many websites have adopted jQuery for dynamic effects and is now highly used.
Web API, Async and Performance in an ASP.NET MVC application
(Suprotim Agarwal) Async and performance are often a considered to go hand in hand because performance is bracketed with scaling. Today we explore the differences and see how to best leverage async operations to gain performance and build an ASP.NET MVC Web API Application that scales better.
Are You Better at Enforcing Referential Integrity than Oracle?
(David Fitzjarrell) From time to time I find a situation where a developer believes he or she is better at enforcing referential integrity than the database. They code intricate sections generating unique IDs based on the maximum value of the id column.
What Language I Use for… Creating Reusable Libraries: Objective-C
(David Chisnall) When most people think of Objective-C, they think of it as “that language that you use for programming iPhones (or possibly Macs).” I write a lot of Objective-C code, but I run very little of it on an Apple platform.
Slow SQL Server Caused by Missing Indexes?
(Jayleen Heft) One of the reasons for a SQL Server database performance problem can be missing indexes.
Denormalize tables to improve cardinality estimate
(Bobby Durrett) I was working on the example from an earlier blog post that showed how the optimizer could not correctly estimate the number of rows accessed on a table if the non-join condition was on a different table.
YASTS: Yet Another SQL Tuning Script: planx.sql
(Carlos Sierra) Having SQLTXPLAIN and SQLHC available, WHY do I need yet another way to display execution plans?