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.
A new tool that can generate code is being previewed in the Visual Studio Code Insiders channel seeks to ease the tedious data preparation process that data scientists need to go through to get good data for successful analysis projects.
Decision trees are useful for relatively small datasets that have a relatively simple underlying structure, and when the trained model must be easily interpretable, explains Dr. James McCaffrey of Microsoft Research, who provides step-by-step instructions and full source code.
Microsoft has open sourced an internal incubation project that can help developers integrate cutting-edge AI models quickly and easily into their apps.
Power Platform "is reinventing software development with AI-powered no-code development."
There are a raft of minor improvements for the brand-new Visual Studio 2022 v17.6 Preview 2, with accompanying release notes revealing that the IDE is ditching the baked-in Edge Developer Tools
> More Webcasts