Callum 
SQL Server Extended Events to track PAGE SPLITS in SQL Database
What is the extended event to track page split?SQL Server page split occurs when the...
Display dates between two input dates using SQL DATEDIFF function in SQL Server
This blog includes a simple script to display dates between two input dates from table...
Use Memory Optimization for Faster temp table performance
Read this article to learn how to optimize your SQL code by using memory-optimized tables...
Contained Availability Group SQL Server 2022
SQL Server 2022 is the latest version of SQL Server and the first version to...
Generate and Decode QR Codes with Python
This post discusses how to use Python to generate and decode QR Codes. Learn how...
SQL Server agent jobs without notification using T-SQL
This article will describe how to get a list of SQL Server agent jobs without...
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.’ for...
Utilizing Conditional Logic with `sp_MSforeachtable`
The `sp_MSforeachtable` and sp_MSforeachDB stored procedures in SQL Server are undocumented stored procedures for performing...
T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password
Learn how to change the Master Key encryption password for an SQL Server Integration Services...
PowerShell Script to configure SQL Server static Port
The article How to configure a static port for SQL Server? Explains the process of...