This isn’t a good month for IT admins to take time off if they want to get ahead of all the patches Microsoft pushed out this week.

If when installing SolidWorks, Microsoft SQL Server fails to install, first change block sizes and the instance name and see. More solutions here.

If you want to install File Server Resource Manager (FSRM) on Windows Server and configure it, follow the steps mentioned here in this guide.

You’ll need to reconfigure your SQL server to utilize more memory resources from your system by adjusting the maximum Server Memory option in SQL Server Configuration Manager.

Now open SQL Server Configuration Manager and click Yes (if UAC prompt received). Then, expand SQL Server Network Configuration and select Protocols for (the server/database name) in the left pane.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Click on SQL Server Configuration Manager and choose Yes on the UAC prompt. Expand SQL Server Network Configuration and select Protocols for (the server/database name).