Pablo Echeverria

I've worked for more than 10 years as a software programmer and analyst, during which time I studied parallel programming and became a senior programmer specialist. In 2016, I switched jobs to a DBA position, where I've implemented new processes and created better monitoring tools, while I'm growing my data scientist skills to improve my customer's businesses.

Check out Pablo's most recent book https://bpbonline.com/products/hands-on-data-virtualization-with-polybase. This book brings exciting coverage on establishing and managing data virtualization using Polybase. This book teaches how to configure Polybase on almost all relational and nonrelational databases. You will learn to setup a test environment for any tool or software instantly without any hassle. You will learn how rapidly to design and build high performing data warehousing solutions.
  • Interests: technology
  • Skills: programming, databases

SQLServerCentral Article

Check Your Backup Compliance Against a Data Management Provider

As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]

(1)

You rated this post out of 5. Change rating

2020-04-02

1,300 reads

SQLServerCentral Article

Monitor Current Analysis Services Activity

Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any locks? What commands are being run, who is running them, from where? How […]

(3)

You rated this post out of 5. Change rating

2019-12-17

9,988 reads

Blogs

Identity Columns Can’t Be Updated: #SQLNewBlogger

By

I’m not sure I knew identity column values could not be updated. I ran...

Rolling Back a Broken Release

By

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Read the latest Blogs

Forums

Can someone please explain what happens?

By skeleton567

I have mentioned this several times over several years.  Can someone please help me...

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

By tim8w

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin
I run this code:
SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;
What are the results?

See possible answers