Ysaias Portes

Principal Database Engineer and founder of Forward Thinkers Consulting, a data engineering practice I started in 2010. I work on SQL Server administration, security, high availability, and migrations, plus SSIS ETL and healthcare EDI X12 for payers and health systems.

Before consulting full time I spent 13 years as a senior DBA at a large hospital system, running 80+ SQL Servers with 3,000+ databases and building its first enterprise data warehouse, and four years leading business intelligence at a Medicaid health plan.

I maintain sp_SQLFlightRecorder, an open-source T-SQL diagnostic recorder, and contribute to Ola Hallengren's Maintenance Solution.

Based in Miramar, Florida. forwardthinkersconsulting.com
  • Interests: SQL Server internals, performance tuning, high availability, ETL and data integration, healthcare data and EDI X12, Azure SQL
  • Skills: SQL Server 6.5-2022, T-SQL, performance tuning, AlwaysOn Availability Groups, clustering, replication, disaster recovery, TDE and Always Encrypted, SSIS, SSRS, Azure SQL Database and Managed Instance, Azure DevOps, EDI X12 (834, 835, 837, 270/271, 278), C#, PowerShell

All authors

All authors

Blogs

T-SQL Tuesday #204 – Are blogs still relevant?

By

Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....

A Front Door for the DBA Team – AgentDBA UI

By

AgentDBA began as a command line. That suits one DBA on one server, but...

Cleaning Up Azure MS Defender Billing

By

I have a few Azure subscriptions, which are fairly small and not used that...

Read the latest Blogs

Forums

SQL Server Vector Support II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Vector Support II

Great Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Great Things

Troubleshooting Slow Queries That Already Have an Index

By Imran2629

Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers