Distributed Monoliths
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
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.
Blogs
A New Word: Fardle-dun
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch
The post Lukáš Karlovský: I got the green light from management and built Fabric...
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Forums
Migrating from SSRS 2008 (SP Integrated) to 2022 (Native)
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
NC index creation duration question
Hey All, My setup is as follows: Table with Clustered Index on ID col....
CPU Performance Advice in SQL Server 2005
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
Question of the Day
Subqueries II
What is wrong (if anything) with this code?
SELECT * FROM Sales.SalesOrderHeader AS soh WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)See possible answers