...
Stay connected
Recent Posts
SQL

Working with XML Data in T-SQL: Marvel Movies Example 

XML (eXtensible Markup Language) remains a powerful and popular format for storing and exchanging structured data. In this blog post, we’ll explore how to work with XML data in T-SQL using an example that features Marvel movies and their directors. We’ll cover how to create…

PLAY
Data, Podcast

What is Data governance 

Don’t feel like reading? Then listen to the podcast by clicking here Today, we’re diving into a topic that might sound dry but is absolutely crucial for any modern enterprise—Data Governance.  So lets jump right into it. So, what is data governance? Imagine you’re the…

PLAY
SQL

Stored Procedures vs Functions 

Stored procedures and functions are both important concepts in SQL used to encapsulate and reuse code. Many people don’t seem to know the difference between the 2. I’ve realised that from interviewing many many people and asking them to explain the differences. Here are the…

PLAY
Podcast

Telling stories with data 

Today, we’re diving into one of the most important skills in the data world – Storytelling with Data where you’ll learn how to Communicate Insights Effectively.  From uncovering hidden trends to making data-driven decisions, telling a compelling story with data can be a game-changer. But…

Data

7 reasons why you should be using NoSQL 

If you work in the data or tech world, you would have heard about NoSQL and how it growing rapidly within in organisations. Here are 7 reasons why you should use it in your next project. Flexible Data Models: NoSQL databases like MongoDB, Cassandra, and…

PLAY
Data, SQL

Stop using IsNumeric for data validation 

The infamous ISNUMERIC function! It seems helpful at first, but then you wake up…hopefully. Here’s why you should ditch ISNUMERIC and join the TRY_CAST crew: ISNUMERIC – Returns true for ‘+’, ‘-‘, and ‘.’ – Thinks hexadecimal strings are numeric (um, ok!) – Says strings…

PLAY
Data, Podcast

Can you run SQL Server on a Mac? 

Introduction Apple Silicon, Apple’s pioneering venture into ARM-based processors, has been met with widespread acclaim for its impressive performance and power efficiency. However, it is not without its challenges, especially when it comes to compatibility with certain software. One such software is Microsoft’s SQL Server,…

PLAY
Data, Podcast

What is a data analyst? 

Data Analysts: Pioneers in the Data World Ever wondered who’s behind the valuable insights derived from the overwhelming amounts of data generated every day? Meet the data analyst. They play a critical role in helping businesses make data-driven decisions and predict future trends. What is…

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.