rajendra guptaJan 101 minHow to configure a static port for SQL Server?One of the first things to do for securing your SQL Server is to change its default TCP port. Read more to configure it.
rajendra guptaJan 61 minSQL Server Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’ In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...
rajendra guptaJan 61 minScript SQL Database Permissions for database refreshScript SQL Database Permissions for database refresh
rajendra guptaJan 51 minGet a list of installed SQL Server Components with SQL Server Discovery ToolGet a list of installed SQL Server Components with SQL Server Discovery Tool
rajendra guptaJan 51 minT-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL ServerThis article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
rajendra guptaJan 52 minDynamic SQL to move SQL Server TempDB Data and Log Files to different directoriesDynamic SQL to move SQL Server TempDB Data and Log Files to different directories
rajendra guptaJan 42 minDisable and Enable SQL Server IndexesThis article explains how to disable an Index in SQL Server.
rajendra guptaJan 43 minmove SQL Server TempDB database files to a different directory using Dynamic SQLThis article will explain the steps to change the SQL Server Tempdb database data and log file physical location.
rajendra guptaJan 41 minSteps to change the default SQL Server backup directoryThis article provides steps to change the default SQL Server backup directory.
rajendra guptaJan 42 minLearn SQL SELECT TOP statement This SQL tutorial will understand how to use the SQL SELECT TOP queries using various examples.
rajendra guptaJan 32 minHow to stop logging successful backup messages in SQL Server error logsThis article guides you to stop logging successful backup messages in SQL Server Error Logs.
rajendra guptaDec 30, 20211 minT-SQL script to find out SQL Server Logs directoryT-SQL script to find out SQL Server Logs directory
rajendra guptaDec 29, 20211 minT-SQL script to Recycle SQL Server error logs manuallyT-SQL script to Recycle SQL Server error logs manually
rajendra guptaDec 29, 20211 minConfigure the Minimum and Maximum memory for SQL Server InstanceConfigure the Minimum and Maximum memory for SQL Server Database instance
rajendra guptaDec 29, 20211 minIncrease or Decrease the number of error log files and their size in SQL ServerIncrease the number of error log files and their size in SQL Server
rajendra guptaDec 25, 20211 minQuery To Kill All Active Connections in Azure SQL DatabaseQuery To Kill All Active Connections in Azure SQL Database
rajendra guptaDec 16, 20211 minApprox_Count_Distinct in SQL Server 2019 and Azure SQL DatabaseApprox_Count_Distinct in SQL Server 2019 and Azure SQL Database