Brandon Adams

Brandon Adams

SQL Server Tools Product Marketing Manager

With over two decades of experience in SQL, SaaS, data center infrastructure, power quality, data storage, disaster recovery, and IT security, Brandon bridges technical expertise with business needs to help organizations get the most out of their data environments. He focuses on making complex database and infrastructure challenges easier to understand, enabling DBAs and IT leaders to improve performance, strengthen security, and simplify management.

Latest Articles by Brandon

Knowledge Base

Baselines & Dynamic Thresholds: A Practical Setup Guide and Workflow Walkthrough

Brandon Adams 9 minutes read

Knowledge Base

SQL Server Execution Plans: A DBA’s Triage Guide

Brandon Adams 26 minutes read

SQL Diagnostic Manager for SQL Server

Troubleshooting SQL Server Performance Issues: Native Tools, Best Practices, and AI-Powered Monitoring

Brandon Adams 16 minutes read

Realistic Idea of SQL Databases

Knowledge Base

How to Optimize SQL Server Performance as Your Databases Grow

Brandon Adams 12 minutes read

SQL Diagnostic Manager for SQL Server

Planning a SQL Server Migration? Use SQL Diagnostic Manager to Reduce Risk Before, During, and After the Move

Brandon Adams 16 minutes read

Data Backup

Knowledge Base

SQL Server Backup and Recovery Best Practices: 6 Ways to Reduce Downtime and Improve Disaster Recovery Readiness

Brandon Adams 10 minutes read

SQL Server 2014 end of life

Industry Trends

SQL Server 2016 End of Support Is Coming: What DBAs Need to Do Before July 2026

Brandon Adams 18 minutes read

Knowledge Base

How to Start SQL Server Services: 5 Methods Compared

Brandon Adams 11 minutes read

Performance

SQL Server Performance: A Practical Guide for DBAs

Brandon Adams 31 minutes read

Database, infrastructure, new technology, management cloud computing illustration. Generative AI, 4k

Knowledge Base

AI Tools for SQL Query Optimization: A DBA’s Guide

Brandon Adams 20 minutes read

Knowledge Base

Database Migration Tools: How to Choose the Right One

Brandon Adams 20 minutes read

SQL Diagnostic Manager for SQL Server

SQL Server AI: What DBAs Need to Know in 2026

Brandon Adams 18 minutes read

SQL Server

SQL Compliance Manager

Introducing the SQL Compliance Manager Product Update Center

Brandon Adams 2 minutes read

Knowledge Base

Are SQL Server DBAs Experiencing AI Fatigue?

Brandon Adams 7 minutes read

Compliance

SQL Compliance Manager

Database Security Compliance: A Practical Guide for SQL Server DBAs

Brandon Adams 21 minutes read

Product Releases

SQL Diagnostic Manager 14.0: AI-Powered SQL Server Performance Optimization for DBAs

Brandon Adams 6 minutes read

SQL Server

Product Releases

Introducing the SQL Diagnostic Manager Product Update Center

Brandon Adams 2 minutes read

A woman is absorbed in her programming task, typing on a keyboard while surrounded by bright screens filled with colorful lines of code. The low-light setting enhances the tech atmosphere

monitoring performance

Database Performance Tuning | A Practical Guide for DBAs

Brandon Adams 25 minutes read

SQL Diagnostic Manager for SQL Server

Database Monitoring | Essential Guide for Enterprise DBAs

Brandon Adams 21 minutes read

SQL Diagnostic Manager for SQL Server

SQL Server Performance Dashboard: Tools and Best Practices

Brandon Adams 14 minutes read

SQL Diagnostic Manager for SQL Server

Best SQL Server Tools: Key Tools for DBAs and Developers

Brandon Adams 18 minutes read

SQL Diagnostic Manager for SQL Server

SCOM Is Going Away for SQL Server – How Should DBAs Plan Next?

Brandon Adams 6 minutes read

SQL Server Performance Metrics: Complete Monitoring Guide

Knowledge Base

SQL Server Performance Metrics: Complete Monitoring Guide

Brandon Adams 27 minutes read

Product Update

Product Releases

SQL Diagnostic Manager 13.3: The Latest in Smarter SQL Server Performance Monitoring

Brandon Adams 5 minutes read

monitoring performance

SQL Server Activity Monitor: Complete Guide and Best Tools

Brandon Adams 26 minutes read

SQL Diagnostic Manager for SQL Server

Top Database Monitoring Tools: How to Choose the Right One

Brandon Adams 26 minutes read

Knowledge Base

T’was the Night Before Patch Day: A SQL Invaders Holiday Story

Brandon Adams 5 minutes read

SQL Diagnostic Manager for SQL Server

Cloud SQL Monitoring: How to Optimize Performance, Cut Costs, and Gain Full Cloud Visibility

Brandon Adams 27 minutes read

SQL Compliance Manager

SQL Server Auditing: Complete Guide to Compliance and Security

Brandon Adams 44 minutes read

Free tools

Unlock Smarter SQL Workflows with IDERA’s Free AI Tools

Brandon Adams 6 minutes read

Knowledge Base

The Ultimate Holiday SQL DBA Checklist for a Stress Free Year End

Brandon Adams 7 minutes read

Knowledge Base

Understanding the Audit-Trail Gap – Beware the Stealth Invader

Brandon Adams 4 minutes read

SQL Diagnostic Manager for SQL Server

Most DBAs Think High CPU Is the Problem. They’re Wrong — It’s the Symptom.

Brandon Adams 6 minutes read

Knowledge Base

Understanding Alert Fatigue – The Signal Jammer

Brandon Adams 5 minutes read

idera-sql-diagnostic-manager-13.3

Product Releases

SQL Diagnostic Manager 13.2: Smarter SQL Server Performance Monitoring Starts Here

Brandon Adams 4 minutes read

SQL Diagnostic Manager for SQL Server

SQL Query Optimization: 15 Proven Techniques for Faster Database Performance

Brandon Adams 31 minutes read

Knowledge Base

SQL Server Security Best Practices: Protecting Data and Ensuring Compliance

Brandon Adams 20 minutes read

Knowledge Base

Understanding Resource Contention – The CPU Crusher

Brandon Adams 5 minutes read

Knowledge Base

Understanding Query Regressions – The Slow-Burn Invader

Brandon Adams 3 minutes read

SQL Diagnostic Manager for SQL Server

How to Perform a SQL Server Health Check

Brandon Adams 14 minutes read

SQL Server

Knowledge Base

Top 5 SQL Server Performance Monitoring Tools

Brandon Adams 30 minutes read

SQL Diagnostic Manager for SQL Server

SQL Performance Tuning Dos and Dont’s

Brandon Adams 11 minutes read

sql-compliance-manager-7.0

SQL Workload Analysis for SQL Server

Announcing the General Availability of IDERA SQL Workload Analysis 1.8

Brandon Adams 3 minutes read

SQL Diagnostic Manager for SQL Server

Understanding TempDB Contention

Brandon Adams 2 minutes read

Knowledge Base

SQL Under Siege: The Hidden Threats Lurking in Your Databases

Brandon Adams 8 minutes read

Knowledge Base

Understanding Blocking vs. Deadlocks

Brandon Adams 2 minutes read

SQL Compliance Manager

ApexSQL Audit Is Reaching End of Life — Here’s Your Next Step

Brandon Adams 3 minutes read

SQL Diagnostic Manager for SQL Server

Understanding SQL Server Memory Usage

Brandon Adams 2 minutes read

SQL Diagnostic Manager for SQL Server

Understanding Baselines for SQL Server Performance

Brandon Adams 2 minutes read

Knowledge Base

Understanding Query Wait Types

Brandon Adams 3 minutes read

Product Update

SQL Safe Backup

IDERA SQL Safe Backup 9.4 Now Available

Brandon Adams 5 minutes read

Product Update

Product Releases

IDERA SQL Compliance Manager 8.0 Now Available

Brandon Adams 5 minutes read

A young curly-haired professional intensely working on code across multiple computer monitors in a modern office

SQL Diagnostic Manager for SQL Server

Dealing with Parameter Sniffing in SQL Server

Brandon Adams 10 minutes read

SQL Diagnostic Manager for SQL Server

Maximizing SQL Server Performance in the Cloud

Brandon Adams 14 minutes read

database-management

Top 10 Myths About Database Management That Could Be Costing You

Brandon Adams 9 minutes read

Product Update

SQL Diagnostic Manager for MySQL

Announcing the General Availability of SQL Diagnostic Manager for MySQL 8.9.7

Brandon Adams 5 minutes read

How to Choose the Right Database

Enterprise Data Management

How to Choose the Right Database Management System for Your Needs

Brandon Adams 27 minutes read

A snail moves slowly across a digital circuit board.

database-tools

10 Reasons Behind a Slow SQL Server

Brandon Adams 9 minutes read

Digital padlock icon on a touchscreen interface, surrounded by binary code and encryption symbols, representing secure data, online privacy, and protection from cyber threats

Knowledge Base

Top 7 Ways to Secure Your SQL Server Against Cyber Threats

Brandon Adams 7 minutes read

sql-server-dba

database-management

Top 10 Concerns Keeping SQL Server DBAs Awake at Night

Brandon Adams 10 minutes read

idera-sql-diagnostic-manager-13.3

Product Releases

Announcing the General Availability of IDERA SQL Secure 4.5

Brandon Adams 3 minutes read

SQL Diagnostic Manager 13.2

Product Releases

Announcing General Availability of SQL Inventory Manager 2.6.6

Brandon Adams 3 minutes read

SQL Server PCI Compliance

SQL Compliance Manager

Achieving PCI Compliance in Your SQL Server Environment: Best Practice

Brandon Adams 12 minutes read

sox-compliance-in-sql-server

SQL Compliance Manager

Achieving SOX Compliance in Your SQL Server Environment: Key Strategies

Brandon Adams 8 minutes read

sql-compliance-manager-7.0

Product Releases

Announcing the General Availability of IDERA SQL Safe Backup 9.3

Brandon Adams 2 minutes read

Prescriptive Analysis

Industry Trends

Getting Proactive with Performance: Leveraging Prescriptive Analysis in IDERA’s SQL Diagnostic Manager

Brandon Adams 12 minutes read

sql-compliance-manager-7.0

Product Releases

SQL Diagnostic Manager 13 General Availability

Brandon Adams 5 minutes read

A woman is absorbed in her programming task, typing on a keyboard while surrounded by bright screens filled with colorful lines of code. The low-light setting enhances the tech atmosphere

Industry Trends

SQL Server Monitoring: Predictive Analytics & AI Trends for 2025

Brandon Adams 7 minutes read

sql-compliance-manager-7.0

Product Releases

IDERA SQL Compliance Manager 7.0 Now Available

Brandon Adams 7 minutes read

sql-server-performance-issues

SQL Diagnostic Manager for SQL Server

Diagnosing SQL Server Problems Faster: Real-Time Solutions for 2025

Brandon Adams 10 minutes read

SQL-query-performance-tunning-updated

SQL Diagnostic Manager for SQL Server

Query Tuning Secrets for 2025: How to Optimize SQL Server Like a Pro

Brandon Adams 11 minutes read

SQL Server

Industry Trends

2024: A Transformative Year for SQL Server and Beyond

Brandon Adams 10 minutes read

SQL Server

database-tools

The Risks of Running Unsupported SQL Server Versions

Brandon Adams 6 minutes read

Idera News

database-tools

Climb & Idera Partner for Top SQL Server Tools

Brandon Adams 6 minutes read

Empowering Law Firms

database-tools

How SQL Server & Idera Tools Safeguard Law Firm Data

Brandon Adams 9 minutes read

sql-server-scripts

database-tools

Best Practices for Writing SQL Server Scripts

Brandon Adams 10 minutes read

sql-compliance-manager-7.0

Product Releases

Announcing the General Availability of IDERA SQL Workload Analysis 1.7.5

Brandon Adams 4 minutes read

Natural Disaster

database-management

Lessons from Hurricanes Helene and Milton: Why SQL Server DBAs Need a Business Continuity Plan

Brandon Adams 8 minutes read

Subscription vs Perpetual Pricing

database-management

Perpetual vs Subscription: SQL Server Tools Pricing Explained

Brandon Adams 10 minutes read

Image for SQL Server

database-management

Understanding and Managing High Memory Usage in SQL Server

Brandon Adams 7 minutes read

Compliance

database-management

How SQL DBAs Can Stay Ahead of 2025 Compliance Changes

Brandon Adams 9 minutes read

SQL Server 2014 end of life

database-tools

SQL Server 2014 End of Life: What It Means & How Idera Helps

Brandon Adams 7 minutes read

Image for Database Indexing

database-management

Essentials of Database Indexing for SQL Server

Brandon Adams 6 minutes read

Access Permission

database-tools

The Principle of Least Privilege in SQL Server Security

Brandon Adams 8 minutes read

SQL Server Deadlocks

database-management

How to Avoid SQL Server Deadlocks: 5 Essential Steps for DBAs

Brandon Adams 10 minutes read

Data Backup

database-tools

Backup SQL Server: Essential Tools and Strategies

Brandon Adams 6 minutes read

Migrate Data

database-management

How to Successfully Migrate SQL Server to Azure SQL Database

Brandon Adams 15 minutes read

SQL Injection

database-tools

Prevent SQL Injection Attacks and Data Breaches

Brandon Adams 8 minutes read