Using Fivetran (HVR) to Replicate Data From PostgreSQL to an Azure Databricks Warehouse: Data Engineering with Azure
Learn how to use Fivetran HVR software to ETL data into your One Lake Storage from a PostgreSQL database.
Calculate a Moving Average with T-SQL Windowing Functions
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
Reducing the Cycle Time
Building software can be hard and lots of people have tried various methodologies to improve the way their teams work. Steve notes a lot of the process is the same, but he has a preference.
Stairway to SSAS Tabular Level 4: Implementing Date Dimensions
In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to invoke them. It does not change structures and schema objects.
An introduction to Terraform
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
Doing a Little Research
I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]
SQL IS NULL and SQL IS NOT NULL Examples
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
Lies You Should Believe - Anything is possible
We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]
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