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

  • VS Code v1.99 Is All About Copilot Chat AI, Including Agent Mode

    Agent Mode provides an autonomous editing experience where Copilot plans and executes tasks to fulfill requests. It determines relevant files, applies code changes, suggests terminal commands, and iterates to resolve issues, all while keeping users in control to review and confirm actions.

  • Windows Community Toolkit v8.2 Adds Native AOT Support

    Microsoft shipped Windows Community Toolkit v8.2, an incremental update to the open-source collection of helper functions and other resources designed to simplify the development of Windows applications. The main new feature is support for native ahead-of-time (AOT) compilation.

  • New 'Visual Studio Hub' 1-Stop-Shop for GitHub Copilot Resources, More

    Unsurprisingly, GitHub Copilot resources are front-and-center in Microsoft's new Visual Studio Hub, a one-stop-shop for all things concerning your favorite IDE.

  • Mastering Blazor Authentication and Authorization

    At the Visual Studio Live! @ Microsoft HQ developer conference set for August, Rockford Lhotka will explain the ins and outs of authentication across Blazor Server, WebAssembly, and .NET MAUI Hybrid apps, and show how to use identity and claims to customize application behavior through fine-grained authorization.

  • Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard simple techniques, and so evolutionary optimization training is used.

Most   Popular

Subscribe on YouTube