Engineering a Lakehouse with Azure Databricks with Spark Dataframes
How can we get familiar with Azure Databricks with Spark Dataframes?
2025-02-26
Apache Spark
Learning Spark SQL String Functions with Explanations and Code Examples
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
2024-04-29
Managing Files and Folders with Python – Data Engineering with Fabric
In this article, learn how you can manage files and folders for both full and incremental loading situations.
2024-03-27
3,690 reads
Managed Vs Unmanaged Tables – Data Engineering with Fabric
Learn how to get started with Microsoft Fabric along with the differences between managed and unmanaged tables.
2024-03-20
4,699 reads
Using Spark Jobs for Multiple Lakehouse Maintenance in Microsoft Fabric
I have published videos and articles before about Lakehouse maintenance. In this article I want to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces.
2024-01-03
Learn Spark SQL Date and Time Functions
This article covers how to use the different date and time functions when working with Spark SQL.
2023-12-08
Exploring Hive Tables with Spark SQL
In this article, we will look at how to use an Azure Databricks Workspace to explore Hive tables using Spark SQL along with several examples.
2022-12-12
Improving Performance In Spark Using Partitions
In this blog post we are going to show how to optimize your Spark job by partitioning the data correctly. To demonstrate this we are going to use the College Score Card public dataset, which has several key data points from colleges all around the United States. We will compute the average student fees by state with this dataset.
2019-04-12
Ingesting Data From Files With Apache Spark, Part 1
In this post, a data expert teaches us how to take in large data sets using Apache Spark.
2019-04-12
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers