10/16/23

Db2 ML Models for DB Admin

7/28/23

IDUG 2023 Highlights

 6/27/23

Db2, Lakehouse, and watsonx.data

4/18/23

Db2 as a Graph Database

12/19/22

Db2 and Machine Learning

9/27/22

Db2 REST Services to Change DB Data

7/27/22

Db2 Rest End Point   and Database Security

5/27/22

DB2 Connect Usage and Editions (Updated)

3/31/22

Db2 Utilities and Cloud Storage

1/31/22

DB2 11.5.0 – 11.5.7 New Features

 9/29/21

Query any DB from One REST Endpoint

7/29/21

Scheduling Python Scripts  to Run in Cloud Pak for Data 

 5/25/21

Db2 Rest Endpoint

3/30/21

Virtualize Files on Remote Servers

1/29/21

Data Protection Rules for Data Virtualization

11/29/20

Protecting your Virtualized Data

 9/29/20

Data Virtualization

7/31/20

CPD First Steps

 5/29/20

Finding & Understanding Your Data

3/27/20

Always on Data Masking using Db2 RCAC

1/27/20

External Tables w/ Cloud Files 

11/30/19

External Tables 

7/26/19

DB2 11.5 New Features 

6/27/19

IBM Demo Sites

 5/31/19

Db2 Row and Column Access Control

4/29/19

See End Users in Db2  Using Trusted Context

3/29/19

Jupyter Notebook Db2 Client

2/25/19

Query JSON in Db2

7/30/18

IBM Cloud Private for Data Overview

6/28/18

Db2 Event Store

5/29/18

Db2 Deployment Options

4/27/18

Query Db2 Using REST APIs

3/22/18

Query Cloud Db2 Using REST APIs

2/16/18

Creating your Think Agenda: Samples Included

1/30/18

Watson Data Platform

10/31/17

DB2 Edition, Support & Fixpack Updates

9/29/17

Easy Db2 Install Using Docker

4/29/17

Using Various Data

3/31/17 

API Data in Your Database

2/27/17

Redirected PIT TS Restore - Kathryn Ericsson

1/30/17

Put the Weather in your Databases

12/28/16

Combine Exotic Data Sources in dashDB

11/28/16

db2Dean’s 2016 Insight Highlights

10/31/16

Open Source DBs for Enterprises

9/30/16

Creating your WoW Agenda – Samples Included

9/30/16

Loading Data to DashDB

7/29/16

Connecting to dashDB

6/27/16

DB2 11.1 New Features 

5/31/16 

Data Server Manager

4/20/16

DataWorks

2/26/16

Different DB Platforms for Different Jobs

1/30/16

Fast Visualization of JSON data

12/21/15

Watson Analytics - Speed of Visualization

11/27/15

db2Dean’s 2015 Insight Highlights

9/28/15

Creating your Insight Agenda – Samples Included

8/30/15

Spark & Data Scientist Workbench

7/31/15

Big Data - Why Do I Care?

6/22/15

Watson Analytics

5/27/15

 Major updates to:

IBM Support Updates for DB2 for LUW and Z

Getting DB2 Help

4/30/15

Major updates to:

Enable Yourself to Down Load IBM Software

Enabling Yourself to Open IBM Support Requests

3/31/15

High Availability Options for DB2 (Update)

2/26/15

Quickly Convert a File to a Table in Bluemix

1/29/15

Bluemix Cloud Databases

12/31/14

Connecting to your Optim Archive Files

11/28/14 

db2Dean’s 2014 Insight Highlights

10/31/14

Archive Old Data from Host Systems

9/29/14

Creating your IOD Agenda – Samples Included

8/29/14

Running RUNESTATS for DB2/LUW

7/29/14

Overview of Big SQL 3.0 Functionality

6/30/14

Data Warehouse Augmentation using Big Data

5/30/14

Using Federation with Optim

4/28/14

Big Data Overview

 3/28/14

DB2 Connect Usage and Editions (Updated)

2/28/14

Data Studio XML Editor w/ DB2 Auto Maint Example

1/25/14 

 Configure DB2 Auto Maint using Data Studio

12/23/13

BLU for Cloud

11/26/13 

db2Dean’s 2013 IOD Highlights

 10/30/13

Data Studio Update Part 7 Find and Tune Bad Queries from the Package Cache

9/30/13 

Creating your IOD Agenda – Samples Included

8/29/13

Data Studio Update Part 6 Query Tuning for DB2 LUW and z/OS

7/29/13

DB2 10.5 New Features 

6/27/13

Data Studio Update Part 5 Query Building and Editing

5/28/13 

Data Studio Update Part 4 Changing Database Objects 

4/29/13

Data Studio Update Part 3 View DB Objects and Attributes 

 3/28/13

DB2 Ingest Utility

2/28/13

Data Studio Update Part 2 Perspectives Views & DB Connections 

1/31/13

Data Studio Update Part 1 

12/27/12

DB2 Server Installers

11/28/12

db2Dean’s 2012 IOD Highlights

10/29/12

Comprehensive Database Security

9/28/12

Creating your IOD Agenda – Samples Included

8/29/12

Optim Configuration Manage Overview for LUW and Z

7/27/12

DB2 Deployments on IBM PureApplication Systems

6/29/12

Using the db2pd Command

5/31/12

DB2 v10.1 New Features

4/28/12

Data Studio Web Console

3/27/12

Installing and using Optim Designer For ILM Tools (Jody Hair)

2/28/12

Life After the DB2/LUW Implementation

1/26/12

Beginner’s Guide to Optim Information Lifecycle Tools

12/27/11

Managing your Youngest and Oldest Data

11/28/11

db2Dean’s 2011 IOD Highlights

10/28/11

DB2/LUW Security Tools

 9/23/11

Creating your IOD Agenda – Samples Included

8/24/11

DB2 Storage Observations

7/25/11

 Use Static SQL to Enhance Performance

6/27/11

DB2 LUW WLM Work Load Manager (Mark Mulligan)

5/27/11

DB2/LUW Statement Concentration

4/29/11

Running DB2 Queries Part 4

3/21/11

Running DB2 Queries Part 3

2/25/11

DB2 Connect Usage and Editions (Updated)

1/21/11

Running DB2 Queries Part 2 -- CLPPlus

12/23/10

db2Dean’s 2010 IOD Highlights

11/22/10

DBA, Get Your Own Test DB Server (DB2 in the Cloud)

10/30/10

Running DB2 Queries Part 1

9/27/10 

DB2 pureScale Update (Maria Schwenger and Kamen Tsvetkov)

7/29/10

HADR Reads on Standby 

8/28/10

DB2/LUW Security - Inside the Perimeter 

6/28/10 

DBA Productivity Tools 

5/28/10

Pass the DB2/LUW License Audit 

4/16/10

Move or Copy DB2 Data (Updated) 

3/30/10

DB2 pureScale (Maria Schwenger, PhD)

2/24/10

IBM Support Updates for DB2 for LUW and Z

1/25/10

DB2 Health Advisor

12/21/09

DB2 DB Creation Considerations

11/20/09 

db2Dean’s 2009 IOD Highlights

10/31/09

Using DB2 Table (Range) Partitioning

9/25/09

DB2 Clients -- Connect to your Database

8/25/09 

DB2 Administrative Views

7/20/09

IBM Performance Expert (Jeff Sullivan)

6/23/09 

New Features of DB2/LUW v9.7

5/20/09

Essential DB2 Health Check

4/17/09 

Database Federation or Replicaiton

3/24/09

Data Studio Overview

2/20/09 

DB2 Cost Savings Tips

1/20/09 

Move or Copy DB2 Data

12/19/08

DB2 Samples Scripts

11/21/08

db2Dean’s 2008 IOD Highlights

10/22/08 

SMS, DMS and Automatic Storage

9/19/08

Data Warehousing Terms Explained

8/20/08 

Lesser Known Features of DB2 v9.5

7/21/08 

Lesser Known Features of DB2 v9.1

6/20/08

Recommended Reading

5/20/08 

DB2 Built-in Performance & Health Tools

3/25/08 

IBM Database Replication Tools Comparison (Sean Byrd)

1/25/08 

Rational Data Architect

1/7/08 

Virtual Databases

11/15/07 

Enable Yourself to Down Load IBM Software

10/31/07 

IOD 2007 Trip Report

9/12/07 

Enabling Yourself to Open IBM Support Requests

5/17/07

Getting DB2 Help

3/27/07 

DB2 Connect Usage and Editions

3/1/07

High Availability Options for DB2/LUW

1/9/07

Replicating Data Loads from a DB2 9 HADR Primary Server to a Standby Server (Craig Maddux)

12/15/06 

Dean’s Favorite Links

12/6/06 

DB2Fix Packs