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

164 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,565 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

107 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,766 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

283 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

424 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By Anthony Nocentino

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By Randolph West

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

PostgreSQL 19 Is Late

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PostgreSQL 19 Is Late

Hyperscale Replicas V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas V

A Heavy Heart

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Heavy Heart

Visit the forum

Question of the Day

Hyperscale Replicas V

I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?

See possible answers