With the release of security update KB5058722 (SQL Server 2019 CU32) on July 8, 2025, some administrators and developers reported encountering the error “object not found” when accessing objects outside the default dbo schema. This post explains the root cause of this issue, why it occurs after the update, and how to address it.
Posts for: #Sqlserver
ORM vs. Raw SQL: A Performance Showdown
In the realm of data access, the choice between Object-Relational Mappers (ORMs) like Entity Framework (EF) Core and direct SQL approaches like Dapper can significantly impact application performance. This post delves into the nuances of each and explore a comparative analysis using .NET code examples.
Recover deleted .net EF Core Migration History Table
Working with Microsoft EF Core you might need to recover the records on the entity framework migration history table. Here’s an easy way to do it.
Better Powershell SQL comand exection using Dbatools
Recently I chose to develop a quick batch solution, for working with SQL Server databases, using Powershell and the Invoke-SqlCmd cmdlet. I was faced with unexpected errors. After quick workaround on the code, I was able to get things done. However, recently I got to redo the batch resulting on a more performant solution. The key to this was the Invoke-DbaQuery Cmdlet.
Powershell Error on Invoke-Sqlcmd? Ditch the pipe operator.
As you might have read, I’m a fan of GTD. Having to develop a quick batch solution for some data copying between different SQL Server databases, I chose to use Powershell scripting and the Invoke-SqlCmd cmdlet. However I was faced with unexpected errors for something as trivial as an export/import job.