In-Depth

Discover New T-SQL Enhancements

T-SQL isn't dead yet. See how the new enhancements in T-SQL can make you more efficient.

Watch the video of the session! Running time: (1 hour, 5 minutes, Windows Media format)

By now you've heard that you can write stored procedures in C# and VB.NET for SQL Server 2005. But that doesn't mean T-SQL is dead. A lot has changed in the world of T-SQL with the next version of SQL Server. See how efficient you can become with the new T-SQL enhancements. You can crosstab in seconds with the PIVOT statement, perform recursive queries much more easily with Common Table Expressions, manipulate XML data more easily with the XML data type, and aggregate with ease using the new TOP functions. Stephen Forte looks at the new T-SQL enhancements, data types, and the like. He'll also look at how to choose between CLR Stored Procedures and T-SQL.

comments powered by Disqus

Featured

  • .NET Core Ranks High Among Frameworks in New Dev Survey

    .NET Core placed high in a web-dominated ranking of development frameworks published by CodinGame, which provides a tech hiring platform.

  • Here's a One-Stop Shop for .NET 5 Improvements

    Culled from reams of Microsoft documentation, here's a high-level summary of what's new for performance, networking, diagnostics and more, along with links to the nitty-gritty details for those wanting to dig in more.

  • Azure SQL Database Ranked Among Top 3 Databases of 2020

    Microsoft touted the inclusion of Azure SQL Database among the top three databases of 2020 in a popularity ranking by DB-Engines, which collects and manages information about database management systems, updating its lists monthly.

  • Time Tracker Says VS Code Is No. 1 Editor for Devs, Some Working 15+ Hours Per Day

    WakaTime, which does time tracking for programmers, released data for 2020 showing that Visual Studio Code is by far the top editor/IDE used by its coders, some of whom are hacking away for more than 15 hours per day.

Upcoming Events