Ron L'Esteve

Ron L'Esteve is a seasoned Data Architect who holds an MBA and MSF. Ron has over 15 years of consulting experience with Microsoft Business Intelligence, data engineering, emerging cloud and big data technologies.

Ron C. L'Esteve is a Data and AI Leader and professional Author residing in Chicago, IL, USA. He is well-known for his impactful books and article publications on Azure Data & AI Architecture, Engineering, and Leadership. Ron holds a Master of Business Administration (M.B.A.) and Master of Science in Corporate Finance (M.S.F.) from Loyola University Chicago. Ron possesses deep technical skills and experience in designing, implementing, leading, and delivering modern Azure Data & AI projects for numerous clients around the world. He is a Motorola Certified Six Sigma Green Belt, a Microsoft Global Challenger, and also holds numerous additional Microsoft, Snowflake, and Databricks professional certifications in Big Data Engineering, Artificial Intelligence, Apache Spark and Data Platform Architecture.

Ron is an advocate for data excellence across industries and consulting practices and empowers self-service data, BI, and AI through his high-quality article contributions to the Microsoft technical community. With over 20 years of experience, Ron has been a trusted technology advisor, strategist, and leader for the largest and most impactful cloud digital transformation and innovation projects. He has a demonstrated history of delivering on his commitments of scaling key data architectures, defining the roadmap and strategy for the future of data and business intelligence, and challenging customers to grow by thoroughly understanding the fluid business opportunities and enabling change by translating them into high-quality and sustainable technical solutions that solve the most complex challenges and promote digital innovation and transformation. He applies a practical and business-oriented approach by taking transformational ideas from concept to scale. In addition, he has proven his capabilities in leading, advising, and mobilizing globally dispersed teams to deliver complex end-to-end Azure Data and AI opportunities successfully as an enabler of positive and impactful change by championing a growth mindset.

2022 Awards   

2021 Awards      

2020 Awards      

2019 Awards   

Apache SparkGetting Started with Graph Analytics Using Apache Spark's GraphFrame API
Apache SparkReal-time IoT Analytics Using Apache Sparks Structured Streaming into Databricks Delta Lake
AzureAzure Data Lake Analytics using U-SQL Queries
AzureAzure Vision Service and Face API Example with Python
AzureCreate Azure Data Lake Database, Schema, Table, View, Function and Stored Procedure
AzureCreating Lakehouse ELT Jobs with Apache Spark for Azure Pipelines
AzureDesign and Manage Azure SQL Data Warehouse
AzureDesigning an Azure Data Lake Store Gen2
AzureExample Using C# Code with U-SQL Scripts
AzureGetting Started with Azure Purview for Data Governance
AzureIngestion and Processing Layers in Azure Data Lakehouse
AzureReading and Writing to Snowflake Data Warehouse from Azure Databricks using Azure Data Factory
AzureReal-Time Anomaly Detection Using Azure Stream Analytics
AzureReporting, Advanced Analytics, CICD, and Governance in the Lakehouse
AzureStorage and Serving Layers in the Data Lakehouse
AzureUsing Azure Databricks to Query Azure SQL Database
AzureUsing PowerShell and Azure Blueprints to provision a Modern Data and Analytics Platform
AzureWrite Federated U-SQL Queries to Join Azure Data Lake Store Files to Azure SQL DB
Azure Data FactoryAzure Data Factory Data Transformation with U-SQL
Azure Data FactoryAzure Data Factory Mapping Data Flow for Datawarehouse ETL
Azure Data FactoryAzure Data Factory Mapping Data Flows for Big Data Lake Aggregations and Transformations
Azure Data FactoryAzure Data Factory Pipeline Logging Error Details
Azure Data FactoryAzure Data Factory Pipeline to fully Load all SQL Server Objects to ADLS Gen2
Azure Data FactoryAzure Data Factory vs SSIS vs Azure Databricks
Azure Data FactoryCreate Azure Data Lake Linked Service Using Azure Data Factory
Azure Data FactoryFast Way to Load Data into Azure Data Lake using Azure Data Factory
Azure Data FactoryGetting Started with Delta Lake Using Azure Data Factory
Azure Data FactoryImport Data from Excel to Azure SQL Database using Azure Data Factory
Azure Data FactoryIncrementally Upsert data using Azure Data Factory's Mapping Data Flows
Azure Data FactoryLoad Data Lake files into Azure Synapse Analytics Using Azure Data Factory
Azure Data FactoryLoading Azure SQL Data Warehouse Dynamically using Azure Data Factory
Azure Data FactoryLogging Azure Data Factory Pipeline Audit Data
Azure Data FactorySnowflake Data Warehouse Loading with Azure Data Factory and Databricks
Azure DatabricksAdvanced Databricks Lakehouse Capabilities
Azure DatabricksAdvanced Schema Evolution using Databricks Auto Loader
Azure DatabricksAzure Databricks Access Controls and Row Level Security
Azure DatabricksBloom Filter Indexes using Databricks Delta
Azure DatabricksCreate a Python Wheel File to Package and Distribute Custom Code
Azure DatabricksCreating Deep and Shallow Delta Clones in Azure Databricks
Azure DatabricksDatabricks Delta Change Data Feed
Azure DatabricksGetting Started with Databricks Delta Live Tables
Azure DatabricksGetting Started with Databricks Delta Sharing
Azure DatabricksGetting Started with MLflow in Azure Databricks
Azure DatabricksManaging Auto Loader Resources
Azure DatabricksMount an Azure Data Lake Storage Gen2 Account in Databricks
Azure DatabricksOptimizing Spark Performance with Adaptive Query Execution
Azure DatabricksPerformance Tuning Apache Spark with Z-Ordering and Data Skipping in Azure Databricks
Azure DatabricksQuerying Star Schemas in Databricks with Dynamic Partition Pruning
Azure DatabricksReal-Time Analytics, Advanced Analytics and Reporting in Databricks
Azure DatabricksSecurity, Governance and CI/CD in Databricks
Azure DatabricksStorage, Compute and Workspaces in Databricks
Azure DatabricksUsing Delta Schema Evolution in Azure Databricks
Azure DatabricksWriting Databricks Notebook Code for Apache Spark Lakehouse ELT Jobs
Azure Synapse AnalyticsExploring the Capabilities of Azure Synapse Spark External Tables
Azure Synapse AnalyticsGetting Started with Azure Synapse Analytics Hyperspace for Spark Indexing
Azure Synapse AnalyticsGetting Started with Azure Synapse Analytics Workspace Samples
Azure Synapse AnalyticsGetting Started with Azure Synapse Link for Cosmos DB
Azure Synapse AnalyticsReal-Time Analytics, Advanced Analytics and Reporting in Azure Synapse Analytics
Azure Synapse AnalyticsSecurity, Governance, and CI / CD in Azure Synapse Analytics Workspace
Azure Synapse AnalyticsSynapse Analytics vs Snowflake for Delta Format Files, Machine Learning, Table Relationships and Constraints
Azure Synapse AnalyticsUnderstanding the Capabilities of Azure Synapse Analytics Workspace
Azure Synapse AnalyticsUsing COPY INTO command to load Azure Synapse Analytics from Azure Data Lake Storage Gen2
Big DataRealizing Business Value through an AI-driven Strategy and Culture
Cloud StrategyA Cloud Data Lakehouse Success Story - Part 1
Cloud StrategyA Cloud Data Lakehouse Success Story - Part 2
Cloud StrategyBecoming a Cloud Data Platform Driven Organization - Part 1
Cloud StrategyBecoming a Cloud Data Platform Driven Organization - Part 2
Cloud StrategyDelivering Cloud Transformation Excellence: Assumptions, Dependencies, Pricing Models, Backlogs, & Capacity - Part 5
Cloud StrategyDelivering Cloud Transformation Excellence: Collaboration, Communication and Governance - Part 6
Cloud StrategyDelivering Cloud Transformation Excellence: Envisioning Current and Future State Project Requirements - Part 3
Cloud StrategyDelivering Cloud Transformation Excellence: Project Initiation, Planning of Scope, Team and Risks - Part 4
Cloud StrategyDelivering Cloud Transformation Excellence: The Need for Centers of Excellence - Part 1
Cloud StrategyDelivering Cloud Transformation Excellence: The Need for Cultures of Innovation and a Data Strategy - Part 2
Cloud StrategyDesigning a Data Lake Management and Security Strategy
Data WarehousingPlanning for a Cloud Data Warehouse Project
DevOpsAzure Boards for Project Management
DevOpsAzure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project
DevOpsDeploy Azure Data Factory CI/CD Changes with Azure DevOps
DevOpsDeploy SQL Database from Azure DevOps with an ARM Template and DACPAC File
DevOpsGetting Started with Azure Blueprints
DevOpsManaging Azure Blueprints with PowerShell
DevOpsSecuring Secrets in Azure DevOps
DevOpsUsing Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets
DevOpsUsing Azure DevOps CI CD to Deploy Azure Data Factory Environments
Import and ExportFlatten Semi-Structured Data with Snowflake
Integration Services ExcelUsing SQL Server Integration Services to Generate Excel Files Based on Criteria
Other Database PlatformsUnderstanding the Capabilities of Snowflake
Professional Development CareerPart 1: Understanding the Responsibilities of a Successful Data and AI Leader
Professional Development CareerPart 2: Understanding the Responsibilities of a Successful Data and AI Leader
Professional Development CertificationsPrepare for Microsoft AI 100 Exam
Professional Development InterviewingHow to Ace an Azure Data Engineer Interview
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (73)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (70)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (69)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (320)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (132)
Power PlatformPower BI Charts (45)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)