The Evolution of SQL Server BI
It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Robert Sheldon takes stock with the Simple BI Timeline which explains how BI has evolved over the years.
Teambuilding
This week Steve Jones wants to know about your efforts to create bonds with co-workers and build a team. Does your company do anything to help facilitate this?
Introduction to SQL Server 2016 Temporal Tables
Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.
Product Review: GenesisOne T-SQL Source Code Unscrambler
MVP Jody Roberts reviews GenesisOne T-SQL Source Code Unscrambler, a tool that aims to clarify code and server environments with simple diagrams and plain English.
Stairway to Columnstore Indexes Level 4: Catalog Views
In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers