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.
DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz
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.
How Much AI Do We Need?
AI seems to be invading many different parts of our life. Today Steve wonders how much we really need.
On Looking and Acting the Part
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.
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.
The Data Center that Exploded
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!
An introduction to Terraform
As a Data Engineer I found myself having to learn rather more about cloud infrastructure than I had expected.
Blogs
Ways to land data into Fabric OneLake
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
A Very Cool Benefit in SSMS 21
By Steve Jones
I saw a post from Erin that Preview 2 is available. I’d gotten a...
AI Helping with an API
By Steve Jones
Can an AI help me with some database API work? Let’s see. This is...
Forums
Copy a large table from one table to another
Hi, I have large table with 75 columns and 1.1 billion rows. Want to...
Topic marked as spam - by mistake?
I received the following notification a few hours ago. It seems legit but has...
Getting blockage on Update Statement
Hi, Need your help. I've a SP that is using Update statement on a...
Question of the Day
The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers