SQL Optimization is intimidating for a lot of people. Even when you have great tools like Quest SQL Optimizer, people can be reluctant to hop into a different UI with so many powerful options. Thankfu...
Introduction Several articles have been written about how to track the usage of indexes and there are several scripts to determine which indexes are being used after monitoring for a while. In previou...
Introduction In my previous articles I explained two very important concepts about Undo Data; one is how Oracle manages the retention time and the other is how Oracle reuses the undo extents. You can ...
In this blog post, I would like to show you how to install Toad for DB2 version 6.3 and IBM Data Server Driver. Using IBM Data Server Driver is a new option in Toad for DB2 version 6.3. Previously it ...
This is the fourth part of series of blog posts on 'How the EU GDPR will affect the use of Machine Learning‘ In this blog post (Part4b) I will examine some of the more technical aspects and how the i...
Hi, I’ve written a lot of articles on Oracle12 new features. This article will conclude the series with a list of miscellaneous new features for the various other tools like data pump, the scheduler,...
In this second of a series of entries on my favorite SQL-related enhancements provided via Db2 12 for z/OS (and "Db2," versus "DB2," is officially the new form of the product name), I will describe us...
En el presente artículo quiero compartir con toda la comunidad las entrevistas que llevé a cabo a dos colegas amigos Mónica Godoy y Daniel Bozzolo junto con mi experiencia siendo desarrolladora. Nues...
In this article, I want to share with all the community the interviews I conducted with two friends and colleagues, Monica Godoy and Daniel Bozzolo, as well as my own experience as a developer. Our ma...
Introduction Apache Solr is a leading enterprise search engine based on Apache Lucene. Apache Solr stores the data it indexes in the local filesystem by default. HDFS (Hadoop Distributed File Syste...
Introduction In an earlier article, Continuous Integration from AWS CodeCommit to Docker Hub with AWS CodeBuild, we discussed how Jenkins has some limitations as a build tool and how AWS CodeBuild ov...
Hi follow Toadies! As a SQL Server administrator you're likely managing dozens if not hundreds of databases. It's extremely time consuming to run a script on each and every one of those databases and...
