Get SQL Server Configuration using T-SQL
As a SQL architect or Database administrator, it is required to know how to get SQL Server configuration using T-SQL....
Month: January 2026
153 articles
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database. To understand the...
Troubleshoot “Database might contain bulk-logged changes that have not been backed up” in SQL Server
Solution: Once we create a new SQL Database in full recovery mode and have not taken a full backup, the...
T-SQL Query to find Orphan data and log files of SQL Databases
This query will find your server’s orphan data and log files of SQL Databases. It helps monitor your SQL database...
Restore database in SQL Server Always On Availability Group
In this blog, we will look at how to restore a database participating in SQL Server Always On Availability Group...
Install SQL Server 2022 on Ubuntu in 5 minutes
Having trouble installing SQL Server 2022 on Ubuntu? Follow our 5-minute guide and get SQL Server up and running on...
SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information
Today’s post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The...
How to modify SQL Server Analysis Services Modes
SQL Server Analysis Services can be installed in one of three modes. Tabular Multidimensional SharePoint How to check the current...
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. You...
SQL Server 2022 STRING_SPLIT Function
SQL Server 2022 STRING_SPLIT Function – This function allows you to split a string by a delimiter and return a...