Articles by Melissa Connors

Advisory Conditions : Available Actions

Melissa Connors shows you how to implement all of the Available Actions for Alerts on SentryOne Advisory Conditions.

November 29, 2016 | Melissa Connors | Alerting, SQL Sentry, Advisory Conditions, SentryOne 0

Custom Conditions: Trigger Threshold

Melissa Connors explains when you should set a Trigger Threshold value on a Custom Condition and demonstrates a use case.

September 6, 2016 | Melissa Connors | SQL Sentry, Advisory Conditions, Custom Conditions 0

#EntryLevel : Compression & Data Types

Melissa Connors walks through the basics of when SQL Server data will benefit from compression and illustrates cases when it will not.

August 17, 2016 | Melissa Connors | #entrylevel, #BackToBasics, Community, SQL Server 0

New Custom Conditions Pack (July 2016)

Melissa Connors (@MelikaNoKaOi) tells you what's new in the latest SQL Sentry Custom Conditions Pack for more intelligent SQL Server altering.

July 29, 2016 | Melissa Connors | Alerting, SQL Sentry, Advisory Conditions, Custom Conditions 0

Trust Issues Hurting Database Performance?

Melissa Connors discusses locating & resolving SQL Server database trust issues (check constraints & foreign keys).

July 21, 2016 | Melissa Connors | Performance, T-SQL, SQL Server, Advisory Conditions, Custom Conditions 1

T-SQL Tuesday #080 : DBCC CLONEDATABASE

Melissa Connors (@MelikaNoKaOi) takes a look at the new DBCC CLONEDATABASE command in SQL Server 2014 SP 2 in this T-SQL Tuesday post.

July 12, 2016 | Melissa Connors | SQL Server, T-SQL Tuesday 3

SQL Sentry Custom Conditions for VMware

Melissa Connors describes the VMware-specific custom conditions and their use cases in right-sizing your virtual environments.

June 21, 2016 | Melissa Connors | Advisory Conditions, Custom Conditions, Virtualization 0

Custom Conditions: Maximum Instance Count

Melissa Connors explains what the Maximum Instance Count is and how to use it when creating a Custom Condition.

June 16, 2016 | Melissa Connors | Advisory Conditions, Custom Conditions 0

SQL Sentry at SQL Saturday Maine 2016

Melissa Connors, organizer of SQL Saturday Maine, provides a recap of the 2016 event & SQL Sentry speakers.

June 8, 2016 | Melissa Connors | SQLSaturday, Community 5

Common Criteria Compliance: A True Story

Melissa Connors (@MelikaNoKaOi) explains the importance of the Common Criteria Compliance Enabled custom condition & avoiding unexpected performance issues.

May 26, 2016 | Melissa Connors | Alerting, Advisory Conditions, Custom Conditions 0

New SQL Sentry Custom Conditions Pack

Melissa Connors shows you what's new in the latest SQL Sentry Custom Conditions Pack for more intelligent alerting options.

April 27, 2016 | Melissa Connors | Alerting, Advisory Conditions, Custom Conditions 0

Custom Conditions : A Logical Choice

Melissa Connors guides you through creating advanced SQL Sentry Custom Conditions with multi-step condition checks for intelligent alerting.

March 3, 2016 | Melissa Connors | Alerting, SQL Server, Advisory Conditions, Custom Conditions 0

Delayed Durability while Purging Data

Melissa Connors investigates using SQL Server's delayed durability feature to improve performance while purging data.

January 14, 2016 | Melissa Connors | SQL Server, Baselines, Delayed Durability, Monitoring 11

Applying Data Compression to the SQL Sentry Database : Part 5 (Follow-up)

Melissa Connors (@MelikaNoKaOi) follows up on her data compression series, providing details on wait statistics, MAXDOP settings, and Performance Advisor.