Welcome to the third part of our SQL Server 2025 AlwaysOn Lab series. In the first two parts, we configured the Active Directory and set up a Windows […]
Setting Up SQL Server 2025 AlwaysOn Lab – Part 2: Configuring SQL Nodes & Cluster
In the previous part of this lab series, we set up the Active Directory, which forms the backbone for everything that follows. If you haven’t gone through that […]
Getting Started with SQL Server 2025: Step-by-Step AlwaysOn Configuration and Lab Setup
If you’re eager to get ahead with Microsoft SQL Server 2025, this video tutorial is your perfect starting point. Even though SQL Server 2025 hasn’t officially launched yet, […]
The certificate received from the remote server was issued by an untrusted certificate authority
Recently there has been a rise in number of error messages regarding certificates in Microsoft SQL Server Management Studio (SSMS). This is because of the breaking change that has […]
![Warning: SQL71562: Procedure: [dbo].[Someproc] has an unresolved reference to object [Targetdb].[dbo].[TargetDb].](https://www.jayanthkurup.com/wp-content/uploads/2024/06/Visual-Studio-circular.webp)
Warning: SQL71562: Procedure: [dbo].[Someproc] has an unresolved reference to object [Targetdb].[dbo].[TargetDb].
Recently I came across an issue I have faced multiple time before but unlike previous times I was not able to fix the issue., the problem was that […]
Should you monitor Logical Reads
The argument that reducing logical reads isn’t crucial because they occur in memory and are fast compared to physical reads is indeed valid on the surface. However, it’s […]
How to Setup and Configure Query Store in MS SQL Server
Query Store is a powerful feature in Microsoft SQL Server that serves as a performance monitoring and troubleshooting tool. It essentially acts as a database-wide flight data recorder, […]
ADR new features in SQL 2022 – multithreaded version store
Accelerated database recovery is one of those features that was introduced in SQL 2019 and you have probably been enjoying its benefits without ever knowing how much it […]
administration / Azure / Database / MSSQL
How to modify a bacpac file – Moving databases from Azure SQL to SQL VM
When working with Azure SQL databases one of the challenges is how difficult it is to move data across environments. Say for example we have a production database […]
Modifying a bacpac file
When working with Azure SQL databases one of the biggest irritants is the lack of access to backup files. A lot of the time we need to refresh […]