top of page


How to install PowerShell SQLServer module in a specific directory
Troubleshoot error - Install-Module: Administrator rights are required to install modules in 'C:\Program Files\WindowsPowerShell\Modules.'
rajendra gupta
Jan 14, 20221 min read


Troubleshoot PowerShell-No match was found for the specified search criteria,module FailoverClusters
Troubleshoot PowerShell-No match was found for the specified search criteria, module FailoverClusters
rajendra gupta
Jan 14, 20221 min read


Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
rajendra gupta
Jan 13, 20221 min read


T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
rajendra gupta
Jan 13, 20221 min read


SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup
rajendra gupta
Jan 13, 20221 min read


How to modify SQL Server Analysis Services Modes
This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.
rajendra gupta
Jan 12, 20221 min read


PowerShell Script to restart SQL Services
Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of SQL Server.
rajendra gupta
Jan 11, 20221 min read


How 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 gupta
Jan 11, 20221 min read


Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
rajendra gupta
Jan 11, 20221 min read


PowerShell Script to configure SQL Server static Port
Read the article to use a PowerShell Script for configuring SQL Server static Port
rajendra gupta
Jan 11, 20221 min read
bottom of page





