John Miner

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

SQL Server MVP linkedin 

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.

2023 Awards   MSSQLTips award   MSSQLTips award

2022 Awards   MSSQLTips award

2021 Awards   MSSQLTips award   MSSQLTips award

2020 Awards   MSSQLTips award

2019 Awards   MSSQLTips award   MSSQLTips award

2018 Awards   MSSQLTips award

2017 Awards   MSSQLTips award   MSSQLTips award

2016 Awards   MSSQLTips award

2015 Awards   MSSQLTips award

Category Tip Title
Apache Spark Data Engineering with Microsoft Azure Databricks, Synapse and Apache Spark
Apache Spark Data Processing using Apache Spark and SQL Server using pymssql
Apache Spark Exploring Hive Tables with Spark SQL
Apache Spark Filtering and Aggregating Hive Tables with Spark SQL
Apache Spark Learn Spark SQL Date and Time Functions
Apache Spark Learning Spark SQL Numeric Functions - Basic, Binary, Statistical
Apache Spark Learning Spark SQL String Functions with Explanations and Code Examples
Apache Spark Managing Excel Files with Apache Spark for Azure Databricks Implementation
Apache Spark Managing XML Files with Apache Spark
Apache Spark Working with Spark files and Hive tables
Auditing and Compliance Audit and Prevent Unwanted SQL Server Table Changes
Azure Azure Automation and PowerShell Runbooks
Azure Azure Database for MySQL
Azure Azure Event Hub Service Telemetry Example with PowerShell
Azure Business Critical Tier of Azure SQL Services
Azure Creating SQL Server Linked Servers with Azure
Azure Deploy and Configure PostgreSQL on an Azure Virtual Machine
Azure Deploying Azure Analysis Services using PowerShell cmdlets
Azure Deploying Azure SQL Data Warehouse Using Resource Manager
Azure Exploring Azure Table Storage with PowerShell
Azure Improve Security with an Azure Service Principal
Azure Leveraging PolyBase to load data into Azure SQL Data Warehouse
Azure Managing Azure Data Lake Storage with PowerShell
Azure Microsoft Azure Key Vault for Password Management for SQL Server Applications
Azure Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
Azure Setup an Azure Virtual Machine and Contoso Sample Database for SQL Server Testing
Azure SQL Azure Cross Database Querying
Azure System Stored Procedures for SQL Azure Linked Servers
Azure The tale of two Azure Hubs - IoT Hub and Event Hub
Azure Transfer files between a Data Science Virtual Machine and Azure Data Lake Storage
Azure Update an Azure SQL Data Mart with ADLS files
Azure Using Azure to store and process large amounts of SQL data
Azure What's new in Azure Data Lake Storage Gen2
Azure Backup and Restore Copying SQL Server Backup Files to Azure Blob Storage with AzCopy
Azure Backup and Restore Create Database Copies in Azure SQL Database
Azure Backup and Restore Long Term Storage for Azure SQL Database Backups
Azure Backup and Restore Using PowerShell to Restore an Azure SQL Database
Azure Cosmos DB Introduction to Azure Cosmos DB database and the SQL API
Azure Data Factory Azure Data Factory Parameter Driven Pipelines to Export Tables to CSV Files
Azure Data Factory Build Azure Data Factory Pipelines with On-Premises Data Sources
Azure Data Factory Lambda Architecture in Azure for Batch Processing
Azure Data Factory Leveraging the Power Query activity within Azure Data Factory
Azure Data Factory Leveraging the Script Activity within Azure Data Factory
Azure Data Factory Managing schema drift within the ADF copy activity
Azure Data Factory Supporting multiple data lake file formats with Azure Data Factory
Azure Data Studio Azure Data Studio Step By Step Tutorial
Azure Databricks Azure Databricks Local File System Management
Azure Databricks Code Reuse with Spark Functions for Azure Databricks
Azure Databricks Configure Azure Databricks as a Delta Lakehouse
Azure Databricks Create Parameter Driven Databricks Engineering Notebooks
Azure Databricks Databricks Processing using Medallion Data Quality Zones - Part 1
Azure Databricks Managing Azure Databricks with the Azure Cloud Shell Command Line Interface
Azure Functions How to Schedule T-SQL Statements to Run with Azure Functions
Azure Integration Services Deploy SSIS Catalog to Azure Cloud - Part 1
Azure Integration Services SQL Server Integration Services Flexible File System Task with Azure Blob Storage
Azure Integration Services SQL Server Integration Services Flexible File Task with Azure Data Lake Storage
Azure SQL Database Azure SQL Database - Table Partitioning
Azure SQL Database Azure SQL database auditing using Blob Storage
Azure SQL Database Azure SQL Database Table Partitioning Example
Azure SQL Database Bulk Insert Data into a Azure SQL Database with PowerShell
Azure SQL Database Deploying Azure SQL Database Using Resource Manager PowerShell cmdlets
Azure SQL Database Enabling Active Geo-Replication For Azure SQL Database
Azure SQL Database Enabling alerts for Azure SQL database via PowerShell cmdlets
Azure SQL Database General Purpose Tier for Azure SQL Database
Azure SQL Database Going Serverless with Azure SQL Database
Azure SQL Database Move Azure SQL Databases using the Export and Import PowerShell cmdlets
Azure SQL Database Using Snapshot Replication with an Azure SQL Database
Azure SQL Database Using Transactional Replication with an Azure SQL Database
Azure SQL Managed Instance Deploy and Configure Azure SQL Managed Instance
Azure SQL Managed Instance Enable Auditing for Azure SQL Managed Instance
Azure Synapse Analytics Azure Synapse Analytics Serverless SQL Pools to Replace the Interactive SPARK Clusters
Azure Synapse Analytics Read Data Stored in a Lake Database using Azure Synapse Analytics
Cloud Strategy Data Platform Options - Relational, NoSQL, Graph, Apache Spark and Data Warehouses
Compression Using the SQL Server 2016 Compress Function
Compression Using the SQL Server 2016 Decompress Function
Database Design Change SQL Server Table Structures with SQL ALTER TABLE
Database Design Reverse Engineer SQL Server Databases with Visual Studio
Database Mail SQL Server Database Mail configured with the Send Grid Email Service in the Azure Market Place
DevOps Azure DevOps for Agile Projects
DevOps Continuous database deployments with Azure DevOps
DevOps Continuous SQL Server Database Integration with Visual Studio and Azure DevOps
Full Text Search Full text indexing with Azure SQL database
Functions System Aggregate and Summarize Totals with SQL SUM
Functions System Parsing string data with the new SQL Server 2016 STRING_SPLIT function
Google Cloud Deploy and Secure Cloud SQL Database on Google Cloud Platform (GCP)
Import and Export Adding Salesforce Connectivity to SQL Server
Import and Export Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell
Import and Export Salesforce and QuickBooks Integration to Snowflake via CData SSIS Connectors
Integration Services Administration SSIS Catalog Deployment to Support Dev, QA and Production
Integration Services Development Power Query Source for SQL Server Integration Services
Integration Services Development SQL Server Integration Services Flexible File System Task with Local Storage
JOIN Tables SQL LEFT JOIN Examples
Partitioning Database Sharding to help Improve Performance and Maintenance Tasks
Partitioning Improve Performance and Management of Large Table by Converting to Partitioned View in SQL Server
PostgreSQL Deploy and Configure Azure SQL Database for PostgreSQL using Azure Portal
PostgreSQL SQL Server to PostgreSQL Database Schema Conversion
Power BI Advanced Mathematical Formulas using the M Language
Power BI Converting and formatting numbers using the M Language
Power BI Introduction to the Power BI Desktop and the M Language
Power BI Manage Power BI Dataset with PowerShell
Power BI Manage Power BI Reports with PowerShell
Power BI Managing Power BI Workspaces with PowerShell
Power BI Rounding Numbers using the M Language
Power BI Simple mathematical formulas using the M Language
Power BI Text Extraction using the M Language with Power BI
PowerShell Processing text files with PowerShell
PowerShell Using PowerShell to Work with Directories and Files
Python Introduction to JSON, Python and REST API
Spatial Data Storage Calculate Geographical Coding and Time Zone for an Address in SQL Server with PowerShell, T-SQL and Google Maps
SQL Server 2016 New Drop If Exists Syntax in SQL Server 2016
SQL Server 2016 SQL Server 2016 New Date Objects
SQL Server on Linux Getting Started with SQL Server on Linux
TSQL SQL SELECT DISTINCT Examples
TSQL The T-SQL DELETE statement
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (23)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (7)
Business Intelligence Import and Export (81)
Business Intelligence R Language (11)
Business Intelligence Snowflake (29)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (21)
Cloud Azure (149)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (51)
Cloud Azure SQL Managed Instance (5)
Cloud Cloud Strategy (25)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (39)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (42)
Cloud Analytics Microsoft Fabric (17)
Data Quality Data Cleansing for Validation (4)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (14)
Database Administration Database Administration (208)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (19)
Database Configuration Database Mail (18)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (92)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (15)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (46)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (36)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (14)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (80)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (78)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (12)
Infrastructure Hardware (14)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (116)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (45)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (11)
Other RDBMS SQL Server and Oracle Comparison (29)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (11)
Performance Extended Events (22)
Performance Indexing (94)
Performance Locking and Blocking (43)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (124)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (7)
Power Platform Power Apps (20)
Power Platform Power BI (172)
Power Platform Power BI Charts (57)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (20)
Professional Development Professional Development Certifications (62)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (89)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (8)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (67)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (5)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (47)
Security Encryption (35)
Security Security (199)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (4)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (11)
SQL Coding Stored Procedures (30)
SQL Coding Transactions (9)
SQL Coding Triggers (44)
SQL Coding TSQL (342)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (95)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (55)










get free sql tips
agree to terms