2020

The State of Database Management: Transforming the Role of the DBA. Big Data Quarterly, December 14, 2020. The Changing Database Landscape. Database Trends and Applications, Dec 2, 2020. Expanding Role of Metadata Management, Data Quality, and Data Governance. The Data Administration Newsletter (TDAN), December 2, 2020. Data Gravity and Cloud Computing. Database Trends and Applications, Nov 4, 2020. Everything is Big Data. The Data Administration Newsletter (TDAN), October 21, 2020. The Cloud and Database Administration. Database Trends + Applications, Oct 9, 2020. The Benefits of In-Memory Processing. Planet Mainframe, September 24, 2020. The Expanding Role of Metadata Management, Data Quality, and Data Governance. Database Trends and Applications, September 9, 2020. Navigating IBM COBOL 4.2 End of Support Waters. Cloudframe blog, August 19, 2020. The Plight of the Modern DBA. Database Trends and Applications, August 11, 2020. The Mainframe is a Modern Platform. TDAN, July 15, 2020. Consider Cross-Compiling COBOL to Java to Reduce Costs. Cloudframe blog, July 7, 2020. Development DBAs versus Production DBAs. Database Trends and Applications, July 1, 2020. What is a Data Aggregration? TechTarget, June 2020. Optimizing Mainframe Data Access. Planet Mainframe, June 11, 2020. Database Performance Monitoring vs Management. Database Trends & Apps, June 10, 2020. Automation is Key to Effective Database DevOps. IDERA Community Blog, June 5, 2020. DevOps, Database Design and Change Management. IDERA Community Blog, May 27, 2020. The Mainframe is a Modern Platform. Enterprise Systems Media, May 20, 2020. Embracing In-Memory Processing for Optimizing Performance. Planet Mainframe, May 20, 2020. The Mainframe is a Modern Platform. Enterprise Systems Media, May 19, 2020. Minimzing Database Lock Contention Issues. Database Trends and Applications, May 13, 2020. DevOps, SQL Quality, and Performance. IDERA Community Blog, April 22, 2020. The Role of the DBA in the App Dev Process. Database Trends & Applications, Apr 8, 2020. Don’t let cloud exuberance stop other IT infrastructure investments. IBM IT Infrastructure Blog, March 30, 2020. DevOps Impact on Database Administration. IDERA Community Blog, March 25, 2020. The Importance of Database-Enforced Integrity. Database Trends & Applications, Mar 19, 2020. The Data Catalog Has Risen. The Data Administration Newsletter (TDAN), March 4, 2020. The Mainframe is a Modern Platform. Database Trends and Applications, February 10, 2020. What is a ELT (Extract, Load, and Transform)? TechTarget, January 24, 2020. What is a DbaaS (Database-as-a-Service)? TechTarget, January 2020. SQL Performance Testing and DevOps. Database Trends and Applications, January 13, 2020. Evaluating Data Warehouse Platform Options and Your Need for One. SearchDataManagement, January 3, 2020.

2019

Evaluating the Different Types of DBMS Products. SearchDataManagement, December 23. 2019. The Five Key Factors for Database Performance. Planet Mainframe, December 5, 2019. The Rise of the Data Catalog. Database Trends and Applications, December 1, 2019. Data Breaches are Pervasive and Costly. TDAN, November 20, 2019. What is a Database Administrator (DBA)? TechTarget, November 1, 2019. The Five Key Factors for Database Performance. Database Trends and Apps, Oct 31, 2019. DevOps and Db2 for z/OS: Mixing Db2 DBA with DevOps. IDUG, October 8, 2019. Best Practices for Managing Database Infrastructure. Database Trends and Apps, Oct 1, 2019. Analytics Projects Offer Value and Challenges. Database Trends and Applications, Sept 3, 2019. Introduction to Blockchain for DBAs. TDAN, August 21, 2019. Hybrid multicloud: A mouthful, but the right approach. IBM IT Infrastructure, Aug 15, 2019. Data Breaches: Pervasive and Costly. Database Trends and Applications, August 7, 2019. Db2 – The AI Database … and more! Database Trends and Applications, July 10, 2019. The Impact of the Connected Economy on Database Administration. TDAN, July 3, 2019. Managing Backup & Recovery is the Most Important Thing DBAs Do. IDERA Community Blog, June 20, 2019. Implementing DBA Best Practices. Database Trends and Applications, June 10, 2019. We Need Data Ethics Now. TDAN, June 5, 2019. It’s Time for Db2 SQL Performance Testing to Shift Left. Compuware Blog, May 7, 2019. The Challenge of Managing the Modern IT Infrastructure. Database Trends and Applications, May 1, 2019. DevOps and the DBA. IDERA Community Blog, May 1, 2019. Three Important Database Security Features. Database Trends and Apps, April 10, 2019. The Impact of Cloud on DBA. IDERA Community Blog, April 2, 2019. What is an OODBMS? TechTarget, March 2019. Database Scalability, Elasticity, & Availability. Database Trends and Applications, March 4, 2019. Improving Db2 Performance: Q&A with Craig S. Mullins. Big Data Quarterly, February 26, 2019. IBM Z Offers Powerful Scalability, Robust Security, and High Performance. TrustRadius, February 20, 2019. What is a DBA? Database Trends and Applications, February 8, 2019. What is a Data Center Administrator? TechTarget, February 2019. Teradata Vantage: The Platform for Pervasive Data Intelligence. Database Trends and Applications, January 2, 2019.

2018

SQL Performance, Part 4: Additional Considerations. IDERA Community Blog, Dec 10, 2018. Managing Database Performance. Database Trends and Applications, December 4, 2018. SQL Performance Pt 3: Multiple Table Access Methods. IDERA Community Blog, Nov 30, 2018. SQL Performance Pt 2: Query Analysis and Access Path Formulation. IDERA Community Blog, November 19, 2018. SQL Performance Pt 1: Relational Optimization. IDERA Community Blog, November 12, 2018. The Impact of the Connected Economy on DBA. Database Trends & Applications, Nov 1, 2018. The Importance of Data Lineage. IDERA Community Blog, October 31, 2018. Data Modeling Still Important in a Big Data, Analytics World. IDERA Community Blog, October 22, 2018. The Mainframe Does Big Data. Database Trends and Applications, October 10, 2018. IT Infrastructure Transparency Vital to the Modern Enterprise. Planet Mainframe, September 6, 2018. DevOps and the Database. Database Trends and Applications, September 4, 2018. Blazing Fast Access with Ancelus Algorithmic Database. Database Trends and Applications, August 8, 2018. We Are in Need of Data Ehtics Now. Database Trends and Applications, July 2, 2018. Who Owns the Data? Database Trends and Applications, June 1, 2018. Architecting the Modern Enterprise: 10 Key Technologies for a Strong Foundation. Big Data Quarterly, May 11, 2018. Relational Database Management System Optimization. Database Trends & Apps, May 8, 2018. No Money Should be Harmed: IT Infrastructure Transparency & the Modern Enterprise. Direction IT, April 19, 2018. How to Evaluate a DBA Job Offer. TDAN, April 18, 2018. Data Lake Versus Data Warehouse: Understanding the Differences. Database Trends and Applications, April 12, 2018. Embracing the Challenges of Gaining Value from Analytics. Planet Mainframe, April 6, 2018. TIMESTAMP versus DATE/TIME. datAvail Blog, March 28, 2018. Db2 Nulls and the IS [NOT] DISTINCT FROM Clause. datAvail Blog, March 15, 2018. Code for Performance from the Start. Database Trends and Applications, March 7, 2018. Null Troubles. datAvail Blog, February 28, 2018. What is the Elastic SQL Approach? NuoDB Blog, February 22, 2018. What are the Database Scalability Methods? NuoDB Blog, February 14, 2018. Db2 Best Practices. datAvail Blog, February 13, 2018. What do we mean by Database Scalability? NuoDB Blog, February 9, 2018. It’s All Big Data. Database Trends and Applications, February 1, 2018. Reinventing DevOps: Continuous delivery and the database. IBM IT Infrastructure Blog, January 23, 2018. What is Production Data? datAvail Blog, January 16, 2018. Tighten Database-Application Integration. IBM Z, January 8, 2018. Don’t Neglect Database Performance. TDAN, January 3, 2018. An Introduction to Blockchain for DBAs. Database Trends and Applications, January 2, 2018. Some New Year’s Resolutions for DBAs. datAvail Blog, January 2, 2018.

2017

Which is better? “BETWEEN” vs. “<=” and “>=”. datAvail Blog, December 20, 2017. The Rising Need for Database Scalability. NuoDB Blog, December 19, 2017. The Pros and Cons of Database Scaling Options. NuoDB Blog, December 11, 2017. Evaluating a DBA Job Offer. datAvail Blog, December 7, 2017. The High Cost of Poor Data Quality. Database Trends and Applications, December 1, 2017. Moving Beyong Relational with Data Integration. Big Data Quarterly, November 28, 2017. Replacing UNION with CASE (Db2). datAvail Blog, November 22, 2017. Quick Thoughts on Db2 Performance. datAvail Blog, November 9, 2017. The Role of ACID in the Integrity of Your Database Data. Database Trends and Applications, November 1, 2017. Is Information Overload a Myth? TDAN, November 1, 2017. Reading Things That Aren’t There… and Missing Things That Are! datAvail Blog, Oct 26, 2017. What Type of DBA Are You? Database Trends and Applications, October 18, 2017. On The Importance of Choosing the Correct Data Types. datAvail Blog, October 11, 2017. Limiting the Number of Rows Fetched. datAvail Blog, September 27, 2017. The “Dirty Read” (AKA Uncommitted Read). datAvail Blog, September 13, 2017. Don’t Neglect Database Performance. Database Trends and Applications, September 7, 2017. Database Standards Can Be a Problem. TDAN, September 6, 2017. Know Your ISOLATION Levels. datAvail Blog, August 30, 2017. Ensuring Data Integrity is a Tricky Business. datAvail Blog, August 18, 2017. The Importance of Referential Constraints for Data Integrity. Database Trends and Applications, August 9, 2017. Approaches to Access Path Management… or The Five R’s. datAvail Blog, July 25, 2017. The New IBM z14: More Secure, Flexible, Powerful and Analytical Than Ever Before. Planet Mainframe, July 18, 2017. The Impact of the Connected Economy on Data Management. Electronic Specifier, July 17, 2017. Basic DB2 Buffering and Memory Guidelines. datAvail Blog, July 11, 2017. What is an In-Memory Database System? Database Trends and Applications, July 5, 2017. Cost vs. Advantage of Moving From IMS DB to Db2. datAvail Blog, June 28, 2017. Autonomics to Modernize Database Administration. TDAN, June 21, 2017. The Impact of the Connected Economy on Data Management. u-blox blog, June 16, 2017. Planning Database Recovery Options. Database Trends and Applications, June 1, 2017. A Short Introduction to Lock Avoidance. datAvail Blog, May 29, 2017. The Role of the DBA in Cybersecurity. Cybersecurity Sourcebook 2017, May 2017. Database Performance Advice for DBAs. Database Trends and Applications, May 5, 2017. Understanding DB2 Performance. LogicalRead Blog, April 25, 2017. Embracing the Challenges of Gaining Value from Analytics. DirectionIT Magazine, April 17, 2017. Can You Drown in a Data Lake? IDUG Content Blog, April 11, 2017. Taking Full vs Incremental Database Backups. Database Trends and Applications, April 7, 2017. Appreciating Metadata Through Music. TDAN, April 5, 2017. The Most Common Types of DBAs. datAvail Blog, March 30, 2017. Structuring Your DBA Staff: Generalists or Specialists? datAvail Blog, March 23, 2017. Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts. datAvail Blog, March 16, 2017. The Importance of the Relational System Catalog. Database Trends & Applications, Mar 2, 2017. VOLATILE: A Useful Little Db2 Keyword. datAvail Blog, March 2, 2017. A Look at the Leading Operational Database Management Systems. SearchDataManagement (TechTarget), February 13, 2017. Digital Transformantion and the DBA. Database Trends and Applications, February 9, 2017. Using INTERSECT and EXCEPT in DB2. datAvail Blog, February 9, 2017. Sorting Out a Solution in DB2. datAvail Blog, January 26, 2017. Mobile Computing, The Mainframe, and z/OS Connect. Planet Mainframe, January 11, 2017. Trends Impacting DBAs in 2017. Database Trends and Applications, January 3, 2017.

2016

Microsoft SQL Server 2016 relational DBMS overview. SearchDataManagement, Dec 5, 2016. Modernizing Database Administration with Autonomics. Database Trends & Apps, Dec 1, 2016. What Does a DBA Do? 22 Responsisilities - Part 2. datAvail Blog, December 1, 2016. A look at the EnterpriseDB Postgres data management platform. SearchDataManagement, November 30, 2016. Inside the Amazon DynamoDB NoSQL cloud database as a service. SearchDataManagement, November 28, 2016. DB2 Performance Monitoring Overview. datAvail Blog, November 17, 2016. The Ten (Database) Commandments. TDAN, November 16, 2016. Navicat: A Helpful Toolkit for DBAs. Database Trends and Applications, November 9, 2016. What Does a DBA Do? 22 Responsisilities - Part 1. datAvail Blog, November 6, 2016. Legacy Systems of the Future. DirectionIT Magazine, October 2016. An Overview of Today’s Leading DBMS Platforms. datAvail Blog, October 27, 2016. Using Extended Indicator Variables in DB2 for z/OS. Toad World, October 20, 2016. How Many DBAs? datAvail Blog, October 20, 2016. DBA as a Management Discipline. datAvail Blog, October 12, 2016. Designing for Batch Database Applications. Database Trends and Applications, Oct 7, 2016. The Importance of Database Design Reviews. datAvail Blog, September 29, 2016. DBA Roles & Responsibilities: Constantly Changing. datAvail Blog, September 27, 2016. Use a Little SQL Magic to Clean Up Your Data. Toad World, September 26, 2016. Business Eye for the DBA Guy. datAvail Blog, September 22, 2016. Data Modeling Concepts Every DBA Should Know. datAvail Blog, September 20, 2016. Introduction to Database Design: From Logical to Physical. datAvail Blog, September 8, 2016. Big Data Guidance for Relational DBAs. Database Trends and Applications, September 2, 2016. How to Evaluate DBA Tool Vendors. Toad World, August 22, 2016. Improving IT Security with Database Auditing Techniques. Database Trends and Applications, August 4, 2016. A look inside the SolarWinds Database Performance Analyzer. SearchDataManagement, July 22, 2016. An overview of Dell's database performance tools. SearchDataManagement, July 21, 2016. Inside IBM's Data Server Manager and other database performance tools. SearchDataManagement, July 21, 2016. Hashing and Hash-Organized Tables in DB2. Toad World, July 19, 2016. When Not to Index. datAvail Blog, July 19, 2016. New Trends in Database Administration. Database Trends and Applications, July 12, 2016. Exploring Bradmark Technologies' database performance monitoring tools. SearchDataManagement, July 8, 2016. Exploring the features of Oracle Enterprise Manager 13c. SearchDataManagement, July 8, 2016. Inside IDERA’s database performance manaement and optimization tools. SearchDataManagement, July 7, 2016. Inside BMC’s database performance tools for DB2 for z/OS. SearchDataManagement, July 6, 2016. Database performance management requires keen attention. SearchDataManagement, June 29, 2016. It’s Not Your Daddy’s DB2! - Part 6 (Autonomics). BMC Blog, June 24, 2016 Tips on selecting the right database performance tools. SearchDataManagement, Jun 23, 2016. Using DB2 SQL Functions to Count the Number of Characters. Toad World, June 22, 2016. Examining the functions and features of database performance tools. SearchDataManagement, June 17, 2016. Sequence Objects and Identity Columns. datAvail Blog, June 14, 2016. The Importance of Keeping Your DBMS Up-to-Date. Database Trends & Apps, June 9, 2016. It’s Not Your Daddy’s DB2! - Part 5 (SQL and Development Trends). BMC Blog, June 9, 2016 Three indicators that could signal database performance issues. SearchDataManagement, June 8, 2016. The Two Biggest DB2 Performance “Things”. datAvail Blog, June 7, 2016. Inside CA Technolgoies’ database performance management products. SearchDataManagement, June 3, 2016. The Nexus of Forces Impacts the Mainframe, Too. Planet Mainframe, May 26, 2016. A Quick Intro to DB2 SQL Functions. datAvail Blog, May 18, 2016. DB2 – What’s in a Name? Toad World, May 18, 2016. What You Need to Know About Database Performance Software. SearchDataManagement, May 12, 2016. On DB2 Naming Conventions. datAvail Blog, May 12, 2016. To REBIND or Not to REBIND. datAvail Blog, May 11, 2016. The Importance of SLAs. Database Trends and Applications, May 4, 2016. How to Tell Your Mom About the Mainframe. Planet Mainframe, May 3, 2016. Character Versus Numeric Data Types. datAvail Blog, May 3, 2016. What are NoSQL Databases? TDAN, May 1, 2016. It’s Not Your Daddy’s DB2! - Part 4 (Data Structures and Other DDL). BMC Blog, April 29, 2016. The Mainframe Dilemma: Coping With an Aging Workforce. Planet Mainframe, April 2016. Dynamic SQL and Performance. datAvail Blog, April 21, 2016. An Education in DB2. Toad World, April 20, 2016. How to Improve Database Security. Database Trends and Applications, April 19, 2016. Intelligent Automatic Reoptimization? datAvail Blog, April 12, 2016. Craig Mullins Aims to Introduce Data Summit Attendees to Big Data Concepts. Database Trends and Applications, April 8, 2016. Learning Metadata Through Music. Toad World, March 28, 2016. The Most Important Things is Recoverability. datAvail Blog, March 24, 2016. Five factors to help select the right data warehouse product. SearchDataManagement, March 22, 2016. It’s Not Your Daddy’s DB2! - Part 3 (Unstructured Data and LOBs). BMC Blog, March 16, 2016 The DB2 Performance Advisor: What is Performance? Planet Mainframe, March 2016. Selecting Every Other Row in DB2. datAvail Blog, March 15, 2016. Pivotal Greenplum streamlines big data query optimization. SearchDataManagement, March 11, 2016. A Look Inside the SAP IQ column-oriented DBMS. SearchDataManagement, March 10, 2016. Examining Teradata Active Enterprise Data Warehouse. SearchDataManagement, Mar 9, 2016. The Integrity of Your Data is of the Utmost Importance. Database Trends & Apps, Mar 3, 2016. It’s Not Your Daddy’s DB2! - Part 2 (Universal Table Spaces). BMC Blog, February 26, 2016 DB2 Performance Advisor: SQL Tuning Basics. DirectionIT Magazine, February 25, 2016. Evaluating the keys features of Data Warehouse Platforms. SearchDataManagement, February 24, 2016. The History of DB2 for z/OS. Toad World, February 23, 2016. IBM dashDB delivers with cloud data warehouse. SearchDataManagement, February 19, 2016. What to Expect from Oracle Exadata Database Machine. SearchDataManagement, Feb 18, 2016. On Date Formats in DB2 - Part 2. datAvail Blog, February 18, 2016. Examining the IBM PureData System for Analytics appliance. SearchDataManagement, February 16, 2016. Using Data Models to Improve Development. Database Trends and Applications, Feb 10, 2016. Exploring the Actian Analytics Platform. SearchDataManagement, February 9, 2016. On Date Formats in DB2 - Part 1. datAvail Blog, February 9, 2016. Exploring the HPE Vertica Analytics Platform. SearchDataManagement, February 8, 2016. Big Data and the Mainframe: A Perfect Partnership. Planet Mainframe, February 5, 2016. Exploring Amazon Redshift cloud data warehouse as a service. SearchDataManagement, January 28, 2016. DB2 Date and Time Data. datAvail Blog, January 26, 2016. It’s Not Your Daddy’s DB2! - Part 1 (Industry and DBA Trends). BMC Blog, January 19, 2016 DB2-L: The DB2 Mailing List. Toad World, January 19, 2016 Expert Interview: Changing Roles for DBAs. Syncsort Blog, January 13, 2016 Does the Title “DBA” Still Apply? Database Trends and Applications, January 7, 2016. Evaluating Your Need for a Data Warehouse Platform. SearchDataManagement, Jan 6, 2016.

2015

Q+A: Locking. datAvail Blog, December 24, 2015. Consider Table Expressions to Improve Performance. datAvail Blog, December 23, 2015. Database Performance and Row Size for DB2. datAvail Blog, December 18, 2015. DB2 Optimization and Access Paths: Understanding the Basics Part 3: Optimization Class. Toad World, December 14, 2015 Q+A: Nulls and DASD. datAvail Blog, December 14, 2015. Every IT Professional Should Work in a Mainframe Environment (…at some point). Planet Mainframe, December 9, 2015. Determining Your Database Backup Schedule. Database Trends & Applications, Dec 2, 2015. DB2 Optimization and Access Paths: Understanding the Basics Part 2: Join Methods. Toad World, November 20, 2015 The Benefits of Deploying a Data Warehouse Platform. SearchDataManagement, Nov 2015. The DB2 Performance Advisor: What is Performance? DirectionIT, November 2015. The Difference Between Development DBAs and Production DBAs. Database Trends and Applications, November 9, 2015. Consider Capping to Control Costs. Planet Mainframe, November 7, 2015. DB2 Optimization and Access Paths: Understanding the Basics Part 1: Scans vs Indexed Access. Toad World, October 29, 2015 VARCHAR versus Compression. datAvail Blog, October 27, 2015. DBAs: Get Your Priorities Straight! Database Trends and Applications, October 2015. A Sample DBA Job Posting. TDAN, October 2015. Understanding DB2 for LUW Messages. Toad World, September 17, 2015 The Problem with Database Standards. Database Trends and Applications, September 2015. Evaluating DB2 Tool Vendors. datAvail Blog, September 1, 2015. How to select the best DBMS software: A buyer’s guide. TechTarget, August 27, 2015. Using Date and Time Arithmetic in DB2. Toad World, August 20, 2015 Adding Column Names to an Unload File. datAvail Blog, August 19, 2015. The Big Unstructured Data Lie. Database Trends and Applications, August 2015. SAP HANA in-memory DBMS overview. SearchDataManagement, August 7, 2015. Advice on Using Variable Character Columns in DB2. datAvail Blog, August 4, 2015. Redis Open Source DBMS overview. SearchDataManagement, July 29, 2015. Riak NoSQL DBMS overview. SearchDataManagement, July 29, 2015. MySQL Open Source RDBMS overview. SearchDataManagement, July 28, 2015. DB2 Compression: z/OS versus LUW. Toad World, July 28, 2015 Neo4j Graph DBMS overview. SearchDataManagement, July 21, 2015. MongoDB NoSQL DBMS overview. SearchDataManagement, July 18, 2015. MarkLogic Server NoSQL DBMS overview. SearchDataManagement, July 16, 2015. A Compendium of DBA Quotes and Wisdom. Database Trends and Applications, July 2015. InfiniteGraph distributed graph database overview. SearchDataManagement, June 29, 2015. So Just What is a Big Database These Days? Toad World, June  26, 2015. IBM DB2 relational DBMS overview. SearchDataManagement, June 19, 2015. Microsoft SQL Server 2014 relational DBMS overview. SearchDataManagement, June 18, 2015. Amazon SimpleDB overview. SearchDataManagement, June 16, 2015. Apache Cassandra DBMS overview. SearchDataManagement, June 16, 2015. Aerospike NoSQL DBMS overview. SearchDataManagement, June 15, 2015. Which in-memory DBMS best fits your company’s needs? SearchDataManagement, June 12, 2015. What is a NewSQL Database System? Database Trends and Applications, June 2015. How to determine which NoSQL DBMS best fits your needs. SearchDataManagement, June 5, 2015. Oracle Database 12c relational database management system overview. SearchDataManagement, June 5, 2015. The Never-Ending To-Do List of the DBA. T oad World, May 27, 2015. Returning Only Numeric Data. datAvail Blog, May 26, 2015. How and When to Use DB2 Scrollable Cursors. datAvail Blog, May 19, 2015. How Effective Are Your DBAs? Database Trends and Applications, May 2015. Accessing Partitioned Data in DB2 for z/OS. datAvail Blog, May 1, 2015. Which relational DBMS is best for your company? SearchDataManagement, April 2015. How to determine if an in-memory DBMS is right for your company. SearchDataManagement, April 2015. A High Level Overview of DB2 for z/OS. Toad World, April 21, 2015. Data Modeling Still Applies. Database Trends and Applications, April 2015. Using Nulls in DB2. datAvail Blog, April 6, 2015. Key criteria for deciding if a NoSQL DBMS meets your IT needs. SearchDataManagement, March 2015. A Reasonable Approach to View Creation. Toad World, March 19, 2015. Missing Information and the Relational Null. Database Trends and Applications, March 2015. A Short Overview of DB2 Connect. Toad World, February 24, 2015. Key criteria for deciding if a relational DBMS meets your IT needs. SearchDataManagement, February 2015. DSNTEP2 a.k.a Batch SPUFI. datAvail Blog, February 19, 2015. The Impact of Change on Database Structures. Database Trends and Applications, Feb 2015. VSAM Demystified. datAvail Blog, February 2, 2015. Evaluating the Different Types of DBMS Products. SearchDataManagement, January 2015. DB2 SQL Query Tweaking. Toad World, January 24, 2015. Key Developments in Big Data, Data Management, and New Tech in 2014. Database Trends and Applications, January 2015. Know Your Isolation Levels. Toad World, January 5, 2015.

2014

Minimizing Lock Contention Issues. datAvail Blog, December 30, 2014 DB2 Compression: z/OS versus LUW. datAvail Blog, December 16, 2014 Controlling the Rolling Four Hour Average and DB2 Costs. Toad World, December 10, 2014 The Aging Mainframer. datAvail Blog, December 4, 2014 What Can You Do to Avoid Database Locking Problems? Database Trends & Apps, Dec 2014. Top 10 Steps to Building Useful Database Indexes. Database Trends & Applications, Nov 2014. A Sample DBA Job Posting. Toad World, October 24, 2014. Improving Data Integrity Using Check Constraints. Database Trends and Applications, Oct 2014. How to Assure Data Integrity in DB2 for z/OS. Toad World, September 26, 2014. A Short History of DB2 for z/OS. Database Trends and Applications, September 2014. The Danger of Dirty Reads. Database Trends and Applications, August 2014. DB2 Optimization and Access Paths: Understanding the Basics [Part 2]. SSWUG, July 28, 2014. DB2 Optimization and Access Paths: Understanding the Basics [Part 1]. SSWUG, July 21, 2014. The Ten Database Commandments to Ensure an Effective, Accurate, Well-Designed Database. Database Trends and Applications, July 2014. Database Auditing on DB2 for z/OS. Enterprise Tech Journal, June / July 2014. Database Standards and Procedures. Toad World, June 24, 2014. Counting Characters Using Only SQL. SSWUG, June 16, 2014. Regulatory Compliance Requires Metadata and Data Quality Programs. Database Trends and Applications, June 2014. Using REOPT to Control SQL Dynamism in DB2 for z/OS. Enterprise Tech Journal, May / June 2014. Avoid Black Boxes to Optimize DB2 Application Efficiency. Toad World, May 28, 2014. A SQL Trick to Eliminate Unwanted Spaces .SSWUG, May 27, 2014. Introduction to Recursive SQL. Database Trends and Applications, May 2014. Best Practices for Upgrading to a New DBMS Version. Toad World, April 30, 2014. Advanced Analytics Projects Offer Value. Database Trends and Applications, April 2014. The Database Report: 1Q2014. The Data Administration Newsletter, April 2014. Types of Performance Monitoring and Tuning for DB2 Applications. Toad World, March 24, 2014. Database Contingency Planning - Preparing for Disasters You Hope Won’t Happen. Database Trends and Applications, March 2014. Top Ten Steps to Building the Right Indexes. Toad World, February 28, 2014. Gaining an Appreciation of Metadata Through Music. Database Trends & Apps, February 2014. Compression Improvements Ease Big Data Burdens. Toad World, January 22, 2014. A Data-Tinged Look Back at 2013. Database Trends and Applications, January 2014. The Database Report: 4Q2013. The Data Administration Newsletter, January 2014.

2013

DSNZPARMs: DB2 Systems Configuration Parameters. Toad World, December 18, 2013. DB2 Performance Fundamentals. SSWUG, December 9, 2013. Thinking About Migrating to Version 11 of DB2 for z/OS? Database Trends and Applications, December 2013. A Primer on the Basics of NoSQL Databases. Database Trends and Applications, Nov 2013. Using Check Constraints To Simulate Domains. Toad World, November 20, 2013. Webinar: Building a Performance Centric Organization. datAvail Blog, November 12, 2013. Dynamic SQL Performance (for DB2). Toad World, October 23, 2013. How to ORDER BY an Expression in DB2. SSWUG, October 22, 2013. Understanding the Rolling Four Hour (R4H) Average to Control DB2 Costs. Information on Demand 2013, October 21, 2013. Metadata Matters. Insurance Day, October 16, 2013. Selecting Every Other Row. SSWUG, October 15, 2013. The Database Report: 3Q2013. The Data Administration Newsletter, October 2013. The DBA’s Guide to Application Development. Database Trends and Applications, Oct 2013. What Does a DBA Do? Information on Demand 2013, October 1, 2013. Agility in the Data Center: An Interview With CA Technologies’ Troy Coleman. Enterprise Executive, September/October 2013. Database Recovery is a Compliance Issue. SSWUG, September 26, 2013. DB2 Developer’s Guide: Helping DB2 Professionals for More Than 20 Years. Information on Demand 2013, September 25, 2013. Successful Database Change Management Requires Planning. Database Trends & Applications, September 2013. Hunting Down Unused DB2 for z/OS Programs and Indexes. Toad World, Sept 20, 2013. Managing DB2 for z/OS Application Performance. SSWUG, September 10, 2013. What’s In a Name? On Database Naming Standards. SSWUG, September 3, 2013. High-Level Tips & Techniques for DB2 SQL Performance. Toad World, August 27, 2013. DBA Proverbs – More Words to Live By. Enterprise Tech Journal, August / September 2013. Bad Database Standards Can Cause Performance Problems. Database Trends and Applications, August 2013. Coding DB2 SQL for Performance. Toad World, July 29, 2013. How to Become a DBA. Database Trends and Applications, July 2013. Issuing SQL Statements in DB2 Utilities. SSWUG, July 2, 2013. The Database Report: 2Q2013. The Data Administration Newsletter, July 2013. The Ever-Changing Role of the DBA. The Data Administration Newsletter, July 2013. First, You Must Define Data Integrity. SSWUG, June 13, 2013. The Importance of Storage Management for Database Administration. Database Trends and Applications, June 2013. Managing Database Storage. SSWUG, May 23, 2013. DB2 News from IDUG NA 2013. Toad World, May 20, 2013. Preparing for Database Application Design Reviews. SSWUG, May 16, 2013. SELECT from INSERT, DELETE, UPDATE and MERGE. SSWUG, May 9, 2013. General Guidelines for LOAD, REORG and REBUILD Utilities. Enterprise Tech Journal, May 2013. Data on the Move: Techniques and Tips to Maintain Control. Database Trends and Applications, May 2013. Database Administration in an Increasingly Complex World. SSWUG, May 2, 2013. Should Traditional Data Management Concepts Apply in the Age of Big Data? Database Trends and Applications, April 2013. The Database Report: 1Q2013. The Data Administration Newsletter, April 2013. Curbing the Curmudgeons in the Corner. SSWUG, April 1, 2013. Safeguarding Financial Data. SSWUG, March 4, 2013. DBA Rules of Thumb. The Data Administration Newsletter, March 1, 2013. Working with Variable Length Data. SSWUG, February 25, 2013. Database Recovery Is a Compliance Issue. Database Trends & Applications, March 2013. Developing Cross-Platform Database Apps with FileMaker Pro 12. Database Trends and Applications, February 2013. Database Capacity Planning. SSWUG, February 11, 2013. Recoverability Trumps Performance. SSWUG, February 4, 2013. DB2 SQL: Stages 3 and 4. SSWUG, January 28, 2013. A Data-Tinged Look Back at 2012. Database Trends and Applications, January 2013. The Database Report: 4Q2012. The Data Administration Newsletter, January 2013.

2012

New Year’s Resolutions for DBAs. SSWUG, December 2012. The Scoop on “Dirty Read” Enterprise Tech Journal, December 2012 / January 2013. Avoiding Database Design Trap to Ensure Usability. Database Trends & Applications, Dec 2012. Data Administration versus Database Administration. SSWUG, November 2012. Database Design: From Logical to Physical. SSWUG, November 2012. Reading Things That Aren’t There… and Missing Things That Are! SSWUG, November 2012. A DBA By Any Other Name. Database Trends and Applications, November 2012. Materialized Query Tables…and the Death of Denormalization? SSWUG, November 2012. What Can You Do to Avoid DB2 Locking Problems? Enterprise Tech Journal, October / November 2012. The Ever-Changing Role of the DBA. SSWUG, October 2012. Denormalization Techniques for Relational Databases. SSWUG, October 2012. Performance Management Must Evolve to Meet Changing Data Warehouse Demands. Database Trends and Applications, October 2012. SELECT from DELETE, UPDATE, and MERGE. SSWUG, October 2012. The Database Report: 3Q2012. The Data Administration Newsletter, October 2012. The Dirty Read (AKA Uncommitted Read). SSWUG, October 2012. DB2 Buffer Pool Essentials. SSWUG, September 2012. Surrogate Keys or Natural Keys? Database Trends and Applications, September 2012. The Big Deal About Big Data. Enterprise Tech Journal, August / September 2012. Using Nulls in DB2. SSWUG, August 2012. Regulatory Compliance and Database Administration. Database Trends & Apps, Aug 2012. Building a Database Systems Bookshelf. SSWUG, August 2012. Don't Forget DISPLAY as a Part of Your DB2 Tuning Efforts. SSWUG, July 2012. Database Archiving for Long-Term Data Retention. ILM Solutions, July 2012. Removing Superfluous Spaces. Database Trends and Applications, July 2012. The Database Report: 2Q2012. The Data Administration Newsletter, July 2012. pureXML: Using XML in DB2 for z/OS. InformIT, June 2012. UNIX for DBAs. SSWUG, June 2012. The Myth of Information Overload. The Data Administration Newsletter, June 2012. Bachelor Programming Syndrome. Database Trends and Applications, June 2012. A Short History of DB2 for z/OS. SSWUG, May 2012. What is Large? Database Trends and Applications, May 2012. Can Data Quality Be Forced? zJournal, April / May 2012. The Database Report: 1Q2012. The Data Administration Newsletter, April 2012. Harden Your Applications to Combat SQL Injection. Database Trends & Applications, April 2012. Making Static SQL More Dynamic...and Vice Versa. SSWUG, April 2012. DB2 Tips. zJournal, February / March 2012. There's No Such Thing as Information Overload. SSWUG, March 2012. Evaluating a DBA Job Offer. Database Trends and Applications, March 2012. Four Non-Technical Steps to Data Security. SSWUG, February 2012 Supporting Temporal Data in the Database. Database Trends and Applications, February 2012. Avoiding Bachelor Programming Syndrome. SSWUG, January 2012 A Resurgence of Metadata Management. SSWUG, January 2012 The Database Report: 4Q2011. The Data Administration Newsletter, January 2012. A Data-Tinged Look Back at 2011. Database Trends and Applications, January 2012. Security Improvements in DB2 10 for z/OS. zJournal, December 2011 / January 2012.

2011

The Tao of the Database Administrator. SWUG, December 2011 Compliance and Data Access Tracking. Database Trends and Applications, December 2011. Optimistic Locking in DB2 for z/OS. SSWUG, December 2011 The Guide to Being a Successful DBA. Database Trends and Applications, November 2011. The Impact of Mergers on Data Management. SSWUG, November 2011 Data Quality Starts with Proper Data Types. SSWUG, October 2011 DB2 Security - A Common Language for a Common Goal. IDUG Tech Library Blog, October 2011 (co-authored with Rebecca Bond) The Return of the DBA Proverbs. zJournal, October / November 2011. Building Your SQL Library. Database Trends and Applications, October 2011. The Database Report: 3Q2011. The Data Administration Newsletter, October 2011. Ten Breakthroughs That Changed DB2 Forever. SSWUG, October 2011 Collecting Histogram Statistics With RUNSTATS. SSWUG, September 2011 Cost Containment Thru Capping. Database Trends and Applications, September 2011. The State of Database Administration 2011: Types, Trends, & Technologies. SSWUG, August/September 2011 On The Need for Temporal Data. zJournal, August/September 2011. Through The Looking Glass. Database Trends and Applications, August 2011. The Database Report: 2Q2011. The Data Administration Newsletter, July 2011. Blinking Your Databases to Health. Database Trends and Applications, July 2011. The Procedural DBA. SSWUG, July 2011 Partitioning Pros and Cons. zJournal, June/July 2011. A Basic Introduction to Coding DB2 SQL for Performance. SSWUG, June 2011 DBA as a Management Discipline. Database Trends and Applications, June 2011. atabase Archiving and Auditing Can Minimize the Potential of a Data Breach. SSWUG,May 2011 The Importance of Database Design Reviews. Database Trends and Applications, May 2011. Best Practices in DB2 Storage Management. zJournal, Apr/May 2011. Not Your Standard Sorting Requirement.  Quest ToadWorld Pipelines, April 2011. Mitigating Data Risk During an Acquisition. Database Trends and Applications, April 2011. The Database Report: 1Q2011. The Data Administration Newsletter, April 2011. Database Administration and the Goal of Diminishing Downtime. Database Trends and Applications, March 2011. Dynamic SQL Versus Static SQL. zJournal, Feb/March 2011. Consider Capping to Control Costs. The Data Administration Newsletter, February 2011. Taking A Systematic Approach to View Creation. Database Trends and Applications, Feb 2011. The Database Report: 4Q2010. The Data Administration Newsletter, January 2011. A Data-Tinged Look Back at 2010. Database Trends and Applications, January 2011.

Recent Articles 2011-2020

Links to recent articles by Craig S. Mllins

Craig’s Db2 Books Db2 Dev Guide Db2 App Perf

Craig’s DBA Book DBA Best Practices 2ed