Page Compression, Unique Identifiers and Speed

The Double-Edged Sword of AI and Data Democratization

Agentic AI is often hailed as a game-changer by organizations, bringing autonomous decision-making, intelligent automation, and powerful predictive capabilities. However, as organizations rush to leverage these technologies, those dealing with critical data in relational databases, documents and datasets, especially personally identifiable information (PII) face a harsh reality: moving AI projects from proof-of-concept to production is […]

Always On Availability Groups and Capabilities

The Problem with AI Job Loss Headlines?

Every few weeks, headlines scream about how artificial intelligence is coming for our jobs. The narrative is often the same: white-collar professions are at risk, automation is taking over, and we’re all doomed to obsolescence.

When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense

As we continue to build more applications using AI embedded solutions, database professionals are increasingly being asked to support workloads that would have seemed outside their charter just a few years ago. One of the most significant shifts has been the rise of vector data (i.e. high-dimensional numerical representations of content like text, images, and […]

Capacity Planning for an Existing SQL Server Workload?

Why Podcasts Matter for the Technical Professional

In a world of always-on learning and the relentless march of tech evolution, podcasts emerged as a quiet revolution in how I consume information.  I’ve been part of several podcasts this year, including recording one earlier today with Ed Roske for the Oracle community. As a data professional and technical specialist, for me they’re more […]

TCP Provider Errors in SQL Server

Transactional DDL in SQL Server: In Oracle, It Does Not Compute

Oracle treats most DDL as auto-committing, meaning once it executes, it's done. SQL Server, however, blurs that line in fascinating ways, allowing some DDL operations to be part of an explicit transaction.

Always On AG Latency for Read-Only Workload After Failover?