You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.