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

SQL Vulnerability Assessment

by Eduardo Pivaral

SQL Guatemala

A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment.

What is...

2017-12-12

161 reads

How to check advanced options in SQL Server?

by Eduardo Pivaral

SQL Guatemala

To check the available advanced options configured at instance level in SQL Server, you need to use the sp_configure system...

2017-11-24

45,530 reads

Finally I am MCSA

by Eduardo Pivaral

SQL Guatemala

I have recently obtained the certification Microsoft Certified Solutions Associate: SQL Server 2012/2014.
I began with this path almost 2 years...

2017-11-20

102 reads

Query to determine mirrored database status

by Eduardo Pivaral

SQL Guatemala

I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their...

2017-11-10

6,730 reads

SSIS Basics: Integration Services Catalogs

by Eduardo Pivaral

SQL Guatemala

In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...

2017-11-06

275 reads

T-SQL Basics: MERGE Statement

by Eduardo Pivaral

SQL Guatemala

One useful sentence when you need to add data to an existing table from an external source or database, and...

2017-10-06

420 reads

Blogs

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

The flight recorder: Replaying what an AI agent did on my SQL Server

“What exactly did it do on my server?” is the first question a DBA...

Announcements from the Microsoft Fabric Community Conference — Barcelona 2026

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

Read the latest Blogs

Forums

It's Never Just One Thing

By Grant Fritchey

Comments posted to this topic are about the item It's Never Just One Thing

Calculating Min-Max Normalization in PowerBI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI

Checking the Error Log III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking the Error Log III

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers