Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clustering index, and he wanted to know how he could get Db2 to a...
Hi everybody, I'd like to share with you my plans for my upcoming speaking activities for the first half of 2018. Israel Oracle User (ILOUG) Group Tech Days 2018 (Jan 22-23) – very excited to presen...
Introduction In an earlier article we introduced creating an AWS CodePipeline to continuously integrate GitHub code for a Docker image and subsequently continuously deploy a Docker platform applicat...
Introduction InModularization by using Oracle Database Containers and PDBs on Docker Engine we discussed using a Docker image for Oracle Database 12c. A Docker image is built from a Dockerfile, which ...
¡Que éste inicio del nuevo año sea un año lleno de éxitos personales y profesionales para cada uno! Este año 2017 fue un año en el cual he podido cumplir muchas metas personales y profesionales, ent...
There’s a lot of versions of SQL Server available today. I’ve seen clients deploying new services on SQL Server 2015, SQL Server 2016, SQL Server 2017 (yes we have a client on SQL Server 2017 already...
For the purposes of this, we’re ignoring SQL Server 7.0 and below. Out of the box, SQL Server will encrypt some things by default to protect you and your data. Out of the box, SQL Server will encrypt...
Hi, This article is a continuation of part 5 of this series (click here to see Part 5) in which I will discuss the Native Dynamic SQL and how I used dynamic SQL to solve tough parallel SQL performance...
This video demonstrates the use of the Database Compare feature in the Toad DevOps Toolkit. The demo covers the basics features and function utilizing PowerShell. Sample script used in this video: Dem...
This video demonstrates the use of the Script Execution feature in the Toad DevOps Toolkit. The demo covers the basics features and function utilizing PowerShell. Sample script used in this video: Dem...
This video demonstrates the use of the Table Compare feature in the Toad DevOps Toolkit. The demo covers the basics features and function utilizing PowerShell. Sample script used in this video: Demo_C...
