• 23 Nov 2017

    Toad and Foglight in harmony – The PL/SQL Profiler

    My favourite feature in Toad has always been the PL/SQL Profiler. I love the way it can profile your code executions is integrated with the editor. It is such an easy and visual feature to use. So if you have Foglight for Oracle Performance Investigator make sure you also have a copy of Toad for Oracle to dig down and understand where the resource consuming parts of your code are. Take this example: I've...
    • 22 Nov 2017

    Checking When DBCC CheckDB Last Checked Your DB

    I had a customer ask how they could use Foglight to find out when "dbcc checkdb" last ran against their SQL Server databases. This is a great use case for User-Defined Collections! As a refresher, my colleague Trent Mera wrote a great blog on this topic called User-Defined Collections (UDC). I did a post on creating a rule on the result of a user-defined collection. The difficult part is typically researching...
    • 22 Nov 2017

    Understanding Advertised Deduplication Savings for Backup Workloads

    When considering deduplication for backups, the advertised deduplication savings does not accurately reflect storage saving for your environment. It is highly recommended to test a deduplication solution within your own backup environment where you have a complete understanding of the type of data and the number of copies required to achieve a savings value. Comparing this way will ensure you have accurate information...
    • 22 Nov 2017

    Welcome to Two Techs on a Quest!

    In our Quest weekly podcast, Two Techs on a Quest, our IT heroes embark on an epic quest to provide tech guidance to those seeking resiliency and security for their infrastructure realms. Braving the perilous landscape of IT, they must battle monstrous IT challenges in hopes of empowering the people against the evil empire of misinformation. Will they succeed? Will they fail? Only time will tell. (Please visit the site...
    • 21 Nov 2017

    How Do You Solve a Problem with Maria(DB)? Or Cassandra Or Mongo or SQLServer?

    Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in a MariaDB database - for those unfamiliar with OpenSource, MariaDB is a MySQL compatible OpenSource database offering. That database is getting pretty large, with over 700,000 rows in the “observation” table, and...
    • 21 Nov 2017

    SQL Server Performance Investigator – Let Me Put This Into Context!

    If you are a developer or DBA using stored procedures in SQL Server one task you might experience is trying to work out how changes to stored procedures have impacted performance. Or you might have been tasked with improving a procedure and need to know if your efforts have been successful. So in Foglight Performance Investigator you have a feature that allows you to compare one or more stored procedure’s performance...
    • 20 Nov 2017

    What’s your hybrid AD and Azure AD recovery plan?

    Whether you are running a hybrid Active Directory (AD) environment with Azure AD Connect, or have cloud-only objects or attributes that aren’t synchronized, it’s critical for security and compliance purposes to ensure the availability and integrity of both on-premises AD as well as Azure AD. According to a recent Microsoft blog , there continues to be strong growth with organizations using Azure AD or Azure...
    • 14 Nov 2017

    What are the security risks involved when uploading data to the Spotlight Cloud?

    In the Information Technology world, we often ask ourselves, "What are the security risks involved uploading data to the Cloud?" With the Spotlight Cloud services, you can now monitor all your SQL Server Connections on your mobile device or from a browser at https://www.spotlightessentials.com . Monitoring features include a Heatmap, an Alarms List, Alarm Details and the ability to Snooze, or Acknowledge alarms...
    • 13 Nov 2017

    A new version of On Demand Migration for Email (ODME), 1.11 has been deployed!

    We are excited to announce a new version of On Demand Migration for Email (ODME) 1.11 has been deployed. Quest® On Demand Migration for Email securely migrates data to Office 365 and on-premises Exchange or hosted Exchange email platforms leveraging a hosted infrastructure to minimize the footprint within each organization. From a single console, you can migrate multiple mailboxes simultaneously, including data...
    • 13 Nov 2017

    Archived Webcast: SQL Server 2017 Features You Can Use!

    There's been a lot of chatter about SQL Server 2017's new support for Linux and Container installations, however taking advantage of these capabilities will require a fairly significant change in most uses infrastructures. This archived webcast takes a look at the enhancements to SQL Server 2017 that will work across all installations of SQL Server, thereby providing value to all DBA's regardless of what infrastructure...
    • 10 Nov 2017

    A new version of Migrator for Notes to SharePoint is now available!

    We are excited to announce a new version of Migrator for Notes to SharePoint 6.10 is now available for download. Look what's new: o Support for setting a stop time for scheduled migration task. o Support for creating scheduled task for the SharePoint site provision (Git# 544). o Support for migrating to SharePoint Document Set fields with Azure Turbo mode. o Support for opening embedded attachments in PDF and...
    • 8 Nov 2017

    Customer Conversation: Backup Escalation in Litespeed for SQL Server

    A customer recently asked me to clarify the option "Enable Backup Escalation" in Litespeed for SQL Server. The customer has been using Litespeed for a while so I was a bit surprised the question was asked. When we spoke further, I learned they had built their own full and differential backup strategy rather than letting Litespeed handle it for them. Wait, you didn't know Litespeed can manage a full and differential...