SQL Server

Still More SQL Server Features that Time Forgot

  • Article

As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.

2017-12-20

3,745 reads

Even More SQL Server Features that Time Forgot

  • Article

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.

2017-12-01

5,018 reads

Blogs

Better Productivity: Cycling the Windows Clipboard in Windows 10

By

A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V...

Daily Coping 21 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

sql server 2016 performance tuning

By rohitkocharda

I have opportunity to tune below monster query. Is there anything right off the...

How Many Distinct Records

By Sergiy

Comments posted to this topic are about the item How Many Distinct Records

Dear Past Me on My First Day as a DBA

By Pam Mooney

Comments posted to this topic are about the item Dear Past Me on My...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers