• 13 Feb 2018

    Spotlight on SQL Server Enterprise Tip: Reduce Noise Using Planned Outages

    Naturally, it's VERY important to know when things are going wrong with our monitored instances. What's not helpful is the dreaded "False Positive." You know the scenario I'm about to describe. It's 03:00 and you're sleeping soundly and dreaming of the yacht you'll be sailing during your retirement. Suddenly, you're awakened by an alert that your instances are unavailable! During...
    • 30 Oct 2017

    Reconsidering the idea of monitoring pre-production database instances

    It is a foregone conclusion that performance monitoring is part and parcel of managing a database instance once it is in production. But what about pre-production? Especially when the instance itself is reaching critical phases of testing and quality assurance prior to roll-out. I often ask my clients how they are currently monitoring their pre-production environment and in many cases it is considered a nice-to-have instead...
    • 9 Oct 2017

    Customer Story: Using Foglight SQL PI to Detect Unauthorized User Activity

    Let me be very clear when I say that I do not advertise Foglight for Databases as a security auditing or intrusion detection solution. What is interesting to me is a scenario described by a customer working with Foglight to monitor his SQL Server databases. In a similar vein to my friend David Orlandi's post about user-level investigations using Foglight, this customer told me how he used Foglight to find that a user...
    • 4 Sep 2017

    Keeping Your Data Protection Ahead of the Ongoing Digital Transformation

    As an IT professional, are you so consumed by keeping servers running and data flowing that it’s difficult to keep up with the digital transformation going on outside your walls? For example, energy companies are investing in smart meters to g...
    • 31 Aug 2017

    Predicting the Future of Endpoint Management in a Mobile World

    A few weeks ago, my colleague John O’Boyle posted that there is no end to endpoint management . That’s no secret to system administrators who spend most of their time thinking about mobile device management , endpoint security, security pat...
    • 4 Aug 2017

    Simplify Healthcare M&A with Automated AD and Exchange Tools

    Simplify your healthcare mergers and acquisitions with secure and automated tools for Active Directory and Exchange consolidations.
    • 1 Aug 2017

    Healthcare Mergers and Acquisitions: A Prescription to Improve Security Before Migration

    Several forces are combining to create a historic period of consolidation in the healthcare industry. Increased competition, a shift to outcomes-based reimbursement models, and an overall need to widen the scope of care while reducing costs are driving more and bigger M&A deals. In fact, according to Thomson Reuters, healthcare M&A deals totaled US$672.9 billion during 2015, which was a 71% increase from 2014...
    • 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

    Meet Our Experts! The Voices behind @QuestExperts: Andre Cooley

    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 – Andre Cooley. Tell us a little about yourself: My name is Andre Cooley and I am a Senior Technical Support Advisor for the NetVault Product Family...
    • 28 Mar 2017

    Getting Ready to Query the Foglight Performance Investigator Repository

    The backend repository for the Foglight Performance Investigator is based on Infobright , an analytics engine for machine generated data. However, you can connect natively via anything that can connect to PostgreSQL. The schema reference for Performance Investigator is available for Oracle and SQL Server from support. But how do we get setup to start building queries? We'll need some tools. Naturally, I prefer...
    • 8 Feb 2017

    Secure Automation Using Toad for Oracle

    While Toad for Oracle has had Automation for a long time now it has been necessary to run it on your desktop. While this is an important feature this limitation made it not ideal for organizations where security is imperative, such as in t...
    • 31 Jan 2017

    Active Directory Management and Azure AD: A Perfect Match

    It just seemed to me a perfect superhero team like the Wonder Twins could also represent Quest Active Administrator and Microsoft Azure AD . The Quest Active Administrator is a single plane of glass tool for DNS, GPO, and AD management . The tool combines typical and advanced functions for these objects plus auditing and alerting, backup and recovery, and DC management. Just like the Wonder Twins; Quest Active Administrator...
    • 27 Jan 2017

    Insider Threats: The Unknowns of Active Directory Security

    There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know. Donald Rumsfeld At one point in my career the security boundary was defined by the outside of the network vs the inside. We setup domains and forests with a particular architecture...
    • 24 Jan 2017

    Application Monitoring, where should I start? What are the colors that Van Gogh used?

    It’s been amazing how much creativity and innovation is out there. Customers have been teaching me a lot over the last 20 plus years. Two identical applications behave differently for two different clients and their different customers and in their different environments. I am a Van Gogh fan. Like any Van Gogh painting, you see beautiful and mostly bright colors, and the amazing shades that are used. There are some...
    • 24 Jan 2017

    java monitoring instrumentation levels, who would know better than you?

    Java Monitoring for Dev, Test, QA and Prod environments & collection options Best part of my job over the last 20+ years is working with more than 200 companies and working very closely with a few dozens. The variety that I have been exposed to has helped me learn a lot from these diverse environments and the people involved. Most companies, especially the ones with Performance Teams, have interesting guidelines...
    • 24 Jan 2017

    Do you know where your java transactions are, part 2

    Java Workload Characterization – Part 2. My 3, 5, 7, 10 Rule I hope you had a chance to look at do you know where your java transactions are, my Java Workload Characterization – Part 1 blog. And I love to hear what else you can add or suggest to our audience. Here in this part two, I like to cover some additional dimensions to my monitoring. Occasionally you end up working for one very large composite...
    • 24 Jan 2017

    Do you know where your java transactions are? Part 1

    Java Workload Characterization, understand your transaction Mix Over the years, I have met, worked and learned from a number of experts in Performance Management field. These are professionals that are dedicating most or all of their times supporting large volume production systems, or are the consultants that customers go to, to get help from. These Pros have taught me that deviations in the Workload and the Transaction...
    • 19 Jan 2017

    Similar Solutions and Customer Conversations: Spotlight and Foglight

    I normally write about specific aspects of the solutions that I support, but I thought I'd try something a little different today. For those of you that don't know, I'm a sales engineer supporting Quest's Database Performance Monitoring portfolio. For people concerned about SQL Server performance, there are two similar solutions within this portfolio: Spotlight On SQL Server Enterprise and Foglight . When...
    • 19 Jan 2017

    The server is down! – The CEO is on the phone and wants to know who you are.. Just another day in backup..

    RTO and RPO..Recovery Time Objectives and Recovery Point Objectives. These terms are very common today when we speak of backup philosophy. One size does not fit all, each customer will have different views on what they deem acceptable RTO/RPO for the...
    • 19 Jan 2017

    Database Developers: Start 2017 by Developing at the Speed of Agile

    What’s the only thing harder than running hurdles? Running them while trying to catch up to someone going faster. And making sure that you don’t lose your 3-step stride. Or knock over a hurdle. Or completely lose your footing. What&rsquo...
    • 6 Jan 2017

    Data, Information and Knowledge

    Nowadays with such a growing interest in data analysis / data science, there are abundant articles and material covering the skillset necessary to master those disciplines. Virtually, any blog, magazine, book, or specialized web site or portal descri...
    • 3 Jan 2017

    I Found My Foglight Hosts Services!

    I previously shared a challenge I had with finding the services that were created in the Hosts dashboard . Ideally we want to be able to use them in the Hosts and Infrastructure dashboards, but also add them to the Service Operations Console or attach them to an existing service definition in the Service Builder. To start, we'll add a new category in the Service Builder. Next, we'll add a child service to...
    • 29 Dec 2016

    Excel Puzzler - Problem Solved with AverageIf Function

    I could write SQL to solve this problem.. but the data was in Excel. I pulled pricing and mileage data from several car for-sale sites and dropped it in an Excel sheet. Columns include year, price, kilometers (mileage), etc. Here is a snippet of the data: Now I had some data in Excel that would mimic how it would be stored in a relational database but I wanted to analyze it. I wanted to get the average price and...
    • 27 Dec 2016

    The Quest for perfect IT solutions: A Tale of Two Cities

    Dickens wrote “It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of belief, it was the epoch of incredulity, it was the season of Light, it was the season of Darkness….” Too often this is how I see IT solution requests; a conflict of two opposites occurring at the same time. As we struggle to meet the demands of both internal...
    • 21 Dec 2016

    Unfortunate Provisioning Scenarios

    Imagine it's your first day at a new company. Whether it's your first job out of college or a new company to show off your talent, there are certain expectations you have. You'll likely spend the first couple of days getting to know your...