Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Under Appreciated Features

By Andy Warren,

If you look back at the evolution of SQL Server for the last 10 years, there has been a lot of interesting growth in features and capabilities. DTS lead to SSIS, OLAP lead to Analysis Services, Reporting Services was added, and those are some of the big ones. But there have been a lot of smaller things changed and added during the journey; varchar(max), separate date and time types, Management Studio, blocking detection, and more.

Thinking about those smaller changes got me thinking – what is the most underappreciated feature of SQL Server? What’s the feature that doesn’t get used nearly as much as it should? Maybe because it doesn’t have a great UI, or it seems intimidating, or just doesn’t get talked about, some features just never seem to take off.

I’ve got a couple in mind already that I’ll post as a comment, but I’d like to hear what you think first.  What feature would you tell your fellow DBA’s to spend some time learning?

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

Give us all the features

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

ARTICLE

Adding Old Features?

Is Row Level Security a new feature? Or should MS work on improving old ones?

ARTICLE

Thinking Time

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

ARTICLE

Thinking Time

Do you get time to stop and think, without being pressured to solve a specific problem? Steve Jones ...

FORUM

Features in SQLServer 2005

Features in SQLServer 2005

Tags
editorial    
friday poll    
 
Contribute