21
Sat, Dec
3 New Articles

Kent Milligan

 

  Sort By:
  Display:
Published Title Category Hits
01 December 2021 TechTip: More Deterministic Performance for UDFs DB2 | Analytics & Cognitive 5,039
05 May 2021 New Solution for Combining Multiple Row Values into a Single Row with SQL SQL | Programming 12,663
15 January 2021 TechTip: Streamline Your SQL Procedures, Functions, and Triggers SQL | Programming 6,124
11 December 2020 TechTip: Top 3 Reasons to Avoid Mixing SQL with QTEMP DB2 | Analytics & Cognitive 9,524
13 November 2020 Hands-Free SQL DROPs with New IF EXISTS Support SQL | Programming 10,401
01 February 2016 A Checkup on IBM Watson Health Analysis of News Events | Current Events & Commentary 4,449
08 May 2015 TechTip: Routing Away Your QZDASOINIT Troubles DB2 | Analytics & Cognitive 18,214
10 April 2015 TechTip: Secure Sensitive IBM i Data in DB2 for i Monitor Collections DB2 | Analytics & Cognitive 4,511
13 March 2015 TechTip: Dealing with Blank Checks in DB2 SQL | Programming 8,872
27 February 2015 Book Review: DB2 10 for z/OS: The Smarter, Faster Way to Upgrade DB2 | Analytics & Cognitive 9,189
13 February 2015 TechTip: More on Combining Multiple Row Values into a Single Row with SQL in DB2 for i SQL | Programming 10,637
09 January 2015 TechTip: Combining Multiple Row Values into a Single Row with SQL in DB2 for i SQL | Programming 40,447
05 December 2014 TechTip: Enhanced Debug Experience for SQL Routines in IBM i SQL | Programming 7,021
14 November 2014 TechTip: DB2 for i's Sample Database DB2 | Analytics & Cognitive 9,138
22 August 2014 TechTip: Protecting Against Accidental Updates with Masked Values DB2 | Analytics & Cognitive 5,398
11 July 2014 TechTip: New Function Resolution Casting Rules for DB2 DB2 | Analytics & Cognitive 4,641
14 May 2014 Simplicity and Security Abounds in DB2 for i 7.2 DB2 | Analytics & Cognitive 7,435
15 November 2013 TechTip: Streamline Your Migration to SQL SQL | Programming 6,662
11 October 2013 TechTip: Get a Grip on Your IBM i Databases with IBM Data Studio DB2 | Analytics & Cognitive 13,655
13 September 2013 TechTip: Keep DB2 Routines in Synch Across Systems DB2 | Analytics & Cognitive 5,336
17 May 2013 TechTip: Simplify and Centralize Your SQL Triggers SQL | Programming 8,010
12 April 2013 TechTip: Direct SQL Control of System Names SQL | Programming 7,130
02 January 2013 Simplified Management of SQL Procedures and Functions SQL | Programming 7,348
12 December 2012 TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults DB2 | Analytics & Cognitive 6,063
20 July 2012 Book Review: DB2 9.7 for Linux, UNIX, and Windows Database Administration (Exam 541) DB2 | Analytics & Cognitive 9,316
13 July 2012 TechTip: Easier DB2 for i Data Transfers with New Technology Refresh DB2 | Analytics & Cognitive 6,871
20 June 2012 DB2 Field Procedures Finally Support Conditional Masking RPG | Programming 15,430
13 April 2012 TechTip: DB2's CONNECT BY Simplifies Recursive Processing DB2 | Analytics & Cognitive 18,686
20 January 2012 TechTip: Simplify Tracking of DB2 Table Metrics DB2 | Analytics & Cognitive 5,959
28 October 2011 TechTip: Achieve Memory-Making SQL Performance with DB2 In-Memory Support DB2 | Analytics & Cognitive 16,867
25 July 2011 Get Your System Humming: 7 Great Tips for Tuning DB2 for i DB2 | Analytics & Cognitive 22,437
20 May 2011 TechTip: Boost SQL Performance on DDS Databases SQL | Programming 9,603
01 April 2011 TechTip: Database Blocking Made Simple DB2 | Analytics & Cognitive 11,295
28 March 2011 Enable Transparent Encryption with DB2 Field Procedures DB2 | Analytics & Cognitive 23,184
03 December 2010 TechTip: Understanding Your SQL Output Options SQL | Programming 22,354
03 September 2010 TechTip: Simplify Your Development with DB2 Automatic Timestamp Support DB2 | Analytics & Cognitive 27,671
06 August 2010 TechTip: Tracking DB2 QSQSRVR Job Usage Just Got a Lot Easier DB2 | Analytics & Cognitive 15,696
26 April 2010 DB2 for i 7.1: More Than Meets the Eye DB2 | Analytics & Cognitive 18,357
02 April 2010 TechTip: Grab Control of the DB2 QSQSRVR Jobs DB2 | Analytics & Cognitive 16,177
16 December 2009 Halt Those Long-Running SQL Queries SQL | Programming 16,547
10 July 2009 TechTip: Minimize DB2 Database Monitor Overhead DB2 | Analytics & Cognitive 9,111
13 March 2009 TechTip: Hidden Filters Improve DB2 Database Monitor in V5R4 DB2 | Analytics & Cognitive 7,483
08 August 2008 TechTip: Speed Up SQL Procedures with Service Program Support SQL | Programming 10,758
18 July 2008 TechTip: More-Flexible SQL Triggers SQL | Programming 15,193
25 April 2008 TechTip: RUNSQLSTM Is Bigger and Better in V6R1 General | Programming - Other | Programming 22,608
09 November 2007 TechTip: Pseudo Journal—Estimate the Overhead of System i Journaling DB2 | Analytics & Cognitive 12,201
20 July 2007 TechTip: V5R3 PTFs for SQL and RPG Free-Format IBM i (OS/400, i5/OS) | Operating Systems | IT Infrastructure 11,214
06 April 2007 Partner TechTip: Blend SQL and RPGLE to Make Better Tools SQL | Programming 10,602
30 March 2007 TechTip: Cut to the Chase with DB2 Index Advisor PTFs DB2 | Analytics & Cognitive 11,810
16 March 2007 TechTip: SQL and i5/OS Record Format Names SQL | Programming 21,074
Kent Milligan
Kent Milligan is a Senior Db2 for i Consultant in the IBM Lab Services Power Systems Delivery Practice.  Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the DB2 for i Lab Services practice in 2020, Kent spent 5 years working on healthcare solutions powered by IBM Watson technologies. Kent is a sought-after speaker and author on Db2 for i & SQL topics.