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
MSSQLTips award

2017 Awards
MSSQLTips award

2016 Awards
MSSQLTips award

2015 Awards
MSSQLTips award

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 DevOps for Agile Projects (last update: 3/6/2019)
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)
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)
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)
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)

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

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)

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

Tutorials DBA Dev BI Career Categories Webcasts Scripts Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

John Miner

More SQL Server Solutions