This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.
2026-07-13
2,545 reads
A short introduction to how deadlocks work and how you can affect their behavior inside your system.
2026-07-13 (first published: 2026-05-01)
2,781 reads
This article examines three recurring database-layer failures documented in the EDPB’s 2026 enforcement findings: the complexity of executing erasure across relational schemas, the backup paradox that can silently undo compliant deletions, and the audit log contradiction that traps organizations between two competing obligations.
2026-07-13
When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.
2026-07-10
2,345 reads
We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Availability Mode for the secondary replica. This article explains how to troubleshoot and resolve:
2026-07-10
Learn about a few new features built into SQL Server 2022 that can help improve performance on your workload.
2026-07-08
2,705 reads
Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint
2026-07-08
Learn how to add the geometric mean in Power BI to your calculations.
2026-07-06
1,030 reads
In a previous tip on Orphaned User Detection for SQL Server High Availability Databases, we have seen how to identify when there are orphaned database users in an Availability Group database. Is there a way where we no longer need to worry about missing database users or different SID values between primary and secondary databases in an Availability Group?
2026-07-06
Learn how to get started with an MCP server that can query your SQL Server database.
2026-07-03
2,670 reads
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
NO AI was used to generate this content. Grammarly was used to check and...
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Hi, We are looking out to read parquet file directly from on premise shared...
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Comments posted to this topic are about the item Forward Deployed Engineers
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers