Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

T-SQL received a lot of improvements in SQL Server 2012 including support for the ANSI FIRST_VALUE and LAST_VALUE functions, declarative data paging using FETCH and OFFSET, and .NET’s parsing ...

mcp_ohmy_sql is an open-source Text-to-SQL system developed for deployment in enterprise production. It is not about specific features as much as about integration, scale and reliability: It supports ...

While ledger is a game-changer for security, SQL Server 2022 also introduced new functionality around Dynamic Data Masking (DDM), T-SQL enhancements and more.

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

Microsoft's continued focus on SQL Server 2025 highlights the lasting demand for on-premises and hybrid deployments that prioritize performance, control and flexibility for enterprise workloads.

How to Create Full Database Backup Using T-SQL If you want to automate the backup, you can use the T-SQL code. T-SQL is the SQL Server language used to automate SQL Server tasks. The following example ...

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.

SQL Server 2025 preview debuts with Ubuntu 24.04 support and TLS 1.3 encryption for stronger security and Linux flexibility.