Eduardo Pivaral

Eduardo Pivaral is an MCSA, SQL Server Database Administrator and Developer with over 15 years of experience working in large environments.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2020 | Author of the Year Contender - 2019 | Rookie of the Year - 2018
Title Category Date
Foundational Data Analysis using Python and SQL Server Python2026-01-08
SQL Server Semantic Search using New AI Features Artificial Intelligence2025-11-19
Running SQL Server in Local Containers with VSCode MSSQL Extension Containers2025-11-12
AI Image Generator with Azure OpenAI and SQL Server Application Development2025-09-02
Optimize Large SQL Server Inserts, Updates, Deletes with SQL Batching Processing TSQL2025-06-18
Update Statistics for All Tables and Databases in SQL Server Maintenance2025-06-16
Advanced Features of DAB (Data API Builder) to Build a REST API API2024-07-09
Automating SQL Deployments using GitHub Actions – Part 2 DevOps2024-07-01
Build REST API with Azure Data API Builder (DAB) API2024-06-03
GitHub Options to Prevent Saving Passwords in Application Code DevOps2024-05-20
GitHub Actions to Deploy Database Changes After Commit to Main Branch DevOps2024-04-30
Copy Data from Azure Blob Storage to Snowflake Azure Synapse Analytics2023-07-18
Copy Data from Snowflake with an Azure Synapse Analytics Pipeline Azure Synapse Analytics2023-05-18
Capturing SQL Server Deadlocks using Extended Events Monitoring2022-08-03
Tune and Optimize SQL Server Queries Query Optimization2022-02-23
Power BI AI Insights to Build Feature Rich Reports Power BI2021-12-16
Power BI Streaming Dataset to Visualize Real Time Data Power BI2021-08-26
Schedule Azure SQL DB Processes using Azure Functions Azure Functions2021-08-13
SSMS Custom Report for SQL Server Database Metrics Monitoring2021-04-02
Custom SSMS SQL Server Instance Level Metrics Report Monitoring2021-03-24
Azure SQL Data Sync to Replicate Data Azure2021-02-08
Execution Plan in Azure Data Studio Query Plans2020-03-10
How to Capture IoT Data in Azure Azure2020-02-27
Azure Text Analytics and Power BI Power BI2019-11-19
SQL Server Foreign Key Hierarchy Order and Dependency List Script Database Design2019-09-24
Publish Power BI Report to Power BI Service Power BI2019-08-09
SQL Indexing Performance, Implicit Conversions and Parameter Sniffing TSQL2019-07-24
SQL Server T-SQL Developer Best Practices Tips- Part 2 TSQL2019-07-08
SQL Server T-SQL Performance Best Practices Tips – Part 1 TSQL2019-06-25
Create Azure Data Studio Extension with TypeScript Azure Data Studio2019-06-12
Creating Dashboard Extensions for Azure Data Studio Azure Data Studio2019-05-17
Getting Started with Power BI and Power Query for Simple ETL – Part 2 Power BI2019-04-24
Create SQL Server Notebooks in Azure Data Studio Azure Data Studio2019-04-10
SSRS Auto Refresh Report Reporting Services Development2019-02-25
Getting Started with Power BI – Part 1 Power BI2019-02-19
Create custom T-SQL code snippets with Azure Data Studio Database Administration2018-12-12
SQL Server 2019 Memory Grant Feedback Example and Data Collection SQL Server 20192018-11-29
Optimize Large SQL Server DML Processes by Using Batches TSQL2018-11-13
Start and Stop Extended Events Sessions Using SQL Server Agent Jobs Extended Events2018-11-02
Using COMPRESS and DECOMPRESS in SQL Server to Save Disk Space Compression2018-10-09
Multi-detail reports using sub reports in SSRS Reporting Services Development2018-09-19
Conditional Formatting for SSRS Reports Reporting Services Formatting2018-09-04
Script to Get Error Numbers and Messages from SQL Server Error Log Monitoring2018-08-10
Determine SQL Server Network Protocol Information using T-SQL and DMVs Functions System2018-08-06