SQL & BI

Blog Post

Big Data: An Introduction with Hive

Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides...

2012-12-27

26 reads

Big Data And Hadoop Part 2

In my previous blog I have given more insight on Big Data and now we will take a closer look at Hadoop.

Hadoop

Hadoop is a software framework that supports data-intensive...

2012-12-24

38 reads

Blog Post

Big Data and Hadoop Part 1

Big Data Definition

As per wiki Big Data usually includes data sets with sizes beyond the ability of commonly-used software tools to capture, curate, manage, and process the data within...

2012-12-14

27 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes

By Site Owners

Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

By Site Owners

Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...

Storytelling with Data: Let's Practice!

By Site Owners

Comments posted to this topic are about the item Storytelling with Data: Let's Practice!

Visit the forum

Question of the Day

The Decoded Value

In SQL Server 2025, what is returned from this code:

DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000)));
SELECT BASE64_DECODE(@encoded) 

See possible answers