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

2018 Awards
MSSQLTips award

Azure

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)
Script to Retrieve All Error Numbers and Messages from the SQL Server Error Log (last update: 8/10/2018)

Power BI

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)

Reporting Services Development

Multi-detail reports using sub reports in SQL Server Reporting Services (last update: 9/19/2018)
SQL Server Reporting Services SSRS 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)

T-SQL

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)

Tutorials DBA Dev BI Career Categories Webcasts Scripts Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Eduardo Pivaral

More SQL Server Solutions