Available posts for the Category: Technology
How to implement audit trail using triggers in SQL
By Database AdminA custom approach to store audit trail using Triggers and JSON format in SQL Server database.
T-SQL Tips and Tricks: Copying Stored Procedure or Function from one database to multiple target databases
By Database AdminA script to copy stored procedure or function from one DB to another DB or to multiple target databases
How to migrate Mobile Apps From Xamarin and Xamarin Forms to .Net MAUI
By Greg Kabacinski & Rutul MehtaThis article explains how to migrate the mobile apps developed using Xamarin Forms to use .Net MAUI - a newer framework by Microsoft
T-SQL Tips and Tricks: Efficiently Querying Audit Entries created by Entity Framework in MS SQL
By Database AdminAn easy way to query audit entries created by Entity Framework. This can be used by Microsoft .Net Developers in reports and UI to display history of changes to certain tables by users.
T-SQL Tips and Tricks: Copying Views from one database to multiple target databases
By Database AdminA script to copy T-SQL view from one MS SQL database to another or multiple target databases
T-SQL Tips and Tricks: Executing a Query in multiple databases
By Database AdminA script to Execute T-SQL Queries in multiple databases