Install WebsitePanel on Windows
This article will guide you on steps to #install #WebsitePanel on #Windows. Also, we saw how to fix some common errors of WebsitePanel.
WebsitePanel began as #DotNetPanel, which its creators made only for the Windows web technology platform as a Windows #hosting panel. The initial DotNetPanel developers contributed a great deal to WebsitePanel. And now #Microsoft has added to their legacy by investing in WebsitePanel’s future.
WebsitePanel is a Multi-Tenant, Enterprise Hosting Automation Tool with support for Private #Cloud Servers. It enables you to centralize the management of your hosting infrastructure and share resources across multiple customer accounts.
1. Save time and money spent on system management.
2. Simplify deployment processes.
3. Administer everything from a single interface.
Auto shrink feature in SQL server
This article will guide you on how to enable and disable AutoShrink #database property. Basically, it is not recommended to enable the AutoShrink database property as it can cause many issues in the #SQL Server.
Auto Shrink is database property that allow SQL Server to automatically shrink database files if its value set to ON/True. Shrinking a database is not a good practice because it is very expensive operation in terms of I/O, CPU usage, locking and #transaction log generation.
Users can enable and disable database auto shrink option using SSMS and T-SQL both ways.
To turn on auto shrink in SQL Server:
1. Activating the database auto shrink by using #SSMS:
2. Enable database auto shrink using T-SQL:
3. Database >> #Reports >> Standard Reports >> Disk Usage.
4. Check free space for the database files:
5. Shrink database file:
Orphaned users in SQL Server
This article will help you to identify #Orphaned #Windows #Logins and Groups in #SQL Server.
To Resolve an Orphaned User:
To map an orphaned user to a login which already exists in master, execute the ALTER USER #statement in the user database, specifying the login name.
ALTER USER <user_name> WITH Login = <login_name>; When you recreate a missing login, the user can access the database using the password provided.
To fix orphaned users for all databases in SQL Server:
1. Login with same name as user exists – generate ALTER LOGIN to map the user to the login.
2. No login with same name exists – generate DROP USER to delete the orphan user.
3. Orphan user is [dbo] – change the database owner to SA (or whatever SA was renamed to).
Perfmon Counters for CPU usage
This article will guide you on how to use #Perfmon Counters for CPU #Usage and #Optimization.
Monitoring #CPU #Performance #Counters:
1. System, #Counter: Processor Queue Length. This Performance Monitor counter displays the number of threads waiting to be executed in the queue, which all the processors on your system share.
2. Processor, Counter: % Processor Time.
3. Processor, Counter: Interrupts/sec and Performance Object; Processor, Counter: % DPC Time.
Windows update error 0x80240023
This article will guide you on steps to fix #Windows #update #error #0x80240023 which usually triggers while updating the Windows #system.
When you encounter an error #message, reboot your #machine and try to run the updates again. If you haven't run Windows #Update for some time, then you might have to repeat this process several times before all updates have been installed.
To fix errors on Windows 10:
1. Make sure that your #device has enough space.
2. Run Windows Update a few times.
3. Check third-party #drivers and download any updates.
4. Unplug extra #hardware.
5. Check Device #Manager for errors.
6. Remove third-party security #software.
7. Repair hard-drive errors.
8. Do a clean restart into Windows.
Nginx multiple domains SSL Certificates
This article will guide you on steps to resolve common issues with "Nginx multiple domains #SSL". Basically, the multi-domain SSL #certificate offers security for multiple websites.
The technique for hosting more than one domain/subdomain on a single IP address/host is called #virtual #hosts. The http get request contains the domain name that the requests is for which allows the web server to match up the request with a particular virtual domain.
You can host multiple websites on #Nginx:
1. Configure Nginx to Host Multiple Websites.
2. Create Directory Structure.
3. Create Virtual Configuration.
4. Test Your #Websites.
5. Adding PHP-FPM Support to Nginx.
