LL – Laxmi Lal Menaria Blog!

Category: Windows Application

  • How to restart remote server using Powershell?

    Some time we need to restart the remote machine or server, i.e. not able to connect through RDP. To restart we need full name of system, if not then we need to call then #1 to do that. If you already knows the name, then you can directly use #2, 1 [system.net.dns]::gethostentry(‘192.168.1.123’) 2 Restart-Computer -ComputerName…

  • How to list SQL Jobs using Query?

  • 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…

  • 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…

  • How to read DBF to Datatable

    [csharp] OleDbConnection oConn = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp;Extended Properties=dBase III”); OleDbCommand command = new OleDbCommand(“SELECT * FROM Test.DBF”, oConn); oConn.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); oConn.Close(); [/csharp]

  • 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.

  • Missing Windows Authentication Feature IIS and Windows 10

    If you have windows 10 Home or SL version when might be you are unable to see Windows Authentication under IIS options when installing. To enable “Windows Authentication” either you need to upgrade the OS to Pro version or you can run this command to enable it. C:\WINDOWS\system32>dism /online /norestart /add-package:%SystemRoot%\servicing\Packages\Microsoft-Windows-IIS-WebServer-AddOn-2-Package~31bf3856ad364e35~amd64~~10.0.17134.1.mum The file name will…

  • How to Create Multiple SQL Server Instances on Same Server

    When you install SQL Server, the installation creates an instance (DEFAULT OR SQLEXPRESS) of SQL Server. In my case I have created instanace named DEVSQL. Some times we do need to create multiple instances based on requirements. To create more instances, start the setup again. The following screen appears when setup starts for the SQL…