SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Not Useless Features

By Steve Jones,

Some time ago I noticed Adam Machanic had written a post titled The SQL Hall of Shame. In it, Adam notes there are features that Microsoft will introduce in SQL Server and then let die. These are the useless features that aren't widely used, or even useful for many projects. You can read his list, and agree or disagree.

I think there certainly are some features that were silly experiments and I wish they had been introduced as experimental, or beta, features early, allowing users to give feedback on whether they're useful and where they need refinement. I certainly think too many resources were initially wasted on items like MDW and Query Notifications, and far too little investment later. These days I think we'll see more early releases of items in Azure where users can experiment and provide feedback to help Microsoft decide if more investment is needed. At least, that's my hope.

Today I'm wondering if you think there are features in SQL Server that do need more attention. Those features you use, but appear forgotten and you'd hope they are improved in the next version.

For me, I certainly wish replication would get more attention, tooling, and resilience. I'm not sure if this needs an overhaul, like SQL Server 2005 was, or there just needs to be some reworking of the code, but in today's distributed world, we need a more reliable way to hook up portions of databases and move data around. Not ETL, not Availabilty Groups, a better replication architecture and implementation.

There might be other features you use or want, but let me know today. What's a not useless feature that you want improved.

Total article views: 86 | Views in the last 30 days: 1
Related Articles

Give us all the features

The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should...


What Is the Hardest Feature to Learn About SQL Server?

SQL Server is a complex product and many of us work with only a small part of the product. However m...


SQL Server Features

SQL Server Features Implemented


Thinking Time

It's important to have time to think, but quite often we don't find the time. Steve Jones comments o...


SQL Server 2014 Deprecated Features

SQL Server 2014 Deprecated Features – Database Engine Everyone looks at the new features when try...