John Miner

Independent Journalist at Freelance

[email protected]

Featured in: Favicon

nature.com Favicon

nationalpost.com Favicon

torontosun.com Favicon

vancouversun.com Favicon

edmontonjournal.com Favicon

thestarphoenix.com Favicon

calgarysun.com Favicon

theprovince.com Favicon

lfpress.com Favicon

brantfordexpositor.ca + 31 more

Articles

The Fabric Modern Data Platform – SQLServerCentral

1 month ago | sqlservercentral.com | John Miner

A New and Improved Data Warehouse: Data Engineering with FabricIn this next installment, John performs the research you might do if your management asked you to examine Fabric.
More pesticides are coming to combat Colorado Potato Beetle

2 months ago | ontariofarmer.com | John Miner |Ontario Farmer

More pesticides are coming to combat Colorado Potato BeetleAvailable now for use is Cimegra, a foliar insecticide, while Plinazolin and Calantha are in the pipeline John Miner • Ontario FarmerPublished Apr 08, 2025 • 3 minute readYou can save this article by registering for free here. Or sign-in if you have an account. A family of Colorado potato beetle larvae making a meal of a potato leaf.
More pesticides are coming to combat Colorado Potato Beetle

2 months ago | lfpress.com | John Miner |Ontario Farmer

Advertisement 1Available now for use is Cimegra, a foliar insecticide, while Plinazolin and Calantha are in the pipelineAuthor of the article: • Ontario Farmer • You can save this article by registering for free here. Or sign-in if you have an account. Article contentGUELPH – Canadian farmers are getting new pesticides to counter the Colorado Potato Beetle, a bug with a long track record of defeating pest control measures.
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric – SQLServerCentral

2 months ago | sqlservercentral.com | John Miner

Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this concept about seven years ago in which there were two architectural designs: either store data in Azure SQL Database and transform data using stored procedures; or land data in Azure Data Lake Storage Gen 1 and transform data with USQL. Roll forward seven years, many things have changed. Most people are transitioning to Microsoft Fabric.
Calgary buyer is looking for rural accounting firms

2 months ago | ontariofarmer.com | John Miner |Ontario Farmer

Skip to ContentAdvertisement 1When local tax professionals in rural Canada decide to retire there are three common scenariosAuthor of the article: • Ontario Farmer • You can save this article by registering for free here. Or sign-in if you have an account. Article contentAfter a three-year trial to test its business concept, a Calgary-based company is now shopping for rural accounting firms across the country.
Data Streaming Databricks in Azure

2 months ago | mssqltips.com | John Miner

87The core functionality of Apache Spark has support for structured streaming using either a batch or a continuous method. The two most popular sources of input data are data lake files and Kafka events. Check point files in the data lake are used to keep track of what data has been processed to date. Performance issues may arise when a directory contains a substantial number of files. Databricks saw this limitation and created the Auto Loader feature for data lake files.
Engineering a Lakehouse with Azure Databricks with Spark Dataframes

Feb 25, 2025 | mssqltips.com | John Miner

122Time does surely fly. I remember when Databricks was released to general availability in Azure in March 2018. This means data engineers have been developing Azure Databricks Spark programs for seven years. Many technological changes have been made over that time. Understanding the different ways to process files is key since many different techniques might be used in your environment. How can we get familiar with Azure Databricks with Spark Dataframes?
Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric – SQLServerCentral

Feb 25, 2025 | sqlservercentral.com | John Miner

Did you know that Edgar F. Codd is considered the father of the relational model that is used by most database systems? He authored papers on both relational calculus and normal forms in the 1970s. It is especially important to know where the history of where today’s technology comes from. The Fabric Warehouse does support a subset of Microsoft’s Transact Structured Query Language (T-SQL). However, the Fabric storage engine (OneLake) is based upon the delta lake file format.
How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric – SQLServerCentral

Feb 11, 2025 | sqlservercentral.com | John Miner

The SQL endpoint of the Fabric Data Warehouse allows programs to read from and write to tables. The flexibility of the warehouse can lead to a big debate within your company on “How to develop with this new service?”. Older programmers might want to use SQL Server Management Studio, Azure Data Studio or Visual Studio Code while newer developers might want to use Fabric web interface.
How to Load a Fabric Warehouse: Data Engineering with Fabric – SQLServerCentral

Jan 7, 2025 | sqlservercentral.com | John Miner

The data warehouse in Microsoft Fabric was re-written to use OneLake storage. This means each and every table in the warehouse is based on the Delta file format. Staying away from single transactions will keep the warehouse performing at its best. We already learned in a prior article that T-SQL insert statements can be used to add rows to a table. Are there any other ways to insert or update rows in our warehouse?