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

146 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,237 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

85 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,506 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

241 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

399 reads

Blogs

Understanding Fabric Ontology

What problem is Fabric Ontology trying to solve? For years, most data conversations have...

QUOTENAME Basics: #SQLNewBlogger

Recently I ran across some code that used a lot of QUOTENAME() calls. A...

When growing companies outgrow Excel

By ChrisJenkins

There are some telltale signs that your growing business has outgrown Excel for your...

Read the latest Blogs

Forums

Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployment...

QUOTENAME Quote Parameters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Quote Parameters

Limit the Blast Radius

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limit the Blast Radius

Visit the forum

Question of the Day

QUOTENAME Quote Parameters

When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?

See possible answers