Pablo Echeverria

Pablo Echeverria has 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. Afterward, he switched to a DBA position implementing new processes and creating better monitoring tools, while growing his data scientist skills to improve my customer's businesses.  Check out Pablo's most recent book, "Hands-on Data Virtualization with Polybase". This book brings exciting coverage on establishing and managing data virtualization using Polybase. It teaches how to configure Polybase on almost all relational and nonrelational databases, to setup a test environment for any tool or software instantly without any hassle, and to rapidly design and build high performing data warehousing solutions.
  • MSSQLTips Awards: Rising Star (50+ tips) - 2024 | Author Contender - 2018, 2022, 2023 | Rookie Contender - 2017
Title Category Date
Machine Learning in SQL Server vs Oracle for Sentiment Analysis SQL Server and Oracle Comparison2026-06-04
Create Table SQL Server vs Oracle Database Design2026-06-02
Monitor Performance Counters with PowerShell in SQL Server Agent Job Monitoring2026-05-29
Backup SQL Server on Linux Databases using SQL Server Agent on Windows SQL Server on Linux2023-12-14
Power BI vs Tableau Reporting Comparison with SQL Server Data Power BI2023-12-12
File Watcher Notification for SQL Server vs. Oracle SQL Server and Oracle Comparison2023-08-10
Historical Query Performance Statistics in SQL Server vs Oracle SQL Server and Oracle Comparison2023-07-27
Automatically Refresh Cached Web Page Data from SQL Server or Oracle Application Development2023-06-22
SQL Server and Oracle Cached Query Statistics and Execution Plans SQL Server and Oracle Comparison2023-06-09
SQL Server and Oracle Locking Scripts SQL Server and Oracle Comparison2023-05-24
Troubleshoot Active Sessions in SQL Server vs. Oracle Monitoring2023-05-01
How to Cache SQL Server Data for a Web Application Application Development2023-04-21
Visual Studio 2019 ASP.NET Core Web Application – SQL Server vs Oracle Application Development2023-01-12
ETL Tools Comparison – SSIS vs Oracle ODI SQL Server and Oracle Comparison2022-12-30
How to Script Database Objects with SSMS and SQL Developer SQL Server and Oracle Comparison2022-11-09
Install SSIS vs Oracle Data Integrator from the Command Line Tools2022-10-25
SQL Server and Oracle Performance Improvement with Multiple Data Files SQL Server and Oracle Comparison2022-09-28
Automatically Handle Scheduled Jobs that hang in SQL Server and Oracle SQL Server and Oracle Comparison2022-09-22
Transparent Data Encryption Comparison between SQL Server and Oracle SQL Server and Oracle Comparison2022-08-31
Data Masking in SQL Server vs Oracle Security2022-07-27
Semantic Search Capabilities in SQL Server and Oracle Full Text Search2022-06-21
SQL Server Full Text Search vs Oracle Text Search Full Text Search2022-05-20
Setup Encrypted Connections to SQL Server and Oracle using TLS Encryption2022-04-26
Compare SQL Server BCP and Oracle SQL*Loader SQL Server and Oracle Comparison2022-03-23
SQL CREATE DATABASE vs Oracle CREATE DATABASE SQL Server and Oracle Comparison2022-02-09
Install SQL Server and Oracle on Windows Containers SQL Server and Oracle Comparison2022-01-05
SQL Server PolyBase Scale-out Group Using Amazon Web Services Big Data2021-11-19
Copy Table from Oracle to SQL Server on Linux Import and Export2019-12-05
Find Embedded SQL Server Logins in Jobs, Linked Servers or SSISDB Security2019-10-17
List SQL Server Permissions for Read and Write Access All Databases Security2019-08-22
Data Analysis of SQL Server Tables using T-SQL for Machine Learning Data Science2019-07-31
How to Copy a Table in SQL Server to Another Database Import and Export2019-05-14
T-SQL Script to Correct SQL Server Full Text Indexes Not Updating Full Text Search2019-04-12
SQL Server Agent Job Step History Error Messages for SSIS Package Integration Services Administration2019-03-29
Script out SQL Server Credentials and Proxies Security2018-11-21
SQL Server Parallelism Overview Database Configurations2018-10-15
Script for SQL Server Database Growth Since Last Backup Backup2018-09-14
Increase PowerShell available commands in a SQL Server Agent Job step SQL Server Agent2018-08-15
Comprehensive SQL Server Monitoring Report via Email Monitoring2018-07-09
Script to Distribute Existing SQL Server Full Text Indexes Across Multiple Catalogs Full Text Search2018-06-11
Script for SQL Server Agent Job Issues Across All Instances SQL Server Agent2018-05-30
Migrate a database from SQL Server 2008 to 2016 and use new features Upgrades and Migrations2018-05-09
Check current patch levels for all SQL Servers in environment Database Administration2018-04-09
Find all stopped SQL Server services for all instances Monitoring2018-03-21
Scripts to check SQL Server instant file initialization and lock pages in memory for all servers Database Configurations2018-01-04
Purge SQL Server MSDB Database History Tables with Partitioning System Databases2017-12-22
Graph SQL Server Database Growth Using R and PowerShell Database Administration2017-11-20
Find Drives with Low Disk Space for all SQL Instances using PowerShell PowerShell2017-11-07
Read all errors and warnings in the SQL Server Error Log for all versions Error Logs2017-10-18
Backup SQL Server Databases in Parallel with PowerShell PowerShell2017-09-27
Standardized table based SQL Server monitoring email with PowerShell Monitoring2017-07-28