How do I truncate a log file in SQL Server?

Shrinking a log file to a specified target size SQL Dev servers typically use “Simple” for the Recovery Mode while SQL Prod servers use “Full.” The SQL query below assumes that you are temporarily switching from Full Recovery Mode to Simple and then back to Full. The following example shrinks the log file in the AdventureWorks database … Read more

How To Clone a Hard Drive In Windows 10

You might be replacing a broken drive or thinking about upgrading to a faster solid state drive. Whatever you’re planning, it can often be an inconvenience when you’re switching from one hard drive to another, especially if it’s the drive that contains your operating system or important documents and media files. Rather than slowly and manually copying across … Read more

GitHub Error: Authentication Failed from the Command Line

After setting up 2 Factor Authentication on GitHub, I couldn’t push my remote repositories from the command line anymore. When I tried to push a remote repo, the command line threw this error: ~ :> git push origin my-branchUsername for ‘’: myusernamePassword for ‘https://[email protected]’: mypasswordremote: Invalid username or password.fatal: Authentication failed for ‘’ The error … Read more

How to install Sublime Text editor on Ubuntu 20.04

How to install Sublime Text editor on Ubuntu 20.04 step by step instructions Method 1 The first, easiest and recommend method is to install sublime text editor from Ubuntu snap repository. Execute the bellow command to install the Sublime text editor on your Ubuntu 20.04 system: $ sudo snap install sublime-text –classic To upgrade Sublime text editor … Read more