How do I change the password of a user in SQL Server?
The following example changes the password of login Mary5 to a strong password.
Tech Tips Made Easy
The following example changes the password of login Mary5 to a strong password.
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
When trying to map a database [go to Security > Logins > username > Properties > User Mapping > Select Database > set as db_owner and then okay, I keep on getting the following error message: User, group, or role ‘someuser’ already exists in the current database. (Microsoft SQL Server, Error: 15023) What is causing … Read more
Set the following options in File Explorer options:
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
See source link with photos. On one of the servers running Windows Server 2016, an additional disk (not a system one) connected as a SAN LUN over FC gets offline after each restart of the server. If you open Disk Management console (diskmgmt.msc), you can see that this disk is in Offline state. To make the disk … Read more
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 ‘https://github.com’: myusernamePassword for ‘https://[email protected]’: mypasswordremote: Invalid username or password.fatal: Authentication failed for ‘https://github.com/my-repository’ The error … Read more
In /etc/pihole/setupVars.conf you should have 2 settings: As soon as there are valid IP addresses entered, they will show up on Admin/Settings/System
When I initially set up my Pi-Hole, I only had IPv4 on my system. Thus Pi-Hole only downloaded IPv4-capable blacklists. So I turned IPv6 on on my home router, and enabled DHCPv6.I turned IPv6 on on my Pi-Hole computer, and rebooted. ip -o addr then showed that I had an IPv6 address. Actually, it has … Read more
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