Five Data Management Predictions for 2018

Happy New Year! I hope everyone has their 2018 filled with good health, happiness and prosperity. Once again I am offering you my data management predictions for 2018. Thank you all for great support in 2017 and countless emails regarding my conference, user group presentations and blogs last year.

For 2018, I will continue to . . . → Read More: Five Data Management Predictions for 2018

5 Ways to Save Millions When Migrating from Oracle to Db2

Working with a large number of consulting customers brings many different corporate attitudes, database platforms, innovative ideas, styles of database utilization and cost structures for database operations. Software licensing, support and application development costs often lead into strategic discussions of ways to save millions. IBM is helping companies save millions of dollars by migrating their . . . → Read More: 5 Ways to Save Millions When Migrating from Oracle to Db2

5 Performance Tips from the 2013 Holiday Rush

Since this holiday season is shorter and more people hate the mall crowds, billions will be spent online this season. Unfortunately for management, lack of application development testing, up-to-date standards, and performance procedures will hinder profitability through poor performance of the company website. While the application developers will always blame the database, below are five . . . → Read More: 5 Performance Tips from the 2013 Holiday Rush

5 More Things to Learn from the HealthCare.gov Website Problems

As I noted in last week’s blog, there are many things IT organizations can learn from the website problems on Healthcare.gov. Here are five more things we all might learn from this website situation or any problem project that has these types of issues.

Best practices and industry standards work. I have written previously . . . → Read More: 5 More Things to Learn from the HealthCare.gov Website Problems

5 Things to Learn from the HealthCare.gov Website Problems

Channel surfing the other night I came upon the C-SPAN video replay of the congressional testimony regarding the Healthcare.gov website. Thinking about all the testimony and the political partisan points I was amazed at the project planning comments, lack of understanding of the technological problems, and number of issues that were discussed. As . . . → Read More: 5 Things to Learn from the HealthCare.gov Website Problems

Big Data: BLU Acceleration DB2 Version 10.5 Kepler Considerations

The BLU Acceleration technology is coming out and the new DB2 Version 10.5 Kepler performance improvements are game changing and dramatic especially for Big Data. I blogged about these features in a more detailed entry (IBM BLU Acceleration – Best Yet for Big Data!). The Columnar data store, 10x compression, in-memory processing, Single Instruction . . . → Read More: Big Data: BLU Acceleration DB2 Version 10.5 Kepler Considerations

DB2 SQL Tips: 10 Performance Guidelines

Recently I discussed DB2 SQL tips that have provided application performance for decades with my clients’ SQL developers. These DB2 SQL tips provide developers with performance guidelines that can help their application designs and SQL coding get the best performance the first time.

Since clients have many different DB2 SQL tips, I’ve listed below 10 . . . → Read More: DB2 SQL Tips: 10 Performance Guidelines

Database Performance Tuning Is Only Getting More Important

Hardware continues to get faster, cheaper, and with more capacity. Now UNIX and even Windows systems are trying to handle billions of rows or terabytes of data. Database performance tuning is vital, but continues to get destroyed through wretched designs, poor application practices and maintenance malpractice which dramatically impacts overall database performance. Unfortunately, throwing more . . . → Read More: Database Performance Tuning Is Only Getting More Important

DB2 Performance Maintenance – Get All the Cache

DB2 Clean up – Close Out the Past

As I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week we look into the DB2 Plan and Package settings. These settings can . . . → Read More: DB2 Performance Maintenance – Get All the Cache

DB2 Performance Maintenance - Trust But Verify

DB2 Clean up – Close Out the Past

As I said last week, within every DB2 LUW or DB2 z/OS systems there are things that always need to be cleaned up. This week it’s recommended that you look into your various program’s plan and package . . . → Read More: DB2 Performance Maintenance – Trust But Verify