Callum 
Get SQL Server Configuration using T-SQL
As a SQL architect or Database administrator, it is required to know how to get...
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up...
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...
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...
Restore database in SQL Server Always On Availability Group
In this blog, we will look at how to restore a database participating in SQL...
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...
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...
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 configure a static port for SQL Server?
One of the first things to do for securing your SQL Server is to change...
SQL Server 2022 STRING_SPLIT Function
SQL Server 2022 STRING_SPLIT Function – This function allows you to split a string by...