DB2 LUW indexes, like any database indexes, can be extremely helpful for queries that need data that’s scattered in the database. They act, of course, like a book’s index – rather than methodically ...
PostgreSQL database is one of the leading open source databases and often compared with MySQL database. While PostgreSQL is completely open source, MySQL has commercial versions also. PostgreSQL datab...
Db2 9 for z/OS became generally available back in 2007. In the years since, most of the features introduced with Db2 9 have been broadly put to use. An interesting exception is the auto-sizing of buff...
Toad Data Point Quick Tip Video on Auto Replace...
One of my customers had a problem about logging in to ODI Studio. Their ODI implementation is configured to use external authentication (Microsoft Active Directory). The configuration was done years a...
Learn how to replay workloads for migration testing, SQL performance tuning, and more with Benchmark Factory. Watch this demo of an Oracle Database Replay. You can get started with Benchmark Factory b...
When is data less valuable? How do you manage data as it becomes less valuable? In the good old days the answer to these questions was easy; it was simply based on what the company was willing to pay...
Toad Data Point Quick Video Tip on Code Completion...
The next release of Toad for Oracle is coming soon and, as ever, we have some exciting things to tell you about! Our main theme continues to be workflow simplification for users who may be new to Toa...
We launched our first release of Toad DevOps Toolkit last November and we’ve already seen a huge amount of interest. We’ve listened to feedback from our customers and it’s been extremely positive. Ho...
This is the fourth blog post which I share sample scripts of my presentation about “Apache Spark with Python“. Spark supports two different way for streaming: Discretized Streams (DStreams) and Struct...
In this blog post, I’ll share example #3 and #4 from my presentation to demonstrate capabilities of Spark SQL Module. As I already explained in my previous blog posts, Spark SQL Module provides DataFr...
