John Miner

John Miner is a Senior Data Architect at Insight Digital Innovation helping corporations solve their business needs with various data platform solutions. He has over thirty years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems. His credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Also, he has earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA), Data Management & Analytics (MCSE), Data Science (MPP), Databricks Certified, and Fabric Certified. John has been recognized with the Microsoft MVP award nine times for his outstanding contributions to the Data Platform community. When he is not busy talking to local user groups or writing blog entries on new technology, he spends time with his wife and daughter enjoying outdoor activities. Some of John’s hobbies include wood working projects, crafting a good beer and playing a game of chess.
  • MSSQLTips Awards: Author of the Year - 2019, 2022, 2023 | Champion (100+tips) - 2023
Title Category Date
Spark Engine File Format Options and the Associated Pros and Cons Apache Spark2026-06-02
Read and Write XML Files using Apache Spark Apache Spark2026-05-21
Create an Azure Databricks SQL Warehouse Azure Databricks2026-05-20
Engineering a Lakehouse with Azure Databricks with Spark Dataframes Azure Databricks2026-05-19
Data Streaming Databricks in Azure Azure Databricks2025-02-18
What is Databricks? Azure Databricks2024-10-02
Read Data Stored in a Lake Database using Azure Synapse Analytics Azure Synapse Analytics2024-04-25
Spark SQL String Functions Code Examples Apache Spark2024-04-01
Spark SQL Numeric Functions – Basic, Binary and Statistical Apache Spark2024-03-19
Deploy and Configure Azure SQL Database for PostgreSQL using Portal PostgreSQL2024-02-29
Migrate a Database Schema from SQL Server to PostgreSQL PostgreSQL2024-02-22
Deploy and Configure PostgreSQL on an Azure Virtual Machine Azure2024-02-16
Spark SQL Date and Time Function Examples Apache Spark2023-11-17
Delta Lakehouse Design uses Medallion (bronze, silver, and gold) Zones Azure Databricks2023-11-02
Create Parameter Driven Databricks Engineering Notebooks Azure Databricks2023-10-23
Create a Delta Lakehouse Design Pattern for Azure Databricks Azure Databricks2023-10-05
Managing Azure Databricks with the Azure Cloud Shell CLI Azure Databricks2023-09-21
Deploy and Secure a SQL Server Instance on GCP Managed Service Google Cloud2023-09-08
Azure Synapse Analytics Serverless SQL Pools as Data Lake Alternative Azure Synapse Analytics2023-08-30
Python to store data in JSON format and deploy in Azure with REST API Python2023-05-18
SQL SUM Function for Aggregating and Summarizing Totals Functions System2023-04-20
Microsoft and Databricks High-Speed Apache Spark Data Connector Apache Spark2023-04-03
Scalar, Using, Table, User-Defined Spark Functions for Azure Databrick Azure Databricks2023-03-07
Manage Microsoft Excel Files using Apache Spark for Azure Databricks Apache Spark2023-02-20
Introduction to Databases – Relational, NoSQL, Graph, Apache Spark Cloud Strategy2023-02-06
Pros and Cons of Database Sharding for Performance and Maintenance Partitioning2022-12-26
Audit an Azure SQL Managed Instance Azure SQL Managed Instance2022-12-19
Secure FTP for Azure Blob Storage Azure2022-12-14
Apache Spark to Filter and Aggregate Data Stored in Hive Tables Apache Spark2022-12-06
How to Deploy, Configure and Test Azure SQL Managed Instance Azure SQL Managed Instance2022-11-28
Explore Hive Tables using Spark SQL and Azure Databricks Workspace Apache Spark2022-11-11
Convert Large Table to Partitioned View in SQL Server Partitioning2022-10-28
Azure Data Factory Script Activity to Deploy and Populate Databases Azure Data Factory2022-10-14
SQL ALTER TABLE to Add, Delete and Change Columns in a Table Database Design2022-09-19
Power Query to build code free transformations in Azure Data Factory Azure Data Factory2022-02-10
Handle Unexpected Schema Changes with Azure Data Factory Azure Data Factory2022-01-24
Transform a Raw File into a Refined File with Microsoft Azure Apache Spark2021-12-21
Build Azure Data Factory Pipelines with On-Premises Data Sources Azure Data Factory2021-08-11
Supporting multiple data lake file formats with Azure Data Factory Azure Data Factory2021-07-21
Azure Data Factory Pipelines to Export All Tables to CSV Files Azure Data Factory2021-06-25
SQL LEFT JOIN Examples JOIN Tables2021-04-19
SQL SELECT DISTINCT Examples TSQL2021-04-05
Learn the DELETE SQL Command TSQL2021-03-17
Manage Power BI Reports PowerShell Power BI2021-01-29
Azure Databricks Local File System Management Azure Databricks2020-12-29
Power BI Dataset Management with PowerShell Power BI2020-11-06
Power BI Workspace Management with PowerShell Power BI2020-10-07
Azure Database for MySQL Azure2020-09-04
Lambda Architecture in Azure for Batch Processing Azure Data Factory2020-06-22
Business Critical Tier of Azure SQL Services Azure2020-05-26
SSIS Flexible File Task with Azure Data Lake Storage Azure Integration Services2020-05-20
SSIS Flexible File System Task with Azure Blob Storage Azure Integration Services2020-04-30
SSIS Flexible File System Task with Local Storage Integration Services Development2020-04-02
Deploy SSIS Catalog to Azure Cloud – Part 1 Azure Integration Services2020-03-17
SSIS Catalog Deployment to Support Dev, QA and Production Integration Services Administration2020-03-04
General Purpose Tier for Azure SQL Database Azure SQL Database2020-02-12
Power Query Source for SSIS Integration Services Development2020-02-07
The tale of two Azure Hubs – IoT Hub and Event Hub Azure2020-01-29
Azure Event Hub Service Telemetry Example with PowerShell Azure2020-01-20
Going Serverless with Azure SQL Database Azure SQL Database2019-12-20
Transfer File Data Science Virtual Machine and Azure Data Lake Storage Azure2019-05-29
Improve Security with an Azure Service Principal Azure2019-05-20
Azure Data Studio Step By Step Tutorial Azure Data Studio2019-04-30
What’s new in Azure Data Lake Storage Gen2 Azure2019-04-08
Continuous database deployments with Azure DevOps DevOps2019-03-27
Azure DevOps for Agile Projects DevOps2019-03-06
Reverse Engineer SQL Server Databases with Visual Studio Database Design2019-02-07
Continuous SQL Server Database Integration with Azure DevOps DevOps2019-02-06
Azure Key Vault for Password Management for SQL Server Applications Azure2019-01-18
Azure Automation and PowerShell Runbooks Azure2019-01-10
Update an Azure SQL Data Mart with ADLS files Azure2018-12-26
Importing Enriched Data into Azure Data Lake Storage with PowerShell Import and Export2018-11-26
Managing Azure Data Lake Storage with PowerShell Azure2018-09-07
Text Extraction using the M Language with Power BI Power BI2018-07-16
Azure SQL Database Table Partitioning Example Azure SQL Database2018-05-10
How to Schedule T-SQL Statements to Run with Azure Functions Azure Functions2018-04-26
Introduction to Azure Cosmos DB database and the SQL API Azure Cosmos DB2018-04-12
Exploring Azure Table Storage with PowerShell Azure2018-03-27
Leveraging PolyBase to load data into Azure SQL Data Warehouse Azure2018-03-05
Enabling alerts for Azure SQL database via PowerShell cmdlets Azure SQL Database2018-02-16
Deploying Azure Analysis Services using PowerShell cmdlets Azure2018-02-07
Audit and Prevent Unwanted SQL Server Table Changes Auditing and Compliance2018-01-26
Azure SQL database auditing using Blob Storage Azure SQL Database2018-01-09
Full text indexing with Azure SQL database Full Text Search2017-10-10
Bulk Insert Data into a Azure SQL Database with PowerShell Azure SQL Database2017-09-25
Processing text files with PowerShell PowerShell2017-09-15
Using PowerShell to Work with Directories and Files PowerShell2017-09-01
Using Transactional Replication with an Azure SQL Database Azure SQL Database2017-08-22
Using Snapshot Replication with an Azure SQL Database Azure SQL Database2017-08-09
Long Term Storage for Azure SQL Database Backups Azure Backup and Restore2017-07-24
Using PowerShell to Restore an Azure SQL Database Azure Backup and Restore2017-04-10
Getting Started with SQL Server on Linux SQL Server on Linux2017-02-17
Move Azure SQL Databases with Export and Import PowerShell cmdlets Azure SQL Database2017-02-07
Enabling Active Geo-Replication For Azure SQL Database Azure SQL Database2017-01-13
Copying SQL Server Backup Files to Azure Blob Storage with AzCopy Azure Backup and Restore2017-01-04
Deploying Azure SQL Data Warehouse Using Resource Manager Azure2016-12-26
Using Azure to store and process large amounts of SQL data Azure2016-12-15
SQL Azure Cross Database Querying Azure2016-11-28
Create Database Copies in Azure SQL Database Azure Backup and Restore2016-11-10
SQL Server Database Mail configured with the Send Grid Email Service in the Azure Market Place Database Mail2016-10-13
Calculate Geographical Coding and Time Zone for Address in SQL Server Spatial Data Storage2016-09-23
SQL Server 2016 New Date Objects SQL Server 20162016-09-09
Setup an Azure Virtual Machine and Contoso Sample Database for SQL Server Testing Azure2016-09-08
New Drop If Exists Syntax in SQL Server 2016 SQL Server 20162016-08-22
Using the SQL Server 2016 Decompress Function Compression2016-08-17
Using the SQL Server 2016 Compress Function Compression2016-08-01
Deploying Azure SQL Database Using Resource Manager PowerShell cmdlets Azure SQL Database2016-07-22
Parsing string data with the new SQL Server 2016 STRING_SPLIT function Functions System2016-06-27
Advanced Mathematical Formulas using the M Language Power BI2015-12-03
Converting and formatting numbers using the M Language Power BI2015-11-23
Simple mathematical formulas using the M Language Power BI2015-10-16
Rounding Numbers using the M Language Power BI2015-10-06
Introduction to the Power BI Desktop and the M Language Power BI2015-09-25
System Stored Procedures for SQL Azure Linked Servers Azure2015-05-26
Creating SQL Server Linked Servers with Azure Azure2015-05-20
Azure SQL Database – Table Partitioning Azure SQL Database2015-01-29