Learn how to use SQL triggers, procedures, and functions to automate or enhance database operations with SQL syntax and logic examples.

Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV files compliant with the RFC ...

To encrypt and decrypt a string we have a predefined functions in sql server 2008 that are easy to use. suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...

Introduction This repository contains the Azure SQL bindings for Azure Functions extension code as well as a quick start tutorial and samples illustrating how to use the binding in different ways. The ...

Examine the optimal data migration strategy in light of the SQL Server system’s capacity to withstand overhead and outages. Use the most efficient method measured in terms of downtime to migrate the ...

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.

The newest update for PowerApps (version 680) can delegate the Sum, Average, Min, and Max functions to SQL Server. We provide an example of summing a million records in a few seconds and show how it ...

After my post about Encrypting Rich Text fields in Power Apps that store their data in SQL server now the promised decryption code in this post as well.