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

In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

JSON support consists of keywords and functions you can incorporate into your queries. Unlike the XML support in SQL Server, JSON support does not include a JSON data type -- you just store JSON ...

From Python to adaptive query optimization to the many cloud-focused changes (not to mention Linux!), Joey D'Antoni takes you through the major changes coming to SQL Server 2017.

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 ...

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is ...

News Host Integration Server 2000: New Name, New Functions By Scott Bekker 09/25/2000 Host Integration Server 2000 is Microsoft Corp.’s new SNA gateway for the end-user to Internet, intranet or client ...