Database Trends and Applications Magazine: April/May 2021 Issue

Volume 35 | Number 2

APRIL/MAY 2021

This issue features a Best Practices section titled, "Unlocking the Power of IoT and Edge Computing."

CONTENTS

FEATURES

RESEARCH@DBTA

2 LINUX BECOMES A PLAYER IN THE SQL SERVER WORLD 
BY JOE MCKENDRICK

FEATURE STORY

4 THE TECHNIQUES AND TECHNOLOGIES BRINGING AGILITY TO ENTERPRISE DATA
BY JOE MCKENDRICK

DEPARTMENTS

DBTA LIVE

16 MODERNIZING DATA MANAGEMENT
BUILDING A MODERN ANALYTICS ECOSYSTEM

17 MUST-HAVES FOR MODERN DATA WAREHOUSING
EXPERTS AT PYTHIAN GIVE AN OVERVIEW OF THE BEST OPEN SOURCE DATABASES

APPLICATIONS

15 HOW 3D DATA LINEAGE PROVIDES DETAILED INFORMATION AROUND DATA CATALOGS 
BY EMILY WASHINGTON

18 IMPROVING MONGODB PERFORMANCE TUNING 
BY JOYCE WELLS

19 WHERE IN-MEMORY COMPUTING IS GOING IN 2021 
BY NIKITA IVANOV

20 WHY A MAJORITY OF DATA WAREHOUSE PROJECTS FAIL—AND WHAT BUSINESSES CAN DO 
BY CRAIG STEWART

TRENDS

22 CYBERATTACKS ARE ON THE RISE: HERE’S HOW TO MITIGATE YOUR RISKS 
BY RUSTY CHAPIN

MV SOLUTIONS

24 ROCKET SOFTWARE INTRODUCES UNIOBJECTS FOR PYTHON
ROYAL PAPERS CONTINUES TO THRIVE WITH PICK CLOUD MULTIVALUE

25 DOCKMASTER MOVES ITS HOSTED CLIENTS TO JBASE

COLUMNS

26 QUEST IOUG OBSERVATIONS > BY SHELBY KLINGERMAN
DATABASE OPTIMIZATION: GETTING THE BEST OUT OF ORACLE ENTERPRISE MANAGER

28 NEXT-GEN DATA MANAGEMENT > BY THOMAS LAROCK
CLEANING DIRTY DATA

29 EMERGING TECHNOLOGIES > BY GUY HARRISON
DREMIO REINVIGORATES THE DATA LAKE

30 DBA CORNER > BY CRAIG S. MULLINS
THE IMPORTANCE OF DATA MODELING IN A BIG DATA WORLD

31 SQL SERVER DRILL DOWN > BY KEVIN KLINE
AZURE SQL DATABASE GETS MORE SECURE WITH SECURE ENCLAVES

32 DATABASE ELABORATIONS > BY TODD SCHRAML
CHANGE AND NOT CHANGE IS ULTIMATELY ZEN IN ACTION