John Miner

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

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

CategoryTitle
Apache SparkData Engineering with Microsoft Azure Databricks, Synapse and Apache Spark
Auditing and ComplianceAudit and Prevent Unwanted SQL Server Table Changes
AzureAzure Automation and PowerShell Runbooks
AzureAzure Database for MySQL
AzureAzure Event Hub Service Telemetry Example with PowerShell
AzureAzure SQL Database - Table Partitioning
AzureAzure SQL database auditing using Blob Storage
AzureAzure SQL Database Table Partitioning Example
AzureBulk Insert Data into a Azure SQL Database with PowerShell
AzureBusiness Critical Tier of Azure SQL Services
AzureCreating SQL Server Linked Servers with Azure
AzureDeploying Azure Analysis Services using PowerShell cmdlets
AzureDeploying Azure SQL Data Warehouse Using Resource Manager
AzureDeploying Azure SQL Database Using Resource Manager PowerShell cmdlets
AzureEnabling Active Geo-Replication For Azure SQL Database
AzureEnabling alerts for Azure SQL database via PowerShell cmdlets
AzureExploring Azure Table Storage with PowerShell
AzureGeneral Purpose Tier for Azure SQL Database
AzureGoing Serverless with Azure SQL Database
AzureHow to Schedule T-SQL Statements to Run with Azure Functions
AzureImprove Security with an Azure Service Principal
AzureLeveraging PolyBase to load data into Azure SQL Data Warehouse
AzureManaging Azure Data Lake Storage with PowerShell
AzureMicrosoft Azure Key Vault for Password Management for SQL Server Applications
AzureMove Azure SQL Databases using the Export and Import PowerShell cmdlets
AzureSetup an Azure Virtual Machine and Contoso Sample Database for SQL Server Testing
AzureSQL Azure Cross Database Querying
AzureSystem Stored Procedures for SQL Azure Linked Servers
AzureThe tale of two Azure Hubs - IoT Hub and Event Hub
AzureTransfer files between a Data Science Virtual Machine and Azure Data Lake Storage
AzureUpdate an Azure SQL Data Mart with ADLS files
AzureUsing Azure to store and process large amounts of SQL data
AzureUsing Snapshot Replication with an Azure SQL Database
AzureUsing Transactional Replication with an Azure SQL Database
AzureWhat's new in Azure Data Lake Storage Gen2
Azure Backup and RestoreCopying SQL Server Backup Files to Azure Blob Storage with AzCopy
Azure Backup and RestoreCreate Database Copies in Azure SQL Database
Azure Backup and RestoreLong Term Storage for Azure SQL Database Backups
Azure Backup and RestoreUsing PowerShell to Restore an Azure SQL Database
Azure Cosmos DBIntroduction to Azure Cosmos DB database and the SQL API
Azure Data FactoryAzure Data Factory Parameter Driven Pipelines to Export Tables to CSV Files
Azure Data FactoryBuild Azure Data Factory Pipelines with On-Premises Data Sources
Azure Data FactoryLambda Architecture in Azure for Batch Processing
Azure Data FactoryLeveraging the Power Query activity within Azure Data Factory
Azure Data FactoryManaging schema drift within the ADF copy activity
Azure Data FactorySupporting multiple data lake file formats with Azure Data Factory
Azure Data StudioAzure Data Studio Step By Step Tutorial
Azure DatabricksAzure Databricks Local File System Management
Azure Integration ServicesDeploy SSIS Catalog to Azure Cloud - Part 1
Azure Integration ServicesSQL Server Integration Services Flexible File System Task with Azure Blob Storage
Azure Integration ServicesSQL Server Integration Services Flexible File Task with Azure Data Lake Storage
CompressionUsing the SQL Server 2016 Compress Function
CompressionUsing the SQL Server 2016 Decompress Function
Database DesignChange SQL Server Table Structures with SQL ALTER TABLE
Database DesignReverse Engineer SQL Server Databases with Visual Studio
Database MailSQL Server Database Mail configured with the Send Grid Email Service in the Azure Market Place
DevOpsAzure DevOps for Agile Projects
DevOpsContinuous database deployments with Azure DevOps
DevOpsContinuous SQL Server Database Integration with Visual Studio and Azure DevOps
Full Text SearchFull text indexing with Azure SQL database
Functions SystemParsing string data with the new SQL Server 2016 STRING_SPLIT function
Import and ExportImporting Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell
Integration Services AdministrationSSIS Catalog Deployment to Support Dev, QA and Production
Integration Services DevelopmentPower Query Source for SQL Server Integration Services
Integration Services DevelopmentSQL Server Integration Services Flexible File System Task with Local Storage
JOIN TablesSQL LEFT JOIN Examples
Other Database PlatformsAdding Salesforce Connectivity to SQL Server
Other Database PlatformsSalesforce and QuickBooks Integration to Snowflake via CData SSIS Connectors
Power BIAdvanced Mathematical Formulas using the M Language
Power BIConverting and formatting numbers using the M Language
Power BIIntroduction to the Power BI Desktop and the M Language
Power BIManage Power BI Dataset with PowerShell
Power BIManage Power BI Reports with PowerShell
Power BIManaging Power BI Workspaces with PowerShell
Power BIRounding Numbers using the M Language
Power BISimple mathematical formulas using the M Language
Power BIText Extraction using the M Language with Power BI
PowerShellProcessing text files with PowerShell
PowerShellUsing PowerShell to Work with Directories and Files
Spatial Data StorageCalculate Geographical Coding and Time Zone for an Address in SQL Server with PowerShell, T-SQL and Google Maps
SQL Server 2016New Drop If Exists Syntax in SQL Server 2016
SQL Server 2016SQL Server 2016 New Date Objects
SQL Server on LinuxGetting Started with SQL Server on Linux
TSQLSQL SELECT DISTINCT Examples
TSQLThe T-SQL DELETE statement
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (25)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (47)
CloudApache Spark (3)
CloudAzure (188)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (12)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (36)
CloudCloud Strategy (12)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (75)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (22)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (190)
Database AdministrationDatabase Configurations (18)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (11)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (74)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (123)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (129)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (10)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (13)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (71)
Database DevelopmentDates (49)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (70)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (77)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (40)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (48)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (28)
Database DevelopmentSynonyms (5)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (9)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (321)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (12)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (133)
Power PlatformPower BI Charts (46)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (23)
Professional DevelopmentProfessional Development Interview Questions Developer (9)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (32)
SecuritySecurity (196)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (16)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (93)
ToolsSQL Server Management Studio (77)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (33)