1 / 9

What’s New In Denali - TSQL

What’s New In Denali - TSQL. David Ballantyne. Who am I ?. Dave@clearskysql.co.uk @ davebally www.sqlblogcasts.com/blogs/sqlandthelike Kent .Net / SqlServer User Group Founder Next meeting 3 rd October for SqlRelay # KentNetSqlUserGroup. Overview. Deprecation What have we lost ?

toan
Download Presentation

What’s New In Denali - TSQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s New In Denali - TSQL David Ballantyne

  2. Who am I ? Dave@clearskysql.co.uk @davebally www.sqlblogcasts.com/blogs/sqlandthelike Kent .Net/SqlServer User Group Founder • Next meeting 3rd October for SqlRelay • #KentNetSqlUserGroup

  3. Overview • Deprecation • What have we lost ? • What is going to break? • CTP 1 • Sequencing • Paging • Throw • CTP 3 • OVER Clause Enhancements – Windowing • Analytic functions (LAG, LEAD , FIRST_VALUE and LAST_VALUE) • Formatting / Parsing functions

  4. Deprecation ? • “deprecation is a status applied to software features to indicate that they should be avoided, typically because they have been superseded” • Removed from next version • Removed from a future version • BOL Reference • “SQL Server Database Engine Backward Compatibility” • http://msdn.microsoft.com/en-us/library/ms143532(v=SQL.110).aspx

  5. Whats going to break ? • *= and =* Removed • XML Endpoints (SOAP) Removed • New keywords • NEXT • WITHIN • FASTFIRSTROW Removed

  6. Compatibility Issues • Soundex changes • Lloyd and Scott • Any stored value can be wrong • Row count message for failed DML statements • Sent to client side • Used to be -1 incorrectly, now will be Zero

  7. For future • Next Release • Result sets from triggers • SET ROWCOUNT with DML • Unspecified • Column alias with = and quotes , ' string_alias' = expression • Not ending TSQL statements with ; • SQL Profiler - Use extended events • SET ANSI options ( defined as on ) • SET FMTONLY ON – Replaced with metadata discovery

  8. On with the Code • Demo • Demo • Demo…….

  9. Anything else ? • FileTables • Links File system folders and SqlServer tables • Full text search enhancements • Search documents for properties (Title / Author) • Customizable NEAR, number of terms between search terms • Semantic search • Extract key phrases to match similar meaning documents

More Related