SQL Server vNext and Discontinued Featuers

SQL Server vNext CTP2.0 (Community Technology Preview) is already released by Microsoft and we are expecting that SQL Server 2017 will be launched before September 2017.

 

Latest SQL Server stable version in market:

SQL Server 2016 (Version:13)

As per new rules since SQL Server 2016, only last two versions will remain compatible and any deprecated feature will not remain functional by only changing compatibility level.

Following are the main features which are deprecated in SQL Server 2016 and will not be available in SQL Server vNext.

Data Types:

  • text
  • ntext
  • image

Alternate: Use varchar(max), nvarchar(max), and varbinary(max) data types.

System Tables:

  • sysaltfiles
  • syscacheobjects
  • syscolumns
  • syscomments
  • sysconfigures
  • sysconstraints
  • syscurconfigs
  • sysdatabases
  • sysdepends
  • sysdevices
  • sysfilegroups
  • sysfiles
  • sysforeignkeys
  • sysfulltextcatalogs
  • sysindexes
  • sysindexkeys
  • syslockinfo
  • syslogins
  • sysmembers
  • sysmessages
  • sysobjects
  • sysoledbusers
  • sysopentapes
  • sysperfinfo
  • syspermissions
  • sysprocesses
  • sysprotects
  • sysreferences
  • sysremotelogins
  • sysservers
  • systypes
  • sysusers

 

Table hints:

Specifying table hints without using the WITH keyword. Example SELECT * FROM PMPTXFT (NOLOCK)

Alternate: Use WITH clause: SELECT * FROM PMPTXFT WITH (NOLOCK)

Textpointers:

  • WRITETEXT
  • UPDATETEXT
  • READTEXT
  • TEXTPTR()
  • TEXTVALID()

Transact-SQL

1-A string enclosed in quotation marks used as a column alias for an expression in a SELECT list:

string_alias‘ = expression

Alternate:

  • expression [AS] column_alias
  • expression [AS] [column_alias]
  • expression [AS] “column_alias”
  • expression [AS] ‘column_alias’
  • column_alias = expression

2-Not ending Transact-SQL statements with a semicolon.

Alternate: End Transact-SQL statements with a semicolon ( ; ).

 

Most important SQL Server Profiler is no more available in future. You have to learn Extended Events (EE).

Database Mirroring is also not available in next version. Use Always On.

Advertisements