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.

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 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 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 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
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 Parsing string data with the new SQL Server 2016 STRING_SPLIT function
Import and Export Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell
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
Other Database Platforms Data Platform Options - Relational, NoSQL, Graph, Apache Spark and Data Warehouses
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
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 Aggregate and Summarize Totals with SQL SUM
TSQL SQL SELECT DISTINCT Examples
TSQL The T-SQL DELETE statement
No Records Found
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (31)
Analysis Services Analysis Services Development (94)
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 Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (147)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (199)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (41)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (86)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (41)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (78)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (73)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (73)
Database Development Query Optimization (14)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (367)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (148)
Power Platform Power BI Charts (52)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (50)
Professional Development Professional Development Community (16)
Professional Development Professional Development Conferences (2)
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 (18)
Professional Development Professional Development Management (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (196)
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)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms