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

Keeping Redshift System Table History Past 7 Days with S3 Tables

By

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...

Updating the Data API Builder

By

I was updating my session for the Data API Builder (DAB) recently, mostly to...

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

By

I am excited to host T-SQL Tuesday for the first time. I want to...

Read the latest Blogs

Forums

advice on ssrs version control

By stan

Hi we're a bit behind on versioning ssrs.  I think we have over 1600...

Practical Ways to Approach SQL Server Problems and Case Studies

By academicexpertt

Working with SQL Server can involve more than just writing queries. Understanding database design,...

Measuring Productivity

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Measuring Productivity

Visit the forum

Question of the Day

Tracking All the Queries

I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?

See possible answers