• 8 Mar 2018

    Save Your Nails With SharePlex!

    We all love doing migrations, upgrades and patches on our production databases. The thrill and excitement of hoping nothing will happen just brings joy to a DBA’s heart. This is usually the time where our fingernails can take the brunt of our joy. What if something happens during the migration/upgrade that causes an extended outage, what if we find a bug after the migration, what if….what if… and there...
    • 6 Mar 2018

    3 Surprising Steps to a Successful Cloud Migration

    The whole cloud migration thing’s a little overwhelming, isn’t it? I mean, where do you even begin? Moving to this huge, new, nebulous platform can feel like a monumental undertaking. And you’re probably feeling the pressure to get there, well, yesterday. But the thing is, it’s okay if you haven’t performed a major cloud migration yet. Because while everyone’s talking about moving...
    • 1 Mar 2018

    Collaborate With Us: Hit Up the Quest Booth, #901

    Visit Quest at booth 901 during the Collaborate conference in Las Vegas. We’ve got giveaways that’ll blow your mind and expert advice that’ll change your life.
    • 16 Feb 2018

    Tune Your Queries with SQL Optimizer (Pt 1)

    One of the many ways to improve database performance is to tune SQL queries running in your environment. Two primary reasons for tuning are: Minimize Response Time – End users who are interacting with data want that data as quickly as possible. It may be mission-critical data ( e.g. medical, financial). Often, the speed with which the data is returned shapes the level of customer satisfaction. No one likes to...
    • 5 Feb 2018

    Measuring the Impact of Meltdown and Spectre Patching on your Databases

    The new year kicked off with some big news on January 3rd, 2018 with the news of the Meltdown and Spectre chipset vulnerabilities. There are a lot of resources available to understand the details and potential impact. This one from cnet.com is pretty good. As the patches from the operating system vendors are being rolled out, a question often comes up - "How will this impact me?" Specifically, it's the...
    • 2 Feb 2018

    Evaluating Foglight vs Oracle Enterprise Manager

    As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I see evaluators take note of similarities and differences of architecture, usability and navigation, and product features that present specific information to help address...
    • 9 Jan 2018

    Agile Development: Checking Database Objects into Version Control Using Toad's Team Coding

    Team Coding goes beyond simply providing an easier way to use version control in Toad. Team Coding comes with some optional policies which can determine when PL/SQL objects are checked into your version control repository based on the functional integrity and quality of the code. This will help reduce the number of defects (bugs) which can make their way into production and drive up code quality standards which should...
    • 9 Jan 2018

    Agile Development: Advanced Code Review using Toad Code Analysis

    Are you looking for a simpler, more effective way to carry out code quality reviews of all your Oracle PL/SQL code that takes subjectivity out of the equation and gives you the foundation for an automated way to review your code as part of a DevOps process? Then look no further. Code Analysis is a rules-based code quality feature of Toad that enables you to define those aspects of project code which must comply with specific...
    • 9 Jan 2018

    Agile Development: Creating a simple Oracle PL/SQL unit test using Toad

    Is your organization moving to agile development and DevOps and you now have to test your Oracle PL/SQL code and have no idea what to do? Your worries are over! With Toad for Oracle, creating some simple PL/SQL unit tests to get started is really easy and can be accomplished in Toad's Editor. Once you understand the basics, you'll feel much more confident about creating more advanced tests and bringing automated...
    • 9 Jan 2018

    Agile Development: Setting up Toad's Team Coding with Version Control integration

    Do you use a version control system like Subversion, Git or TFS to manage your Oracle database objects? If you are a Toad for Oracle user, Team Coding will dramatically simplify and streamline your use of version control by enabling you to continue working with your database objects without worrying about the VCS file system. Watch this video to learn how to setup and use Team Coding with your preferred VCS.
    • 4 Jan 2018

    Top 5 challenges of managing cross-platform databases

    If you’re like many DBAs, your life is probably getting more complicated by the week. Are you under pressure to manage larger and larger numbers of database instances? Or to adopt new database technologies like open source or NoSQL? With those changes, are you still required to ensure the best performance and stability for your entire environment? A survey by Unisphere Research 1 showed: 72 percent of DBAs...
    • 11 Dec 2017

    How to Avoid Extinction in the Database Evolution

    Friends. Change is here. All of us DBAs are dealing with it. Look at the number of new database platforms. It’s relentless. They just keep coming. And we’re expected to take on any or all of them that’ll save our companies money. But it’s hard, right? Here’s why. We’re in the midst of a rapid evolution. And as with any evolution, we’re looking at three morphological possibilities...
    • 5 Dec 2017

    DBA crush: SQL Server on Linux

    Falling in love. It’s what life’s about, isn’t it? Not to get too sappy or whatever, but isn’t it the best feeling – when you’re completely smitten? Well, I have a confession to make: I’m currently head over heels. It’s a little embarrassing, sure, given that my excitement is for some thing and not some one . But this thing? It’s kiiiiiiinda special. Okay, so here...
    • 27 Nov 2017

    Unclog Your IT Plumbing with SharePlex

    One of my favorite quotes from Star Trek is Scotty's comment about the new Enterprise in Star Trek III: " The more they overthink the plumbing, the easier it is to stop up the drain ". if you're responsible for IT plumbing, and your job looks like this Quest can help. SharePlex, with multiple use cases for one product, provides a number of tools to improve the interfaces between your databases...
    • 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...