The plethora of new collation options introduced by SQL Server 2000 is a good example of new features bringing new complexity. Collations specify the character set and sort order your SQL Server ...

so I need to group data rows together by year and then order that by semester. I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else ...

SQL Server 2025 is also introducing a native JSON ... and we could not guarantee the order of transactions. I can see a lot of use for Change Streaming in analytical environments.