What would I like to see in SQL Server in the future?

1. Assertions (in the SQL standard since SQL-92. Until now no one has implement them - I hear Oracle...

In the relational model all data is represented as attributes, within tuples within relations (columns, rows and tables in SQL speak). This means that all data manipulation can be achieved...

Or using powershell and regex

([regex]"(?im)--.*?$").replace(([regex]"(?s)\/\*.*?\*\/").replace($sql, ""), "")

The brand new go to technology in the NoSQL arena is TrumpDB.

The  same query in TrumpDB will always deliver a different answer.

TrumpDB is super...

A good article Steve, thank you.

There is one sentence that I would like to comment on.

The data is the more important asset we work with and all our efforts...

In my experience the "just want to hear how everyone is doing" meeting can often turn into the manager talking for the full hour with nobody else getting a word...

For managers the best kind of meeting is the meta-meeting. A meeting in which you do nothing other than discuss other meetings.

@L' Eomot Inversé

Yes, that is something that SQL Server doesn't do well.

However the competitors are no better on this front.

What is SQL Server not good at?

Defining constraints declaratively.

The CREATE ASSERTION statement has been in the SQL standard since 1992. Microsoft still haven't implemented it.

If you have...