.NET Multi-platform App UI (.NET MAUI) is a cross-platform framework for creating native mobile and desktop apps with C# and XAML. .NET MAUI Essentials arrives this fall 2021. Alongside more details of MAUI, Microsoft says it will end updates to the Xamarin mobile app development platform in November 2022. Xamarin has been the Microsoft technology... » read more

Copy Files Between Two Computers

When copying files between two computer on the network, you can either 1) remote desktop on to the computer and copy there or 2) on your local computer, open up folder with the following location… \\Server01\D$\Folder01 Option #2 coping files from your local computer will be faster.

How to delete large data of table in SQL without running out of log space

Change your database’s Recovery Mode to SIMPLE¬†and then delete rows in smaller batches using a while loop something like this: Keep in mind that logs could grow a lot if you don’t commit the transaction after each chunk and perform a checkpoint. This is how I would do it and take this article¬†as reference,... » read more

Long running open transactions in a SQL Server database

Query to return long running transactions and cumulative CPU time in MS for open transactions in a SQL Server Database A long running transaction keeps the transaction log active from the virtual log file containing the first log record of the transaction. Truncation cannot occur from that virtual log file onward. It may leads to... » read more

Deleting Large Number of Records from a Database Table

Things to remember when deleting a large number of records from a database table. Consider using TRUNCATE instead of DELETE if truncating the table (removing all records from the table) is ok. Remove records in batches. Make sure there is enough space for the log files. If database is simple, truncate log after every run.... » read more