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.
Learn how to create a moving average in SQL Server using older and less performant T-SQL and a modern way using windowing functions.
In this first article, get an introduction to DAX, it's uses, and the basics of a DAX query as compared to a T-SQL query.
AI seems to be invading many different parts of our life. Today Steve wonders how much we really need.
Phil Factor's offers tips for longevity in the world of IT consultancy: listen well, humiliate no-one and convince others that it was their expertise that solved the problem.
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.
In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.
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.
A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Hi, I have large table with 75 columns and 1.1 billion rows. Want to...
I received the following notification a few hours ago. It seems legit but has...
Hi, Need your help. I've a SP that is using Update statement on a...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers