by ray | Nov 7, 2020 | Microsoft SQL
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...
by ray | Nov 7, 2020 | Microsoft SQL
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...
by ray | Oct 22, 2020 | Microsoft Windows
Set the following options in File Explorer options:
by ray | Oct 22, 2020 | Microsoft Windows
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...
by ray | Oct 19, 2020 | Microsoft, Microsoft Windows
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...
