Eduardo Pivaral
Eduardo Pivaral is a SQL Server Database Administrator from Guatemala city with nearly 15 years of experience. Eduardo has the MCSE, MCSA SQL Server Database Administrator/Developer certifications. Eduardo is responsible for Production, QA and Development SQL Server Databases as well as all related SQL Server technologies in large environments.
Eduardo is a regular technical writer for developer topics and reviews of Open Source tools for SQL Server database administration, development and productivity.
He is also a Board Member of Guatemala SQL Server users group.
Eduardo has the following certifications:
- Microsoft Certified Solutions Expert: Data Management and Analytics since 2018
- Microsoft Certified Solutions Associate: SQL 2016 Database Administration since 2018
- Microsoft Certified Solutions Associate: SQL Server 2012/2014 since 2017
- Microsoft Certified Professional since 2014
Website: www.sqlguatemala.com
2020 Awards
2019 Awards
2018 Awards
Azure
- How to Capture IoT Data in Azure (last update: 2/27/2020)
- Schedule Azure SQL DB Processes using Azure Functions (last update: 8/13/2021)
- Using Azure SQL Data Sync to Replicate Data (last update: 2/8/2021)
Azure Data Studio
- Create Azure Data Studio Extension with TypeScript (last update: 6/12/2019)
- Create SQL Server Notebooks in Azure Data Studio (last update: 4/10/2019)
- Creating Dashboard Extensions for Azure Data Studio (last update: 5/17/2019)
Compression
- Using COMPRESS and DECOMPRESS in SQL Server to Save Disk Space (last update: 10/9/2018)
Database Administration
- Create custom T-SQL code snippets with Azure Data Studio (last update: 12/12/2018)
Database Design
- SQL Server Foreign Key Hierarchy Order and Dependency List Script (last update: 9/24/2019)
Extended Events
- Start and Stop Extended Events Sessions Automatically Using SQL Server Agent Jobs (last update: 11/2/2018)
Functions System
- Determine SQL Server Network Protocol Information using T-SQL and DMVs (last update: 8/6/2018)
Maintenance
- Update Statistics for All Tables and Databases in a SQL Server Instance (last update: 12/24/2018)
Monitoring
- Capturing SQL Server Deadlocks using Extended Events (last update: 10/1/2018)
- Custom SSMS SQL Server Instance Level Metrics Report (last update: 3/24/2021)
- Script to Retrieve All Error Numbers and Messages from the SQL Server Error Log (last update: 8/10/2018)
- SSMS Custom Report for SQL Server Database Metrics (last update: 4/2/2021)
Power BI
- Azure Text Analytics and Power BI (last update: 11/19/2019)
- Getting Started with Power BI - Part 1 (last update: 2/19/2019)
- Getting Started with Power BI and Power Query for Simple ETL - Part 2 (last update: 4/24/2019)
- Publish Power BI Report to Power BI Service (last update: 8/9/2019)
- Real-Time Streaming using Power BI Streaming Dataset (last update: 8/26/2021)
Query Plans
- Execution Plan in Azure Data Studio (last update: 3/10/2020)
Reporting Services Development
- Multi-detail reports using sub reports in SQL Server Reporting Services (last update: 9/19/2018)
- SQL Server Reporting Services Auto Refresh Report (last update: 2/25/2019)
Reporting Services Formatting
- Conditional Formatting for SQL Server Reporting Services Reports (last update: 9/4/2018)
SQL Server 2019
- SQL Server 2019 Memory Grant Feedback Example and Data Collection (last update: 11/29/2018)
TSQL
- Getting Started with SQL Server Indexing for Performance, Covering Indexes, Implicit Conversions and Parameter Sniffing (last update: 7/24/2019)
- Optimize Large SQL Server DML Processes by Using Batches (last update: 11/13/2018)
- Optimize Large SQL Server Insert, Update and Delete Processes by Using Batches (last update: 8/23/2018)
- SQL Server T-SQL Developer Best Practices Tips- Part 2 (last update: 7/8/2019)
- SQL Server T-SQL Performance Best Practices Tips - Part 1 (last update: 6/25/2019)
