| By Dave Beulke, on July 23rd, 2012 Last week’s blog information made some upset with its basic advice on Big Data. I agree these basic database issues should be common knowledge for business and database professionals and not have to be discussed or even considered. Unfortunately, all the new developers are thinking that they are prodigies of Leonardo da Vinci and their . . . → Read More: Big Data Analytics: More Maddening Basic Issues: NULLS, VARCHARS and DEFAULTS By Dave Beulke, on July 17th, 2012 As I talked about last week the new big data analytics era is upon the IT departments of all types of corporations. Insurance, health care, financial and other types of businesses are starting to accumulate many different and new types of analytics to provide an edge over their competition. As a data management professional these . . . → Read More: Big Data Analytics: Three Critical Success Points By Dave Beulke, on July 11th, 2012 Watching the Facebook IPO and followed by all the Morgan Stanley, NASDAQ and other parties bickering, pointing fingers and preparing lawsuits reminds me of many of the struggling IT projects that I have assisted with as a DB2 consultant. The failures of the Facebook IPO show how having unaligned interests always leads to failure. Even . . . → Read More: DB2 Performance Lessons from the Facebook IPO Failures By Dave Beulke, on August 30th, 2011 There are many design aspects for DB2 Temporal Tables that I have discussed in some of my previous blog entries. While reviewing the design of a recent data warehouse system, it became apparent that many index design points weren’t evaluated and were causing overall poor application DB2 performance. These same index design points are especially . . . → Read More: Three Essential DB2 Performance Design Points about DB2 Temporal Table Indexes By Dave Beulke, on June 14th, 2011 As I continued to review the IDUG presentations from this year, DB2 performance and RAS (Reliability, Availability and Scalability) came to mind. The DB2 LUW presentation by Dale McInnis and Katherine Kurtz’s “Best Practices for Building a Database Recovery Strategy for Your InfoSphere Warehouse Database” popped out at me. I’ve seen many of Dale’s presentations . . . → Read More: DB2 Performance Tuning: Reliability, Availability and Scalability — IDUG Resources By Dave Beulke, on June 7th, 2011 Traveling to different clients throughout the years as a DB2 consultant and seeing different database designs, development methodologies and tools being used provides some interesting technological perspectives. The complex nature of technology can muddy the issues within the business. Even as new buzzwords of cloud computing, Web 2.0 and other technologies come onto the horizon, . . . → Read More: DB2 Performance Tuning: Reliability, Availability and Scalability By Dave Beulke, on May 24th, 2011 The annual North American IDUG conference was held in Anaheim, California and I always like going through the download of presentations to understand all the presentations I missed. Users, DB2 consultants and IBMers always provide great DB2 performance technical insights into how to get the most out of your environment. This year the conference DB2 . . . → Read More: DB2 Performance Tuning for LUW Feature: DB2 pureScale By Dave Beulke, on April 5th, 2011 Reviewing the DB2 10 Data Warehouse DSNZPARM for z/OSThe previous two weeks’ Part 1 and Part 2 discussions highlighted and discussed the various DB2 Data Warehouse DSNZPARMS for z/OS within Versions 8 and 9. With the new DB2 Temporal Tables the system needs . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 3 By Dave Beulke, on March 29th, 2011 Reviewing the DB2 Data Warehouse DSNZPARM for z/OSLast week we talked about the first alphabetic group of DB2 data warehouse DSNZPARMS that can improve your access paths and overall application performance. This week the second set of DSNZPARMS are discussed. Many of the . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 2 By Dave Beulke, on March 22nd, 2011 Reviewing the DB2 Data Warehouse DSNZPARM for z/OSIn the previous weeks I briefly talked about the new DB2 10 temporal tables and how they are great for data warehousing applications. To leverage the temporal tables and data warehousing applications within the DB2 for . . . → Read More: DB2 Data Warehouse DSNZPARMS Part 1 | |