Get Free Tips
MSSQLTips.com

Author: John Miner

Home » Archives for John Miner

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), Data Science (MPP), Databricks Certified, and Fabric Certified. John has been recognized with the Microsoft MVP award nine 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.

  • MSSQLTips Awards: Author of the Year - 2019, 2022, 2023 | Champion (100+tips) - 2023

TitleCategoryDate
Data Streaming Databricks in AzureAzure Databricks2025-02-18
Engineering a Lakehouse with Azure Databricks with Spark DataframesAzure Databricks2025-01-31
Create an Azure Databricks SQL WarehouseAzure Databricks2025-01-10
What is Databricks?Azure Databricks2024-10-02
Read Data Stored in a Lake Database using Azure Synapse AnalyticsAzure Synapse Analytics2024-04-25
Spark SQL String Functions Code ExamplesApache Spark2024-04-01
Spark SQL Numeric Functions – Basic, Binary and StatisticalApache Spark2024-03-19
Deploy and Configure Azure SQL Database for PostgreSQL using PortalPostgreSQL2024-02-29
Migrate a Database Schema from SQL Server to PostgreSQLPostgreSQL2024-02-22
Deploy and Configure PostgreSQL on an Azure Virtual MachineAzure2024-02-16
Spark SQL Date and Time Function ExamplesApache Spark2023-11-17
Delta Lakehouse Design uses Medallion (bronze, silver, and gold) ZonesAzure Databricks2023-11-02
Create Parameter Driven Databricks Engineering NotebooksAzure Databricks2023-10-23
Create a Delta Lakehouse Design Pattern for Azure DatabricksAzure Databricks2023-10-05
Managing Azure Databricks with the Azure Cloud Shell CLIAzure Databricks2023-09-21
Deploy and Secure a SQL Server Instance on GCP Managed ServiceGoogle Cloud2023-09-08
Azure Synapse Analytics Serverless SQL Pools as Data Lake AlternativeAzure Synapse Analytics2023-08-30
Python to store data in JSON format and deploy in Azure with REST APIPython2023-05-18
SQL SUM Function for Aggregating and Summarizing TotalsFunctions System2023-04-20
Microsoft and Databricks High-Speed Apache Spark Data ConnectorApache Spark2023-04-03
Read and Write XML Files using Apache SparkApache Spark2023-03-21
Scalar, Using, Table, User-Defined Spark Functions for Azure DatabrickAzure Databricks2023-03-07
Manage Microsoft Excel Files using Apache Spark for Azure DatabricksApache Spark2023-02-20
Introduction to Databases – Relational, NoSQL, Graph, Apache SparkCloud Strategy2023-02-06
Pros and Cons of Database Sharding for Performance and MaintenancePartitioning2022-12-26
Spark Engine File Format Options and the Associated Pros and ConsApache Spark2022-12-22
Audit an Azure SQL Managed InstanceAzure SQL Managed Instance2022-12-19
Secure FTP for Azure Blob StorageAzure2022-12-14
Apache Spark to Filter and Aggregate Data Stored in Hive TablesApache Spark2022-12-06
How to Deploy, Configure and Test Azure SQL Managed InstanceAzure SQL Managed Instance2022-11-28
Explore Hive Tables using Spark SQL and Azure Databricks WorkspaceApache Spark2022-11-11
Convert Large Table to Partitioned View in SQL ServerPartitioning2022-10-28
Azure Data Factory Script Activity to Deploy and Populate DatabasesAzure Data Factory2022-10-14
SQL ALTER TABLE to Add, Delete and Change Columns in a TableDatabase Design2022-09-19
Power Query to build code free transformations in Azure Data FactoryAzure Data Factory2022-02-10
Handle Unexpected Schema Changes with Azure Data FactoryAzure Data Factory2022-01-24
Transform a Raw File into a Refined File with Microsoft AzureApache Spark2021-12-21
Build Azure Data Factory Pipelines with On-Premises Data SourcesAzure Data Factory2021-08-11
Supporting multiple data lake file formats with Azure Data FactoryAzure Data Factory2021-07-21
Azure Data Factory Pipelines to Export All Tables to CSV FilesAzure Data Factory2021-06-25
SQL LEFT JOIN ExamplesJOIN Tables2021-04-19
SQL SELECT DISTINCT ExamplesTSQL2021-04-05
Learn the DELETE SQL CommandTSQL2021-03-17
Manage Power BI Reports PowerShellPower BI2021-01-29
Azure Databricks Local File System ManagementAzure Databricks2020-12-29
Power BI Dataset Management with PowerShellPower BI2020-11-06
Power BI Workspace Management with PowerShellPower BI2020-10-07
Azure Database for MySQLAzure2020-09-04
Lambda Architecture in Azure for Batch ProcessingAzure Data Factory2020-06-22
Business Critical Tier of Azure SQL ServicesAzure2020-05-26
SSIS Flexible File Task with Azure Data Lake StorageAzure Integration Services2020-05-20
SSIS Flexible File System Task with Azure Blob StorageAzure Integration Services2020-04-30
SSIS Flexible File System Task with Local StorageIntegration Services Development2020-04-02
Deploy SSIS Catalog to Azure Cloud – Part 1Azure Integration Services2020-03-17
SSIS Catalog Deployment to Support Dev, QA and ProductionIntegration Services Administration2020-03-04
General Purpose Tier for Azure SQL DatabaseAzure SQL Database2020-02-12
Power Query Source for SSISIntegration Services Development2020-02-07
The tale of two Azure Hubs – IoT Hub and Event HubAzure2020-01-29
Azure Event Hub Service Telemetry Example with PowerShellAzure2020-01-20
Going Serverless with Azure SQL DatabaseAzure SQL Database2019-12-20
Transfer File Data Science Virtual Machine and Azure Data Lake StorageAzure2019-05-29
Improve Security with an Azure Service PrincipalAzure2019-05-20
Azure Data Studio Step By Step TutorialAzure Data Studio2019-04-30
What’s new in Azure Data Lake Storage Gen2Azure2019-04-08
Continuous database deployments with Azure DevOpsDevOps2019-03-27
Azure DevOps for Agile ProjectsDevOps2019-03-06
Reverse Engineer SQL Server Databases with Visual StudioDatabase Design2019-02-07
Continuous SQL Server Database Integration with Azure DevOpsDevOps2019-02-06
Azure Key Vault for Password Management for SQL Server ApplicationsAzure2019-01-18
Azure Automation and PowerShell RunbooksAzure2019-01-10
Update an Azure SQL Data Mart with ADLS filesAzure2018-12-26
Importing Enriched Data into Azure Data Lake Storage with PowerShellImport and Export2018-11-26
Managing Azure Data Lake Storage with PowerShellAzure2018-09-07
Text Extraction using the M Language with Power BIPower BI2018-07-16
Azure SQL Database Table Partitioning ExampleAzure SQL Database2018-05-10
How to Schedule T-SQL Statements to Run with Azure FunctionsAzure Functions2018-04-26
Introduction to Azure Cosmos DB database and the SQL APIAzure Cosmos DB2018-04-12
Exploring Azure Table Storage with PowerShellAzure2018-03-27
Leveraging PolyBase to load data into Azure SQL Data WarehouseAzure2018-03-05
Enabling alerts for Azure SQL database via PowerShell cmdletsAzure SQL Database2018-02-16
Deploying Azure Analysis Services using PowerShell cmdletsAzure2018-02-07
Audit and Prevent Unwanted SQL Server Table ChangesAuditing and Compliance2018-01-26
Azure SQL database auditing using Blob StorageAzure SQL Database2018-01-09
Full text indexing with Azure SQL databaseFull Text Search2017-10-10
Bulk Insert Data into a Azure SQL Database with PowerShellAzure SQL Database2017-09-25
Processing text files with PowerShellPowerShell2017-09-15
Using PowerShell to Work with Directories and FilesPowerShell2017-09-01
Using Transactional Replication with an Azure SQL DatabaseAzure SQL Database2017-08-22
Using Snapshot Replication with an Azure SQL DatabaseAzure SQL Database2017-08-09
Long Term Storage for Azure SQL Database BackupsAzure Backup and Restore2017-07-24
Using PowerShell to Restore an Azure SQL DatabaseAzure Backup and Restore2017-04-10
Getting Started with SQL Server on LinuxSQL Server on Linux2017-02-17
Move Azure SQL Databases with Export and Import PowerShell cmdletsAzure SQL Database2017-02-07
Enabling Active Geo-Replication For Azure SQL DatabaseAzure SQL Database2017-01-13
Copying SQL Server Backup Files to Azure Blob Storage with AzCopyAzure Backup and Restore2017-01-04
Deploying Azure SQL Data Warehouse Using Resource ManagerAzure2016-12-26
Using Azure to store and process large amounts of SQL dataAzure2016-12-15
SQL Azure Cross Database QueryingAzure2016-11-28
Create Database Copies in Azure SQL DatabaseAzure Backup and Restore2016-11-10
SQL Server Database Mail configured with the Send Grid Email Service in the Azure Market PlaceDatabase Mail2016-10-13
Calculate Geographical Coding and Time Zone for Address in SQL ServerSpatial Data Storage2016-09-23
SQL Server 2016 New Date ObjectsSQL Server 20162016-09-09
Setup an Azure Virtual Machine and Contoso Sample Database for SQL Server TestingAzure2016-09-08
New Drop If Exists Syntax in SQL Server 2016SQL Server 20162016-08-22
Using the SQL Server 2016 Decompress FunctionCompression2016-08-17
Using the SQL Server 2016 Compress FunctionCompression2016-08-01
Deploying Azure SQL Database Using Resource Manager PowerShell cmdletsAzure SQL Database2016-07-22
Parsing string data with the new SQL Server 2016 STRING_SPLIT functionFunctions System2016-06-27
Advanced Mathematical Formulas using the M LanguagePower BI2015-12-03
Converting and formatting numbers using the M LanguagePower BI2015-11-23
Simple mathematical formulas using the M LanguagePower BI2015-10-16
Rounding Numbers using the M LanguagePower BI2015-10-06
Introduction to the Power BI Desktop and the M LanguagePower BI2015-09-25
System Stored Procedures for SQL Azure Linked ServersAzure2015-05-26
Creating SQL Server Linked Servers with AzureAzure2015-05-20
Azure SQL Database – Table PartitioningAzure SQL Database2015-01-29

Categories

Recent Articles

  • SQL Server Transaction Log

  • 10 New Features in SQL Server 2025

  • Elevate Your ETL: Seamlessly Integrate Melissa’s SSIS Data Quality Tools with Azure Data Factory

  • Database Modernization with AI-Powered Tools

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide