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

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

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

This article explores the process modify SQL Server Analysis Services Modes between Tabular, Multidimensional and SharePoint.

Learn how to use PowerShell to restart a SQL service. Learn how to use PowerShell to restart an instance of 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.

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

Read the article to use a PowerShell Script for configuring SQL Server static Port

Download a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete

If you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at

How to take SQL SERVER backup to Azure Blob Storage. This is a guide for SQL Server DBA to store SQL SERVER backup in Azure.

A friend recently asked me how to change the authentication mode of SQL instances. This blog gives steps to change SQL Server authentication

Script SQL Database Permissions for database refresh

Have you seen any SQL code that uses WHERE 1=1? Why do we use that statement? Let's understand In this article.

I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?

In SQL Server Always On Availability Group environment endpoint connection issue is a common problem and it needs to be resolved by...

Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.

It is a standard SQL interview question where the interviewer asks to write a query that finds Nth highest salary from the employee table. H

Do you want to modify the default Select Top 1000 Rows and Edit Top 200 Rows configuration in SQL Server Management Studio? Read more

This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.