How do I truncate a log file in SQL Server?

Shrinking a log file to a specified target size The following example shrinks the log file in the AdventureWorks database to 1 MB. To allow the DBCC SHRINKFILE command to shrink the file, the file is first truncated by setting the database recovery model to SIMPLE.SQLCopy

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 ‘’: 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