Distributed Monoliths
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
What is a distributed monolith vs. a microservice architecture? Steve has a few thoughts today.
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.
By Steve Jones
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...
The post Lukáš Karlovský: I got the green light from management and built Fabric...
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Has anyone done a migration from sharepoint integrated ssrs to native? I'm not finding...
Hey All, My setup is as follows: Table with Clustered Index on ID col....
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...
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