Simple Talks Episode 7
The season 1, seventh episode of Simple Talks is out. Check it out, with Ryan as the main host. Simple Talks is the Redgate podcast from myself, Grant, Ryan,...
2024-09-27
17 reads
Blog Posts
What I learned volunteering at a children's summer camp
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly moves forward, with schools starting and kids returning to their routines, the memories of the...
2024-09-27 (first published: 2024-09-13)
149 reads
Get mentored and coached by me and other industry experts!
This fall you can take the next step in your data leadership journey by joining a cohort of industry peers and get mentored by experts in the field. In...
2024-09-26
11 reads
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the...
2024-09-25 (first published: 2024-09-16)
130 reads
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
61 reads
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
11 reads
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
3 reads
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to production catalogs for the first time. They wanted to copy the schema and data from...
2024-09-25
9 reads
Why Data Analysts Love PostgreSQL (and You Will Too!)
Data analysis is all about wrangling massive datasets. To do that efficiently, you need a database that can handle the pressure. That's why data analysts turn to relational databases,...
2024-09-25 (first published: 2024-09-14)
87 reads
Are You Making These Mistakes? Using Standard SQL Functions for Database Queries Like a Pro!
Let's be honest – SQL can be a bit of a beast. At first glance, it seems simple enough. But as you dive deeper, the complexity ramps up. Suddenly,...
2024-09-23
60 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers