Author
.NET MAUI
.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 http://sqlperformance.com/2013/03/io-subsystem/chunk-deletes 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
Event name should have at least 3 parts separated by slash
Error: Error in Visual Studio when trying to publish project. Event name should have at least 3 parts separated by slash Fix: This specific error happens when you are not logged in to the Azure account in VS (the account that contains the Function app). To work-around this issue: You can go to File ->... » 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
Keyboard Shortcut to Open File Explorer to Specific Location
Create a macro and open the following application… C:\Windows\explorer.exe and set the parameter to the folder location C:\\folder01 Sources:
Add Default Constraint for Table Column
For Existing Table For New Table Definition