Skip to content

When Nothing Is True – Everything Is Permitted

  • Life

There is a growing anxiety in the digital age that goes beyond partisanship, beyond specific leaders, beyond even artificial intelligence itself. It is the fear that we are entering an era in which truth is no longer socially enforceable.

If every video can be fabricated, every voice cloned, every image synthesized – then every piece of real evidence can be dismissed as fake.

And if real evidence can be dismissed at will, then accountability erodes.

This is no longer science fiction. It is a structural vulnerability in our emerging information ecosystem.

Read More »When Nothing Is True – Everything Is Permitted

Hidden Risks in SQL Agent Job Logging: How Retry and Output Settings Can Compromise Your Logs

In many SQL Server environments, DBAs configure SQL Agent jobs with retry attempts (which is a smart move to handle transient issues gracefully). But with it comes a hidden pitfall that often goes unnoticed:

Retry-enabled job steps can silently overwrite logs.

And improper output file settings can cause runaway file growth.

The culprit? Improper use of append settings and missing time-based tokens in output file paths.

Read More »Hidden Risks in SQL Agent Job Logging: How Retry and Output Settings Can Compromise Your Logs

Resolving and Preventing Deadlocks in SQL Server

Deadlocks in SQL Server can be frustrating and can cause significant performance and reliability issues. A deadlock occurs when two or more transactions are waiting for each other to release a lock on a resource, resulting in a situation where no transaction can proceed, and eventually, one of them is automatically killed and rolled back. This can happen when two transactions try to access the same data in a different order or when one transaction holds a lock on a resource while waiting for a lock held by another transaction. In this blog post, we’ll discuss how to troubleshoot and prevent deadlocks in SQL Server.

Read More »Resolving and Preventing Deadlocks in SQL Server

Incremental Integrity Check for Large Databases

Traditional database integrity checks in SQL Server can be time-consuming and resource-intensive, especially for large databases, even when using super cool tools like Ola Hallengren’s maintenance solution.

To address this challenge, I developed a TSQL script for performing incremental integrity checks, which significantly optimizes the process and reduces its impact on the server.

Read More »Incremental Integrity Check for Large Databases

SQL Server Index Mastery: Choosing the Right Column Order

It’s been a while since my last post about SQL Server performance optimization. This one focuses on index design and how the order of columns in your indexes can make or break your database queries. Using my insights from real-world consulting experience, this guide should help you understand the critical decisions that would impact your database performance.

How does SQL Server decide where to look first when executing a query? The answer lies in the structure of your indexes. Learn how the sequence of key columns can optimize your data retrieval, making your database faster and more responsive.

Read More »SQL Server Index Mastery: Choosing the Right Column Order