Callum 
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...
Understand SQL WHILE loop with examples
This tutorial will explain what a while loop is in SQL. It will also explain...
How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an...
Script SQL Database Permissions for database refresh
Do you restore SQL databases across SQL instances? The Database administrators get frequent requests to...
T-SQL script to Measure Transactions Per Seconds in SQL Server
Learn how to measure transactions per second in SQL Server with this quick and easy...
Locks with SQL Server UPDATE STATISTICS WITH FULLSCAN
SQL Server UPDATE STATISTICS WITH FULLSCAN is a process that is used to update statistics...
T-SQL script to Backup database SQL Server with TimeStamp
The T-SQL script takes a full backup of all databases(System databases and user databases) in...
Get a list of installed SQL Server Components with SQL Server Discovery Tool
Usually, DBA needs to check the SQL Server and find out the answer to the...
Install SQL Server 2022 on Windows
Microsoft announced a private preview of SQL Server 2022 last fall at ignite. SQL Server...