• 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...
    • 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...