Differential backups make perfect sense….backup only what has changed since the last Full backup. Differential backups dramatically reduce the storage needed to maintain backups, while lowering maintenance windows associated with Full backups. 

Summary

This is one of those special Enterprise Monitoring use cases that I mentioned in my last blog post; The Not So Obvious Enterprise System Monitoring Essentials.  While this is not the only way to do Foglight alert integration, it is what we felt…

A customer would like to forward alarms from Foglight with all the appropriate information, such as alarm time, source, severity, message, and the rule name, to a pager script which in turn pages the on-call DBA.

The content of this was written by my…

Foglight can now monitor the MS SQLServer BI stack – SSIS, SSAS, and SSRS.

Foglight supports monitoring SSIS for MS SQLServer 2012 and above. For this SSIS monitoring, Foglight needs to access the SSISDB catalog. This should be automatically created…

In my last post, I covered the four stages of capacity management, and talked about some of the reasons why managing your virtual capacity is equally as important as physical capacity management.  Now it’s time to talk specifically about how we can help…

Can Foglight run on a Raspberry Pi running Linux? This blog answers the question.

Interestingly, I've been asked more than once recently if the Foglight Agent Manager can be installed on a Raspberry Pi (version 3) running Raspbian. One of the main use…

As the old saying goes, “the one constant in life is change”, and this is especially true in database environments.  There are many reasons why database environments experience change whether it be through typical maintenance efforts such…

Early in my career, I worked in systems support. Part of my responsibilities included ensuring server backups were running properly. However, the organization had not formalized a process around actually testing those backups. I was new to the world of…

Office 365 has three types of identity models for sign-in: cloud, synchronized, and federated.  Cloud is the simplest, where users sign on directly.  With synchronized sign-in, users are passed through a directory syncing tool and validated.  Active Directory…

The need for virtual capacity management is on the rise.  In Gartner’s ‘Market Guide for Capacity Management Tools’ report, published on January 30, 2015, it states “Through 2018, more than 30 percent of enterprises will use IT infrastructure capacity…

SQL Performance Investigator (SQL-PI) is an extension to the standard Foglight for SQL Server Cartridge, and adds Real-time and historical data.

If you have used Performance Analysis for SQL Server, then SQL Performance Investigator should look very familiar…

The Application User Interface is simply Role Based Access control to the Function and Features of the Change Auditor when using client, it restricts access to the client interface based on permission, it is also known as User Interface Authorization.