John Miner

John Miner is a Data Architect at Insight Digital Innovation helping corporations solve their business needs with various data platform solutions.

He has over twenty five 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. He has also earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA) and Data Management & Analytics (MCSE).

Before joining Blue Metal, John won the Data Platform MVP award in 2014, 2015 and 2018 for his outstanding contributions to the SQL Server 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.

2019 Awards
     

2018 Awards
  

2017 Awards
     

2016 Awards
  

2015 Awards
  

• Audit and Prevent Unwanted SQL Server Table Changes (last update: 1/26/2018)
  

• Azure Automation and PowerShell Runbooks (last update: 1/10/2019)
  
• Azure Data Studio Step By Step Tutorial (last update: 4/30/2019)
  
• Azure DevOps for Agile Projects (last update: 3/6/2019)
  
• 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)
  
• Continuous database deployments with Azure DevOps (last update: 3/27/2019)
  
• 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)
  
• 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)
  

• Using the SQL Server 2016 Compress Function (last update: 8/1/2016)
  
• Using the SQL Server 2016 Decompress Function (last update: 8/17/2016)
  

• Reverse Engineer SQL Server Databases with Visual Studio (last update: 2/7/2019)
  

• SQL Server Database Mail configured with the Send Grid Email Service in the Azure Market Place (last update: 10/13/2016)
  

• Continuous SQL Server Database Integration with Visual Studio and Azure DevOps (last update: 2/6/2019)
  

• Full text indexing with Azure SQL database (last update: 10/10/2017)
  

• Parsing string data with the new SQL Server 2016 STRING_SPLIT function (last update: 6/27/2016)
  

• Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell (last update: 11/26/2018)
  

• SSIS Catalog Deployment to Support Dev, QA and Production (last update: 3/4/2020)
  

• 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)
  

• 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)
  
• 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)
  

• Processing text files with PowerShell (last update: 9/15/2017)
  
• Using PowerShell to Work with Directories and Files (last update: 9/1/2017)
  

• Calculate Geographical Coding and Time Zone for an Address in SQL Server with PowerShell, T-SQL and Google Maps (last update: 9/23/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)
  

• Getting Started with SQL Server on Linux (last update: 2/17/2017)