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) and Data Science (MPP).
John has been recognized with the Microsoft MVP award five 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.
2021 Awards
2020 Awards
2019 Awards
2018 Awards
2017 Awards
2016 Awards
2015 Awards
Auditing and Compliance
- Audit and Prevent Unwanted SQL Server Table Changes (last update: 1/26/2018)
Azure
- Azure Automation and PowerShell Runbooks (last update: 1/10/2019)
- Azure Data Studio Step By Step Tutorial (last update: 4/30/2019)
- Azure Database for MySQL (last update: 9/4/2020)
- Azure Databricks Local File System Management (last update: 12/29/2020)
- Azure Event Hub Service Telemetry Example with PowerShell (last update: 1/20/2020)
- Azure SQL Database - Table Partitioning (last update: 1/29/2015)
- Azure SQL database auditing using Blob Storage (last update: 1/9/2018)
- Azure SQL Database Table Partitioning Example (last update: 5/10/2018)
- Bulk Insert Data into a Azure SQL Database with PowerShell (last update: 9/25/2017)
- Business Critical Tier of Azure SQL Services (last update: 5/26/2020)
- Copying SQL Server Backup Files to Azure Blob Storage with AzCopy (last update: 1/4/2017)
- Create Database Copies in Azure SQL Database (last update: 11/10/2016)
- Creating SQL Server Linked Servers with Azure (last update: 5/20/2015)
- Deploy SSIS Catalog to Azure Cloud - Part 1 (last update: 3/17/2020)
- Deploying Azure Analysis Services using PowerShell cmdlets (last update: 2/7/2018)
- Deploying Azure SQL Data Warehouse Using Resource Manager (last update: 12/26/2016)
- Deploying Azure SQL Database Using Resource Manager PowerShell cmdlets (last update: 7/22/2016)
- Enabling Active Geo-Replication For Azure SQL Database (last update: 1/13/2017)
- Enabling alerts for Azure SQL database via PowerShell cmdlets (last update: 2/16/2018)
- Exploring Azure Table Storage with PowerShell (last update: 3/27/2018)
- General Purpose Tier for Azure SQL Database (last update: 2/12/2020)
- Going Serverless with Azure SQL Database (last update: 12/20/2019)
- How to Schedule T-SQL Statements to Run with Azure Functions (last update: 4/26/2018)
- Improve Security with an Azure Service Principal (last update: 5/20/2019)
- Introduction to Azure Cosmos DB database and the SQL API (last update: 4/12/2018)
- Leveraging PolyBase to load data into Azure SQL Data Warehouse (last update: 3/5/2018)
- Long Term Storage for Azure SQL Database Backups (last update: 7/24/2017)
- Managing Azure Data Lake Storage with PowerShell (last update: 9/7/2018)
- Microsoft Azure Key Vault for Password Management for SQL Server Applications (last update: 1/18/2019)
- Move Azure SQL Databases using the Export and Import PowerShell cmdlets (last update: 2/7/2017)
- Setup an Azure Virtual Machine and Contoso Sample Database for SQL Server Testing (last update: 9/8/2016)
- SQL Azure Cross Database Querying (last update: 11/28/2016)
- SQL Server Integration Services Flexible File System Task with Azure Blob Storage (last update: 4/30/2020)
- SQL Server Integration Services Flexible File Task with Azure Data Lake Storage (last update: 5/20/2020)
- System Stored Procedures for SQL Azure Linked Servers (last update: 5/26/2015)
- The tale of two Azure Hubs - IoT Hub and Event Hub (last update: 1/29/2020)
- Transfer files between a Data Science Virtual Machine and Azure Data Lake Storage (last update: 5/29/2019)
- Update an Azure SQL Data Mart with ADLS files (last update: 12/26/2018)
- Using Azure to store and process large amounts of SQL data (last update: 12/15/2016)
- Using PowerShell to Restore an Azure SQL Database (last update: 4/10/2017)
- Using Snapshot Replication with an Azure SQL Database (last update: 8/9/2017)
- Using Transactional Replication with an Azure SQL Database (last update: 8/22/2017)
- What's new in Azure Data Lake Storage Gen2 (last update: 4/8/2019)
Azure Data Factory
- Azure Data Factory Parameter Driven Pipelines to Export Tables to CSV Files (last update: 6/25/2021)
- Lambda Architecture in Azure for Batch Processing (last update: 6/22/2020)
- Supporting multiple data lake file formats with Azure Data Factory (last update: 7/21/2021)
Compression
- Using the SQL Server 2016 Compress Function (last update: 8/1/2016)
- Using the SQL Server 2016 Decompress Function (last update: 8/17/2016)
Database Design
- Reverse Engineer SQL Server Databases with Visual Studio (last update: 2/7/2019)
Database Mail
- SQL Server Database Mail configured with the Send Grid Email Service in the Azure Market Place (last update: 10/13/2016)
DevOps
- Azure DevOps for Agile Projects (last update: 3/6/2019)
- Continuous database deployments with Azure DevOps (last update: 3/27/2019)
- Continuous SQL Server Database Integration with Visual Studio and Azure DevOps (last update: 2/6/2019)
Full Text Search
- Full text indexing with Azure SQL database (last update: 10/10/2017)
Functions - System
- Parsing string data with the new SQL Server 2016 STRING_SPLIT function (last update: 6/27/2016)
Import and Export
- Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell (last update: 11/26/2018)
Integration Services Administration
- SSIS Catalog Deployment to Support Dev, QA and Production (last update: 3/4/2020)
Integration Services Development
- Power Query Source for SQL Server Integration Services (last update: 2/7/2020)
- SQL Server Integration Services Flexible File System Task with Local Storage (last update: 4/2/2020)
JOIN Tables
- SQL LEFT JOIN Examples (last update: 4/19/2021)
Power BI
- Advanced Mathematical Formulas using the M Language (last update: 12/3/2015)
- Converting and formatting numbers using the M Language (last update: 11/23/2015)
- Introduction to the Power BI Desktop and the M Language (last update: 9/25/2015)
- Manage Power BI Dataset with PowerShell (last update: 11/6/2020)
- Manage Power BI Reports with PowerShell (last update: 1/29/2021)
- Managing Power BI Workspaces with PowerShell (last update: 10/7/2020)
- Rounding Numbers using the M Language (last update: 10/6/2015)
- Simple mathematical formulas using the M Language (last update: 10/16/2015)
- Text Extraction using the M Language with Power BI (last update: 7/16/2018)
PowerShell
- Processing text files with PowerShell (last update: 9/15/2017)
- Using PowerShell to Work with Directories and Files (last update: 9/1/2017)
Spatial Data Storage
- Calculate Geographical Coding and Time Zone for an Address in SQL Server with PowerShell, T-SQL and Google Maps (last update: 9/23/2016)
SQL Server 2016
- New Drop If Exists Syntax in SQL Server 2016 (last update: 8/22/2016)
- SQL Server 2016 New Date Objects (last update: 9/9/2016)
SQL Server on Linux
- Getting Started with SQL Server on Linux (last update: 2/17/2017)
T-SQL
- SQL SELECT DISTINCT Examples (last update: 4/5/2021)
- The T-SQL DELETE statement (last update: 3/17/2021)
