• 7 Nov 2017

    The Juggling Act of Modern DBAs

    Database performance monitoring can be a real circus! And with an ever-growing amount of technology platforms to manage, we’ve become the ultimate jugglers. Didn’t sign up to be a clown? Hey, I know. I didn’t, either. But, listen, sometimes we’ve gotta adapt to the new roles in which we find ourselves as database administrators. It’s been a progression. Many of us who’ve been around...
    • 27 Oct 2017

    Toad for DB2 - The easy way of transferring scripts from Toad files to PDS member on z/OS

    If you work with Toad for DB2 on your DB2 subsystem, it happens quite often that your work results in a DDL or DML script in the editor. It can’t be executed directly but needs to be scheduled for running in the night. Now you have the challenge to transfer it to your mainframe. No worries, if you use Toad you can easily transfer your script into a PDS member. Before you can start, please ensure this: On each...
    • 19 Oct 2017

    Don’t Be Like the Titanic! SharePlex Can Save You!

    We all know the story of the Titanic and its sinking. Everyone thought it was unsinkable and with that mindset, there were never any thoughts on making sure there were enough life boats. Even after it hit the iceberg, many of the passengers refused to believe that is was actually going to sink until it was too late. Don’t be like the designers who designed Titanic. It had the very best of everything, but this...
    • 19 Sep 2017

    Virtualize Oracle Databases like an Oracle ACE

    Imagine a world where your system administrator provisions a fully functional Linux server that’s patched with all the up-to-date kernel parameters, device drivers and configurations in just one hour. Come on. For real? Yep. Now imagine this: ...
    • 18 Sep 2017

    The Top Five Oracle OpenWorld Sessions

    With so many of the world’s biggest names in IT speaking at Oracle OpenWorld , you have the opportunity to vastly expand your knowledge. But with a whopping fifty speaking sessions to choose from, where do you even begin? Relax. We’ve got...
    • 7 Sep 2017

    Your Oracle OpenWorld (OOW) Survival Guide

    Holy tradeshow chaos! Look at these humans everywhere – all up in your biz! The sweaty handshakes, the names you won’t remember, the pressure to buy products. You had to put on pants. Your “nice” shirt is slowly and methodic...
    • 22 Aug 2017

    Wearing too many hats? A look at the many roles of today’s DBAs

    Once upon a time, database administrators (DBAs) were responsible for as few as one or two database platforms. They had time for things like lunch. Real lunches. Not stress snacks, devoured over keyboards, leaving crumbs wedged between the keys. Back in the day, DBAs had time for friends, for family. They even had energy left over for hobbies. But new tech advancements meant new responsibilities. And that overwhelming...
    • 8 Aug 2017

    Monitoring Workload – Heads or Tails, it's two sides of the same coin

    I often get asked about monitoring SQL workload that is consuming a database instance’s resources. The first question that comes to my mind is, “What is the symptom you are trying to resolve?” Are you looking to understand the root cause of compute resource consumption such as CPU, I/O, memory and timing? Or are you looking to get to the bottom of a specific set of wait events that have been present...
    • 24 Jul 2017

    Logging in Litespeed

    Although we don't like to think about our backups and restores going wrong, there are times when things just sometimes don't work as planned, and if it's not something that is easy to troubleshoot, you may find yourself raising a support case to help fix the issue. One of the things that is most helpful to assist with troubleshooting, is an ' Advanced Engine Log '. This is a verbose log file, which...
    • 24 Jul 2017

    “Pimp Your Ride” with Foglight Custom Dashboards

    Merriam-Webster defines ‘Custom’ as made or performed according to personal order. Tailored, fitted, personalized…or ‘pimped out’, slang meaning something is modified to extreme performance. There was a television serie...
    • 21 Jul 2017

    SharePlex and Jim Clark, the best of the best!

    For those of you who don’t know me. I love racing. I love Formula 1 racing and even more so I love the “Golden Age” of Formula 1 racing before all the electronics and ground effects. Back when it was driver against driver and you had to know how to drift through a turn at full throttle. Jim Clark was one of those drivers. He was born with the natural ability to control a race car through any type of...
    • 14 Jul 2017

    Meet Our Experts! The Voices behind @QuestExperts on Twitter: Aaron Mares

    We are lucky enough to work with a number of extremely talented and passionate people. Some of our coworkers have been here for a number of years and have some great stories to tell. We wanted to use this interview as an introduction to one such individual – Aaron Mares. Tell us a little about yourself: I currently support Spotlight as an Enterprise Tech Support Advisor. I am a firm believer that hard work...
    • 11 Jul 2017

    How DevOps can benefit from Continuous Monitoring of Application Databases

    Managing production application databases has become more demanding than ever before not only due to the complexity of the applications they support, but also the very small margins for performance slowdowns or outages. Being proactive and resolving issues quickly in production requires the collaboration of the operations, DBA and development teams. The Emergence of DevOps Over the years a lot has changed when it...
    • 3 Jul 2017

    The Fourth V

    The key characteristics of Big Data are commonly known as “the 3 V’s”: Volume , Velocity , and Variety . Volume for the amount of data stored to process; Velocity for the tremendous pace required to generate, store and analyze data; and Variety for the many sources of data generated as well as the disparity of formats. There are “2 V’s” that have become incorporated into the literature...
    • 26 Jun 2017

    Backup to Azure with LiteSpeed

    In a previous blog, we learnt how to backup to Amazon S3 with LiteSpeed . Let's see now how to backup directly to Azure. Remember that LiteSpeed does not use any temporary local storage for backups at all ...the backups just go directly to the cloud! First that all let's start registering our account with LiteSpeed. Since in the previous blog we used the "Add Cloud Account" Wizard , let's use the...
    • 23 Jun 2017

    SharePlex Optimistic Commit Explained

    So the other day, as I was using a taxi to get to the airport for a flight. I was watching all the traffic on the freeway and it got me thinking about SharePlex’s optimistic commit feature and a taxi are similar. How can SharePlex and a taxi have anything in common you ask? Well they are both responsible for moving something from one point to another with as little latency or delay as possible. Optimistic commit...
    • 12 Jun 2017

    New Chapter: SharePlex 9.0 SQL Server Capture

    Having worked with SharePlex for the last seventeen years, it is exciting to see SharePlex capture can now replicate data from non-Oracle database SQL Server for the first time. It is very easy to set up and looks and feels just like SharePlex for Oracle. The current 9.0 release supports SQL Server 2012, SQL Server 2014 and SQL Server 2016 on both source and target running on windows 2012. You can replicate from on...
    • 6 Jun 2017

    Let's test SQL Server Optimal Backup Settings with LiteSpeed!

    Let’s compare these two different conversations. Conversation 1: Conversation 2: Does this situation ring you a bell? Do not worry! Backup Analyser is here to help you even though nobody answers your questions .With just a few clicks you can have a nice graph and an Excel file with that information! Let’s start! First open Backup Analyser.You can open it from the Database menu or selecting a database...
    • 30 May 2017

    Join the open-source movement with Toad Edge Preview Release

    MySQL is great. The cost benefits? Also great. What’s not so great? Struggling to learn a new database platform. Oh, yeah. We hear your collective groan. You’re already juggling a million more responsibilities than you had when you started out, and now you’ve got to figure out yet another new technology? There’s got to be a better way. Maybe you’re already muddling through MySQL on...
    • 22 May 2017

    Restore from Amazon S3 with LiteSpeed

    Today I am going to talk about …hold on… where is my database? WHERE IS MY DATABASE? It was there 5 minutes ago!! Where did it go? I spent a lot of time setting up the database for this blog. Ok! Do not panic! Do I have a backup? Oh yes! I just run a backup to Amazon S3 in my previous blog so ...relax...and let’s restore it. First let’s open the Restore Wizard: Then select the type...
    • 17 May 2017

    Backup to Amazon S3 with LiteSpeed

    Do you know that LiteSpeed supports backup and restore directly to and from Microsoft Azure Blob Storage and the Amazon S3 (Simple Storage Service)? And with directly I mean exactly this: LiteSpeed does not use any temporary local storage for backups at all ...the backups just go directly to the cloud! In this blog we are going to focus on Amazon S3. Once you have your Amazon S3 account, all you need to do is to...
    • 15 May 2017

    Overview of Foglight Management Server and Agent Manager upgrades

    How would you like to have a quick reference point for your Foglight Management Server (FMS) or Foglight Agent Manager (FglAm) upgrades? This article is designed to help you determine the best steps to take to upgrade your type of FMS and FglAm. Hyperlinks are included for specific topics which direct to the area of interest in the Upgrade Guide. FMS Types Standalone FMS - Typical installation FMS HA - High...
    • 9 May 2017

    Agile Development: Setting up Team Coding with VCS integration

    Are you using a version control system (VCS) and want to know how to access it from Toad to simplify check-out/check-in? This video shows how to install and configure Team Coding to work with a VCS provider as well as how to define and manage your pr...
    • 4 May 2017

    Toad Allows You to Do More and Not Just Try

    Yoda’s Jedi IT cousin Toada agrees “Do or do not, there is no try!”. It today’s climate of downsizing, staff reductions and the explosion of data sources and data volumes you must be able to do and do more and just trying without the right tools will lead to failure. “Seek help, you must! With less do more. Yes, hmmm” says Toada Automate, Optimize, Document and Diagnose. “Problems...
    • 1 May 2017

    Benchmark Factory – Performance Testing is Critical !!

    One time when I was a little boy, I was driving with my dad and we went over a bridge and there was a sign that read “Weight Limit 10 Tons”. I asked my dad how they figure out how much load the bridge can handle. My dad, being a dad, answered, “Well they build the bridge and then keep driving bigger and bigger trucks over it until it collapses. They then weigh the truck and rebuild the bridge and...