LL – Laxmi Lal Menaria Blog!

Category: Security

  • How to restart remote server / machine using Remote Desktop, Powershell or Command Prompt?

    To restart a remote Windows desktop / laptop or server, there are several methods, which includes remote desktop (RDP), Windows PowerShell, or Command Prompt.Here are some common methods to restart a remote windows machine: Method 1: By using Remote Desktop (RDP) If you have Remote Desktop access to the server, you can use this method…

  • How to update the Max Memory at SQL Server?

    From the command prompt start sqlCmd using the Dedicated Administrator Connection (DAC). : net start MSSQLServer /mSQLCMD /f C:>sqlcmd -S ServerName -U sa -P –A Once you are connected, execute the following to set the memory to 4 GB, it should be enough to allow you to reconnect using the Management Studio tool. sp_configure ‘show…

  • How to use CLR function at SQL Server?

    Creating a CLR function in SQL Server involves the following steps: 1. Define the function as a static method of a class in a language supported by the .NET Framework 2. Register the assembly in SQL Server by using the CREATE ASSEMBLY statement 3. Create the function that references the registered assembly by using the…

  • How to enable “Windows Authentication” for your websites?

    There are few things which we need to do before access the website using windows authentication. Web.config: Add or replace existing Authentication Tag IIS Express with Visual Studio: Click on your project in the Solution Explorer to select the project. Open Properties pane suing F4. In the Properties pane for your project: a) Set “Anonymous…

  • RDP- Automatically sign out of disconnected users?

    Open the ‘Group Policy Editor’ for your server. Navigate to: Local Computer Policy / Computer Configuration / Administrative Templates / Windows Components / Remote Desktop Services / Remote Desktop Session Host / Session Time Limits. Find the key ‘Set time limit for disconnected sessions’ Enable and set the Time Limit at dropdown, what ever you…

  • To turn on BitLocker Encryption in Windows 10/11.

    You must be login using Administrator Account. Click Start button, and then under Windows System, select Control Panel. In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Select Turn on BitLocker and then follow the instructions. Make Sure you Save the Key.

  • Cannot load Counter Name data because an invalid index ” was read from the registry

    Cannot load Counter Name data because an invalid index ” was read from the registry When we are trying to read system performance counters, some time we will get this type of error on machines. “Cannot load Counter Name data because an invalid index ” was read from the registry” To fix the issue: Click…

  • Search in MSSQL tables

    Sometime we need to reverse engineering in the database tables to find a specific values, we can find the column name easily but in large database, to search a specific key value is too hard. From below query we can easily search value in all tables, it will list column with table in the result.…

  • SQL SERVER – Installation Failure Database engine services failed.

    Sometimes when we install SQL Server or Add any new SQL Server Instance on Windows Machine, we can see the database errors listed below. To resolve these errors we are trying to repair existing installation or do something else. If nothing happens then we are trying to install it completely from control panel, but it…

  • Fix: SQL Server Management Studio 18.0 won’t open – only splash screen

    Replace the “Microsoft.VisualStudio.Shell.Interop.8.0.dll” in “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies” with the copy from “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PrivateAssemblies\Interop” and then try. It should work.