DBblogger | Rajendra Gupta

Jan 14, 20221 min read

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

678 views0 comments

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

77 views0 comments

Jan 13, 20221 min read

Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server

442 views0 comments

Jan 13, 20221 min read

T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)

3,993 views2 comments

Jan 13, 20221 min read

SQL Database Error - BACKUP LOG cannot be performed because there is no current database backup

60 views0 comments

Jan 12, 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.

508 views0 comments

Jan 11, 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.

2,700 views0 comments

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.

1,001 views0 comments

Jan 11, 20221 min read

Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database

33 views0 comments

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

1,668 views0 comments