sql server 2012_denali_for_developers
DESCRIPTION
Denali CTP release for developers. The SQL Server vNextTRANSCRIPT
![Page 1: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/1.jpg)
SQL Server 2012 (Denali)
for Developers
Amit Bansal
www.twitter.com/A_Bansal
www.SQLServerGeeks.com
www.amitbansal.net
![Page 2: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/2.jpg)
Agenda
SSMS Enhancements
What’s new in T-SQL
Juneau (SQL Server Data Tools)
![Page 3: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/3.jpg)
SSMS Enhancements
IntelliSense
Code Snippets
Surround With
TSQL Debugging
![Page 4: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/4.jpg)
Demo
![Page 5: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/5.jpg)
What’s new in T-SQL
SEQUENCE object ◦ Code snippet 1:
http://www.sqlservergeeks.com/blogs/AmitBansal/sql-
server-bi/349/sql-server-2012-denali-series-sequence-
object-%E2%80%93-part-2
◦ Code Snippet 2:
http://www.sqlservergeeks.com/blogs/AmitBansal/sql-
server-bi/346/sql-server-2012-denali-series-sequence-
object
THROW statement
![Page 6: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/6.jpg)
Demo
![Page 7: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/7.jpg)
SQL Server Data Tools (Juneau)
![Page 8: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/8.jpg)
Demo
![Page 9: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/9.jpg)
Q & A
![Page 10: Sql server 2012_denali_for_developers](https://reader038.vdocuments.us/reader038/viewer/2022100600/554ebd05b4c905de468b4888/html5/thumbnails/10.jpg)
Thanks.