Like most databases created in the last few decades, SQL Server allows developers to extend the database by creating functions. But prior to the upcoming 2019 release, SQL Server’s support for ...

Here's a collection of such nuggets for developing SQL Server applications. 1) Replace COUNT(*) With EXISTS When Checking for Existence Developers often use the value from the COUNT(*) function when ...

This restricts which users can view what data in a table, based on a function. SQL Server 2016 introduces this feature, which is very useful in multi-tenant environments where you may want to ...