To use SQL triggers, procedures, and functions effectively, you should follow some best practices. For example, use descriptive and consistent names for your triggers, procedures, and functions.

This function supports the export of huge result sets by writing the contents of each CSV file in multiple batches. Both functions require the following parameters: ServerName: The SQL Server instance ...

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

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

By Design: Output bindings against tables with columns of data types NTEXT, TEXT, or IMAGE are not supported and data upserts will fail. These types will be removed in a future version of SQL Server ...

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