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

Considerations for dealing with big databases

by Eduardo Pivaral

SQL Guatemala

Stress everywhere, user wants everything "Para ayer"Photo by Bernard Goldbach

If you are like me, and have SQL Server instances with...

2018-02-01

586 reads

Meltdown and Spectre exploits, they can affect your SQL Server instances

by Eduardo Pivaral

SQL Guatemala

A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...

2018-01-05

55 reads

Happy new year 2018 to all!

by Eduardo Pivaral

SQL Guatemala

From SQL Guatemala, we wish you a happy new year 2018.

We hope this new year brings you joy and zero:...

2017-12-30

325 reads

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

140 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,115 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

80 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,386 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

235 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

391 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers