Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...

UNSAFE code isn't restricted in any way, including using unmanaged code. Using UNSAFE could compromise SQL Server, so only users who are members of the sql_admins role can even permit UNSAFE ...

Figure 1: SQL Server Yukon Project in Visual Studio.NET To address these fears, a great deal of work has occurred to ensure that the database engine can maintain tight control over managed code ...

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.

This article introduces the SQL Server Data Tools (SSDT) feature of Visual Studio 2013. This feature is used to manage databases using a source code first methodology.

If you ever need to sort character strings stored in SQL Server fields, check out this demonstration of how to write a common sorting algorithm using SQL Server TSQL code.