Eduardo Pivaral

SQL Server Database Administrator/Developer with experience in large environments.
I have worked on IT for nearly 15 years in different areas.

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: http://www.sqlguatemala.com

All authors

Introduction to StudyYourServer

by Eduardo Pivaral

SQL Guatemala

I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...

2020-02-04

123 reads

Introduction to StudyYourServer

by Eduardo Pivaral

SQL Guatemala

I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...

2020-02-04

25 reads

New Youtube Channel

by Eduardo Pivaral

SQL Guatemala

Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...

2020-01-31

39 reads

New Youtube Channel

by Eduardo Pivaral

SQL Guatemala

Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...

2020-01-31

8 reads

T-SQL Basics: using OUTPUT

by Eduardo Pivaral

SQL Guatemala

You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...

2020-01-09 (first published: 2020-01-03)

1,067 reads

T-SQL Basics: using OUTPUT

by Eduardo Pivaral

SQL Guatemala

You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...

2020-01-03

11 reads

Xmas tree in T-SQL

by Eduardo Pivaral

SQL Guatemala

This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...

2019-12-27

260 reads

Xmas tree in T-SQL

by Eduardo Pivaral

SQL Guatemala

This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...

2019-12-27

4 reads

Refreshing dependent views after a DDL change

by Eduardo Pivaral

SQL Guatemala

When you are in charge of databases with tons of objects, making a small change over an object can be difficult to replicate if you have a lot of...

2019-08-02 (first published: 2019-07-15)

1,278 reads

SQL Engine basics: Caching data

by Eduardo Pivaral

SQL Guatemala

SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...

2019-07-16 (first published: 2019-07-05)

1,102 reads

All authors

Eduardo Pivaral

Introduction to StudyYourServer

Introduction to StudyYourServer

New Youtube Channel

New Youtube Channel

T-SQL Basics: using OUTPUT

T-SQL Basics: using OUTPUT

Xmas tree in T-SQL

Xmas tree in T-SQL

Refreshing dependent views after a DDL change

SQL Engine basics: Caching data

Blogs

Local LLM Models at SQL Saturday Boston 2025

3 things you must do to start data quality management right

Set Theory vs. Batch Mode in SQL Server

Forums

SSC Website Deployment 24 Sept 2025

Timeout when expanding the table

Single User SQL Server on Linux

Question of the Day

Single User SQL Server on Linux